FND Design Data [Home] [Help]

View: POFV_REQUISITIONS

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.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

Name
REQUISITION_ID
DOCUMENT_NUMBER
OPERATING_UNIT_ID
OPERATING_UNIT_NAME
"_LA:REQUISITION_TYPE"
"_LA:AUTHORIZATION_STATUS"
AUTHORIZER_NOTE
"_LA:CLOSURE_STATUS"
DESCRIPTION
EMERGENCY_PO_NUMBER
"_LA:TRANSFERRED_TO_OE_FLAG"
USSGL_TRANSACTION_CODE
"_DF"
PREPARER_ID
PREPARER_NAME
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY
"_LA:CANCEL_FLAG"
CBC_ACCOUNTING_DATE
"_LA:CHANGE_PENDING_FLAG"
APPS_SOURCE_CODE
EMERGENCY_PO_NUM
PCARD_ID
PCARD_NUMBER
CONTRACTOR_STATUS
CONTRACTOR_REQUISITION_FLAG
APPROVED_DATE