DBA Data[Home] [Help]

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on XLA_AE_HEADERS

Line 256: FROM xla_ae_headers aeh, ap_invoice_payments aip

252: l_count number;
253: BEGIN
254: SELECT count(aeh.event_id)
255: INTO l_count
256: FROM xla_ae_headers aeh, ap_invoice_payments aip
257: WHERE aeh.ledger_id = aip.set_of_books_id
258: AND aeh.application_id = 200
259: AND aeh.event_id = aip.accounting_event_id
260: AND aip.invoice_id = p_invoice_id

Line 833: xla_ae_headers XAH,

829: -- mtl_system_items MTLSI,
830: xla_distribution_links XDL,
831: xla_ae_lines XAL,
832: ap_acct_class_code_gt AAGT ,
833: xla_ae_headers XAH,
834: ap_alc_ledger_gt ALGT
835: WHERE APIDG.po_distribution_id = POD.po_distribution_id(+)
836: AND API.invoice_id = APIL.invoice_id
837: AND APIL.invoice_id = APIDG.invoice_id

Line 1338: xla_ae_headers XAH,

1334: -- mtl_system_items MTLSI,
1335: xla_distribution_links XDL,
1336: xla_ae_lines XAL,
1337: ap_acct_class_code_gt AAGT ,
1338: xla_ae_headers XAH,
1339: ap_alc_ledger_gt ALGT
1340: WHERE APIDG.po_distribution_id = POD.po_distribution_id(+)
1341: AND API.invoice_id = APIL.invoice_id
1342: AND APIL.invoice_id = APIDG.invoice_id

Line 1796: xla_ae_headers XAH,

1792: --po_lines_all POL, /*Bug12703009: Commented the unused table*/
1793: po_vendors POV,
1794: --po_line_types_b POLT,
1795: xla_distribution_links XDL,
1796: xla_ae_headers XAH,
1797: xla_ae_lines XAL,
1798: ap_alc_ledger_gt ALGT,
1799: ap_acct_class_code_gt AAGT,
1800: ap_lookup_codes APL -- bug 8927096: add