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,
Need to know requisition came from iProc
-
- Posts: 7
- Joined: Thu Jul 09, 2009 3:54 am
- Location: India
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
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
Who is online
Users browsing this forum: No registered users and 2 guests