APPS.BOM_DEFAULT_RTG_HEADER SQL Statements

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

Line: 37

                SELECT bom_operational_routings_s.nextval
                  INTO l_routing_sequence_id
                  FROM sys.dual;

Line: 161

                SELECT DECODE(eng_item_flag, 'Y', 1, 2)  eng_routing_flag
                FROM mtl_system_items
                WHERE inventory_item_id = p_assembly_item_id
                AND   organization_id = p_org_id;

Line: 193

                SELECT serial_number_control_code
                FROM mtl_system_items
                WHERE inventory_item_id = p_assembly_item_id
                AND   organization_id = p_org_id;

Line: 234

            SELECT
              COMPLETION_SUBINVENTORY,
              COMPLETION_LOCATOR_ID
            FROM
              BOM_OPERATIONAL_ROUTINGS
            WHERE
                ROUTING_SEQUENCE_ID = P_CommRtgSeqId
            AND ORGANIZATION_ID     = P_OrgId
            AND NVL(ALTERNATE_ROUTING_DESIGNATOR, 'primary alternate') =
                  NVL(P_Alt, 'primary alternate');

Line: 379

                    SELECT DECODE(p_rtg_header_rec.eng_routing_flag, 1, 2, 1)
                    INTO  x_rtg_header_unexp_rec.routing_type
                    FROM SYS.DUAL ;

Line: 534

            SELECT
              COMPLETION_SUBINVENTORY,
              COMPLETION_LOCATOR_ID
            FROM
              BOM_OPERATIONAL_ROUTINGS
            WHERE
                ROUTING_SEQUENCE_ID = P_CommRtgSeqId
            AND ORGANIZATION_ID     = P_OrgId
            AND NVL(ALTERNATE_ROUTING_DESIGNATOR, 'primary alternate') =
                  NVL(P_Alt, 'primary alternate');