APPS.INV_PICK_RELEASE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1232: FROM mtl_system_items

1228: primary_uom_code, NVL(reservable_type,1)
1229: INTO l_revision_control_code, l_lot_control_code,
1230: l_primary_uom_tbl(l_item_index),
1231: l_reservable_type
1232: FROM mtl_system_items
1233: WHERE organization_id = l_organization_id
1234: AND inventory_item_id = l_item_index;
1235: EXCEPTION
1236: WHEN no_data_found THEN

Line 3078: FROM mtl_system_items msi

3074: WHERE line_status = 5
3075: AND line_id = l_mol_id_tbl(ii)
3076: AND EXISTS
3077: ( SELECT 'x'
3078: FROM mtl_system_items msi
3079: WHERE msi.organization_id = mtrl.organization_id
3080: AND msi.inventory_item_id = mtrl.inventory_item_id
3081: AND NVL(msi.reservable_type,1) = 1
3082: );