APPS.BOM_DEFAULT_BOM_HEADER SQL Statements

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

Line: 37

    		SELECT bom_inventory_components_s.nextval
    	  	  INTO l_bill_sequence_id
    	  	  FROM sys.dual;

Line: 152

 	          SELECT attribute_category, attribute1,
 	                         attribute2, attribute3, attribute4, attribute5, attribute6,
 	                     attribute7, attribute8, attribute9, attribute10, attribute11,
 	                             attribute12, attribute13, attribute14, attribute15
 	              INTO   l_attribute_category, l_attribute1,
 	                         l_attribute2, l_attribute3, l_attribute4, l_attribute5, l_attribute6,
 	                     l_attribute7, l_attribute8, l_attribute9, l_attribute10, l_attribute11,
 	                                 l_attribute12, l_attribute13, l_attribute14, l_attribute15
 	                  FROM  BOM_STRUCTURES_B
 	                  WHERE bill_sequence_id = p_src_bill_seq_id;

Line: 239

			SELECT decode(eng_item_flag, 'N', 1, 2)
                  	  INTO x_bom_header_rec.assembly_type
                  	  FROM mtl_system_items
                 	  WHERE inventory_item_id = p_bom_head_unexp_rec.assembly_item_id
                   	    AND organization_id   = p_bom_head_unexp_rec.organization_id;

Line: 261

		    SELECT structure_type_id,
               enable_unimplemented_boms
		    INTO x_bom_head_unexp_rec.structure_type_id,
             x_bom_head_unexp_rec.enable_unimplemented_boms
 		    FROM bom_alt_designators_val_v
		    WHERE ( (x_bom_header_rec.alternate_bom_code IS NULL AND
		          alternate_designator_code IS NULL
			  AND organization_id = -1)
			  OR
         (x_bom_header_rec.alternate_bom_code IS NOT NULL AND
          x_bom_header_rec.alternate_bom_code = alternate_designator_code AND
                            x_bom_head_unexp_rec.organization_id = organization_id)
             );

Line: 275

        SELECT  ENABLE_UNIMPLEMENTED_BOMS
        INTO    x_bom_head_unexp_rec.enable_unimplemented_boms
        FROM    BOM_ALT_DESIGNATORS_VAL_V
        WHERE ( (     x_bom_header_rec.alternate_bom_code IS NULL
                 AND  ALTERNATE_DESIGNATOR_CODE IS NULL
                 AND  ORGANIZATION_ID = -1 )
              OR
                (     x_bom_header_rec.alternate_bom_code IS NOT NULL
                AND   x_bom_header_rec.alternate_bom_code = ALTERNATE_DESIGNATOR_CODE
                AND   x_bom_head_unexp_rec.organization_id = ORGANIZATION_ID )
              );

Line: 293

            SELECT structure_type_id, nvl(enable_unimplemented_boms, 'N')
             INTO x_bom_head_unexp_rec.structure_type_id,
                  x_bom_head_unexp_rec.enable_unimplemented_boms
             FROM bom_structure_types_b
             WHERE structure_type_name = 'Asset BOM';