View: APFV_AP_INVOICE_PAYMENTS

Product:	AP - Payables
Description:	Business view
Implementation/DBA Data:	APPS.APFV_AP_INVOICE_PAYMENTS

View Text

SELECT /* UNIQUE ATTRIBUTES */ AIP.INVOICE_PAYMENT_ID INVOICE_PAYMENT_ID
, /* REGULAR ATTRIBUTES */ AIP.ACCOUNTING_DATE ACCOUNTING_DATE
, AIP.ACCRUAL_POSTED_FLAG ACCRUAL_POSTED_FLAG
, AIP.AMOUNT AMOUNT
, AIP.ASSETS_ADDITION_FLAG ASSETS_ADDITION_FLAG
, AIP.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUMBER
, AIP.BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE
, AIP.BANK_NUM BANK_NUMBER
, AIP.CASH_POSTED_FLAG CASH_POSTED_FLAG
, AIP.DISCOUNT_LOST DISCOUNT_LOST
, AIP.DISCOUNT_TAKEN DISCOUNT_TAKEN
, AIP.EXCHANGE_DATE EXCHANGE_DATE
, AIP.EXCHANGE_RATE EXCHANGE_RATE
, AIP.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, AIP.INVOICE_BASE_AMOUNT INVOICE_BASE_AMOUNT
, AIP.PAYMENT_BASE_AMOUNT PAYMENT_BASE_AMOUNT
, AIP.PAYMENT_NUM PAYMENT_NUMBER
, AIP.PERIOD_NAME PERIOD_NAME
, AIP.POSTED_FLAG POSTED_FLAG
, AIP.INVOICE_PAYMENT_TYPE INVOICE_PAYMENT_TYPE
, '_LA:AIP.INVOICE_PAYMENT_TYPE:AP_LOOKUP_CODES:NLS TRANSLATION:DISPLAYED_FIELD' PAYMENT_TYPE
, /* RESOLVED FK RESOLUTIONS */ AC.CHECK_NUMBER CHECK_NUMBER
, AC.CHECK_DATE CHECK_DATE
, AC.AMOUNT CHECK_AMOUNT
, AC.CURRENCY_CODE CHECK_CURRENCY_CODE
, AC.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, '_LA:AC.PAYMENT_METHOD_CODE:AP_LOOKUP_CODES:PAYMENT METHOD:DISPLAYED_FIELD' CHECK_TYPE
, '_LA:AC.STATUS_LOOKUP_CODE:AP_LOOKUP_CODES:CHECK STATE:DISPLAYED_FIELD' CHECK_STATUS
, AI.INVOICE_NUM INVOICE_NUMBER
, AI.INVOICE_DATE INVOICE_DATE
, AI.INVOICE_AMOUNT INVOICE_AMOUNT
, AI.AMOUNT_PAID AMOUNT_PAID
, AI.DESCRIPTION DESCRIPTION
, GSOB.NAME SET_OF_BOOKS_NAME
, '_DF:JG:JG_AP_INVOICE_PAYMENTS:AIP'
, /* IDS */ AIP.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID
, APS.EXTERNAL_BANK_ACCOUNT_ID APS_EXTERNAL_BANK_ACCOUNT_ID
, AIP.ACCTS_PAY_CODE_COMBINATION_ID ACCTS_PAY_CODE_COMBINATION_ID
, AIP.ASSET_CODE_COMBINATION_ID ASSET_CODE_COMBINATION_ID
, AIP.CHECK_ID CHECK_ID
, AIP.GAIN_CODE_COMBINATION_ID GAIN_CODE_COMBINATION_ID
, AIP.INVOICE_ID INVOICE_ID
, AIP.LOSS_CODE_COMBINATION_ID LOSS_CODE_COMBINATION_ID
, AIP.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, /* WHO COLUMNS */ AIP.CREATED_BY CREATED_BY
, AIP.CREATION_DATE CREATION_DATE
, AIP.LAST_UPDATED_BY LAST_UPDATED_BY
, AIP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AIP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM AP_INVOICE_PAYMENTS AIP
, AP_INVOICES_ALL AI
, AP_CHECKS_ALL AC
, GL_SETS_OF_BOOKS GSOB
, AP_PAYMENT_SCHEDULES_ALL APS
WHERE AIP.INVOICE_ID = AI.INVOICE_ID
AND AIP.CHECK_ID = AC.CHECK_ID
AND AIP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND APS.INVOICE_ID = AIP.INVOICE_ID
AND APS.PAYMENT_NUM = AIP.PAYMENT_NUM WITH READ ONLY

Columns