APPS.AHL_PRD_NONROUTINE_PVT dependencies on WIP_DISCRETE_JOBS

Line 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)

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;
1323:
1324: CURSOR validate_quantity(c_instance_id IN NUMBER, c_wo_id IN NUMBER) IS
1325: SELECT csi.quantity