View: PO_RELEASES_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_RELEASES_V

View Text

SELECT POR.ROWID
, POR.RELEASE_NUM
, POR.PO_RELEASE_ID
, POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, POR.PO_HEADER_ID
, POR.RELEASE_TYPE
, POR.RELEASE_DATE
, POR.REVISION_NUM
, POR.REVISED_DATE
, POH.REVISION_NUM
, PPF.FULL_NAME
, POR.AGENT_ID
, POV.VENDOR_NAME
, POV.VENDOR_ID
, PVS.VENDOR_SITE_CODE
, PVS.VENDOR_SITE_ID
, POH.CURRENCY_CODE
, HRL.INVENTORY_ORGANIZATION_ID
, HRLT.LOCATION_CODE
, POH.SHIP_TO_LOCATION_ID
, PO_RELEASES_SV2.GET_RELEASE_STATUS(PO_RELEASE_ID)
, PO_RELEASES_SV2.GET_REL_TOTAL(PO_RELEASE_ID)
, POR.APPROVED_DATE
, POR.APPROVED_FLAG
, POR.AUTHORIZATION_STATUS
, POR.ACCEPTANCE_DUE_DATE
, POR.ACCEPTANCE_REQUIRED_FLAG
, POR.FIRM_STATUS_LOOKUP_CODE
, POR.CANCEL_DATE
, POR.CANCEL_REASON
, POR.CANCELLED_BY
, POR.CANCEL_FLAG
, POR.HOLD_BY
, POR.HOLD_DATE
, POR.HOLD_REASON
, POR.HOLD_FLAG
, POR.CLOSED_CODE
, POR.FROZEN_FLAG
, POR.PRINT_COUNT
, POR.PRINTED_DATE
, POR.USSGL_TRANSACTION_CODE
, POR.GOVERNMENT_CONTEXT
, POR.CREATED_BY
, POR.CREATION_DATE
, POR.LAST_UPDATED_BY
, POR.LAST_UPDATE_DATE
, POR.LAST_UPDATE_LOGIN
, POR.PROGRAM_APPLICATION_ID
, POR.PROGRAM_ID
, POR.PROGRAM_UPDATE_DATE
, POR.REQUEST_ID
, POR.ATTRIBUTE1
, POR.ATTRIBUTE10
, POR.ATTRIBUTE11
, POR.ATTRIBUTE12
, POR.ATTRIBUTE13
, POR.ATTRIBUTE14
, POR.ATTRIBUTE15
, POR.ATTRIBUTE2
, POR.ATTRIBUTE3
, POR.ATTRIBUTE4
, POR.ATTRIBUTE5
, POR.ATTRIBUTE6
, POR.ATTRIBUTE7
, POR.ATTRIBUTE8
, POR.ATTRIBUTE9
, POR.ATTRIBUTE_CATEGORY
, PDTL.TYPE_NAME
, POH.BLANKET_TOTAL_AMOUNT
, PPF2.FULL_NAME
, 0
, DECODE(POH.VENDOR_CONTACT_ID
, NULL
, NULL
, PVC.LAST_NAME||'
, '||PVC.FIRST_NAME)
, POH.COMMENTS
, POH.NOTE_TO_VENDOR
, POH.NOTE_TO_RECEIVER
, POH.START_DATE
, POH.END_DATE
, APT.NAME
, POR.EDI_PROCESSED_FLAG
, POR.GLOBAL_ATTRIBUTE_CATEGORY
, POR.GLOBAL_ATTRIBUTE1
, POR.GLOBAL_ATTRIBUTE2
, POR.GLOBAL_ATTRIBUTE3
, POR.GLOBAL_ATTRIBUTE4
, POR.GLOBAL_ATTRIBUTE5
, POR.GLOBAL_ATTRIBUTE6
, POR.GLOBAL_ATTRIBUTE7
, POR.GLOBAL_ATTRIBUTE8
, POR.GLOBAL_ATTRIBUTE9
, POR.GLOBAL_ATTRIBUTE10
, POR.GLOBAL_ATTRIBUTE11
, POR.GLOBAL_ATTRIBUTE12
, POR.GLOBAL_ATTRIBUTE13
, POR.GLOBAL_ATTRIBUTE14
, POR.GLOBAL_ATTRIBUTE15
, POR.GLOBAL_ATTRIBUTE16
, POR.GLOBAL_ATTRIBUTE17
, POR.GLOBAL_ATTRIBUTE18
, POR.GLOBAL_ATTRIBUTE19
, POR.GLOBAL_ATTRIBUTE20
, POR.WF_ITEM_TYPE
, POR.WF_ITEM_KEY
, POR.PCARD_ID
, POR.PAY_ON_CODE
, POR.CONSIGNED_CONSUMPTION_FLAG
, POR.SHIPPING_CONTROL
, POR.CHANGE_SUMMARY
, POR.VENDOR_ORDER_NUM
, POH.AMOUNT_LIMIT
, POH.MIN_RELEASE_AMOUNT
, POH.PRICE_UPDATE_TOLERANCE
, POH.AUTHORIZATION_STATUS
, POH.FOB_LOOKUP_CODE
, POH.FREIGHT_TERMS_LOOKUP_CODE
, POR.ORG_ID
FROM HR_LOCATIONS_ALL_TL HRLT
, HR_LOCATIONS_ALL HRL
, PO_VENDOR_SITES_ALL PVS
, PER_ALL_PEOPLE_F PPF
, PO_VENDORS POV
, PO_HEADERS_ALL POH
, PO_RELEASES POR
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PER_ALL_PEOPLE_F PPF2
, PO_VENDOR_CONTACTS PVC
, AP_TERMS APT
WHERE POR.PO_HEADER_ID = POH.PO_HEADER_ID
AND POH.VENDOR_ID = POV.VENDOR_ID
AND POH.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND POR.AGENT_ID = PPF.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND POH.SHIP_TO_LOCATION_ID = HRL.LOCATION_ID
AND NVL(HRL.BUSINESS_GROUP_ID(+)
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)) = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)
AND HRL.LOCATION_ID = HRLT.LOCATION_ID
AND HRLT.LANGUAGE = USERENV('LANG')
AND PDTL.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')
AND PDTL.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND PDTL.ORG_ID = POR.ORG_ID
AND PDTL.LANGUAGE = USERENV('LANG')
AND PPF2.PERSON_ID = POH.AGENT_ID
AND TRUNC(SYSDATE) BETWEEN PPF2.EFFECTIVE_START_DATE
AND PPF2.EFFECTIVE_END_DATE
AND POH.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID (+)
AND APT.TERM_ID (+) = POH.TERMS_ID
AND PVS.ORG_ID = POR.ORG_ID

Columns