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.

APPS.FV_FACTS_TRX_REGISTER dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1861: ap_invoice_payments_all aip

1857: l_reference_4,
1858: l_reference_6
1859: FROM ap_payment_hist_dists aphd,
1860: ap_invoice_distributions_all aid,
1861: ap_invoice_payments_all aip
1862: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
1863: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1864: AND aip.invoice_payment_id = aphd.invoice_payment_id;
1865: EXCEPTION

Line 1954: ap_invoice_payments_all aip

1950: l_reference_4,
1951: l_reference_6
1952: FROM ap_payment_hist_dists aphd,
1953: ap_invoice_distributions_all aid,
1954: ap_invoice_payments_all aip
1955: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
1956: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1957: AND aip.invoice_payment_id = aphd.invoice_payment_id;
1958: EXCEPTION

Line 3219: ap_invoice_payments_all apip

3215: apip.creation_date,
3216: apip.created_by
3217: FROM ap_checks_all apc,
3218: ap_invoices_all api,
3219: ap_invoice_payments_all apip
3220: WHERE apc.check_id = to_number(p_reference3)
3221: AND api.invoice_id = to_number(p_reference2)
3222: AND apc.check_id = apip.check_id
3223: AND api.invoice_id = apip.invoice_id;

Line 3271: FROM ap_invoice_payments_all

3267: FROM ap_checks_all
3268: WHERE check_id = p_reference3;
3269: CURSOR Pay_Treas_Void IS
3270: SELECT creation_date, created_by
3271: FROM ap_invoice_payments_all
3272: WHERE check_id = p_reference3
3273: AND invoice_payment_id = (SELECT max(invoice_payment_id)
3274: FROM ap_invoice_payments_all
3275: WHERE check_id = p_reference3);

Line 3274: FROM ap_invoice_payments_all

3270: SELECT creation_date, created_by
3271: FROM ap_invoice_payments_all
3272: WHERE check_id = p_reference3
3273: AND invoice_payment_id = (SELECT max(invoice_payment_id)
3274: FROM ap_invoice_payments_all
3275: WHERE check_id = p_reference3);
3276: CURSOR Pay_Treas IS
3277: SELECT ftc.checkrun_name,
3278: ftc.treasury_doc_date,

Line 3291: FROM ap_invoice_payments_all

3287: FROM ap_checks_all
3288: WHERE check_id = p_reference3;
3289: CURSOR Pay_Pay_Void IS
3290: SELECT NVL(MAX(invoice_payment_id),0)
3291: FROM ap_invoice_payments_all
3292: WHERE invoice_id = NVL(p_reference2, 0)
3293: AND check_id = NVL(p_reference3,0)
3294: AND invoice_payment_id > p_reference9;
3295: CURSOR Pay_Pay_Void_Values IS

Line 3298: FROM ap_invoice_payments_all apip,

3294: AND invoice_payment_id > p_reference9;
3295: CURSOR Pay_Pay_Void_Values IS
3296: SELECT api.invoice_num, apip.creation_date,
3297: apip.created_by
3298: FROM ap_invoice_payments_all apip,
3299: ap_invoices_all api
3300: WHERE api.invoice_id = NVL(p_reference2, 0)
3301: AND api.invoice_id = apip.invoice_id
3302: AND apip.check_id = NVL(p_reference3,0)

Line 3309: ap_invoice_payments_all apip

3305: SELECT api.invoice_num, apc.creation_date,
3306: apc.created_by
3307: FROM ap_checks_all apc,
3308: ap_invoices_all api,
3309: ap_invoice_payments_all apip
3310: WHERE apc.check_id = to_number(p_reference3)
3311: AND api.invoice_id = to_number(p_reference2)
3312: AND apc.check_id = apip.check_id
3313: AND api.invoice_id = apip.invoice_id;