APPS.AHL_PRD_NONROUTINE_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1318: FROM mtl_system_items_b mtl, csi_item_instances csi

1314:
1315: --amsriniv ER 6014567 Begin
1316: CURSOR check_inst_nonserial(c_instance_id IN NUMBER, c_workorder_id IN NUMBER) IS
1317: SELECT 'X'
1318: FROM mtl_system_items_b mtl, csi_item_instances csi
1319: WHERE csi.instance_id = c_instance_id
1320: AND csi.inventory_item_id = mtl.inventory_item_id
1321: AND mtl.organization_id = (SELECT organization_id from wip_discrete_jobs wdj, ahl_workorders awo where wdj.wip_entity_id = awo.wip_entity_id and awo.workorder_id = c_workorder_id)
1322: AND mtl.serial_number_control_code = 1;