Product: | AP - Payables |
---|---|
Description: | Business view |
Implementation/DBA Data: | APPS.APFV_PAYMENT_SCHEDULES |
SELECT AI.INVOICE_NUM INVOICE_NUMBER
, AI.INVOICE_DATE
, '_LA:AI.INVOICE_TYPE_LOOKUP_CODE:AP_LOOKUP_CODES:INVOICE TYPE:DESCRIPTION'
, APS.PAYMENT_NUM PAYMENT_NUMBER
, '_LA:NVL(APS.PAYMENT_STATUS_FLAG
, ''N''):AP_LOOKUP_CODES:INVOICE PAYMENT STATUS:DISPLAYED_FIELD'
, POV.SEGMENT1
, POV.VENDOR_NAME
, AI.VENDOR_SITE_ID
, AI.INVOICE_CURRENCY_CODE
, AI.PAYMENT_CURRENCY_CODE
, AI.PAY_GROUP_LOOKUP_CODE
, APS.AMOUNT_REMAINING AMOUNT_REMAINING
, APS.CREATED_BY CREATED_BY
, APS.CREATION_DATE CREATION_DATE
, APS.DISCOUNT_AMOUNT_AVAILABLE DISCOUNT_AMOUNT_AVAILABLE
, APS.DISCOUNT_AMOUNT_REMAINING DISCOUNT_AMOUNT_REMAINING
, APS.DISCOUNT_DATE DISCOUNT_DATE
, APS.DUE_DATE DUE_DATE
, APS.FUTURE_PAY_DUE_DATE FUTURE_PAY_DUE_DATE
, APS.GROSS_AMOUNT GROSS_AMOUNT
, APS.HOLD_FLAG HOLD_FLAG
, APS.LAST_UPDATED_BY LAST_UPDATED_BY
, APS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, APS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, '_LA:APS.PAYMENT_METHOD_LOOKUP_CODE:AP_LOOKUP_CODES:PAYMENT METHOD:DISPLAYED_FIELD'
, APS.PAYMENT_PRIORITY PAYMENT_PRIORITY
, APS.SECOND_DISCOUNT_DATE SECOND_DISCOUNT_DATE
, APS.SECOND_DISC_AMT_AVAILABLE SECOND_DISC_AMT_AVAILABLE
, APS.THIRD_DISCOUNT_DATE THIRD_DISCOUNT_DATE
, APS.THIRD_DISC_AMT_AVAILABLE THIRD_DISC_AMT_AVAILABLE
, '_DF:SQLAP:AP_PAYMENT_SCHEDULES:APS'
, '_DF:JG:JG_AP_PAYMENT_SCHEDULES:APS'
, APS.INVOICE_ID INVOICE_ID
, APS.EXTERNAL_BANK_ACCOUNT_ID
FROM AP_PAYMENT_SCHEDULES APS
, AP_INVOICES_ALL AI
, PO_VENDORS POV
WHERE APS.INVOICE_ID = AI.INVOICE_ID
AND AI.VENDOR_ID = POV.VENDOR_ID WITH READ ONLY