DBA Data[Home] [Help]

APPS.WIP_BOMROUTING_PVT dependencies on WIP_DISCRETE_JOBS

Line 152: from wip_discrete_jobs wdj

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

Line 348: from wip_discrete_jobs

344: l_altBom,
345: l_altRtg,
346: l_jobstartDate, /*Bug 12580949*/
347: l_jobCompDate /*Bug 12580949*/
348: from wip_discrete_jobs
349: where organization_id = p_orgID
350: and wip_entity_id = p_wipEntityID;
351:
352: -- Bug 9834677. modified logic since forms will pass '@@@' for primary routings.

Line 504: from wip_discrete_jobs wdj

500:
501: select wdj.scheduled_start_date,
502: wdj.scheduled_completion_date
503: into l_startDate, l_endDate
504: from wip_discrete_jobs wdj
505: where wdj.organization_id = p_orgID
506: and wdj.wip_entity_id = p_wipEntityID;
507: end if;
508: */

Line 570: from wip_discrete_jobs wdj

566: -- Added for bug 8463132.
567: if l_startDate is null then
568: select wdj.scheduled_start_date
569: into l_startDate
570: from wip_discrete_jobs wdj
571: where wdj.organization_id = p_orgID
572: and wdj.wip_entity_id = p_wipEntityID;
573: end if;
574:

Line 649: from wip_discrete_jobs wdj

645: -- Added for Bug 8463132.
646: if ( p_schedulingMethod = wip_constants.leadtime ) then
647: select wdj.scheduled_start_date
648: into l_startDate
649: from wip_discrete_jobs wdj
650: where wdj.organization_id = p_orgID
651: and wdj.wip_entity_id = p_wipEntityID;
652: end if;
653: