View: POFV_REQUISITIONS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_REQUISITIONS

View Text

SELECT RH.REQUISITION_HEADER_ID
, RH.SEGMENT1
, RH.ORG_ID
, OP.NAME
, '_LA:RH.TYPE_LOOKUP_CODE:PO_LOOKUP_CODES:REQUISITION TYPE:DISPLAYED_FIELD'
, '_LA:RH.AUTHORIZATION_STATUS:PO_LOOKUP_CODES:AUTHORIZATION STATUS:DISPLAYED_FIELD'
, RH.NOTE_TO_AUTHORIZER
, '_LA:RH.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, RH.DESCRIPTION
, RH.EMERGENCY_PO_NUM
, '_LA:RH.TRANSFERRED_TO_OE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RH.USSGL_TRANSACTION_CODE
, '_DF:PO:PO_REQUISITION_HEADERS:RH'
, RH.PREPARER_ID
, PP.FULL_NAME
, RH.CREATION_DATE
, RH.CREATED_BY
, RH.LAST_UPDATE_DATE
, RH.LAST_UPDATED_BY
, '_LA:RH.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RH.CBC_ACCOUNTING_DATE
, '_LA:RH.CHANGE_PENDING_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, RH.APPS_SOURCE_CODE
, RH.EMERGENCY_PO_NUM
, RH.PCARD_ID
, AP.CARD_NUMBER
, RH.CONTRACTOR_STATUS
, RH.CONTRACTOR_REQUISITION_FLAG
, RH.APPROVED_DATE
FROM PO_REQUISITION_HEADERS_ALL RH
, HR_ALL_ORGANIZATION_UNITS OP
, PER_PEOPLE_F PP
, AP_CARDS_ALL AP
WHERE RH.ORG_ID = OP.ORGANIZATION_ID
AND RH.PREPARER_ID = PP.PERSON_ID(+)
AND PP.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND PP.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND RH.PCARD_ID = AP.CARD_ID(+)
AND '_SEC:RH.ORG_ID' IS NOT NULL WITH READ ONLY

Columns