View: ITG_REQ_HEADERS_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This is used to generate XML at requisition headers level
Implementation/DBA Data:	APPS.ITG_REQ_HEADERS_V

View Text

SELECT REQUISITION_HEADER_ID REQ_HEADER_ID
, HA.CREATION_DATE CREATION_DATE
, ITG_X_UTILS.SUMREQLINES (HA.REQUISITION_HEADER_ID) SUM_REQLINES
, SOB.CURRENCY_CODE CURRENY_CODE
, HA.SEGMENT1 REQUISITNID
, DECODE ( UPPER (HA.AUTHORIZATION_STATUS)
, 'APPROVED'
, 1
, 0) APPROVED
, HA.DESCRIPTION DESCRIPTN
, DECODE ( UPPER (HA.CLOSED_CODE)
, 'APPROVED'
, '1'
, 'CLOSED'
, '2'
, 'FINALLY CLOSED'
, '2'
, 'CLOSED FOR RECEIVING'
, '3'
, 'CANCELLED'
, '4'
, 'AWAITING PRINTING'
, '5'
, 'CLOSED FOR INVOICE'
, '5' ) HDRSTATUS
, HA.ORG_ID POENTITY
, PER.EMPLOYEE_NUMBER REQUESTER
, HA.ATTRIBUTE1 HEADER_UA_ATTRIBUTE1
, HA.ATTRIBUTE2 HEADER_UA_ATTRIBUTE2
, HA.ATTRIBUTE3 HEADER_UA_ATTRIBUTE3
, HA.ATTRIBUTE4 HEADER_UA_ATTRIBUTE4
, HA.ATTRIBUTE5 HEADER_UA_ATTRIBUTE5
, HA.ATTRIBUTE6 HEADER_UA_ATTRIBUTE6
, HA.ATTRIBUTE7 HEADER_UA_ATTRIBUTE7
, HA.ATTRIBUTE8 HEADER_UA_ATTRIBUTE8
, HA.ATTRIBUTE9 HEADER_UA_ATTRIBUTE9
, HA.ATTRIBUTE10 HEADER_UA_ATTRIBUTE10
, HA.ATTRIBUTE11 HEADER_UA_ATTRIBUTE11
, HA.ATTRIBUTE12 HEADER_UA_ATTRIBUTE12
, HA.ATTRIBUTE13 HEADER_UA_ATTRIBUTE13
, HA.ATTRIBUTE14 HEADER_UA_ATTRIBUTE14
, HA.ATTRIBUTE15 HEADER_UA_ATTRIBUTE15
, ITG_X_UTILS.GETATTACHMENTS('PO_REQUISITION_HEADERS'
, 'REQ INTERNAL'
, REQUISITION_HEADER_ID) TO_PO_INTERNAL
, ITG_X_UTILS.GETATTACHMENTS('PO_REQUISITION_HEADERS'
, 'MISC'
, REQUISITION_HEADER_ID) TO_MISC
, ITG_X_UTILS.GETATTACHMENTS('PO_REQUISITION_HEADERS'
, 'APPROVER'
, REQUISITION_HEADER_ID) TO_APPROVER
, ITG_X_UTILS.GETATTACHMENTS('PO_REQUISITION_HEADERS'
, 'BUYER'
, REQUISITION_HEADER_ID) TO_BUYER
, ITG_X_UTILS.GETATTACHMENTS('PO_REQUISITION_HEADERS'
, 'PAYABLES'
, REQUISITION_HEADER_ID) TO_PAYABLES
, ITG_X_UTILS.GETATTACHMENTS('PO_REQUISITION_HEADERS'
, 'RECEIVER'
, REQUISITION_HEADER_ID) TO_RECEIVER
, ITG_X_UTILS.GETATTACHMENTS('PO_REQUISITION_HEADERS'
, 'VENDOR'
, REQUISITION_HEADER_ID) TO_SUPPLIER
FROM GL_SETS_OF_BOOKS SOB
, ORG_ORGANIZATION_DEFINITIONS ORG
, PER_PEOPLE_F PER
, PO_REQUISITION_HEADERS_ALL HA
WHERE SOB.SET_OF_BOOKS_ID (+) = ORG.SET_OF_BOOKS_ID
AND ORG.ORGANIZATION_ID (+) = HA.ORG_ID
AND HA.CREATION_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PER.PERSON_ID = HA.PREPARER_ID
AND NVL(PER.EFFECTIVE_END_DATE
, SYSDATE+1) > SYSDATE

Columns