Product: | ITG - Internet Procurement Enterprise Connector |
---|---|
Description: | This view is used to generate XML at the PO release headers level for Sync PO Release XML |
Implementation/DBA Data: | APPS.ITG_SP_REL_HEADERS_V |
SELECT PHA.PO_HEADER_ID
, PRA.PO_RELEASE_ID
, PRA.APPROVED_DATE DATETIME_DOCUMENT
, ITG_X_UTILS.SUMPOLINELOCS(PHA.PO_HEADER_ID
, PRA.PO_RELEASE_ID) OPERAMT_EXTENDED
, PHA.CURRENCY_CODE OPERAMT_CURRENCY
, PHA.SEGMENT1 POID
, PER.FULL_NAME BUYERID
, LOC.LOCATION_CODE DELIVERTO
, PHA.COMMENTS NOTES
, TO_CHAR(PRA.ORG_ID) POENTITY
, PRA.RELEASE_NUM PORELEASE
, PRA.AUTHORIZATION_STATUS POSTATUS
, PHA.TYPE_LOOKUP_CODE POTYPE
, NULL TAXWHEXMPT
, ITG_X_UTILS.GETATTACHMENTS('PO_RELEASES'
, 'PO INTERNAL'
, PRA.PO_RELEASE_ID) TO_PO_INTERNAL
, ITG_X_UTILS.GETATTACHMENTS('PO_RELEASES'
, 'MISC'
, PRA.PO_RELEASE_ID) TO_MISC
, ITG_X_UTILS.GETATTACHMENTS('PO_RELEASES'
, 'APPROVER'
, PRA.PO_RELEASE_ID) TO_APPROVER
, ITG_X_UTILS.GETATTACHMENTS('PO_RELEASES'
, 'BUYER'
, PRA.PO_RELEASE_ID) TO_BUYER
, ITG_X_UTILS.GETATTACHMENTS('PO_RELEASES'
, 'PAYABLES'
, PRA.PO_RELEASE_ID) TO_PAYABLES
, ITG_X_UTILS.GETATTACHMENTS('PO_RELEASES'
, 'RECEIVER'
, PRA.PO_RELEASE_ID) TO_RECEIVER
, ITG_X_UTILS.GETATTACHMENTS('PO_RELEASES'
, 'VENDOR'
, PRA.PO_RELEASE_ID) TO_SUPPLIER
FROM PER_PEOPLE_F PER
, HR_LOCATIONS_ALL LOC
, PO_HEADERS_ALL PHA
, PO_RELEASES_ALL PRA
WHERE PER.PERSON_ID (+) = PHA.AGENT_ID
AND LOC.LOCATION_ID (+) = PHA.SHIP_TO_LOCATION_ID
AND PRA.PO_HEADER_ID = PHA.PO_HEADER_ID
AND NVL(PER.EFFECTIVE_END_DATE
, SYSDATE+1) > SYSDATE