APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_SYSTEM_ITEMS

Line 2232: mtl_system_items msi

2228: cost_element_id,
2229: level_type,
2230: layer_id
2231: ) temp,
2232: mtl_system_items msi
2233: WHERE mcacd.transaction_id = p_transaction_id
2234: AND mcacd.organization_id = p_organization_id
2235: AND mcacd.inventory_item_id = p_inventory_item_id
2236: AND mcacd.inventory_item_id = msi.inventory_item_id

Line 6527: FROM mtl_system_items msi

6523: l_stmt_num := 15;
6524: -- Get Item Expense Flag
6525: SELECT decode(inventory_asset_flag, 'Y',0,1)
6526: INTO l_exp_item
6527: FROM mtl_system_items msi
6528: WHERE msi.inventory_item_id = l_inventory_item_id
6529: AND msi.organization_id = l_organization_id;
6530:
6531: l_stmt_num := 20;

Line 6555: mtl_system_items mitems

6551: 'Y', decode(msub.asset_inventory,1,0,1), 1)
6552: INTO l_transfer_si_asset_yes_no,
6553: l_xfer_exp_flag
6554: FROM mtl_secondary_inventories msub,
6555: mtl_system_items mitems
6556: WHERE msub.secondary_inventory_name = l_transfer_subinventory
6557: AND msub.organization_id = l_xfer_organization_id
6558: AND mitems.inventory_item_id = l_inventory_item_id
6559: AND mitems.organization_id = l_xfer_organization_id;

Line 7371: FROM mtl_system_items

7367:
7368: /* Check if item is NL trackable */
7369: SELECT nvl(comms_nl_trackable_flag, 'N'), asset_creation_code
7370: INTO l_nl_trackable, l_asset_creation_code
7371: FROM mtl_system_items
7372: WHERE inventory_item_id = p_inventory_item_id
7373: AND organization_id = p_organization_id;
7374:
7375: /* 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 7562: /*Get the primary UOM code of the item from mtl_system_items */

7558: /* The following insert statement into pa_transaction_interface will be changed to insert into pa_transaction_interface_all */
7559:
7560: /* Modified the insert to insert the Inventory_item_id and basic UOM code bug 3298023 */
7561:
7562: /*Get the primary UOM code of the item from mtl_system_items */
7563:
7564: select primary_uom_code into l_uom_code
7565: from mtl_system_items msi
7566: where msi.inventory_item_id = p_inventory_item_id

Line 7565: from mtl_system_items msi

7561:
7562: /*Get the primary UOM code of the item from mtl_system_items */
7563:
7564: select primary_uom_code into l_uom_code
7565: from mtl_system_items msi
7566: where msi.inventory_item_id = p_inventory_item_id
7567: AND msi.organization_id = p_organization_id;
7568:
7569: If l_debug = 'Y' then