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