APPS.CTO_BOM_RTG_PK dependencies on MTL_PARAMETERS

Line 399: from bom_cto_src_orgs bcso, bom_cto_order_lines bcol, mtl_parameters mp

395: bcso.config_item_id,
396: bcso.group_reference_id
397: -- bcso.cost_rollup, bug 3877317 column will be queried in the cursor
398: -- bcso.organization_type bug 3877317 column will be queried in the cursor
399: from bom_cto_src_orgs bcso, bom_cto_order_lines bcol, mtl_parameters mp
400: where bcso.line_id = pLineId
401: and bcso.model_item_id = pModelId
402: and bcso.config_item_id is not null
403: and bcso.line_id = bcol.line_id

Line 409: v_primary_cost_method mtl_parameters.primary_cost_method%type := null ;

405:
406:
407:
408:
409: v_primary_cost_method mtl_parameters.primary_cost_method%type := null ;
410: v_cto_cost cst_item_costs.item_cost%type := null ;
411: v_cto_cost_xudc cst_item_costs.item_cost%type := null ;
412: v_valuation_cost cst_item_costs.item_cost%type := null ;
413: v_buy_cost cst_item_costs.item_cost%type := null ;

Line 806: mtl_parameters mp

802: into lEstRelDate
803: from bom_calendar_dates cal,
804: mtl_system_items msi,
805: bom_cto_order_lines bcol,
806: mtl_parameters mp
807: where msi.organization_id = lNextRec.organization_id
808: and msi.inventory_item_id = pModelId
809: and bcol.line_id = pLineId
810: and bcol.inventory_item_id = msi.inventory_item_id

Line 942: from mtl_parameters

938: END IF;
939:
940: select organization_code
941: into lOrg_code
942: from mtl_parameters
943: where organization_id = lNextRec.organization_id ;
944:
945: -- Bug Fix 519975
946:

Line 2019: From MTL_PARAMETERS

2015: From MTL_MATERIAL_TRANSACTIONS t
2016: Where Inventory_Item_Id = p_inventory_item_id
2017: And Exists
2018: (Select 'all these org have the org as costing org'
2019: From MTL_PARAMETERS
2020: Where Cost_Organization_Id = p_organization_id
2021: AND Organization_Id = t.Organization_Id);
2022:
2023: Cursor Check_Updateable_2 is

Line 2029: From MTL_PARAMETERS

2025: From MTL_MATERIAL_TRANSACTIONS_TEMP t
2026: Where Inventory_Item_Id = p_inventory_item_id
2027: And Exists
2028: (Select 'all these org have the org as costing org'
2029: From MTL_PARAMETERS
2030: Where Cost_Organization_Id = p_organization_id
2031: AND Organization_Id = t.Organization_Id);
2032:
2033: BEGIN

Line 2136: v_primary_cost_method mtl_parameters.primary_cost_method%type := null ;

2132: lXErrorMessage varchar2(100);
2133: lXMessageName varchar2(100);
2134: lXTableName varchar2(100);
2135:
2136: v_primary_cost_method mtl_parameters.primary_cost_method%type := null ;
2137: v_cto_cost cst_item_costs.item_cost%type := null ;
2138: v_cto_cost_xudc cst_item_costs.item_cost%type := null ;
2139: v_valuation_cost cst_item_costs.item_cost%type := null ;
2140: v_buy_cost cst_item_costs.item_cost%type := null ;

Line 2198: from mtl_parameters mp1

2194:
2195: begin
2196:
2197: select mp1.primary_cost_method into v_primary_cost_method
2198: from mtl_parameters mp1
2199: where mp1.organization_id = p_cost_organization_id ; -- 3116778
2200:
2201: exception
2202: