DBA Data[Home] [Help]

APPS.WIP_DEFAULT_REPSCHEDULE dependencies on DUAL

Line 219: FROM dual

215: RETURN NULL;
216: END IF;
217:
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

Line 269: FROM dual

265: RETURN NULL;
266: END IF;
267:
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

Line 315: FROM dual

311: RETURN NULL;
312: END IF;
313:
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

Line 364: FROM dual

360: RETURN NULL;
361: END IF;
362:
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

Line 630: Select wip_entities_s.nextval into l_wip_entity_id FROM dual;

626:
627: RETURN NULL;
628: /* Use the following section if you need a new wip entity id */
629: /*
630: Select wip_entities_s.nextval into l_wip_entity_id FROM dual;
631: RETURN l_wip_entity_id;
632: */
633:
634: END Get_Wip_Entity;