APPS.FV_SF224_TRANSACTIONS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1985: ap_invoice_distributions_all aid,

1981: fv_report_definitions frd,
1982: fv_fund_parameters ffp,
1983: fv_treasury_symbols fts,
1984: ap_invoices_all ai,
1985: ap_invoice_distributions_all aid,
1986: ap_invoice_payments_all aip,
1987: ap_payment_hist_dists aphd,
1988: gl_import_references glir,
1989: xla_ae_headers xah,

Line 2099: ap_invoice_distributions_all aid,

2095: fv_report_definitions frd,
2096: fv_fund_parameters ffp,
2097: fv_treasury_symbols fts,
2098: ap_invoices_all ai,
2099: ap_invoice_distributions_all aid,
2100: ap_invoice_payments_all aip,
2101: gl_import_references glir,
2102: xla_ae_headers xah,
2103: xla_ae_lines xal,

Line 2191: ap_invoice_distributions_all aid,

2187: fv_report_definitions frd,
2188: fv_fund_parameters ffp,
2189: fv_treasury_symbols fts,
2190: ap_invoices_all ai,
2191: ap_invoice_distributions_all aid,
2192: ap_invoice_payments_all aip,
2193: gl_import_references glir,
2194: xla_ae_headers xah,
2195: xla_ae_lines xal,

Line 2304: ap_invoice_distributions_all aid,

2300: gl_code_combinations gcc,
2301: fv_report_definitions frd,
2302: fv_fund_parameters ffp,
2303: fv_treasury_symbols fts,
2304: ap_invoice_distributions_all aid,
2305: ap_invoice_payments_all aip,
2306: ap_payment_hist_dists aphd,
2307: gl_import_references glir,
2308: xla_ae_headers xah,

Line 5336: l_po_dist_id ap_invoice_distributions_all.po_distribution_id%TYPE;

5332:
5333: RETURN DATE IS
5334: l_obligation_date DATE;
5335: l_module_name VARCHAR2(100);
5336: l_po_dist_id ap_invoice_distributions_all.po_distribution_id%TYPE;
5337: l_parent_invoice_id ap_invoices_all.invoice_id%TYPE;
5338: BEGIN
5339: l_module_name := g_module_name || 'get_void_check_obligation_date';
5340: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5351: FROM ap_invoice_distributions_all

5347: ------------- modified for bug 5454445
5348: SELECT NVL(max(po_distribution_id),0),
5349: NVL(max(parent_invoice_id),0)
5350: INTO l_po_dist_id, l_parent_invoice_id
5351: FROM ap_invoice_distributions_all
5352: WHERE invoice_id = p_invoice_id ;
5353: --AND distribution_line_number = p_inv_dist_num;
5354: --------------
5355: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5607: ap_invoice_distributions_all apid

5603: FROM
5604: ap_checks_all apc,
5605: ap_invoice_payments_all apip,
5606: ap_invoices_all api,
5607: ap_invoice_distributions_all apid
5608: WHERE apip.set_of_books_id = l_set_of_books_id
5609: AND apip.set_of_books_id = api.set_of_books_id
5610: AND api.set_of_books_id = apid.set_of_books_id
5611: AND apc.org_id = l_org_id

Line 5632: ap_invoice_distributions_all apid

5628: Commented for bug 14022463
5629: AND EXISTS (SELECT 1
5630: FROM gl_je_lines gljl,
5631: gl_je_headers gljh,
5632: ap_invoice_distributions_all apid
5633: WHERE gljl.ledger_id = apid.set_of_books_id
5634: AND gljl.status = 'P'
5635: AND gljh.je_header_id = gljl.je_header_id
5636: AND gljh.je_from_sla_flag = 'N'

Line 5647: ap_invoice_distributions_all apid

5643: gl_je_headers gljh,
5644: gl_import_references glir,
5645: xla_ae_lines xal,
5646: xla_distribution_links xdl,
5647: ap_invoice_distributions_all apid
5648: WHERE gljl.ledger_id = apid.set_of_books_id
5649: AND glir.je_batch_id = gljh.je_batch_id
5650: AND glir.je_header_id = gljh.je_header_id
5651: AND glir.je_line_num = gljl.je_line_num