APPS.FV_FACTS_TBAL_TRANSACTIONS dependencies on AP_INVOICE_PAYMENTS_ALL

Line 2237: ap_invoice_payments_all apip

2233: Select Distinct api.invoice_num,
2234: apc.check_date,api.created_by,api.creation_date
2235: From ap_checks_all apc,
2236: ap_invoices_all api,
2237: ap_invoice_payments_all apip
2238: where to_char(apc.check_id) = p_reference3
2239: and to_char(api.invoice_id) = p_reference2
2240: and apc.check_id = apip.check_id
2241: and api.invoice_id = apip.invoice_id ;

Line 2295: FROM ap_invoice_payments_all

2291: WHERE check_id = p_reference3;
2292:
2293: Cursor Pay_Treas_Void is
2294: SELECT creation_date, created_by
2295: FROM ap_invoice_payments_all
2296: WHERE check_id = p_reference3
2297: AND invoice_payment_id = (SELECT max(invoice_payment_id)
2298: FROM ap_invoice_payments_all
2299: WHERE check_id = p_reference3);

Line 2298: FROM ap_invoice_payments_all

2294: SELECT creation_date, created_by
2295: FROM ap_invoice_payments_all
2296: WHERE check_id = p_reference3
2297: AND invoice_payment_id = (SELECT max(invoice_payment_id)
2298: FROM ap_invoice_payments_all
2299: WHERE check_id = p_reference3);
2300:
2301: Cursor Pay_Treas is
2302: SELECT ftc.checkrun_name,

Line 2316: FROM ap_invoice_payments_all

2312: WHERE check_id = p_reference3;
2313:
2314: Cursor Pay_Pay_Void is
2315: SELECT NVL(MAX(invoice_payment_id),0)
2316: FROM ap_invoice_payments_all
2317: WHERE invoice_id = NVL(p_reference2, 0)
2318: AND check_id = NVL(p_reference3,0)
2319: AND invoice_payment_id > p_reference9;
2320:

Line 2323: FROM ap_invoice_payments_all apip,

2319: AND invoice_payment_id > p_reference9;
2320:
2321: Cursor Pay_Pay_Void_Values is
2322: SELECT api.invoice_num, apip.creation_date, apip.created_by
2323: FROM ap_invoice_payments_all apip,
2324: ap_invoices_all api
2325: WHERE api.invoice_id = NVL(p_reference2, 0)
2326: AND api.invoice_id = apip.invoice_id
2327: AND apip.check_id = NVL(p_reference3,0)

Line 2334: ap_invoice_payments_all apip

2330: Cursor Pay_Pay_Non_Void is
2331: SELECT api.invoice_num, apc.creation_date, apc.created_by
2332: FROM ap_checks_all apc,
2333: ap_invoices_all api,
2334: ap_invoice_payments_all apip
2335: WHERE to_char(apc.check_id) = p_reference3
2336: AND to_char(api.invoice_id) = p_reference2
2337: AND apc.check_id = apip.check_id
2338: AND api.invoice_id = apip.invoice_id;