VIEW: APPS.POBV_BKT_PO_RELEASES

Source

View Text - Preformatted

SELECT PR.PO_RELEASE_ID, PR.RELEASE_NUM, PR.PO_HEADER_ID, PH.SEGMENT1, PR.ORG_ID, OP.NAME, PR.RELEASE_DATE, PR.REVISION_NUM, PR.REVISED_DATE, '_LA:ph.AUTHORIZATION_STATUS:PO_LOOKUP_CODES:AUTHORIZATION STATUS:DISPLAYED_FIELD', PR.APPROVED_DATE, '_LA:pr.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:ph.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD', '_LA:ph.FIRM_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:pr.FROZEN_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_LA:pr.HOLD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PR.NOTE_TO_VENDOR, '_LA:pr.ACCEPTANCE_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PR.ACCEPTANCE_DUE_DATE, PR.PRINT_COUNT, PR.PRINTED_DATE, PR.EDI_PROCESSED_FLAG, '_LA:pr.PAY_ON_CODE:PO_LOOKUP_CODES:ERS PAY_ON_CODE:DISPLAYED_FIELD', PR.USSGL_TRANSACTION_CODE, PH.VENDOR_ID, PH.VENDOR_SITE_ID, PH.CURRENCY_CODE, PR.AGENT_ID, PR.CANCELLED_BY, PR.PCARD_ID, PR.CREATION_DATE, PR.CREATED_BY, PR.LAST_UPDATE_DATE, PR.LAST_UPDATED_BY, '_LA:PH.XML_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PH.XML_SEND_DATE, PH.XML_CHANGE_SEND_DATE, PH.CBC_ACCOUNTING_DATE, PR.VENDOR_ORDER_NUM, '_LA:PR.CONSIGNED_CONSUMPTION_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', PH.CHANGE_REQUESTED_BY FROM PO_RELEASES_ALL PR, PO_HEADERS_ALL PH, HR_ALL_ORGANIZATION_UNITS OP WHERE PR.RELEASE_TYPE = 'BLANKET' AND PR.PO_HEADER_ID = PH.PO_HEADER_ID AND PR.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY

View Text - HTML Formatted

SELECT PR.PO_RELEASE_ID
, PR.RELEASE_NUM
, PR.PO_HEADER_ID
, PH.SEGMENT1
, PR.ORG_ID
, OP.NAME
, PR.RELEASE_DATE
, PR.REVISION_NUM
, PR.REVISED_DATE
, '_LA:PH.AUTHORIZATION_STATUS:PO_LOOKUP_CODES:AUTHORIZATION STATUS:DISPLAYED_FIELD'
, PR.APPROVED_DATE
, '_LA:PR.CANCEL_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PH.CLOSED_CODE:PO_LOOKUP_CODES:DOCUMENT STATE:DISPLAYED_FIELD'
, '_LA:PH.FIRM_STATUS_LOOKUP_CODE:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PR.FROZEN_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PR.HOLD_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PR.NOTE_TO_VENDOR
, '_LA:PR.ACCEPTANCE_REQUIRED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PR.ACCEPTANCE_DUE_DATE
, PR.PRINT_COUNT
, PR.PRINTED_DATE
, PR.EDI_PROCESSED_FLAG
, '_LA:PR.PAY_ON_CODE:PO_LOOKUP_CODES:ERS PAY_ON_CODE:DISPLAYED_FIELD'
, PR.USSGL_TRANSACTION_CODE
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, PH.CURRENCY_CODE
, PR.AGENT_ID
, PR.CANCELLED_BY
, PR.PCARD_ID
, PR.CREATION_DATE
, PR.CREATED_BY
, PR.LAST_UPDATE_DATE
, PR.LAST_UPDATED_BY
, '_LA:PH.XML_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PH.XML_SEND_DATE
, PH.XML_CHANGE_SEND_DATE
, PH.CBC_ACCOUNTING_DATE
, PR.VENDOR_ORDER_NUM
, '_LA:PR.CONSIGNED_CONSUMPTION_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PH.CHANGE_REQUESTED_BY
FROM PO_RELEASES_ALL PR
, PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PR.RELEASE_TYPE = 'BLANKET'
AND PR.PO_HEADER_ID = PH.PO_HEADER_ID
AND PR.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY