eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CE_AP_FC_DUE_INVOICES_V

Source

View Text - Preformatted


SELECT aps.invoice_id, /* 1 */ aps.payment_num, /* 2 */ Nvl(aps.amount_remaining,0),/*3*/ ap_utilities_pkg.Ap_round_currency(Nvl(aps.amount_remaining,0) * Nvl(ai.exchange_rate,1), asp.base_currency_code),/*4*/ ai.payment_currency_code, /* 5 */ Nvl(aps.payment_priority,99), /* 6 */ Nvl(pv.vendor_type_lookup_code,'-1'), /* 7 */ Nvl(ai.pay_group_lookup_code,'-1'), /* 8 */ aps.due_date, /* 9 */ aps.org_id, /* 10 */ ai.project_id, /* 11 */ Nvl(aps.hold_flag,'N'), /* 12 */ ai.invoice_num, /* 13 */ (aps.invoice_id ||'X' ||aps.payment_num) /* 14 */ FROM ap_payment_schedules_all aps, ap_invoices_all ai, ap_supplier_sites_all pvs, ap_suppliers pv, ap_system_parameters_all asp WHERE aps.invoice_id = ai.invoice_id AND ai.org_id = asp.org_id AND ai.org_id = pvs.org_id AND ai.vendor_site_id = pvs.vendor_site_id AND pvs.vendor_id = pv.vendor_id AND aps.org_id = ai.org_id AND aps.payment_status_flag != 'Y' AND ai.invoice_type_lookup_code NOT IN ('PREPAYMENT','PAYMENT REQUEST') AND NOT EXISTS (SELECT 1 FROM ap_invoice_distributions_all aid WHERE aid.invoice_id = ai.invoice_id AND match_status_flag != 'A') AND EXISTS (SELECT 1 FROM ap_invoice_distributions_all aid WHERE aid.invoice_id = ai.invoice_id) UNION ALL SELECT aps.invoice_id, /* 1 */ aps.payment_num, /* 2 */ NVL(aps.amount_remaining,0), /*3*/ ap_utilities_pkg.Ap_round_currency(NVL(aps.amount_remaining,0) * NVL(ai.exchange_rate,1), asp.base_currency_code), /*4*/ ai.payment_currency_code, /* 5 */ NVL(aps.payment_priority,99), /* 6 */ '-1', /* 7 */ NVL(ai.pay_group_lookup_code,'-1'), /* 8 */ aps.due_date, /* 9 */ aps.org_id, /* 10 */ ai.project_id, /* 11 */ NVL(aps.hold_flag,'N'), /* 12 */ ai.invoice_num, /* 13 */ (aps.invoice_id ||'X' ||aps.payment_num) /* 14 */ FROM ap_payment_schedules_all aps, ap_invoices_all ai , hz_parties hzp, hz_party_sites hzs, ap_system_parameters_all asp WHERE aps.invoice_id = ai.invoice_id AND ai.org_id = asp.org_id and ai.party_id = hzp.party_id and ai.party_site_id = hzs.party_site_id and hzp.party_id = hzs.party_id AND aps.org_id = ai.org_id AND aps.payment_status_flag != 'Y' AND ai.invoice_type_lookup_code ='PAYMENT REQUEST' AND NOT EXISTS (SELECT 1 FROM ap_invoice_distributions_all aid WHERE aid.invoice_id = ai.invoice_id AND match_status_flag != 'A' ) AND EXISTS (SELECT 1 FROM ap_invoice_distributions_all aid WHERE aid.invoice_id = ai.invoice_id )

View Text - HTML Formatted

SELECT APS.INVOICE_ID
, /* 1 */ APS.PAYMENT_NUM
, /* 2 */ NVL(APS.AMOUNT_REMAINING
, 0)
, /*3*/ AP_UTILITIES_PKG.AP_ROUND_CURRENCY(NVL(APS.AMOUNT_REMAINING
, 0) * NVL(AI.EXCHANGE_RATE
, 1)
, ASP.BASE_CURRENCY_CODE)
, /*4*/ AI.PAYMENT_CURRENCY_CODE
, /* 5 */ NVL(APS.PAYMENT_PRIORITY
, 99)
, /* 6 */ NVL(PV.VENDOR_TYPE_LOOKUP_CODE
, '-1')
, /* 7 */ NVL(AI.PAY_GROUP_LOOKUP_CODE
, '-1')
, /* 8 */ APS.DUE_DATE
, /* 9 */ APS.ORG_ID
, /* 10 */ AI.PROJECT_ID
, /* 11 */ NVL(APS.HOLD_FLAG
, 'N')
, /* 12 */ AI.INVOICE_NUM
, /* 13 */ (APS.INVOICE_ID ||'X' ||APS.PAYMENT_NUM) /* 14 */
FROM AP_PAYMENT_SCHEDULES_ALL APS
, AP_INVOICES_ALL AI
, AP_SUPPLIER_SITES_ALL PVS
, AP_SUPPLIERS PV
, AP_SYSTEM_PARAMETERS_ALL ASP
WHERE APS.INVOICE_ID = AI.INVOICE_ID
AND AI.ORG_ID = ASP.ORG_ID
AND AI.ORG_ID = PVS.ORG_ID
AND AI.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID
AND PVS.VENDOR_ID = PV.VENDOR_ID
AND APS.ORG_ID = AI.ORG_ID
AND APS.PAYMENT_STATUS_FLAG != 'Y'
AND AI.INVOICE_TYPE_LOOKUP_CODE NOT IN ('PREPAYMENT'
, 'PAYMENT REQUEST')
AND NOT EXISTS (SELECT 1
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
WHERE AID.INVOICE_ID = AI.INVOICE_ID
AND MATCH_STATUS_FLAG != 'A')
AND EXISTS (SELECT 1
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
WHERE AID.INVOICE_ID = AI.INVOICE_ID) UNION ALL SELECT APS.INVOICE_ID
, /* 1 */ APS.PAYMENT_NUM
, /* 2 */ NVL(APS.AMOUNT_REMAINING
, 0)
, /*3*/ AP_UTILITIES_PKG.AP_ROUND_CURRENCY(NVL(APS.AMOUNT_REMAINING
, 0) * NVL(AI.EXCHANGE_RATE
, 1)
, ASP.BASE_CURRENCY_CODE)
, /*4*/ AI.PAYMENT_CURRENCY_CODE
, /* 5 */ NVL(APS.PAYMENT_PRIORITY
, 99)
, /* 6 */ '-1'
, /* 7 */ NVL(AI.PAY_GROUP_LOOKUP_CODE
, '-1')
, /* 8 */ APS.DUE_DATE
, /* 9 */ APS.ORG_ID
, /* 10 */ AI.PROJECT_ID
, /* 11 */ NVL(APS.HOLD_FLAG
, 'N')
, /* 12 */ AI.INVOICE_NUM
, /* 13 */ (APS.INVOICE_ID ||'X' ||APS.PAYMENT_NUM) /* 14 */
FROM AP_PAYMENT_SCHEDULES_ALL APS
, AP_INVOICES_ALL AI
, HZ_PARTIES HZP
, HZ_PARTY_SITES HZS
, AP_SYSTEM_PARAMETERS_ALL ASP
WHERE APS.INVOICE_ID = AI.INVOICE_ID
AND AI.ORG_ID = ASP.ORG_ID
AND AI.PARTY_ID = HZP.PARTY_ID
AND AI.PARTY_SITE_ID = HZS.PARTY_SITE_ID
AND HZP.PARTY_ID = HZS.PARTY_ID
AND APS.ORG_ID = AI.ORG_ID
AND APS.PAYMENT_STATUS_FLAG != 'Y'
AND AI.INVOICE_TYPE_LOOKUP_CODE ='PAYMENT REQUEST'
AND NOT EXISTS (SELECT 1
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
WHERE AID.INVOICE_ID = AI.INVOICE_ID
AND MATCH_STATUS_FLAG != 'A' )
AND EXISTS (SELECT 1
FROM AP_INVOICE_DISTRIBUTIONS_ALL AID
WHERE AID.INVOICE_ID = AI.INVOICE_ID )