DBA Data[Home] [Help]

APPS.WIP_BOMROUTING_PVT dependencies on WIP_DISCRETE_JOBS

Line 151: from wip_discrete_jobs wdj

147: -- explode the bom
148: select wdj.scheduled_start_date,
149: wdj.scheduled_completion_date
150: into l_startDate, l_endDate
151: from wip_discrete_jobs wdj
152: where wdj.organization_id = p_orgID
153: and wdj.wip_entity_id = p_wipEntityID;
154:
155: wip_bomRoutingUtil_pvt.explodeBOM(p_orgID => p_orgID,

Line 307: from wip_discrete_jobs

303: l_bomRevDate,
304: l_rtgRevDate,
305: l_altBom,
306: l_altRtg
307: from wip_discrete_jobs
308: where organization_id = p_orgID
309: and wip_entity_id = p_wipEntityID;
310:
311: if ( /*Fix for bug 5020741. Routing should be exploded if any relevant feild is not null.

Line 434: from wip_discrete_jobs wdj

430:
431: select wdj.scheduled_start_date,
432: wdj.scheduled_completion_date
433: into l_startDate, l_endDate
434: from wip_discrete_jobs wdj
435: where wdj.organization_id = p_orgID
436: and wdj.wip_entity_id = p_wipEntityID;
437: end if;
438: