APPS.FV_1219_TRANSACTIONS dependencies on AP_INVOICES_ALL

Line 69: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;

65: l_gl_period_name FV_SF1219_TEMP.gl_period_name%TYPE;
66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;
67: l_lines_exist FV_SF1219_TEMP.lines_exist%TYPE;
68:
69: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
70: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
71: l_payables_ia_paygroup FV_OPERATING_UNITS_ALL.payables_ia_paygroup%TYPE;
72: l_cb_flag FV_INTERAGENCY_FUNDS_ALL.chargeback_flag%TYPE;
73: l_billing_agency_fund FV_INTERAGENCY_FUNDS_ALL.billing_agency_fund%TYPE;

Line 70: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;

66: l_processed_flag FV_SF1219_TEMP.processed_flag%TYPE;
67: l_lines_exist FV_SF1219_TEMP.lines_exist%TYPE;
68:
69: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
70: l_vendor_id AP_INVOICES_ALL.vendor_id%TYPE;
71: l_payables_ia_paygroup FV_OPERATING_UNITS_ALL.payables_ia_paygroup%TYPE;
72: l_cb_flag FV_INTERAGENCY_FUNDS_ALL.chargeback_flag%TYPE;
73: l_billing_agency_fund FV_INTERAGENCY_FUNDS_ALL.billing_agency_fund%TYPE;
74: l_dit_flag varchar2(2);

Line 777: ap_invoices_all ai,

773: gl_code_combinations gcc,
774: fv_sf1219_definitions_accts fda,
775: fv_fund_parameters ffp,
776: fv_treasury_symbols fts,
777: ap_invoices_all ai,
778: ap_invoice_distributions_all aid,
779: ap_invoice_payments_all aip,
780: ap_payment_hist_dists aphd,
781: gl_import_references glir,

Line 956: ap_invoices_all ai,

952: gl_code_combinations gcc,
953: fv_sf1219_definitions_accts fda,
954: fv_fund_parameters ffp,
955: fv_treasury_symbols fts,
956: ap_invoices_all ai,
957: ap_invoice_distributions_all aid,
958: ap_invoice_payments_all aip,
959: gl_import_references glir,
960: xla_ae_headers xah,

Line 2423: FROM ap_invoices_all

2419: ELSE
2420: BEGIN
2421: SELECT 'Y'
2422: INTO l_exists
2423: FROM ap_invoices_all
2424: WHERE invoice_id = TO_NUMBER(l_reference_2)
2425: AND org_id = p_def_org_id;
2426:
2427: EXCEPTION

Line 2435: ' FROM AP_INVOICES_ALL WITH REF_2, '||

2431: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2433: l_module_name,
2434: ' NO_DATA_FOUND WHEN SELECTING' ||
2435: ' FROM AP_INVOICES_ALL WITH REF_2, '||
2436: ' HENCE MANUAL');
2437: END IF;
2438:
2439: WHEN INVALID_NUMBER OR VALUE_ERROR THEN

Line 3064: ap_invoices_all api

3060: l_vendor_id,
3061: l_inv_amount,
3062: l_check_date
3063: FROM ap_checks_all apc,
3064: ap_invoices_all api
3065: WHERE api.invoice_id = NVL(l_reference, 0)
3066: AND apc.check_id = to_number(l_reference_3)
3067: AND l_payables_ia_paygroup = api.pay_group_lookup_code
3068: AND apc.payment_method_lookup_code = 'CLEARING';

Line 3502: ap_invoices_all api

3498: apc.void_date
3499: INTO l_accomplish_date,
3500: l_void_date
3501: FROM ap_checks_all apc,
3502: ap_invoices_all api
3503: WHERE api.invoice_id = Nvl(l_reference, 0)
3504: AND apc.check_id = nvl(l_reference_3,0)
3505: AND apc.org_id = p_def_org_id
3506: AND api.org_id = p_def_org_id;

Line 3680: FROM AP_INVOICES_ALL

3676: WHERE TO_CHAR(check_id) = NVL(l_reference_3,'0')
3677: ANd org_id = p_def_org_id;
3678:
3679: SELECT invoice_date into l_invoice_date
3680: FROM AP_INVOICES_ALL
3681: WHERE TO_CHAR(invoice_id) = NVL(l_reference_4,'0')
3682: ANd org_id = p_def_org_id;
3683:
3684: EXCEPTION WHEN NO_DATA_FOUND THEN