DBA Data[Home] [Help]

APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 621: mtl_system_items MTLSI,

617: po_headers_all POH,
618: po_lines_all POL,
619: po_vendors POV,
620: po_line_types_b POLT,
621: mtl_system_items MTLSI,
622: financials_system_params_all FSP,
623: xla_distribution_links XDL,
624: xla_ae_headers XAH,
625: xla_ae_lines XAL,

Line 1023: mtl_system_items MTLSI,

1019: po_headers_all POH,
1020: po_lines_all POL,
1021: po_vendors POV,
1022: po_line_types_b POLT,
1023: mtl_system_items MTLSI,
1024: financials_system_params_all FSP,
1025: xla_distribution_links XDL,
1026: xla_ae_headers XAH,
1027: xla_ae_lines XAL,

Line 1653: FROM mtl_system_items MTLSI, po_distributions_all POD,

1649: AND APID.assets_tracking_flag = 'Y'
1650: AND ('Y', '1') =
1651: (SELECT MTLSI.comms_nl_trackable_flag,
1652: MTLSI.asset_creation_code
1653: FROM mtl_system_items MTLSI, po_distributions_all POD,
1654: po_line_locations_all PLL, po_lines_all POL
1655: WHERE POD.po_distribution_id = APID.po_distribution_id
1656: AND PLL.line_location_id = POD.line_location_id
1657: AND POL.po_line_id = PLL.po_line_id