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.INV_RESERVATION_PVT dependencies on WIP_DISCRETE_JOBS

Line 2610: wip_discrete_jobs wdj WHERE we.wip_entity_id = p_source_header_id

2606:
2607: BEGIN
2608: SELECT we.entity_type, wdj.maintenance_object_source INTO
2609: l_wip_entity_id, l_maintenance_object_source FROM wip_entities we,
2610: wip_discrete_jobs wdj WHERE we.wip_entity_id = p_source_header_id
2611: AND we.wip_entity_id = wdj.wip_entity_id(+);
2612: EXCEPTION
2613: WHEN no_data_found THEN
2614: IF (l_debug = 1) THEN

Line 8737: FROM wip_entities we, wip_discrete_jobs wdj

8733:
8734: BEGIN
8735: SELECT we.entity_type, wdj.maintenance_object_source
8736: INTO l_wip_entity_id, l_maintenance_object_source
8737: FROM wip_entities we, wip_discrete_jobs wdj
8738: WHERE we.wip_entity_id = l_to_rsv_rec.demand_source_header_id
8739: AND we.wip_entity_id = wdj.wip_entity_id(+);
8740: EXCEPTION
8741: WHEN no_data_found THEN

Line 8761: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ

8757: AND ((l_rsv_rec.project_id IS NULL) OR (l_rsv_rec.task_id IS NULL)) THEN
8758: BEGIN
8759: SELECT wdj.project_id, WDJ.TASK_ID
8760: INTO l_project_id, l_task_id
8761: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ
8762: WHERE asmt.scheduled_material_id = l_rsv_rec.demand_source_line_detail
8763: AND asmt.visit_task_id = aw.visit_task_id
8764: AND ASMT.VISIT_ID = AW.VISIT_ID
8765: AND aw.wip_entity_id = wdj.wip_entity_id

Line 10454: FROM wip_entities we, wip_discrete_jobs wdj

10450: ELSIF ( (l_to_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_wip) AND (l_pjm_enabled = 1)) THEN
10451: BEGIN
10452: SELECT we.entity_type, wdj.maintenance_object_source
10453: INTO l_wip_entity_id, l_maintenance_object_source
10454: FROM wip_entities we, wip_discrete_jobs wdj
10455: WHERE we.wip_entity_id = l_to_rsv_rec.demand_source_header_id
10456: AND we.wip_entity_id = wdj.wip_entity_id(+);
10457: EXCEPTION
10458: WHEN no_data_found THEN

Line 10479: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ

10475:
10476: BEGIN
10477: SELECT wdj.project_id, WDJ.TASK_ID
10478: INTO l_project_id, l_task_id
10479: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ
10480: WHERE asmt.scheduled_material_id = l_to_rsv_rec.demand_source_line_detail
10481: AND asmt.visit_task_id = aw.visit_task_id
10482: AND ASMT.VISIT_ID = AW.VISIT_ID
10483: AND aw.wip_entity_id = wdj.wip_entity_id

Line 13610: FROM wip_entities we, wip_discrete_jobs wdj

13606: ELSIF ( (l_to_rsv_rec.demand_source_type_id = inv_reservation_global.g_source_type_wip) AND (l_pjm_enabled = 1)) THEN
13607: BEGIN
13608: SELECT we.entity_type, wdj.maintenance_object_source
13609: INTO l_wip_entity_id, l_maintenance_object_source
13610: FROM wip_entities we, wip_discrete_jobs wdj
13611: WHERE we.wip_entity_id = l_to_rsv_rec.demand_source_header_id
13612: AND we.wip_entity_id = wdj.wip_entity_id(+);
13613: EXCEPTION
13614: WHEN no_data_found THEN

Line 13639: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ

13635: ELSE
13636: BEGIN
13637: SELECT wdj.project_id, WDJ.TASK_ID
13638: INTO l_project_id, l_task_id
13639: FROM ahl_schedule_materials asmt, ahl_workorders aw, WIP_DISCRETE_JOBS WDJ
13640: WHERE asmt.scheduled_material_id = l_to_rsv_rec.demand_source_line_detail
13641: AND asmt.visit_task_id = aw.visit_task_id
13642: AND ASMT.VISIT_ID = AW.VISIT_ID
13643: AND aw.wip_entity_id = wdj.wip_entity_id