APPS.CSD_ESTIMATES_FROM_BOM_PVT SQL Statements

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

Line: 18

/*This takes in the Item to be expanded and inserts the explosion hierarchy	  */
/*to csd_bom_expl_tmp temp table. The temp table will be flushed whenever a	  */
/*commit is issued in the session or when a session closes.			  */
/*@ param: P_Item - The Name of the item to be expanded.			  */
/*@ param:p_alt_bom - Alternate, if any, for the item. Default null		  */
/*--------------------------------------------------------------------------------*/
PROCEDURE explode_bom_items(p_itemId IN NUMBER,p_alt_bom IN VARCHAR2 DEFAULT NULL ) IS

l_bom_exp_tab bompxinq.bomexporttabtype;

Line: 65

	select effectivity_control into l_effectivity_control
	from mtl_system_items_b
	where inventory_item_id = p_itemId
		 and organization_id = l_org_id;

Line: 71

	select min(unit_number),max(unit_number) into
               l_unit_number_from,l_unit_number_to
	from pjm_unit_numbers
	where  master_organization_id = fnd_profile.value('ORG_ID');

Line: 77

	SELECT MAXIMUM_BOM_LEVEL INTO l_max_level
        FROM BOM_PARAMETERS
        WHERE ORGANIZATION_ID = l_org_id;

Line: 81

	SELECT bom_explosion_temp_s.nextval INTO  l_group_id from dual;

Line: 83

	delete from  bom_small_expl_temp;

Line: 121

	delete from csd_bom_expl_temp;

Line: 122

     INSERT INTO csd_bom_expl_temp (
               TOP_BILL_SEQUENCE_ID      ,
               BILL_SEQUENCE_ID          ,
               COMMON_BILL_SEQUENCE_ID   ,
               ORGANIZATION_ID           ,
               COMPONENT_SEQUENCE_ID     ,
               COMPONENT_ITEM_ID         ,
               BASIS_TYPE		 ,
               COMPONENT_QUANTITY        ,
               PLAN_LEVEL                ,
               EXTENDED_QUANTITY         ,
               SORT_ORDER                ,
               GROUP_ID                  ,
               TOP_ALTERNATE_DESIGNATOR  ,
               COMPONENT_YIELD_FACTOR    ,
               TOP_ITEM_ID               ,
               COMPONENT_CODE            ,
               INCLUDE_IN_ROLLUP_FLAG    ,
               LOOP_FLAG                 ,
               PLANNING_FACTOR           ,
               OPERATION_SEQ_NUM         ,
               BOM_ITEM_TYPE             ,
               PARENT_BOM_ITEM_TYPE      ,
               ASSEMBLY_ITEM_ID          ,
               WIP_SUPPLY_TYPE           ,
               ITEM_NUM                  ,
               EFFECTIVITY_DATE          ,
               DISABLE_DATE              ,
               IMPLEMENTATION_DATE       ,
               OPTIONAL                  ,
               SUPPLY_SUBINVENTORY       ,
               SUPPLY_LOCATOR_ID         ,
               COMPONENT_REMARKS         ,
               CHANGE_NOTICE             ,
               OPERATION_LEAD_TIME_PERCENT,
               MUTUALLY_EXCLUSIVE_OPTIONS ,
               CHECK_ATP                  ,
               REQUIRED_TO_SHIP           ,
               REQUIRED_FOR_REVENUE       ,
               INCLUDE_ON_SHIP_DOCS       ,
               LOW_QUANTITY               ,
               HIGH_QUANTITY              ,
               SO_BASIS                   ,
               OPERATION_OFFSET           ,
               CURRENT_REVISION           ,
               LOCATOR                    ,
               CONTEXT                    ,
               ATTRIBUTE1                 ,
               ATTRIBUTE2                 ,
               ATTRIBUTE3                 ,
               ATTRIBUTE4                 ,
               ATTRIBUTE5                 ,
               ATTRIBUTE6                 ,
               ATTRIBUTE7                 ,
               ATTRIBUTE8                 ,
               ATTRIBUTE9                 ,
               ATTRIBUTE10                ,
               ATTRIBUTE11                ,
               ATTRIBUTE12                ,
               ATTRIBUTE13                ,
               ATTRIBUTE14                ,
               ATTRIBUTE15                ,
               ITEM_COST                  ,
               EXTEND_COST_FLAG
 	)

  Select
               TOP_BILL_SEQUENCE_ID      ,
               BILL_SEQUENCE_ID          ,
               COMMON_BILL_SEQUENCE_ID   ,
               ORGANIZATION_ID           ,
               COMPONENT_SEQUENCE_ID     ,
               COMPONENT_ITEM_ID         ,
               BASIS_TYPE		 ,
               COMPONENT_QUANTITY        ,
               PLAN_LEVEL                ,
               EXTENDED_QUANTITY         ,
               SORT_ORDER                ,
               GROUP_ID                  ,
               TOP_ALTERNATE_DESIGNATOR  ,
               COMPONENT_YIELD_FACTOR    ,
               TOP_ITEM_ID               ,
               COMPONENT_CODE            ,
               INCLUDE_IN_ROLLUP_FLAG    ,
               LOOP_FLAG                 ,
               PLANNING_FACTOR           ,
               OPERATION_SEQ_NUM         ,
               BOM_ITEM_TYPE             ,
               PARENT_BOM_ITEM_TYPE      ,
               ASSEMBLY_ITEM_ID          ,
               WIP_SUPPLY_TYPE           ,
               ITEM_NUM                  ,
               EFFECTIVITY_DATE          ,
               DISABLE_DATE              ,
               IMPLEMENTATION_DATE       ,
               OPTIONAL                  ,
               SUPPLY_SUBINVENTORY       ,
               SUPPLY_LOCATOR_ID         ,
               COMPONENT_REMARKS         ,
               CHANGE_NOTICE             ,
               OPERATION_LEAD_TIME_PERCENT,
               MUTUALLY_EXCLUSIVE_OPTIONS ,
               CHECK_ATP                  ,
               REQUIRED_TO_SHIP           ,
               REQUIRED_FOR_REVENUE       ,
               INCLUDE_ON_SHIP_DOCS       ,
               LOW_QUANTITY               ,
               HIGH_QUANTITY              ,
               SO_BASIS                   ,
               OPERATION_OFFSET           ,
               CURRENT_REVISION           ,
               LOCATOR                    ,
               CONTEXT                    ,
               ATTRIBUTE1                 ,
               ATTRIBUTE2                 ,
               ATTRIBUTE3                 ,
               ATTRIBUTE4                 ,
               ATTRIBUTE5                 ,
               ATTRIBUTE6                 ,
               ATTRIBUTE7                 ,
               ATTRIBUTE8                 ,
               ATTRIBUTE9                 ,
               ATTRIBUTE10                ,
               ATTRIBUTE11                ,
               ATTRIBUTE12                ,
               ATTRIBUTE13                ,
               ATTRIBUTE14                ,
               ATTRIBUTE15                ,
               ITEM_COST                  ,
               EXTEND_COST_FLAG
       from bom_small_expl_temp
       where group_id = l_group_id;

Line: 273

DELETE FROM csd_bom_expl_temp;

Line: 280

	INSERT INTO csd_bom_expl_temp (
       top_bill_sequence_id,
       bill_sequence_id,
       organization_id,
       component_sequence_id,
       component_item_id,
       plan_level,
       extended_quantity,
       sort_order,
       request_id,
       program_application_id,
       program_id,
       program_update_date,
       GROUP_ID,
       session_id,
       select_flag,
       select_quantity,
       extend_cost_flag,
       top_alternate_designator,
       top_item_id,
       CONTEXT,
       attribute1, attribute2,
       attribute3, attribute4,
       attribute5, attribute6,
       attribute7, attribute8,
       attribute9, attribute10,
       attribute11, attribute12,
       attribute13, attribute14,
       attribute15, header_id,
       line_id, list_price,
       selling_price,
       component_yield_factor,
       item_cost,
       include_in_rollup_flag,
       based_on_rollup_flag,
       actual_cost_type_id,
       component_quantity,
       shrinkage_rate, so_basis,
       optional,
       mutually_exclusive_options,
       check_atp, shipping_allowed,
       required_to_ship,
       required_for_revenue,
       include_on_ship_docs,
       include_on_bill_docs,
       low_quantity, high_quantity,
       pick_components,
       primary_uom_code,
       primary_unit_of_measure,
       base_item_id,
       atp_components_flag, atp_flag,
       bom_item_type,
       pick_components_flag,
       replenish_to_order_flag,
       shippable_item_flag,
       customer_order_flag,
       internal_order_flag,
       customer_order_enabled_flag,
       internal_order_enabled_flag,
       so_transactions_flag,
       mtl_transactions_enabled_flag,
       stock_enabled_flag,
       description, assembly_item_id,
       configurator_flag,
       price_list_id, rounding_factor,
       pricing_context,
       pricing_attribute1,
       pricing_attribute2,
       pricing_attribute3,
       pricing_attribute4,
       pricing_attribute5,
       pricing_attribute6,
       pricing_attribute7,
       pricing_attribute8,
       pricing_attribute9,
       pricing_attribute10,
       pricing_attribute11,
       pricing_attribute12,
       pricing_attribute13,
       pricing_attribute14,
       pricing_attribute15,
       component_code, loop_flag,
       inventory_asset_flag,
       planning_factor,
       operation_seq_num,
       parent_bom_item_type,
       wip_supply_type, item_num,
       effectivity_date, disable_date,
       implementation_date,
       supply_subinventory,
       supply_locator_id,
       component_remarks,
       change_notice,
       operation_lead_time_percent,
       rexplode_flag,
       common_bill_sequence_id,
       operation_offset,
       current_revision, LOCATOR,
       from_end_item_unit_number,
       to_end_item_unit_number,
       basis_type
 )
	VALUES (
       l_bom_exp_tab(i).top_bill_sequence_id,
       l_bom_exp_tab(i).bill_sequence_id,
       l_bom_exp_tab(i).organization_id,
       l_bom_exp_tab(i).component_sequence_id,
       l_bom_exp_tab(i).component_item_id,
       l_bom_exp_tab(i).plan_level,
       l_bom_exp_tab(i).extended_quantity,
       l_bom_exp_tab(i).sort_order,
       l_bom_exp_tab(i).request_id,
       l_bom_exp_tab(i).program_application_id,
       l_bom_exp_tab(i).program_id,
       l_bom_exp_tab(i).program_update_date,
       l_bom_exp_tab(i).GROUP_ID,
       l_bom_exp_tab(i).session_id,
       l_bom_exp_tab(i).select_flag,
       l_bom_exp_tab(i).select_quantity,
       l_bom_exp_tab(i).extend_cost_flag,
       l_bom_exp_tab(i).top_alternate_designator,
       l_bom_exp_tab(i).top_item_id,
       l_bom_exp_tab(i).CONTEXT,
       l_bom_exp_tab(i).attribute1, l_bom_exp_tab(i).attribute2,
       l_bom_exp_tab(i).attribute3, l_bom_exp_tab(i).attribute4,
       l_bom_exp_tab(i).attribute5, l_bom_exp_tab(i).attribute6,
       l_bom_exp_tab(i).attribute7, l_bom_exp_tab(i).attribute8,
       l_bom_exp_tab(i).attribute9, l_bom_exp_tab(i).attribute10,
       l_bom_exp_tab(i).attribute11, l_bom_exp_tab(i).attribute12,
       l_bom_exp_tab(i).attribute13, l_bom_exp_tab(i).attribute14,
       l_bom_exp_tab(i).attribute15, l_bom_exp_tab(i).header_id,
       l_bom_exp_tab(i).line_id, l_bom_exp_tab(i).list_price,
       l_bom_exp_tab(i).selling_price,
       l_bom_exp_tab(i).component_yield_factor,
       l_bom_exp_tab(i).item_cost,
       l_bom_exp_tab(i).include_in_rollup_flag,
       l_bom_exp_tab(i).based_on_rollup_flag,
       l_bom_exp_tab(i).actual_cost_type_id,
       l_bom_exp_tab(i).component_quantity,
       l_bom_exp_tab(i).shrinkage_rate, l_bom_exp_tab(i).so_basis,
       l_bom_exp_tab(i).optional,
       l_bom_exp_tab(i).mutually_exclusive_options,
       l_bom_exp_tab(i).check_atp, l_bom_exp_tab(i).shipping_allowed,
       l_bom_exp_tab(i).required_to_ship,
       l_bom_exp_tab(i).required_for_revenue,
       l_bom_exp_tab(i).include_on_ship_docs,
       l_bom_exp_tab(i).include_on_bill_docs,
       l_bom_exp_tab(i).low_quantity, l_bom_exp_tab(i).high_quantity,
       l_bom_exp_tab(i).pick_components,
       l_bom_exp_tab(i).primary_uom_code,
       l_bom_exp_tab(i).primary_unit_of_measure,
       l_bom_exp_tab(i).base_item_id,
       l_bom_exp_tab(i).atp_components_flag, l_bom_exp_tab(i).atp_flag,
       l_bom_exp_tab(i).bom_item_type,
       l_bom_exp_tab(i).pick_components_flag,
       l_bom_exp_tab(i).replenish_to_order_flag,
       l_bom_exp_tab(i).shippable_item_flag,
       l_bom_exp_tab(i).customer_order_flag,
       l_bom_exp_tab(i).internal_order_flag,
       l_bom_exp_tab(i).customer_order_enabled_flag,
       l_bom_exp_tab(i).internal_order_enabled_flag,
       l_bom_exp_tab(i).so_transactions_flag,
       l_bom_exp_tab(i).mtl_transactions_enabled_flag,
       l_bom_exp_tab(i).stock_enabled_flag,
       l_bom_exp_tab(i).description, l_bom_exp_tab(i).assembly_item_id,
       l_bom_exp_tab(i).configurator_flag,
       l_bom_exp_tab(i).price_list_id, l_bom_exp_tab(i).rounding_factor,
       l_bom_exp_tab(i).pricing_context,
       l_bom_exp_tab(i).pricing_attribute1,
       l_bom_exp_tab(i).pricing_attribute2,
       l_bom_exp_tab(i).pricing_attribute3,
       l_bom_exp_tab(i).pricing_attribute4,
       l_bom_exp_tab(i).pricing_attribute5,
       l_bom_exp_tab(i).pricing_attribute6,
       l_bom_exp_tab(i).pricing_attribute7,
       l_bom_exp_tab(i).pricing_attribute8,
       l_bom_exp_tab(i).pricing_attribute9,
       l_bom_exp_tab(i).pricing_attribute10,
       l_bom_exp_tab(i).pricing_attribute11,
       l_bom_exp_tab(i).pricing_attribute12,
       l_bom_exp_tab(i).pricing_attribute13,
       l_bom_exp_tab(i).pricing_attribute14,
       l_bom_exp_tab(i).pricing_attribute15,
       l_bom_exp_tab(i).component_code, l_bom_exp_tab(i).loop_flag,
       l_bom_exp_tab(i).inventory_asset_flag,
       l_bom_exp_tab(i).planning_factor,
       l_bom_exp_tab(i).operation_seq_num,
       l_bom_exp_tab(i).parent_bom_item_type,
       l_bom_exp_tab(i).wip_supply_type, l_bom_exp_tab(i).item_num,
       l_bom_exp_tab(i).effectivity_date, l_bom_exp_tab(i).disable_date,
       l_bom_exp_tab(i).implementation_date,
       l_bom_exp_tab(i).supply_subinventory,
       l_bom_exp_tab(i).supply_locator_id,
       l_bom_exp_tab(i).component_remarks,
       l_bom_exp_tab(i).change_notice,
       l_bom_exp_tab(i).operation_lead_time_percent,
       l_bom_exp_tab(i).rexplode_flag,
       l_bom_exp_tab(i).common_bill_sequence_id,
       l_bom_exp_tab(i).operation_offset,
       l_bom_exp_tab(i).current_revision, l_bom_exp_tab(i).LOCATOR,
       l_bom_exp_tab(i).from_end_item_unit_number,
       l_bom_exp_tab(i).to_end_item_unit_number,
       l_bom_exp_tab(i).basis_type
       ); */

Line: 571

		SELECT txn_billing_type_id,transaction_type_id
		INTO g_txn_billing_type_id,g_transaction_type_id
		FROM csd_repair_types_sar_vl
		WHERE repair_type_id = p_repair_type_id
		AND billing_type = 'M';

Line: 688

l_estimate_lines_rec.last_update_date          := null;

Line: 690

l_estimate_lines_rec.last_updated_by           := null;

Line: 692

l_estimate_lines_rec.last_update_login         := null;

Line: 886

			 select distinct h.contract_number
			 into g_contract_num
			 from --okc_k_headers_b h,
			      okc_k_headers_all_b h,
			      okc_k_lines_b l
			 where h.id = l.chr_id
			   and l.id = l_contract_line_id;

Line: 899

			SELECT business_process_id
		        INTO g_business_process_id
		        FROM csd_repair_types_b
		        WHERE repair_type_id = l_repair_type_id;

Line: 909

			SELECT distinct cov.contract_id
                        INTO l_contract_id
			FROM   oks_ent_coverages_v cov
		        WHERE  cov.contract_line_id = l_contract_line_id ;