VIEW: APPS.POFV_PLAN_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, '_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(+) 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
, '_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(+) WITH READ ONLY