DBA Data[Home] [Help]

APPS.WMS_TASK_LOAD dependencies on MTL_SYSTEM_ITEMS

Line 7068: FROM mtl_system_items

7064: INTO l_primary_uom
7065: , l_secondary_uom -- Bug #4141928
7066: , l_lot_code
7067: , l_serial_code
7068: FROM mtl_system_items
7069: WHERE organization_id = p_org_id
7070: AND inventory_item_id = p_item_id;
7071:
7072: --bug 6651517

Line 7334: -- FROM mtl_system_items

7330: ---- , serial_number_control_code
7331: -- INTO l_primary_uom
7332: -- , l_lot_code
7333: -- , l_serial_code
7334: -- FROM mtl_system_items
7335: -- WHERE organization_id = p_org_id
7336: -- AND inventory_item_id = p_item_id;
7337:
7338: --Bug5649056: added sub and locator below

Line 10952: FROM MTL_SYSTEM_ITEMS_KFV

10948: END IF;
10949: BEGIN
10950: SELECT CONCATENATED_SEGMENTS
10951: INTO l_concatenated_segments
10952: FROM MTL_SYSTEM_ITEMS_KFV
10953: WHERE inventory_item_id = l_container_item_id
10954: AND organization_id = p_organization_id;
10955: EXCEPTION
10956: WHEN OTHERS THEN