DBA Data[Home] [Help]

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 809: mtl_parameters mp

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

Line 945: from mtl_parameters

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

Line 2079: From MTL_PARAMETERS

2075: From MTL_MATERIAL_TRANSACTIONS t
2076: Where Inventory_Item_Id = p_inventory_item_id
2077: And Exists
2078: (Select 'all these org have the org as costing org'
2079: From MTL_PARAMETERS
2080: Where Cost_Organization_Id = p_organization_id
2081: AND Organization_Id = t.Organization_Id);
2082:
2083: Cursor Check_Updateable_2 is

Line 2089: From MTL_PARAMETERS

2085: From MTL_MATERIAL_TRANSACTIONS_TEMP t
2086: Where Inventory_Item_Id = p_inventory_item_id
2087: And Exists
2088: (Select 'all these org have the org as costing org'
2089: From MTL_PARAMETERS
2090: Where Cost_Organization_Id = p_organization_id
2091: AND Organization_Id = t.Organization_Id);
2092:
2093: BEGIN

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

2192: lXErrorMessage varchar2(100);
2193: lXMessageName varchar2(100);
2194: lXTableName varchar2(100);
2195:
2196: v_primary_cost_method mtl_parameters.primary_cost_method%type := null ;
2197: v_cto_cost cst_item_costs.item_cost%type := null ;
2198: v_cto_cost_xudc cst_item_costs.item_cost%type := null ;
2199: v_valuation_cost cst_item_costs.item_cost%type := null ;
2200: v_buy_cost cst_item_costs.item_cost%type := null ;

Line 2258: from mtl_parameters mp1

2254:
2255: begin
2256:
2257: select mp1.primary_cost_method into v_primary_cost_method
2258: from mtl_parameters mp1
2259: where mp1.organization_id = p_cost_organization_id ; -- 3116778
2260:
2261: exception
2262: