APPS.BOM_UTIL SQL Statements

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

Line: 15

   SELECT count(bill_sequence_id)  INTO l_first_level_count
   FROM bom_inventory_components
   WHERE bill_sequence_id = p_cbill_sequence_id
   AND implementation_date is NOT NULL;

Line: 36

    SELECT count(distinct change_id)  INTO l_change_order_count
    FROM ENG_REVISED_ITEMS
    WHERE bill_sequence_id = p_bill_sequence_id;

Line: 57

     SELECT count(*) into l_component_count
     FROM
       BOM_INVENTORY_COMPONENTS bomc
     WHERE
        implementation_date is NOT NULL
       AND bomc.bill_sequence_id IN -- For Bug Fix . 2832017
           (SELECT common_bill_sequence_id
            FROM
              BOM_BILL_OF_MATERIALS bom
            WHERE
                bom.assembly_item_id = p_component_item_id
            AND bom.organization_id  = p_organization_id
             -- Commented for Bug Fix 2832017
             -- AND bom.alternate_bom_designator = p_alternate_bom_designator
           );

Line: 92

     SELECT count(*) into l_component_count
     FROM bom_explosions_V
      WHERE  assembly_item_id = p_component_item_id
        and   top_bill_sequence_id = p_top_bill_sequence_id
       --AND   bill_sequence_id = p_bill_sequence_id
       AND  plan_level = p_plan_level + 1;

Line: 106

    SELECT effective_date INTO l_effective_date
    FROM bom_structure_types_b
    WHERE structure_type_id = p_structure_type_id;

Line: 118

     SELECT disable_date INTO l_disable_date
     FROM bom_structure_types_b
     WHERE structure_type_id = p_structure_type_id;

Line: 131

    SELECT count(*) INTO l_structures_count
    FROM bom_bill_of_materials
    WHERE structure_type_id = p_structure_type_id;

Line: 148

    SELECT count(*) INTO l_count
    FROM bom_structure_types_b
    WHERE structure_type_id = p_structure_type_id;

Line: 180

    X_Delete CONSTANT NUMBER := 3;

Line: 185

      SELECT brd.component_reference_designator
      FROM bom_reference_designators brd
      WHERE brd.component_sequence_id = p_old_component_sequence_id
      AND NVL(brd.acd_type, X_Add) = X_Add
      UNION
      SELECT brd.component_reference_designator
      FROM bom_reference_designators brd,
           bom_inventory_components bic
      WHERE DECODE(bic.old_component_sequence_id, NULL,
       bic.component_sequence_id,
       bic.old_component_sequence_id) = p_old_component_sequence_id
      AND   bic.component_sequence_id = brd.component_sequence_id
      AND   bic.implementation_date IS NULL
      AND   brd.acd_type = X_Add
      MINUS
      SELECT brd.component_reference_designator
      FROM bom_reference_designators brd,
           bom_inventory_components bic
      WHERE DECODE(bic.old_component_sequence_id, NULL,
       bic.component_sequence_id,
       bic.old_component_sequence_id) = p_old_component_sequence_id
      AND   bic.component_sequence_id = brd.component_sequence_id
      AND   bic.implementation_date IS NULL
      AND   brd.acd_type = X_Delete;

Line: 232

       SELECT acd_type, old_component_sequence_id
       FROM bom_inventory_components bic
           WHERE bic.component_sequence_id = p_component_seq_id;

Line: 237

    SELECT component_quantity
        FROM bom_inventory_components
          WHERE component_sequence_id = p_component_seq_id
        AND quantity_related = 1;

Line: 252

        SELECT component_reference_designator INTO l_dummy
        FROM bom_reference_designators brd,bom_inventory_components bic
        WHERE bic.component_sequence_id = p_component_seq_id
          AND brd.component_sequence_id = bic.old_component_sequence_id
          AND brd.component_reference_designator = p_ref_desig_name;

Line: 297

        SELECT 'Non-Standard Comp'
            INTO l_dummy
            FROM bom_inventory_Components bic
           WHERE bic.component_sequence_id = p_component_seq_id
             AND bic.bom_item_type IN (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/

Line: 321

      SELECT 'Planning Bill'
        INTO l_dummy
        FROM sys.dual
             WHERE EXISTS (SELECT 'Planning Item'
                 FROM bom_bill_of_materials bom,
                  mtl_system_items msi,
            bom_inventory_components bic
                WHERE msi.bom_item_type	= 3 /* PLANNING */
              AND msi.inventory_item_id = bom.assembly_item_id
                    AND msi.organization_id   = bom.organization_id
              AND bom.bill_sequence_id = bic.bill_sequence_id
              AND bic.component_sequence_id = p_component_seq_id
          );

Line: 418

            SELECT 'parent not disabled'
              INTO l_dummy
              FROM bom_inventory_components bic
            WHERE bic.component_sequence_id = p_component_seq_id
               AND NVL(bic.acd_type, 0)  <> 3;

Line: 448

       SELECT acd_type, old_component_sequence_id
       FROM bom_inventory_components bic
           WHERE bic.component_sequence_id = p_component_seq_id;

Line: 453

      SELECT component_quantity
              FROM bom_inventory_components
             WHERE component_sequence_id = p_component_seq_id
               AND quantity_related = 1;

Line: 496

         SELECT eec.change_notice
         FROM
           eng_engineering_changes eec,
	   eng_revised_items eri--eng_change_lines ecl
         WHERE eri.change_id/*cl.change_id*/ = eec.change_id
        -- AND  ecl.change_line_id = c_p_change_line_id;

Line: 521

       SELECT  person_first_name ||' '||person_last_name
       FROM hz_parties
       WHERE party_id = (SELECT customer_id FROM FND_USER
                  WHERE user_id = c_p_user_id);