APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_SYSTEM_ITEMS

Line 2293: mtl_system_items msi

2289: cost_element_id,
2290: level_type,
2291: layer_id
2292: ) temp,
2293: mtl_system_items msi
2294: WHERE mcacd.transaction_id = p_transaction_id
2295: AND mcacd.organization_id = p_organization_id
2296: AND mcacd.inventory_item_id = p_inventory_item_id
2297: AND mcacd.inventory_item_id = msi.inventory_item_id

Line 6664: FROM mtl_system_items msi

6660: l_stmt_num := 15;
6661: -- Get Item Expense Flag
6662: SELECT decode(inventory_asset_flag, 'Y',0,1)
6663: INTO l_exp_item
6664: FROM mtl_system_items msi
6665: WHERE msi.inventory_item_id = l_inventory_item_id
6666: AND msi.organization_id = l_organization_id;
6667:
6668: l_stmt_num := 20;

Line 6692: mtl_system_items mitems

6688: 'Y', decode(msub.asset_inventory,1,0,1), 1)
6689: INTO l_transfer_si_asset_yes_no,
6690: l_xfer_exp_flag
6691: FROM mtl_secondary_inventories msub,
6692: mtl_system_items mitems
6693: WHERE msub.secondary_inventory_name = l_transfer_subinventory
6694: AND msub.organization_id = l_xfer_organization_id
6695: AND mitems.inventory_item_id = l_inventory_item_id
6696: AND mitems.organization_id = l_xfer_organization_id;

Line 7608: FROM mtl_system_items

7604:
7605: /* Check if item is NL trackable */
7606: SELECT nvl(comms_nl_trackable_flag, 'N'), asset_creation_code
7607: INTO l_nl_trackable, l_asset_creation_code
7608: FROM mtl_system_items
7609: WHERE inventory_item_id = p_inventory_item_id
7610: AND organization_id = p_organization_id;
7611:
7612: /* Bug 2907681 The code that checks for the item to be NL trackable and the NL module to be installed has been removed as it is not true always.We should not error out if the item is NL trackable but the NL module is not installed */

Line 7815: /*Get the primary UOM code of the item from mtl_system_items */

7811: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */
7812:
7813: /* Modified the insert to insert the Inventory_item_id and basic UOM code bug 3298023 */
7814:
7815: /*Get the primary UOM code of the item from mtl_system_items */
7816:
7817: select primary_uom_code into l_uom_code
7818: from mtl_system_items msi
7819: where msi.inventory_item_id = p_inventory_item_id

Line 7818: from mtl_system_items msi

7814:
7815: /*Get the primary UOM code of the item from mtl_system_items */
7816:
7817: select primary_uom_code into l_uom_code
7818: from mtl_system_items msi
7819: where msi.inventory_item_id = p_inventory_item_id
7820: AND msi.organization_id = p_organization_id;
7821:
7822: If l_debug = 'Y' then