View: POFV_PLAN_PO_RELEASES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POFV_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
, '_DF:PO:PO_RELEASES:PR'
, PH.VENDOR_ID
, VE.VENDOR_NAME
, PH.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, PH.CURRENCY_CODE
, CU.NAME
, PR.AGENT_ID
, AG.EMPLOYEE_NUMBER
, AG.FULL_NAME
, PR.CANCELLED_BY
, CA.EMPLOYEE_NUMBER
, CA.FULL_NAME
, PR.PCARD_ID
, CD.CARD_NUMBER
, 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
, PO_VENDORS VE
, PO_VENDOR_SITES_ALL VS
, FND_CURRENCIES_VL CU
, PER_PEOPLE_F AG
, PER_PEOPLE_F CA
, AP_CARDS_ALL CD
WHERE PR.RELEASE_TYPE = 'SCHEDULED'
AND PR.PO_HEADER_ID = PH.PO_HEADER_ID
AND PR.ORG_ID = OP.ORGANIZATION_ID
AND PH.CURRENCY_CODE = CU.CURRENCY_CODE
AND PH.VENDOR_ID = VE.VENDOR_ID(+)
AND PH.VENDOR_SITE_ID = VS.VENDOR_SITE_ID(+)
AND PH.ORG_ID = VS.ORG_ID(+)
AND PR.AGENT_ID = AG.PERSON_ID(+)
AND AG.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND AG.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND PR.CANCELLED_BY = CA.PERSON_ID(+)
AND CA.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND CA.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND PR.PCARD_ID = CD.CARD_ID(+)
AND '_SEC:PR.ORG_ID' IS NOT NULL WITH READ ONLY

Columns