APPS.EAM_COMPLETION dependencies on WIP_ENTITIES

Line 946: | from wip_discrete_jobs wdj, wip_entities we

942: /* --replaced with select statement for bug #2414513.
943: | -- Cursor to hold all child jobs information
944: | cursor child_jobs_cursor(c_wip_entity_id NUMBER) is
945: | select we.wip_entity_name, wdj.status_type
946: | from wip_discrete_jobs wdj, wip_entities we
947: | where wdj.wip_entity_id = we.wip_entity_id
948: | and wdj.parent_wip_entity_id = c_wip_entity_id
949: | and wdj.manual_rebuild_flag = 'Y';
950: |

Line 1053: from wip_discrete_jobs wdj,eam_work_order_details ewod,wip_entities we

1049: l_old_system_status,
1050: l_old_eam_status,
1051: l_workflow_type,
1052: l_wip_entity_name
1053: from wip_discrete_jobs wdj,eam_work_order_details ewod,wip_entities we
1054: where wdj.wip_entity_id = x_wip_entity_id
1055: AND wdj.wip_entity_id = ewod.wip_entity_id(+)
1056: AND wdj.wip_entity_id = we.wip_entity_id;
1057:

Line 1344: FROM wip_discrete_jobs wdj, wip_entities we

1340: SELECT '1'
1341: INTO child_job_var
1342: FROM dual
1343: WHERE EXISTS (SELECT '1'
1344: FROM wip_discrete_jobs wdj, wip_entities we
1345: WHERE wdj.wip_entity_id = we.wip_entity_id
1346: AND wdj.parent_wip_entity_id = x_wip_entity_id
1347: AND wdj.manual_rebuild_flag = 'Y'
1348: AND wdj.status_type NOT IN (WIP_CONSTANTS.COMP_CHRG,