VIEW: APPS.APFV_PAYMENT_SCHEDULES

Source

View Text - Preformatted

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_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

View Text - HTML Formatted

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_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