APPS.WMS_TASK_LOAD dependencies on MTL_SYSTEM_ITEMS

Line 8549: FROM mtl_system_items

8545: INTO l_primary_uom
8546: , l_secondary_uom
8547: , l_lot_code
8548: , l_serial_code
8549: FROM mtl_system_items
8550: WHERE organization_id = p_org_id
8551: AND inventory_item_id = p_item_id;
8552:
8553: --bug 6651517

Line 8860: -- FROM mtl_system_items

8856: ---- , serial_number_control_code
8857: -- INTO l_primary_uom
8858: -- , l_lot_code
8859: -- , l_serial_code
8860: -- FROM mtl_system_items
8861: -- WHERE organization_id = p_org_id
8862: -- AND inventory_item_id = p_item_id;
8863:
8864: --Bug5649056: added sub and locator below

Line 13248: FROM MTL_SYSTEM_ITEMS_KFV

13244: END IF;
13245: BEGIN
13246: SELECT CONCATENATED_SEGMENTS
13247: INTO l_concatenated_segments
13248: FROM MTL_SYSTEM_ITEMS_KFV
13249: WHERE inventory_item_id = l_container_item_id
13250: AND organization_id = p_organization_id;
13251: EXCEPTION
13252: WHEN OTHERS THEN

Line 14911: FROM mtl_system_items

14907: , serial_number_control_code
14908: INTO l_primary_uom
14909: , l_lot_code
14910: , l_serial_code
14911: FROM mtl_system_items
14912: WHERE organization_id = p_org_id
14913: AND inventory_item_id = p_item_id;
14914:
14915: select value

Line 15702: FROM mtl_system_items_b

15698:
15699: CURSOR get_item_details( org_id IN NUMBER
15700: , item_id IN NUMBER) IS
15701: SELECT NVL(lot_divisible_flag, 'Y')
15702: FROM mtl_system_items_b
15703: WHERE organization_id = org_id
15704: AND inventory_item_id = item_id;
15705:
15706: BEGIN

Line 15809: FROM mtl_system_items

15805: inv_quantity_tree_pub.clear_quantity_cache;
15806:
15807: SELECT primary_uom_code
15808: INTO l_primary_uom
15809: FROM mtl_system_items
15810: WHERE organization_id = p_org_id
15811: AND inventory_item_id = p_item_id;
15812:
15813: