DBA Data[Home] [Help]

APPS.WIP_DEFAULT_DISCRETEJOB dependencies on DUAL

Line 681: FROM dual

677: IF g_DiscreteJob_rec.primary_item_id IS NOT NULL
678: AND g_DiscreteJob_rec.organization_id IS NOT NULL THEN
679:
680: SELECT 1 INTO l_rout_exists
681: FROM dual
682: WHERE exists(
683: SELECT routing_sequence_id
684: FROM bom_operational_routings
685: WHERE assembly_item_id = g_DiscreteJob_rec.primary_item_id

Line 722: FROM dual

718: IF g_DiscreteJob_rec.primary_item_id IS NOT NULL
719: AND g_DiscreteJob_rec.organization_id IS NOT NULL THEN
720:
721: SELECT 1 INTO l_rout_exists
722: FROM dual
723: WHERE exists(
724: SELECT routing_sequence_id
725: FROM bom_operational_routings
726: WHERE assembly_item_id = g_DiscreteJob_rec.primary_item_id

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

851:
852: RETURN NULL;
853: /* Use the following section if you need a new wip entity id */
854: /*
855: Select wip_entities_s.nextval into l_wip_entity_id FROM dual;
856: RETURN l_Wip_Entity_Id;
857: */
858:
859: END Get_Wip_Entity;