View: POBV_PLAN_PO_RELEASES

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

View Text

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
, PH.CBC_ACCOUNTING_DATE
, PR.VENDOR_ORDER_NUM
FROM PO_RELEASES_ALL PR
, PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PR.RELEASE_TYPE = 'SCHEDULED'
AND PR.PO_HEADER_ID = PH.PO_HEADER_ID
AND PR.ORG_ID = OP.ORGANIZATION_ID
AND '_SEC:PR.ORG_ID' IS NOT NULL WITH READ ONLY

Columns