DBA Data[Home] [Help]

APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 992: FROM mtl_system_items

988: -- Find the serial control code, lot control code and item primary uom.
989: SELECT primary_uom_code, serial_number_control_code, lot_control_code
990: INTO l_csp_mtltxn_rec.item_primary_uom_code, l_csp_mtltxn_rec.item_serial_control_code,
991: l_csp_mtltxn_rec.item_lot_control_code
992: FROM mtl_system_items
993: WHERE inventory_item_id = l_csp_mtltxn_rec.inventory_item_id
994: AND organization_id = p_organization_id;
995:
996: -- Find the Account Period ID

Line 1228: from mtl_system_items

1224: l_restrict_sub_code NUMBER;
1225: l_inventory_item_id NUMBER := l_csp_mtltxn_rec.inventory_item_id;
1226: BEGIN
1227: select restrict_subinventories_code into l_restrict_sub_code
1228: from mtl_system_items
1229: where inventory_item_id = l_inventory_item_id
1230: and organization_id = p_organization_id;
1231: IF l_restrict_sub_code = 1 THEN -- the item is subinventory-restricted
1232: DECLARE

Line 1274: FROM mtl_system_items

1270: l_restrict_locators_code NUMBER;
1271: l_inventory_item_id NUMBER := l_csp_mtltxn_rec.inventory_item_id;
1272: BEGIN
1273: SELECT restrict_locators_code INTO l_restrict_locators_code
1274: FROM mtl_system_items
1275: WHERE inventory_item_id = l_inventory_item_id
1276: AND organization_id = p_organization_id;
1277:
1278: IF l_restrict_locators_code = 1 THEN -- locators restricted to a predefined list.