APPS.BOM_RTG_VALIDATE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 42

                SELECT 1
                  INTO l_dummy
                  FROM bom_alternate_designators
                 WHERE alternate_designator_code = p_alternate_routing_code
                   AND organization_id          = p_organization_id;

Line: 62

        * Purpose       : Function will select flow routing flag
        *                 If it does then the function will
        *                 return 1, 2, 3, otherwise return 0.
        *********************************************************************/

 FUNCTION Get_Flow_Routing_Flag( p_routing_sequence_id       IN NUMBER
                              ) RETURN  NUMBER
 IS
   l_dummy NUMBER;

Line: 73

                SELECT nvl(cfm_routing_flag,2)
                INTO l_dummy
                FROM bom_operational_routings
                WHERE routing_sequence_id = p_routing_sequence_id;

Line: 104

           SELECT 1 into l_dummy
           FROM  DUAL
           WHERE EXISTS (
           SELECT 1
           FROM bom_operation_resources
           WHERE operation_sequence_id = p_operation_sequence_id
           AND   substitute_group_num = p_substitute_group_number);

Line: 128

           SELECT 1 into l_dummy
           FROM  DUAL
           WHERE EXISTS (
           SELECT 1
           FROM bom_resources
           WHERE organization_id = p_organization_id
           AND   resource_code = p_substitute_resource_code);