Total Pageviews

August 13, 2016

8/13/2016 09:58:00 PM


Lets consider there is a transaction existed in the system, then  how can we identify which type of transaction it is? What is the difference between each three types?
Example: There is a transaction in Oracle Purchasing and by seeing the type we can identify whether it belongs to Internal or Purchase requisition.

PO_REQUISITION_LINES_ALL table, since a requisition can probably have both catalog-items and non-catalog-item lines. 
That said, perhaps explore the following columns from PO_REQUISITION_LINES_ALL table:
CATALOG_TYPE
CATALOG_SOURCE
NONCAT_TEMPLATE_ID - this refers to Non-Catalog Request template identifier

po_requisition_lines_all.catalog_type column.
if value = 'EXTERNAL' then it is punchout.
if value = 'NONCATALOG' then it is non-catalog
If value = blank then it is catalog.

0 comments:

Post a Comment