VIEW: APPS.APFV_AP_INVOICE_PAYMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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