APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on WIP_DISCRETE_JOBS

Line 1052: wip_discrete_jobs wipj

1048: SELECT
1049: wipj.scheduled_completion_date
1050: FROM
1051: ahl_workorders awo,
1052: wip_discrete_jobs wipj
1053: WHERE
1054: wipj.wip_entity_id = awo.wip_entity_id
1055: AND awo.master_workorder_flag = 'Y'
1056: AND awo.visit_task_id IS NULL

Line 1071: WIP_DISCRETE_JOBS wipj

1067: IS
1068: SELECT
1069: wipj.firm_planned_flag
1070: FROM
1071: WIP_DISCRETE_JOBS wipj
1072: WHERE
1073: wipj.wip_entity_id = c_wip_entity_id;
1074:
1075: l_visit_sch_end_date DATE;

Line 2366: WIP_DISCRETE_JOBS WDJ

2362: WO.visit_task_id,
2363: WDJ.owning_department department_id
2364: FROM
2365: AHL_WORKORDERS WO,
2366: WIP_DISCRETE_JOBS WDJ
2367: WHERE
2368: WO.workorder_id = x_id AND
2369: WDJ.wip_entity_id = wo.wip_entity_id;
2370:

Line 3582: wip_discrete_jobs wdj

3578: wdj.organization_id,
3579: wo.wip_entity_id
3580: FROM
3581: ahl_workorders wo,
3582: wip_discrete_jobs wdj
3583: WHERE
3584: wo.workorder_id = c_workorder_id AND
3585: wdj.wip_entity_id = wo.wip_entity_id;
3586:

Line 4046: WIP_DISCRETE_JOBS WDJ,

4042: IS
4043: SELECT
4044: WDJ.firm_planned_flag
4045: FROM
4046: WIP_DISCRETE_JOBS WDJ,
4047: AHL_WORKORDERS AWO
4048: WHERE
4049: AWO.wip_entity_id = WDJ.wip_entity_id AND
4050: AWO.workorder_id = c_workorder_id;