eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_NONROUTINE_PVT dependencies on WIP_DISCRETE_JOBS

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

1465: SELECT 'X'
1466: FROM mtl_system_items_b mtl, csi_item_instances csi
1467: WHERE csi.instance_id = c_instance_id
1468: AND csi.inventory_item_id = mtl.inventory_item_id
1469: 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)
1470: AND mtl.serial_number_control_code = 1;
1471:
1472: CURSOR validate_quantity(c_instance_id IN NUMBER, c_wo_id IN NUMBER) IS
1473: SELECT csi.quantity

Line 2609: WIP_DISCRETE_JOBS WIP,

2605: CURSOR get_firm_planned_flag_csr(c_sr_id IN NUMBER) IS
2606: SELECT WIP.FIRM_PLANNED_FLAG
2607: FROM AHL_VISIT_TASKS_B VST,
2608: AHL_WORKORDERS WO,
2609: WIP_DISCRETE_JOBS WIP,
2610: AHL_UNIT_EFFECTIVITIES_B UE
2611: WHERE VST.SERVICE_REQUEST_ID = c_sr_id
2612: AND VST.TASK_TYPE_CODE IN ('SUMMARY')
2613: AND VST.VISIT_TASK_ID = WO.VISIT_TASK_ID