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 1792: ap_invoice_payments_all aip

1788: l_reference_4,
1789: l_reference_6
1790: FROM ap_payment_hist_dists aphd,
1791: ap_invoice_distributions_all aid,
1792: ap_invoice_payments_all aip
1793: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
1794: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1795: AND aip.invoice_payment_id = aphd.invoice_payment_id;
1796: EXCEPTION

Line 1874: ap_invoice_payments_all aip

1870: l_reference_4,
1871: l_reference_6
1872: FROM ap_payment_hist_dists aphd,
1873: ap_invoice_distributions_all aid,
1874: ap_invoice_payments_all aip
1875: WHERE aphd.payment_hist_dist_id = l_source_distribution_id_num_1
1876: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
1877: AND aip.invoice_payment_id = aphd.invoice_payment_id;
1878: EXCEPTION

Line 3005: ap_invoice_payments_all apip

3001: apip.creation_date,
3002: apip.created_by
3003: FROM ap_checks_all apc,
3004: ap_invoices_all api,
3005: ap_invoice_payments_all apip
3006: WHERE apc.check_id = to_number(p_reference3)
3007: AND api.invoice_id = to_number(p_reference2)
3008: AND apc.check_id = apip.check_id
3009: AND api.invoice_id = apip.invoice_id;

Line 3057: FROM ap_invoice_payments_all

3053: FROM ap_checks_all
3054: WHERE check_id = p_reference3;
3055: CURSOR Pay_Treas_Void IS
3056: SELECT creation_date, created_by
3057: FROM ap_invoice_payments_all
3058: WHERE check_id = p_reference3
3059: AND invoice_payment_id = (SELECT max(invoice_payment_id)
3060: FROM ap_invoice_payments_all
3061: WHERE check_id = p_reference3);

Line 3060: FROM ap_invoice_payments_all

3056: SELECT creation_date, created_by
3057: FROM ap_invoice_payments_all
3058: WHERE check_id = p_reference3
3059: AND invoice_payment_id = (SELECT max(invoice_payment_id)
3060: FROM ap_invoice_payments_all
3061: WHERE check_id = p_reference3);
3062: CURSOR Pay_Treas IS
3063: SELECT ftc.checkrun_name,
3064: ftc.treasury_doc_date,

Line 3077: FROM ap_invoice_payments_all

3073: FROM ap_checks_all
3074: WHERE check_id = p_reference3;
3075: CURSOR Pay_Pay_Void IS
3076: SELECT NVL(MAX(invoice_payment_id),0)
3077: FROM ap_invoice_payments_all
3078: WHERE invoice_id = NVL(p_reference2, 0)
3079: AND check_id = NVL(p_reference3,0)
3080: AND invoice_payment_id > p_reference9;
3081: CURSOR Pay_Pay_Void_Values IS

Line 3084: FROM ap_invoice_payments_all apip,

3080: AND invoice_payment_id > p_reference9;
3081: CURSOR Pay_Pay_Void_Values IS
3082: SELECT api.invoice_num, apip.creation_date,
3083: apip.created_by
3084: FROM ap_invoice_payments_all apip,
3085: ap_invoices_all api
3086: WHERE api.invoice_id = NVL(p_reference2, 0)
3087: AND api.invoice_id = apip.invoice_id
3088: AND apip.check_id = NVL(p_reference3,0)

Line 3095: ap_invoice_payments_all apip

3091: SELECT api.invoice_num, apc.creation_date,
3092: apc.created_by
3093: FROM ap_checks_all apc,
3094: ap_invoices_all api,
3095: ap_invoice_payments_all apip
3096: WHERE apc.check_id = to_number(p_reference3)
3097: AND api.invoice_id = to_number(p_reference2)
3098: AND apc.check_id = apip.check_id
3099: AND api.invoice_id = apip.invoice_id;