APPS.ENG_DEFAULT_REV_COMPONENT SQL Statements

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

Line: 33

	SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
	  FROM SYS.DUAL;

Line: 50

	SELECT To_End_Item_Unit_Number
	  FROM BOM_Inventory_Components
	 WHERE component_sequence_id =
		g_rev_comp_unexp_rec.old_component_sequence_id;

Line: 75

      SELECT nvl(max(item_num), 0) + P_Item_Seq_Increment default_seq
        FROM bom_inventory_components
       WHERE bill_sequence_id = g_rev_Comp_Unexp_rec.Bill_Sequence_Id;

Line: 96

      SELECT decode(pick_components_flag, 'Y', 1, 2) pick_comps
        FROM mtl_system_items
       WHERE inventory_item_id = g_rev_comp_Unexp_rec.component_item_id
         AND organization_id   = g_rev_comp_Unexp_rec.organization_id;

Line: 131

	SELECT scheduled_date
	  FROM eng_revised_items
	 WHERE revised_item_sequence_id =
	   g_Rev_Comp_Unexp_Rec.revised_item_sequence_id;

Line: 199

	SELECT default_include_in_rollup_flag
	  FROM mtl_system_items
	 WHERE inventory_item_id = g_Rev_Comp_Unexp_Rec.component_item_id
	   AND organization_id   = g_Rev_Comp_Unexp_Rec.organization_id;

Line: 231

	SELECT 1 atp_allowed
	  FROM mtl_system_items assy,
	       mtl_system_items comp
	 WHERE assy.organization_id     = g_Rev_Comp_Unexp_Rec.organization_id
	   AND assy.inventory_item_id   = g_Rev_Comp_Unexp_Rec.Revised_item_id
	   AND assy.atp_components_flag = 'Y'
	   AND comp.organization_id   = g_Rev_Comp_Unexp_Rec.organization_id
	   AND comp.inventory_item_id = g_Rev_Comp_Unexp_Rec.component_item_id
	   AND comp.atp_flag IN ( 'Y', 'C', 'R');

Line: 285

	SELECT bom_item_type
	  INTO l_bom_item_type
	  FROM mtl_system_items msi
	 WHERE msi.inventory_item_id = g_Rev_Comp_Unexp_rec.component_item_id
	   AND msi.organization_id   = g_Rev_Comp_Unexp_rec.organization_id;

Line: 306

       SELECT Bill_Sequence_Id
	 FROM bom_bill_of_materials bom
        WHERE bom.assembly_item_id =
	      g_Rev_Comp_Unexp_Rec.revised_item_id
	  AND bom.organization_id =
	      g_Rev_Comp_Unexp_Rec.organization_id
	  AND NVL(bom.alternate_bom_designator, 'NONE') =
	      NVL(g_rev_component_rec.alternate_bom_code, 'NONE');

Line: 316

	SELECT bill_sequence_id
	  FROM eng_revised_items
	 WHERE revised_item_sequence_id =
		g_rev_comp_unexp_rec.revised_item_sequence_id;

Line: 341

		SELECT BOM_INVENTORY_COMPONENTS_S.NextVal
        	  INTO l_Bill_Sequence_Id
        	  FROM SYS.DUAL;