APPS.WSMPWROT dependencies on WIP_DISCRETE_JOBS

Line 311: FROM wip_discrete_jobs

307:
308: if ((p_routing_revision_date is NULL) and (p_wip_supply_type is null)) then
309: SELECT nvl(routing_revision_date, SYSDATE), nvl(wip_supply_type, 7)
310: INTO x_routing_revision_date, x_job_wip_supply_type
311: FROM wip_discrete_jobs
312: WHERE wip_entity_id=p_wip_entity_id;
313: elsif (p_routing_revision_date is NULL) then
314: SELECT nvl(routing_revision_date, SYSDATE)
315: INTO x_routing_revision_date

Line 316: FROM wip_discrete_jobs

312: WHERE wip_entity_id=p_wip_entity_id;
313: elsif (p_routing_revision_date is NULL) then
314: SELECT nvl(routing_revision_date, SYSDATE)
315: INTO x_routing_revision_date
316: FROM wip_discrete_jobs
317: WHERE wip_entity_id=p_wip_entity_id;
318:
319: x_job_wip_supply_type := p_wip_supply_type ;
320: elsif (p_wip_supply_type is null) then

Line 323: FROM wip_discrete_jobs

319: x_job_wip_supply_type := p_wip_supply_type ;
320: elsif (p_wip_supply_type is null) then
321: SELECT nvl(wip_supply_type, 7)
322: INTO x_job_wip_supply_type
323: FROM wip_discrete_jobs
324: WHERE wip_entity_id=p_wip_entity_id;
325:
326: x_routing_revision_date := p_routing_revision_date;
327: else