APPS.BOM_VALIDATE SQL Statements

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

Line: 46

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

Line: 88

    		SELECT  'VALID'
    		INTO     l_dummy
    		FROM     pjm_unit_numbers
    		WHERE
                -- end_item_id = p_revised_item_id AND
                unit_number = p_from_end_item_unit_number;

Line: 137

    		SELECT 'VALID'
      		INTO l_dummy
      		FROM mfg_lookups
     		WHERE lookup_code = p_wip_supply_type
       		AND lookup_type = 'WIP_SUPPLY' ;

Line: 189

          SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (
            SELECT NULL FROM mtl_serial_numbers WHERE
             inventory_item_id = p_assembly_item_id AND
             current_organization_id = p_organization_id AND
             serial_number = p_serial_number);

Line: 235

          SELECT 'x' INTO l_dummy FROM dual WHERE EXISTS (
          select NULL from bom_bill_of_materials a, bom_alternate_designators b
              where a.assembly_item_id = p_assembly_item_id
              and a.organization_id = p_organization_id
              and a.is_preferred = 'Y'
              and a.structure_type_id = b.structure_type_id
              and b.alternate_designator_code = p_alternate_bom_code );

Line: 273

	    SELECT 'Y'
	    FROM   all_objects
	    WHERE  object_type  = cp_object_type
            AND    owner = schema_name
	    AND    object_name  = cp_object_name
	    AND    status       = 'VALID';