APPS.BOM_RTG_NETWORK_VALIDATE_API SQL Statements

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

Line: 21

     SELECT routing_sequence_id
     INTO   l_rtg_seq_id
     FROM   bom_operational_routings
     WHERE  assembly_item_id = p_assy_item_id
        AND    organization_id  = p_org_id
        AND    NVL(alternate_routing_designator, 'NONE') =
                                NVL(p_alt_rtg_desig, 'NONE');

Line: 50

     SELECT 1
     INTO   net_exists
     FROM dual
     WHERE EXISTS (SELECT null
		   FROM bom_operation_networks_v
		   WHERE routing_sequence_id = p_rtg_sequence_id
			AND   operation_type = p_operation_type);

Line: 177

    SELECT from_op_seq_id,from_seq_num,
           to_op_seq_id
    FROM bom_operation_networks_v
    WHERE routing_sequence_id = p_rtg_sequence_id
      AND   operation_type = p_operation_type
      AND   transition_type <> 3
    ORDER BY from_seq_num;

Line: 216

    SELECT DISTINCT from_op_seq_id, from_seq_num
    FROM bom_operation_networks_v bonv
    WHERE routing_sequence_id = p_rtg_sequence_id
      AND   operation_type = p_operation_type
      AND   transition_type <> 3
      AND NOT EXISTS (SELECT NULL
			FROM  bom_operation_networks_v net
			WHERE net.to_op_seq_id = bonv.from_op_seq_id)
    ORDER BY from_seq_num;

Line: 257

    SELECT DISTINCT to_op_seq_id operation_sequence_id
    FROM bom_operation_networks
    CONNECT BY PRIOR to_op_seq_id = from_op_seq_id
        AND transition_type <> 3
    START WITH from_op_seq_id = c_str_op_id
        AND transition_type <> 3;

Line: 273

	SELECT operation_seq_num
        INTO   l_op_seq_num
        FROM   bom_operation_sequences
        WHERE  operation_sequence_id =
                   all_con_op_rec.operation_sequence_id;

Line: 475

	    -- delete the connected list for re-use
	    l_Con_Op_Tbl.DELETE;