DBA Data[Home] [Help]

APPS.OPI_DBI_CURR_INV_EXP_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 596: -- both costing tables will be outer joins. Join to MTL_SYSTEM_ITEMS_B

592: --
593: --
594: -- Due to presence of expense items and the fact that CQL only has
595: -- records for items in layered costing organizations, the joins to
596: -- both costing tables will be outer joins. Join to MTL_SYSTEM_ITEMS_B
597: -- to check whether an item is an expense item or not.
598: --
599: -- Similarly items in expense subinventories will be assigned 0 value.
600: --

Line 769: mtl_system_items_b msi,

765: moq.inventory_item_id,
766: moq.cost_group_id,
767: moq.subinventory_code
768: ) exp_qty,
769: mtl_system_items_b msi,
770: eni_oltp_item_star items,
771: mtl_parameters mp,
772: cst_item_costs cic,
773: cst_quantity_layers cql,