FND Design Data [Home] [Help]

View: AP_PAYMENT_EXTRACT_HEADER_V

Product: AP - Payables
Description:
Implementation/DBA Data: ViewAPPS.AP_PAYMENT_EXTRACT_HEADER_V
View Text

SELECT APH.ACCOUNTING_EVENT_ID EVENT_ID
, AC.CHECK_NUMBER PAYMENT_TRANSACTION_NUMBER
, AC.PAYMENT_TYPE_FLAG PAYMENT_TYPE
, AC.PAYMENT_METHOD_CODE PAYMENT_DOCUMENT_TYPE
, AC.DOC_SEQUENCE_ID PAYMENT_DOCUMENT_SEQUENCE_ID
, FDS.NAME DOC_SEQUENCE_NAME
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, 'S'
, NULL) THIRD_PARTY_TYPE
, NVL(CBA.POOLED_FLAG
, 'N') CBA_POOLED_BANK_ACOUNT_FLAG
, AC.CHECK_ID AC_CHECK_ID
, AC.PROVINCE AC_PROVINCE
, AC.ACTUAL_VALUE_DATE AC_ACTUAL_VALUE_DATE
, AC.ADDRESS_LINE1 AC_ADDRESS_LINE_1
, AC.ADDRESS_LINE2 AC_ADDRESS_LINE_2
, AC.ADDRESS_LINE3 AC_ADDRESS_LINE_3
, AC.ADDRESS_LINE4 AC_ADDRESS_LINE_4
, AC.AMOUNT AC_AMOUNT
, AC.ATTRIBUTE_CATEGORY AC_ATTRIBUTE_CATEGORY
, AC.ATTRIBUTE1 AC_ATTRIBUTE1
, AC.ATTRIBUTE10 AC_ATTRIBUTE10
, AC.ATTRIBUTE11 AC_ATTRIBUTE11
, AC.ATTRIBUTE12 AC_ATTRIBUTE12
, AC.ATTRIBUTE13 AC_ATTRIBUTE13
, AC.ATTRIBUTE14 AC_ATTRIBUTE14
, AC.ATTRIBUTE15 AC_ATTRIBUTE15
, AC.ATTRIBUTE2 AC_ATTRIBUTE2
, AC.ATTRIBUTE3 AC_ATTRIBUTE3
, AC.ATTRIBUTE4 AC_ATTRIBUTE4
, AC.ATTRIBUTE5 AC_ATTRIBUTE5
, AC.ATTRIBUTE6 AC_ATTRIBUTE6
, AC.ATTRIBUTE7 AC_ATTRIBUTE7
, AC.ATTRIBUTE8 AC_ATTRIBUTE8
, AC.ATTRIBUTE9 AC_ATTRIBUTE9
, AC.CHECK_DATE AC_CHECK_DATE
, AC.CHECK_VOUCHER_NUM AC_CHECK_VOUCHER_NUMBER
, AC.CHECKRUN_NAME AC_CHECKRUN_NAME
, AC.CITY AC_CITY
, AC.COUNTRY AC_COUNTRY
, AC.COUNTY AC_COUNTY
, AC.DESCRIPTION AC_DESCRIPTION
, AC.DOC_CATEGORY_CODE AC_DOC_CATEGORY_CODE
, AC.DOC_SEQUENCE_VALUE AC_DOC_SEQUENCE_VALUE
, AC.FUTURE_PAY_DUE_DATE AC_FUTURE_PAY_DUE_DATE
, AC.STATE AC_STATE
, AC.VENDOR_NAME AC_VENDOR_NAME
, AC.VOID_DATE AC_VOID_DATE
, AC.ZIP AC_ZIP
, CBA.ACCOUNT_CLASSIFICATION CBA_ACCOUNT_CLASSIFICATION
, DECODE(AC.PAYCARD_REFERENCE_ID
, NULL
, CBA.BANK_ACCOUNT_NAME
, AC.BANK_ACCOUNT_NAME) CBA_BANK_ACCOUNT_NAME
, CBA.BANK_ACCOUNT_NAME_ALT CBA_BANK_ACCOUNT_NAME_ALT
, DECODE(AC.PAYCARD_REFERENCE_ID
, NULL
, CBA.BANK_ACCOUNT_NUM
, AC.BANK_ACCOUNT_NUM) CBA_BANK_ACCOUNT_NUM
, CBA.BANK_ACCOUNT_TYPE CBA_BANK_ACCOUNT_TYPE
, CBA.DESCRIPTION CBA_DESCRIPTION
, CBA.IBAN_NUMBER CBA_IBAN_NUMBER
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, AC.VENDOR_ID
, NULL) AC_VENDOR_ID
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, AC.VENDOR_SITE_ID
, NULL) AC_VENDOR_SITE_ID
, AC.ORG_ID AC_ORG_ID
, AC.GLOBAL_ATTRIBUTE_CATEGORY AC_GLOBAL_ATTRIBUTE_CATEGORY
, AC.GLOBAL_ATTRIBUTE1 AC_GLOBAL_ATTRIBUTE_1
, AC.GLOBAL_ATTRIBUTE2 AC_GLOBAL_ATTRIBUTE_2
, AC.GLOBAL_ATTRIBUTE3 AC_GLOBAL_ATTRIBUTE_3
, AC.GLOBAL_ATTRIBUTE4 AC_GLOBAL_ATTRIBUTE_4
, AC.GLOBAL_ATTRIBUTE5 AC_GLOBAL_ATTRIBUTE_5
, AC.GLOBAL_ATTRIBUTE6 AC_GLOBAL_ATTRIBUTE_6
, AC.GLOBAL_ATTRIBUTE7 AC_GLOBAL_ATTRIBUTE_7
, AC.GLOBAL_ATTRIBUTE8 AC_GLOBAL_ATTRIBUTE_8
, AC.GLOBAL_ATTRIBUTE9 AC_GLOBAL_ATTRIBUTE_9
, AC.GLOBAL_ATTRIBUTE10 AC_GLOBAL_ATTRIBUTE_10
, AC.GLOBAL_ATTRIBUTE11 AC_GLOBAL_ATTRIBUTE_11
, AC.GLOBAL_ATTRIBUTE12 AC_GLOBAL_ATTRIBUTE_12
, AC.GLOBAL_ATTRIBUTE13 AC_GLOBAL_ATTRIBUTE_13
, AC.GLOBAL_ATTRIBUTE14 AC_GLOBAL_ATTRIBUTE_14
, AC.GLOBAL_ATTRIBUTE15 AC_GLOBAL_ATTRIBUTE_15
, AC.GLOBAL_ATTRIBUTE16 AC_GLOBAL_ATTRIBUTE_16
, AC.GLOBAL_ATTRIBUTE17 AC_GLOBAL_ATTRIBUTE_17
, AC.GLOBAL_ATTRIBUTE18 AC_GLOBAL_ATTRIBUTE_18
, AC.GLOBAL_ATTRIBUTE19 AC_GLOBAL_ATTRIBUTE_19
, AC.GLOBAL_ATTRIBUTE20 AC_GLOBAL_ATTRIBUTE_20
, AC.EXTERNAL_BANK_ACCOUNT_ID AC_EXTERNAL_BANK_ACCOUNT_ID
, APH.PAYMENT_HISTORY_ID APH_PAYMENT_HISTORY_ID
, APH.ACCOUNTING_DATE APH_ACCOUNTING_DATE
, APH.TRANSACTION_TYPE APH_TRANSACTION_TYPE
, APH.REV_PMT_HIST_ID APH_REV_PMT_HIST_ID
, APH.TRX_BANK_AMOUNT APH_BANK_CURR_AMOUNT
, APH.TRX_PMT_AMOUNT APH_AMOUNT
, APH.HISTORICAL_FLAG APH_HISTORICAL_FLAG
, NVL(CGAC.CASH_CLEARING_CCID
, CGAC.ASSET_CODE_COMBINATION_ID) CGAC_CASH_CLEARING_CCID
, CGAC.AP_ASSET_CCID CGAC_AP_ASSET_CCID
, CGAC.BANK_CHARGES_CCID CGAC_BANK_CHARGES_CCID
, CGAC.BANK_ERRORS_CCID CGAC_BANK_ERRORS_CCID
, CGAC.FUTURE_DATED_PAYMENT_CCID CGAC_FUTURE_DATED_PMT_CCID
, DECODE(NVL(FND_PROFILE.VALUE('FV_ENABLED')
, 'N')
, 'Y'
, 'N'
, DECODE(APH.TRANSACTION_TYPE
, 'PAYMENT CANCELLED'
, 'Y'
, 'REFUND CANCELLED'
, 'Y'
, 'N')) TRANSAC_REVERSAL_FLAG --BUG11681786
, AC.PARTY_ID AC_PARTY_ID
, AC.PARTY_SITE_ID AC_PARTY_SITE_ID
, AC.CURRENCY_CODE AC_CURRENCY_CODE
, NVL(AC.EXCHANGE_DATE
, APH.ACCOUNTING_DATE) AC_EXCHANGE_DATE -- BUG9271242
, AC.EXCHANGE_RATE AC_EXCHANGE_RATE
, AC.EXCHANGE_RATE_TYPE AC_EXCHANGE_RATE_TYPE
, NVL(AC.BASE_AMOUNT
, AC.AMOUNT) AC_LEDGER_AMOUNT
, NVL(APH.TRX_BASE_AMOUNT
, APH.TRX_PMT_AMOUNT) APH_BASE_AMOUNT
, NVL(APH.ERRORS_BASE_AMOUNT
, APH.ERRORS_PMT_AMOUNT) APH_ERRORS_BASE_AMOUNT
, NVL(APH.CHARGES_BASE_AMOUNT
, APH.CHARGES_PMT_AMOUNT) APH_CHARGES_BASE_AMOUNT
, APH.BANK_CURRENCY_CODE APH_BANK_CURRENCY_CODE
, APH.BANK_TO_BASE_XRATE_TYPE APH_BANK_TO_BASE_XRATE_TYPE
, NVL(APH.BANK_TO_BASE_XRATE_DATE
, APH.ACCOUNTING_DATE) APH_BANK_TO_BASE_XRATE_DATE -- BUG9271242
, APH.BANK_TO_BASE_XRATE APH_BANK_TO_BASE_XRATE
, APH.PMT_CURRENCY_CODE APH_PMT_CURRENCY_CODE
, APH.PMT_TO_BASE_XRATE_TYPE APH_PMT_TO_BASE_XRATE_TYPE
, NVL(APH.PMT_TO_BASE_XRATE_DATE
, APH.ACCOUNTING_DATE) APH_PMT_TO_BASE_XRATE_DATE -- BUG9271242
, APH.PMT_TO_BASE_XRATE APH_PMT_TO_BASE_XRATE
, APH.INVOICE_ADJUSTMENT_EVENT_ID APH_INVOICE_ADJ_EVENT_ID
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE_CATEGORY
, HZP.ATTRIBUTE_CATEGORY) POV_ATTRIBUTE_CATEGORY
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE1
, HZP.ATTRIBUTE1 ) POV_ATTRIBUTE1
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE10
, HZP.ATTRIBUTE10 ) POV_ATTRIBUTE10
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE11
, HZP.ATTRIBUTE11) POV_ATTRIBUTE11
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE12
, HZP.ATTRIBUTE12) POV_ATTRIBUTE12
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE13
, HZP.ATTRIBUTE13) POV_ATTRIBUTE13
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE14
, HZP.ATTRIBUTE11) POV_ATTRIBUTE14
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE15
, HZP.ATTRIBUTE15) POV_ATTRIBUTE15
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE2
, HZP.ATTRIBUTE2 ) POV_ATTRIBUTE2
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE3
, HZP.ATTRIBUTE3) POV_ATTRIBUTE3
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE4
, HZP.ATTRIBUTE4) POV_ATTRIBUTE4
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE5
, HZP.ATTRIBUTE5) POV_ATTRIBUTE5
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE6
, HZP.ATTRIBUTE6) POV_ATTRIBUTE6
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE7
, HZP.ATTRIBUTE7) POV_ATTRIBUTE7
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE8
, HZP.ATTRIBUTE8) POV_ATTRIBUTE8
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.ATTRIBUTE9
, HZP.ATTRIBUTE9) POV_ATTRIBUTE9
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.VENDOR_NAME_ALT
, HZP.ORGANIZATION_NAME_PHONETIC) POV_VENDOR_NAME_ALT
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.VENDOR_ID
, NULL ) POV_VENDOR_ID
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.SEGMENT1
, NULL ) POV_SEGMENT1
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.VENDOR_NAME
, HZP.PARTY_NAME) POV_VENDOR_NAME
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.SEGMENT2
, NULL) POV_SEGMENT2
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.SEGMENT3
, NULL) POV_SEGMENT3
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.SEGMENT4
, NULL) POV_SEGMENT4
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.SEGMENT5
, NULL) POV_SEGMENT5
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.VENDOR_TYPE_LOOKUP_CODE
, NULL) POV_MERCHANT_TYPE_LOOKUP_CODE
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE1
, HZP.GLOBAL_ATTRIBUTE1 ) POV_GLOBAL_ATTRIBUTE_1
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE2
, HZP.GLOBAL_ATTRIBUTE2) POV_GLOBAL_ATTRIBUTE_2
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE3
, HZP.GLOBAL_ATTRIBUTE3) POV_GLOBAL_ATTRIBUTE_3
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE4
, HZP.GLOBAL_ATTRIBUTE4) POV_GLOBAL_ATTRIBUTE_4
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE5
, HZP.GLOBAL_ATTRIBUTE5) POV_GLOBAL_ATTRIBUTE_5
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE6
, HZP.GLOBAL_ATTRIBUTE6) POV_GLOBAL_ATTRIBUTE_6
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE7
, HZP.GLOBAL_ATTRIBUTE7) POV_GLOBAL_ATTRIBUTE_7
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE8
, HZP.GLOBAL_ATTRIBUTE8) POV_GLOBAL_ATTRIBUTE_8
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE9
, HZP.GLOBAL_ATTRIBUTE9) POV_GLOBAL_ATTRIBUTE_9
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE10
, HZP.GLOBAL_ATTRIBUTE10) POV_GLOBAL_ATTRIBUTE_10
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE11
, HZP.GLOBAL_ATTRIBUTE11) POV_GLOBAL_ATTRIBUTE_11
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE12
, HZP.GLOBAL_ATTRIBUTE12) POV_GLOBAL_ATTRIBUTE_12
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE13
, HZP.GLOBAL_ATTRIBUTE13) POV_GLOBAL_ATTRIBUTE_13
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE14
, HZP.GLOBAL_ATTRIBUTE14) POV_GLOBAL_ATTRIBUTE_14
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE15
, HZP.GLOBAL_ATTRIBUTE15) POV_GLOBAL_ATTRIBUTE_15
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE16
, HZP.GLOBAL_ATTRIBUTE16) POV_GLOBAL_ATTRIBUTE_16
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE17
, HZP.GLOBAL_ATTRIBUTE17) POV_GLOBAL_ATTRIBUTE_17
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE18
, HZP.GLOBAL_ATTRIBUTE18) POV_GLOBAL_ATTRIBUTE_18
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE19
, HZP.GLOBAL_ATTRIBUTE19) POV_GLOBAL_ATTRIBUTE_19
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE20
, HZP.GLOBAL_ATTRIBUTE20) POV_GLOBAL_ATTRIBUTE_20
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.GLOBAL_ATTRIBUTE_CATEGORY
, HZP.GLOBAL_ATTRIBUTE_CATEGORY) POV_GLOBAL_ATTRIBUTE_CATEGORY
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.NUM_1099
, HZP.JGZZ_FISCAL_CODE) POV_NUM_1099
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POV.PARTY_ID
, HZP.PARTY_ID) PARTY_ID
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE1
, HPS.ATTRIBUTE1 ) POS_ATTRIBUTE1
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE10
, HPS.ATTRIBUTE10) POS_ATTRIBUTE10
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE11
, HPS.ATTRIBUTE11 ) POS_ATTRIBUTE11
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE12
, HPS.ATTRIBUTE12) POS_ATTRIBUTE12
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE13
, HPS.ATTRIBUTE13) POS_ATTRIBUTE13
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE14
, HPS.ATTRIBUTE14) POS_ATTRIBUTE14
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE15
, HPS.ATTRIBUTE15) POS_ATTRIBUTE15
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE2
, HPS.ATTRIBUTE2) POS_ATTRIBUTE2
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE3
, HPS.ATTRIBUTE3) POS_ATTRIBUTE3
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE4
, HPS.ATTRIBUTE4) POS_ATTRIBUTE4
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE5
, HPS.ATTRIBUTE5) POS_ATTRIBUTE5
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE6
, HPS.ATTRIBUTE6) POS_ATTRIBUTE6
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE7
, HPS.ATTRIBUTE7) POS_ATTRIBUTE7
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE8
, HPS.ATTRIBUTE8) POS_ATTRIBUTE8
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE9
, HPS.ATTRIBUTE9) POS_ATTRIBUTE9
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ATTRIBUTE_CATEGORY
, HPS.ATTRIBUTE_CATEGORY) POS_ATTRIBUTE_CATEGORY
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ADDRESS_LINE1
, HL.ADDRESS1 ) POS_ADDRESS_LINE1
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ADDRESS_LINE2
, HL.ADDRESS2) POS_ADDRESS_LINE2
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ADDRESS_LINE3
, HL.ADDRESS3) POS_ADDRESS_LINE3
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ADDRESS_LINE4
, HL.ADDRESS4) POS_ADDRESS_LINE4
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ADDRESS_LINES_ALT
, HL.ADDRESS_LINES_PHONETIC) POS_ADDRESS_LINES_ALT
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.CITY
, HL.CITY) POS_CITY
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.COUNTY
, HL.COUNTY) POS_COUNTY
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.COUNTRY
, HL.COUNTRY) POS_COUNTRY
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.VENDOR_SITE_CODE
, NULL) POS_VENDOR_SITE_CODE
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ZIP
, SUBSTR(HL.POSTAL_CODE
, 1
, 20)) POS_ZIP
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.PROVINCE
, HL.PROVINCE) POS_PROVINCE
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.STATE
, HL.STATE) POS_STATE
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.VENDOR_SITE_ID
, NULL) POS_VENDOR_SITE_ID
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE1
, HPS.GLOBAL_ATTRIBUTE1 ) POS_GLOBAL_ATTRIBUTE_1
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE2
, HPS.GLOBAL_ATTRIBUTE2) POS_GLOBAL_ATTRIBUTE_2
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE3
, HPS.GLOBAL_ATTRIBUTE3) POS_GLOBAL_ATTRIBUTE_3
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE4
, HPS.GLOBAL_ATTRIBUTE4) POS_GLOBAL_ATTRIBUTE_4
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE5
, HPS.GLOBAL_ATTRIBUTE5) POS_GLOBAL_ATTRIBUTE_5
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE6
, HPS.GLOBAL_ATTRIBUTE6) POS_GLOBAL_ATTRIBUTE_6
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE7
, HPS.GLOBAL_ATTRIBUTE7) POS_GLOBAL_ATTRIBUTE_7
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE8
, HPS.GLOBAL_ATTRIBUTE8) POS_GLOBAL_ATTRIBUTE_8
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE9
, HPS.GLOBAL_ATTRIBUTE9) POS_GLOBAL_ATTRIBUTE_9
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE10
, HPS.GLOBAL_ATTRIBUTE10) POS_GLOBAL_ATTRIBUTE_10
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE11
, HPS.GLOBAL_ATTRIBUTE11) POS_GLOBAL_ATTRIBUTE_11
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE12
, HPS.GLOBAL_ATTRIBUTE12) POS_GLOBAL_ATTRIBUTE_12
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE13
, HPS.GLOBAL_ATTRIBUTE13) POS_GLOBAL_ATTRIBUTE_13
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE14
, HPS.GLOBAL_ATTRIBUTE14) POS_GLOBAL_ATTRIBUTE_14
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE15
, HPS.GLOBAL_ATTRIBUTE15) POS_GLOBAL_ATTRIBUTE_15
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE16
, HPS.GLOBAL_ATTRIBUTE16) POS_GLOBAL_ATTRIBUTE_16
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE17
, HPS.GLOBAL_ATTRIBUTE17) POS_GLOBAL_ATTRIBUTE_17
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE18
, HPS.GLOBAL_ATTRIBUTE18) POS_GLOBAL_ATTRIBUTE_18
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE19
, HPS.GLOBAL_ATTRIBUTE19) POS_GLOBAL_ATTRIBUTE_19
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE20
, HPS.GLOBAL_ATTRIBUTE20) POS_GLOBAL_ATTRIBUTE_20
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.GLOBAL_ATTRIBUTE_CATEGORY
, HPS.GLOBAL_ATTRIBUTE_CATEGORY) POS_GLOBAL_ATTRIBUTE_CATEGORY
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.FUTURE_DATED_PAYMENT_CCID
, NULL) POS_FDP_CCID
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.PARTY_SITE_ID
, HPS.PARTY_SITE_ID) POS_PARTY_SITE_ID
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.ORG_ID
, NULL) POS_ORG_ID
, DECODE(SIGN(AC.VENDOR_ID)
, 1
, POS.VENDOR_ID
, NULL) POS_VENDOR_ID
, CGAC.GAIN_CODE_COMBINATION_ID CGAC_GAIN_CCID
, CGAC.LOSS_CODE_COMBINATION_ID CGAC_LOSS_CCID
, IPP.PROCESSING_TYPE PAYMENT_PROCESSING_TYPE
, ACPROG.EXPENSE_CLEARING_CCID PAYCARD_ACCRUED_ACCOUNT_CCID
, AC.PAYMENT_DOCUMENT_ID AC_PAYMENT_DOCUMENT_ID
, AC.PAYMENT_PROFILE_ID AC_PAYMENT_PROFILE_ID
FROM AP_CHECKS_ALL AC
, AP_PAYMENT_HISTORY_ALL APH
, FND_DOCUMENT_SEQUENCES FDS
, CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES_ALL CBAU
, CE_GL_ACCOUNTS_CCID CGAC
, AP_SUPPLIERS POV
, AP_SUPPLIER_SITES_ALL POS
, HZ_PARTIES HZP
, HZ_PARTY_SITES HPS
, HZ_LOCATIONS HL
, IBY_PAYMENT_PROFILES IPP
, AP_CARDS_ALL ACARD
, AP_CARD_PROGRAMS_ALL ACPROG
WHERE AC.CHECK_ID = APH.CHECK_ID
AND AC.DOC_SEQUENCE_ID = FDS.DOC_SEQUENCE_ID(+)
AND AC.CE_BANK_ACCT_USE_ID = CBAU.BANK_ACCT_USE_ID(+)
AND CBAU.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID(+)
AND AC.CE_BANK_ACCT_USE_ID = CGAC.BANK_ACCT_USE_ID(+)
AND AC.VENDOR_ID = POV.VENDOR_ID (+)
AND AC.VENDOR_SITE_ID = POS.VENDOR_SITE_ID(+)
AND HZP.PARTY_ID = AC.PARTY_ID
AND AC.PARTY_SITE_ID = HPS.PARTY_SITE_ID(+)
AND HPS.LOCATION_ID = HL.LOCATION_ID(+)
AND AC.PAYMENT_PROFILE_ID = IPP.PAYMENT_PROFILE_ID(+)
AND AC.PAYCARD_REFERENCE_ID = ACARD.PAYCARD_REFERENCE_ID(+)
AND ACARD.CARD_PROGRAM_ID = ACPROG.CARD_PROGRAM_ID (+)