ERPstuff - Oracle EBS Community

Hi all,

I need to know all the requisitions came from iProc module.

We can create requisitions in two ways1) directly from Po module --requisition module
2) thru iProc module.
I believe both the ways req info will be stored same requisition tables

here I need know list the requisitions came from iProc based on what column??

Thanks
Ramesh,

hi

The below query can segregate the Purchasing and iProcurement requisitions.

select requisition_header_id,segment1,Org_id,Description,PCARD_ID,Apps_source_code
from PO_REQUISITION_HEADERS_ALL
where PCARD_ID is not null

The requisitions which have PCARD_ID as not null are requisitions from iProcurement.Also the Apps_source_code will be POR which denotes iProcurement.

PCARD_ID NULL NUMBER(15)
Unique identifier for procurement card used for the order
APPS_SOURCE_CODE NULL VARCHAR2(25)
Application source code, indicating the creation method for the requisition

Hope it helps.
Thanks
PJ