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
, , ,

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
, , , ,

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