APPS.FV_FACTS_TRX_REGISTER dependencies on AP_INVOICES_ALL

Line 2249: FROM ap_invoices_all i,

2245: SELECT v.vendor_id vendor_id,
2246: v.vendor_type_lookup_code vendor_type,
2247: fvv.eliminations_id
2248: INTO l_vendor_id, l_vendor_type, l_eliminations_id
2249: FROM ap_invoices_all i,
2250: po_vendors v,
2251: fv_facts_vendors_v fvv
2252: WHERE i.invoice_id = to_number(l_reference_2)
2253: AND i.vendor_id = v.vendor_id

Line 2995: FROM ap_invoices_all inv

2991: SELECT inv.invoice_num,
2992: inv.invoice_date,
2993: inv.creation_date,
2994: inv.created_by
2995: FROM ap_invoices_all inv
2996: WHERE inv.invoice_id = to_number(p_reference2);
2997: CURSOR Pay_Pay IS
2998: SELECT DISTINCT api.invoice_num,
2999: DECODE(apc.payment_type_flag,'A',apc.check_date,

Line 3004: ap_invoices_all api,

3000: NVL(apc.treasury_pay_date, apc.check_date)) check_date,
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

Line 3085: ap_invoices_all api

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)
3089: AND apip.invoice_payment_id = p_reference9;

Line 3094: ap_invoices_all api,

3090: CURSOR Pay_Pay_Non_Void IS
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