APPS.BOM_COMPARISON_TEMP_PKG SQL Statements

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

Line: 18

  cursor c1 is select bom1.common_bill_sequence_id
		 from BOM_BILL_OF_MATERIALS bom1
		where bom1.organization_id = X_Organization_Id1
	 	  and bom1.assembly_item_id = X_Assembly_Item_Id1
		  and nvl(bom1.alternate_bom_designator, 'NONE') =
		      nvl(X_Alternate1, 'NONE');

Line: 24

  cursor c2 is select bom2.common_bill_sequence_id
		 from BOM_BILL_OF_MATERIALS bom2
		where bom2.organization_id = X_Organization_Id2
	 	  and bom2.assembly_item_id = X_Assembly_Item_Id2
		  and nvl(bom2.alternate_bom_designator, 'NONE') =
		      nvl(X_Alternate2, 'NONE');

Line: 31

  select bom_comparison_temp_s.nextval
    into X_Sequence_Id
    from sys.dual;

Line: 48

	select assembly_type from bom_bill_of_materials bom
	 where bom.organization_id = X_Organization_Id
	   and bom.assembly_item_id = X_Assembly_Item_Id
	   and nvl(bom.alternate_bom_designator,'NONE') =
	       nvl(X_Alternate,'NONE');