DBA Data[Home] [Help]

APPS.PA_MASS_ADDITIONS_CREATE_PKG dependencies on XLA_AE_HEADERS

Line 278: xla_ae_headers xah,

274: ap_invoice_distributions apd,
275: financials_system_params_all fsp,
276: po_vendors pov,
277: xla_distribution_links xdl,
278: xla_ae_headers xah,
279: ap_alc_ledger_gt algt,
280: xla_ae_lines xal,
281: ap_acct_class_code_gt aagt,
282: gl_code_combinations glcc,

Line 936: xla_ae_headers xah,

932: ap_invoice_payments apip,
933: ap_batches_all apb,
934: po_vendors pov,
935: xla_distribution_links xdl,
936: xla_ae_headers xah,
937: xla_ae_lines xal,
938: ap_alc_ledger_gt algt,
939: ap_acct_class_code_gt aagt,
940: gl_code_combinations glcc,

Line 1617: --xla_ae_headers xah, /* 12320402 */

1613: algt.ledger_category_code,
1614: algt.ledger_id,
1615: fsp.inventory_organization_id
1616: from pa_cost_distribution_lines cdl,
1617: --xla_ae_headers xah, /* 12320402 */
1618: xla_ae_lines xal,
1619: xla_distribution_links xdl,
1620: pa_expenditure_items ei,
1621: pa_expenditure_comments eic,

Line 1654: SELECT /*+ index(xah XLA_AE_HEADERS_N2) */ 1 /* 12320402 */

1650: and ei.vendor_id = pov.vendor_id
1651: AND CDL.ACCT_EVENT_ID = XDL.EVENT_ID /* 12320402 */
1652: -- 5911379: Modified the join
1653: AND EXISTS (
1654: SELECT /*+ index(xah XLA_AE_HEADERS_N2) */ 1 /* 12320402 */
1655: FROM XLA_AE_HEADERS XAH
1656: WHERE XAH.APPLICATION_ID = 275
1657: AND xah.balance_type_code = 'A'
1658: and xah.accounting_entry_status_code = 'F'

Line 1655: FROM XLA_AE_HEADERS XAH

1651: AND CDL.ACCT_EVENT_ID = XDL.EVENT_ID /* 12320402 */
1652: -- 5911379: Modified the join
1653: AND EXISTS (
1654: SELECT /*+ index(xah XLA_AE_HEADERS_N2) */ 1 /* 12320402 */
1655: FROM XLA_AE_HEADERS XAH
1656: WHERE XAH.APPLICATION_ID = 275
1657: AND xah.balance_type_code = 'A'
1658: and xah.accounting_entry_status_code = 'F'
1659: --and xah.event_id = xdl.event_id