VIEW: APPS.POBV_REQUISITIONS

Source

View Text - Preformatted

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, RH.PREPARER_ID, 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, RH.CONTRACTOR_STATUS, RH.CONTRACTOR_REQUISITION_FLAG, RH.APPROVED_DATE FROM PO_REQUISITION_HEADERS_ALL RH, HR_ALL_ORGANIZATION_UNITS OP WHERE RH.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY

View Text - HTML Formatted

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
, RH.PREPARER_ID
, 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
, RH.CONTRACTOR_STATUS
, RH.CONTRACTOR_REQUISITION_FLAG
, RH.APPROVED_DATE
FROM PO_REQUISITION_HEADERS_ALL RH
, HR_ALL_ORGANIZATION_UNITS OP
WHERE RH.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY