Entries by Oracle ERP Apps Guide

, , ,

PO Requisition associated with PO Orders

We Using following URL, we can find out the all the requisitions (Purchasing Requisitions) which are associated with what all Purchasing orders. They are 2 types of requisitions. 1) Purchasing Requisition 2) Internal Requisition. Note:- Only Purchase Requisitions will be converted to the Purchase orders. SELECT prha.segment1 “Requisition Number”,prha.type_lookup_code “Requisition Type”,pha.segment1 “Purchase Order Number”,pha.type_lookup_code “Purchase […]

/by
, , ,

Hard Reservation for the Standard Sales order Line against Internal Sales order

Note:- You need to have the ASCP Module Installed for the following script to work. Note:- ASCP decide whether it have to create the PO or Internal sales order based on the Sourcing Rules defined for a Item in the Inventory Organization. When any sales Order created for any particular item for any Quantity and […]

/by
, , ,

Purchase Orders Updated on previous day

You can use the following query to get all the Purchasing Orders upadetd on previous day in any Instance. You can filter-out based on category set or Inventory Organization etc.I have commented out category_set_id and Organization ID conditions in the where clause.You can modify as per your requirement. Note: – This kind of information would […]

/by
, ,

Register the table in Application from backend

Note:- Create this Procedure in APPS schema. This Procedure will register the table and it’s column in Applications. Note:- The procedure has two IN paramters. First would would have the Application_Short_Name where you want to register the table and Second Paramter would have the table name you want to register. Note:- Even through, if table […]

/by
, , , ,

Create directory in Oracle

Create directory in Oracle create or replace directory foo_dir as ‘/tmp’; Directories must be created if external tables are used.Created directories are shown in either dba_directories or all_directories. There is no user_directories. Privileges When a «directory» has been created, the read and write object privileges can be granted on it: create directory some_dir;grant read, write […]

/by