View: AP_INVOICE_EXTRACT_HEADER_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_INVOICE_EXTRACT_HEADER_V

View Text

SELECT XE.EVENT_ID EVENT_ID
, AI.SOURCE AI_SOURCE
, AI.INVOICE_NUM INV_TRANSACTION_NUMBER
, AI.DOC_SEQUENCE_ID INV_DOC_SEQUENCE_IDENTIFIER
, AI.DOC_SEQUENCE_VALUE INV_DOC_SEQUENCE_VALUE
, AI.DOC_CATEGORY_CODE INV_DOC_SEQUENCE_CATEGORY
, FDS.NAME DOC_SEQUENCE_NAME
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, 'S'
, NULL) INV_PARTY_TYPE
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, 'S'
, NULL) THIRD_PARTY_TYPE
, AB.BATCH_NAME AB_BATCH_NAME
, AI.ACCTS_PAY_CODE_COMBINATION_ID AI_ACCTS_PAY_CCID
, AI.INVOICE_ID AI_INVOICE_ID
, AI.ORG_ID AI_ORG_ID
, AI.INVOICE_CURRENCY_CODE AI_INVOICE_CURRENCY_CODE
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, AI.VENDOR_ID
, NULL) AI_VENDOR_ID
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, AI.VENDOR_SITE_ID
, NULL) AI_VENDOR_SITE_ID
, AI.ATTRIBUTE_CATEGORY AI_ATTRIBUTE_CATEGORY
, AI.ATTRIBUTE1 AI_ATTRIBUTE1
, AI.ATTRIBUTE10 AI_ATTRIBUTE10
, AI.ATTRIBUTE11 AI_ATTRIBUTE11
, AI.ATTRIBUTE12 AI_ATTRIBUTE12
, AI.ATTRIBUTE13 AI_ATTRIBUTE13
, AI.ATTRIBUTE14 AI_ATTRIBUTE14
, AI.ATTRIBUTE15 AI_ATTRIBUTE15
, AI.ATTRIBUTE2 AI_ATTRIBUTE2
, AI.ATTRIBUTE3 AI_ATTRIBUTE3
, AI.ATTRIBUTE4 AI_ATTRIBUTE4
, AI.ATTRIBUTE5 AI_ATTRIBUTE5
, AI.ATTRIBUTE6 AI_ATTRIBUTE6
, AI.ATTRIBUTE7 AI_ATTRIBUTE7
, AI.ATTRIBUTE8 AI_ATTRIBUTE8
, AI.ATTRIBUTE9 AI_ATTRIBUTE9
, AI.CANCELLED_DATE AI_CANCELLED_DATE
, AI.DESCRIPTION AI_DESCRIPTION
, AI.INVOICE_AMOUNT AI_INVOICE_AMOUNT
, AI.BASE_AMOUNT AI_INVOICE_BASE_AMOUNT
, AI.INVOICE_DATE AI_INVOICE_DATE
, AI.INVOICE_TYPE_LOOKUP_CODE AI_INVOICE_TYPE_LOOKUP_CODE
, AI.VAT_CODE AI_VAT_CODE
, AI.VOUCHER_NUM AI_VOUCHER_NUM
, AI.AMOUNT_PAID INV_AMOUNT_PAID
, AI.DISCOUNT_AMOUNT_TAKEN INV_DISCOUNT_AMOUNT_TAKEN
, AI.INVOICE_DISTRIBUTION_TOTAL INV_DISTRIBUTION_TOTAL
, AI.AWT_GROUP_ID INV_AWT_GROUP_ID
, AI.GLOBAL_ATTRIBUTE_CATEGORY INV_GLOBAL_ATTRIBUTE_CATEGORY
, AI.GLOBAL_ATTRIBUTE1 INV_GLOBAL_ATTRIBUTE_1
, AI.GLOBAL_ATTRIBUTE2 INV_GLOBAL_ATTRIBUTE_2
, AI.GLOBAL_ATTRIBUTE3 INV_GLOBAL_ATTRIBUTE_3
, AI.GLOBAL_ATTRIBUTE4 INV_GLOBAL_ATTRIBUTE_4
, AI.GLOBAL_ATTRIBUTE5 INV_GLOBAL_ATTRIBUTE_5
, AI.GLOBAL_ATTRIBUTE6 INV_GLOBAL_ATTRIBUTE_6
, AI.GLOBAL_ATTRIBUTE7 INV_GLOBAL_ATTRIBUTE_7
, AI.GLOBAL_ATTRIBUTE8 INV_GLOBAL_ATTRIBUTE_8
, AI.GLOBAL_ATTRIBUTE9 INV_GLOBAL_ATTRIBUTE_9
, AI.GLOBAL_ATTRIBUTE10 INV_GLOBAL_ATTRIBUTE_10
, AI.GLOBAL_ATTRIBUTE11 INV_GLOBAL_ATTRIBUTE_11
, AI.GLOBAL_ATTRIBUTE12 INV_GLOBAL_ATTRIBUTE_12
, AI.GLOBAL_ATTRIBUTE13 INV_GLOBAL_ATTRIBUTE_13
, AI.GLOBAL_ATTRIBUTE14 INV_GLOBAL_ATTRIBUTE_14
, AI.GLOBAL_ATTRIBUTE15 INV_GLOBAL_ATTRIBUTE_15
, AI.GLOBAL_ATTRIBUTE16 INV_GLOBAL_ATTRIBUTE_16
, AI.GLOBAL_ATTRIBUTE17 INV_GLOBAL_ATTRIBUTE_17
, AI.GLOBAL_ATTRIBUTE18 INV_GLOBAL_ATTRIBUTE_18
, AI.GLOBAL_ATTRIBUTE19 INV_GLOBAL_ATTRIBUTE_19
, AI.GLOBAL_ATTRIBUTE20 INV_GLOBAL_ATTRIBUTE_20
, AI.GL_DATE INV_GL_DATE
, AI.HISTORICAL_FLAG INV_HISTORICAL_FLAG
, DECODE(XE.EVENT_TYPE_CODE
, 'INVOICE CANCELLED'
, 'Y'
, 'DEBIT MEMO CANCELLED'
, 'Y'
, 'CREDIT MEMO CANCELLED'
, 'Y'
, 'PREPAYMENT CANCELLED'
, 'Y'
, 'N') TRANSAC_REVERSAL_FLAG
, AI.SET_OF_BOOKS_ID LEDGER_ID
, NVL(AI.EXCHANGE_DATE
, AI.GL_DATE) INV_EXCHANGE_DATE
, AI.EXCHANGE_RATE INV_EXCHANGE_RATE
, AI.EXCHANGE_RATE_TYPE INV_EXCHANGE_RATE_TYPE
, AI.PARTY_ID AI_PARTY_ID
, AI.PARTY_SITE_ID AI_PARTY_SITE_ID
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE_CATEGORY
, HZP.ATTRIBUTE_CATEGORY) POV_ATTRIBUTE_CATEGORY
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE1
, HZP.ATTRIBUTE1 ) POV_ATTRIBUTE1
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE10
, HZP.ATTRIBUTE10 ) POV_ATTRIBUTE10
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE11
, HZP.ATTRIBUTE11) POV_ATTRIBUTE11
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE12
, HZP.ATTRIBUTE12) POV_ATTRIBUTE12
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE13
, HZP.ATTRIBUTE13) POV_ATTRIBUTE13
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE14
, HZP.ATTRIBUTE11) POV_ATTRIBUTE14
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE15
, HZP.ATTRIBUTE15) POV_ATTRIBUTE15
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE2
, HZP.ATTRIBUTE2 ) POV_ATTRIBUTE2
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE3
, HZP.ATTRIBUTE3) POV_ATTRIBUTE3
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE4
, HZP.ATTRIBUTE4) POV_ATTRIBUTE4
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE5
, HZP.ATTRIBUTE5) POV_ATTRIBUTE5
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE6
, HZP.ATTRIBUTE6) POV_ATTRIBUTE6
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE7
, HZP.ATTRIBUTE7) POV_ATTRIBUTE7
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE8
, HZP.ATTRIBUTE8) POV_ATTRIBUTE8
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.ATTRIBUTE9
, HZP.ATTRIBUTE9) POV_ATTRIBUTE9
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.VENDOR_NAME_ALT
, HZP.ORGANIZATION_NAME_PHONETIC) POV_VENDOR_NAME_ALT
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.VENDOR_ID
, NULL ) POV_VENDOR_ID
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.SEGMENT1
, NULL ) POV_SEGMENT1
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.VENDOR_NAME
, HZP.PARTY_NAME) POV_VENDOR_NAME
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.SEGMENT2
, NULL) POV_SEGMENT2
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.SEGMENT3
, NULL) POV_SEGMENT3
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.SEGMENT4
, NULL) POV_SEGMENT4
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.SEGMENT5
, NULL) POV_SEGMENT5
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.VENDOR_TYPE_LOOKUP_CODE
, NULL) POV_MERCHANT_TYPE_LOOKUP_CODE
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE1
, HZP.GLOBAL_ATTRIBUTE1 ) POV_GLOBAL_ATTRIBUTE_1
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE2
, HZP.GLOBAL_ATTRIBUTE2) POV_GLOBAL_ATTRIBUTE_2
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE3
, HZP.GLOBAL_ATTRIBUTE3) POV_GLOBAL_ATTRIBUTE_3
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE4
, HZP.GLOBAL_ATTRIBUTE4) POV_GLOBAL_ATTRIBUTE_4
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE5
, HZP.GLOBAL_ATTRIBUTE5) POV_GLOBAL_ATTRIBUTE_5
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE6
, HZP.GLOBAL_ATTRIBUTE6) POV_GLOBAL_ATTRIBUTE_6
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE7
, HZP.GLOBAL_ATTRIBUTE7) POV_GLOBAL_ATTRIBUTE_7
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE8
, HZP.GLOBAL_ATTRIBUTE8) POV_GLOBAL_ATTRIBUTE_8
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE9
, HZP.GLOBAL_ATTRIBUTE9) POV_GLOBAL_ATTRIBUTE_9
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE10
, HZP.GLOBAL_ATTRIBUTE10) POV_GLOBAL_ATTRIBUTE_10
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE11
, HZP.GLOBAL_ATTRIBUTE11) POV_GLOBAL_ATTRIBUTE_11
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE12
, HZP.GLOBAL_ATTRIBUTE12) POV_GLOBAL_ATTRIBUTE_12
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE13
, HZP.GLOBAL_ATTRIBUTE13) POV_GLOBAL_ATTRIBUTE_13
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE14
, HZP.GLOBAL_ATTRIBUTE14) POV_GLOBAL_ATTRIBUTE_14
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE15
, HZP.GLOBAL_ATTRIBUTE15) POV_GLOBAL_ATTRIBUTE_15
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE16
, HZP.GLOBAL_ATTRIBUTE16) POV_GLOBAL_ATTRIBUTE_16
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE17
, HZP.GLOBAL_ATTRIBUTE17) POV_GLOBAL_ATTRIBUTE_17
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE18
, HZP.GLOBAL_ATTRIBUTE18) POV_GLOBAL_ATTRIBUTE_18
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE19
, HZP.GLOBAL_ATTRIBUTE19) POV_GLOBAL_ATTRIBUTE_19
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE20
, HZP.GLOBAL_ATTRIBUTE20) POV_GLOBAL_ATTRIBUTE_20
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE_CATEGORY
, HZP.GLOBAL_ATTRIBUTE_CATEGORY) POV_GLOBAL_ATTRIBUTE_CATEGORY
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.NUM_1099
, HZP.JGZZ_FISCAL_CODE) POV_NUM_1099
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POV.PARTY_ID
, HZP.PARTY_ID) PARTY_ID
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE1
, HPS.ATTRIBUTE1 ) POS_ATTRIBUTE1
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE10
, HPS.ATTRIBUTE10) POS_ATTRIBUTE10
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE11
, HPS.ATTRIBUTE11 ) POS_ATTRIBUTE11
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE12
, HPS.ATTRIBUTE12) POS_ATTRIBUTE12
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE13
, HPS.ATTRIBUTE13) POS_ATTRIBUTE13
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE14
, HPS.ATTRIBUTE14) POS_ATTRIBUTE14
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE15
, HPS.ATTRIBUTE15) POS_ATTRIBUTE15
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE2
, HPS.ATTRIBUTE2) POS_ATTRIBUTE2
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE3
, HPS.ATTRIBUTE3) POS_ATTRIBUTE3
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE4
, HPS.ATTRIBUTE4) POS_ATTRIBUTE4
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE5
, HPS.ATTRIBUTE5) POS_ATTRIBUTE5
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE6
, HPS.ATTRIBUTE6) POS_ATTRIBUTE6
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE7
, HPS.ATTRIBUTE7) POS_ATTRIBUTE7
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE8
, HPS.ATTRIBUTE8) POS_ATTRIBUTE8
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE9
, HPS.ATTRIBUTE9) POS_ATTRIBUTE9
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ATTRIBUTE_CATEGORY
, HPS.ATTRIBUTE_CATEGORY) POS_ATTRIBUTE_CATEGORY
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ADDRESS_LINE1
, HL.ADDRESS1 ) POS_ADDRESS_LINE1
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ADDRESS_LINE2
, HL.ADDRESS2) POS_ADDRESS_LINE2
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ADDRESS_LINE3
, HL.ADDRESS3) POS_ADDRESS_LINE3
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ADDRESS_LINE4
, HL.ADDRESS4) POS_ADDRESS_LINE4
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ADDRESS_LINES_ALT
, HL.ADDRESS_LINES_PHONETIC) POS_ADDRESS_LINES_ALT
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.CITY
, HL.CITY) POS_CITY
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.COUNTY
, HL.COUNTY) POS_COUNTY
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.COUNTRY
, HL.COUNTRY) POS_COUNTRY
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.VENDOR_SITE_CODE
, NULL) POS_VENDOR_SITE_CODE
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ZIP
, SUBSTR(HL.POSTAL_CODE
, 1
, 20)) POS_ZIP
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.PROVINCE
, HL.PROVINCE) POS_PROVINCE
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.STATE
, HL.STATE) POS_STATE
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.VENDOR_SITE_ID
, NULL) POS_VENDOR_SITE_ID
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE1
, HPS.GLOBAL_ATTRIBUTE1 ) POS_GLOBAL_ATTRIBUTE_1
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE2
, HPS.GLOBAL_ATTRIBUTE2) POS_GLOBAL_ATTRIBUTE_2
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE3
, HPS.GLOBAL_ATTRIBUTE3) POS_GLOBAL_ATTRIBUTE_3
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE4
, HPS.GLOBAL_ATTRIBUTE4) POS_GLOBAL_ATTRIBUTE_4
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE5
, HPS.GLOBAL_ATTRIBUTE5) POS_GLOBAL_ATTRIBUTE_5
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE6
, HPS.GLOBAL_ATTRIBUTE6) POS_GLOBAL_ATTRIBUTE_6
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE7
, HPS.GLOBAL_ATTRIBUTE7) POS_GLOBAL_ATTRIBUTE_7
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE8
, HPS.GLOBAL_ATTRIBUTE8) POS_GLOBAL_ATTRIBUTE_8
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE9
, HPS.GLOBAL_ATTRIBUTE9) POS_GLOBAL_ATTRIBUTE_9
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE10
, HPS.GLOBAL_ATTRIBUTE10) POS_GLOBAL_ATTRIBUTE_10
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE11
, HPS.GLOBAL_ATTRIBUTE11) POS_GLOBAL_ATTRIBUTE_11
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE12
, HPS.GLOBAL_ATTRIBUTE12) POS_GLOBAL_ATTRIBUTE_12
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE13
, HPS.GLOBAL_ATTRIBUTE13) POS_GLOBAL_ATTRIBUTE_13
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE14
, HPS.GLOBAL_ATTRIBUTE14) POS_GLOBAL_ATTRIBUTE_14
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE15
, HPS.GLOBAL_ATTRIBUTE15) POS_GLOBAL_ATTRIBUTE_15
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE16
, HPS.GLOBAL_ATTRIBUTE16) POS_GLOBAL_ATTRIBUTE_16
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE17
, HPS.GLOBAL_ATTRIBUTE17) POS_GLOBAL_ATTRIBUTE_17
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE18
, HPS.GLOBAL_ATTRIBUTE18) POS_GLOBAL_ATTRIBUTE_18
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE19
, HPS.GLOBAL_ATTRIBUTE19) POS_GLOBAL_ATTRIBUTE_19
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE20
, HPS.GLOBAL_ATTRIBUTE20) POS_GLOBAL_ATTRIBUTE_20
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE_CATEGORY
, HPS.GLOBAL_ATTRIBUTE_CATEGORY) POS_GLOBAL_ATTRIBUTE_CATEGORY
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.FUTURE_DATED_PAYMENT_CCID
, NULL) POS_FDP_CCID
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.PARTY_SITE_ID
, HPS.PARTY_SITE_ID) POS_PARTY_SITE_ID
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.ORG_ID
, NULL) POS_ORG_ID
, DECODE(SIGN(AI.VENDOR_ID)
, 1
, POS.VENDOR_ID
, NULL) POS_VENDOR_ID
, AI.PAYMENT_STATUS_FLAG AI_PAYMENT_STATUS_FLAG
, AI.PAYMENT_METHOD_CODE AI_PAYMENT_METHOD_CODE
FROM AP_INVOICES_ALL AI
, AP_BATCHES_ALL AB
, FND_DOCUMENT_SEQUENCES FDS
, XLA_EVENTS_GT XE
, AP_SUPPLIERS POV
, AP_SUPPLIER_SITES_ALL POS
, HZ_PARTIES HZP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
WHERE AI.BATCH_ID = AB.BATCH_ID(+)
AND XE.SOURCE_ID_INT_1 = AI.INVOICE_ID
AND XE.APPLICATION_ID = 200
AND AI.DOC_SEQUENCE_ID = FDS.DOC_SEQUENCE_ID(+)
AND XE.ENTITY_CODE = 'AP_INVOICES'
AND AI.VENDOR_ID = POV.VENDOR_ID (+)
AND AI.VENDOR_SITE_ID = POS.VENDOR_SITE_ID(+)
AND HZP.PARTY_ID = AI.PARTY_ID
AND AI.PARTY_SITE_ID = HPS.PARTY_SITE_ID(+)
AND HPS.LOCATION_ID = HL.LOCATION_ID(+)