DBA Data[Home] [Help]

APPS.WIP_DEFAULT_REPSCHEDULE dependencies on BOM_OPERATIONAL_ROUTINGS

Line 222: FROM bom_operational_routings

218: SELECT 1 INTO l_rout_exists
219: FROM dual
220: WHERE exists(
221: SELECT routing_sequence_id
222: FROM bom_operational_routings
223: WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
224: AND organization_id = g_RepSchedule_rec.organization_id);
225:
226: IF (l_rout_exists = 0) THEN

Line 272: FROM bom_operational_routings

268: SELECT 1 INTO l_rout_exists
269: FROM dual
270: WHERE exists(
271: SELECT routing_sequence_id
272: FROM bom_operational_routings
273: WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
274: AND organization_id = g_RepSchedule_rec.organization_id);
275:
276: IF (l_rout_exists = 0) THEN

Line 318: FROM bom_operational_routings

314: SELECT 1 INTO l_rout_exists
315: FROM dual
316: WHERE exists(
317: SELECT routing_sequence_id
318: FROM bom_operational_routings
319: WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
320: AND organization_id = g_RepSchedule_rec.organization_id);
321:
322: IF (l_rout_exists = 0) THEN

Line 367: FROM bom_operational_routings

363: SELECT 1 INTO l_rout_exists
364: FROM dual
365: WHERE exists(
366: SELECT routing_sequence_id
367: FROM bom_operational_routings
368: WHERE assembly_item_id = g_RepSchedule_rec.primary_item_id
369: AND organization_id = g_RepSchedule_rec.organization_id);
370:
371: IF (l_rout_exists = 0) THEN