eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_COST_PK dependencies on MTL_PARAMETERS

Line 316: from mtl_parameters mp

312: null , -- C.attribute12,
313: null , -- C.attribute13,
314: null , -- C.attribute14,
315: null -- C.attribute15
316: from mtl_parameters mp
317: where mp.organization_id = p_organization_id ;
318:
319: IF PG_DEBUG <> 0 THEN
320: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:cst_item_cost_details',2);

Line 572: from mtl_parameters mp

568: null , -- C.attribute12,
569: null , -- C.attribute13,
570: null , -- C.attribute14,
571: null -- C.attribute15
572: from mtl_parameters mp
573: where mp.organization_id = p_organization_id ;
574:
575: IF PG_DEBUG <> 0 THEN
576: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:cst_item_cost_details',2);

Line 959: From MTL_PARAMETERS

955: From MTL_MATERIAL_TRANSACTIONS t
956: Where Inventory_Item_Id = p_inventory_item_id
957: And Exists
958: (Select 'all these org have the org as costing org'
959: From MTL_PARAMETERS
960: Where Cost_Organization_Id = p_organization_id
961: AND Organization_Id = t.Organization_Id);
962:
963: Cursor Check_Updateable_2 is

Line 969: From MTL_PARAMETERS

965: From MTL_MATERIAL_TRANSACTIONS_TEMP t
966: Where Inventory_Item_Id = p_inventory_item_id
967: And Exists
968: (Select 'all these org have the org as costing org'
969: From MTL_PARAMETERS
970: Where Cost_Organization_Id = p_organization_id
971: AND Organization_Id = t.Organization_Id);
972:
973: BEGIN

Line 1118: , mtl_parameters mp1

1114: , nvl(org.operating_unit,0) oper_unit
1115: from inv_organization_info_v org
1116: , mtl_system_items msi
1117: , cst_item_costs cic
1118: , mtl_parameters mp1
1119: where org.organization_id = msi.organization_id
1120: and cic.inventory_item_id = msi.inventory_item_id
1121: and cic.organization_id = mp1.cost_organization_id --3116778
1122: and cic.based_on_rollup_flag = 1

Line 1146: , mtl_parameters mp

1142: , cic.cost_type_id
1143: , cic.item_cost
1144: from mtl_system_items msi
1145: , cst_item_costs cic
1146: , mtl_parameters mp
1147: where msi.organization_id = cic.organization_id
1148: and msi.inventory_item_id = cic.inventory_item_id
1149: and msi.organization_id = mp.organization_id
1150: and mp.primary_cost_method = cic.cost_type_id

Line 1170: , mtl_parameters mp

1166: is
1167: select msi.inventory_item_id
1168: , mp.cost_organization_id rollup_org_id
1169: from mtl_system_items msi
1170: , mtl_parameters mp
1171: , cst_item_costs cic
1172: where msi.organization_id = mp.organization_id
1173: and mp.primary_cost_method = 1
1174: and cic.inventory_item_id = msi.inventory_item_id

Line 1196: c_primary_cost_method mtl_parameters.primary_cost_method%type ;

1192: v_group_id bom_explosion_temp.group_id%type ;
1193: x_return_status varchar2(200) ;
1194:
1195:
1196: c_primary_cost_method mtl_parameters.primary_cost_method%type ;
1197: c_valuation_cost number;
1198:
1199:
1200: l_token CTO_MSG_PUB.token_tbl;

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

1212: l_cost_update_required varchar2(1) := 'N'; --Bugfix 6717614
1213:
1214: -- bug 13106676
1215: --
1216: v_primary_cost_method mtl_parameters.primary_cost_method%type := null ;
1217: v_is_cst_updatable BOOLEAN := TRUE;
1218:
1219: --Bugfix 12957444: New variables.
1220: --TYPE error_cache_tbl_type IS TABLE OF VARCHAR2(32767) INDEX BY LONG;

Line 1737: mtl_parameters mp ,

1733: gUserId,
1734: sysdate,
1735: gUserId
1736: from mtl_system_items msi,
1737: mtl_parameters mp ,
1738: cst_item_costs cic
1739: where msi.costing_enabled_flag = 'Y'
1740: and mp.organization_id = msi.organization_id
1741: and cic.inventory_item_id = msi.base_item_id

Line 1906: from mtl_parameters mp1

1902:
1903: -- bug 13106676
1904: --
1905: select mp1.primary_cost_method into v_primary_cost_method
1906: from mtl_parameters mp1
1907: where mp1.organization_id = c_organization_id ;
1908:
1909: IF PG_DEBUG <> 0 THEN
1910: oe_debug_pub.add('populate_buy_cost: ' || 'v_primary_cost_method = '||v_primary_cost_method);

Line 2103: c_cost_org_id mtl_parameters.cost_organization_id%type ; -- 3116778

2099: v_buy_cost number ;
2100: c_line_id bom_cto_src_orgs.line_id%type ;
2101: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
2102: c_config_item_id bom_cto_src_orgs.model_item_id%type ;
2103: c_cost_org_id mtl_parameters.cost_organization_id%type ; -- 3116778
2104: c_organization_id bom_cto_src_orgs.organization_id%type ;
2105: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;
2106: c_oper_unit inv_organization_info_v.operating_unit%type ;
2107:

Line 2126: , mtl_parameters mp1 /* master organization */

2122: , bom_cto_order_lines bcol
2123: , financials_system_params_all fsp
2124: , inv_organization_info_v org
2125: , cst_item_costs cic
2126: , mtl_parameters mp1 /* master organization */
2127: , mtl_parameters mp2
2128: where bcso.top_model_line_id = pTopAtoLineId
2129: and bcol.line_id = bcso.line_id
2130: and bcso.cost_rollup = 'Y'

Line 2127: , mtl_parameters mp2

2123: , financials_system_params_all fsp
2124: , inv_organization_info_v org
2125: , cst_item_costs cic
2126: , mtl_parameters mp1 /* master organization */
2127: , mtl_parameters mp2
2128: where bcso.top_model_line_id = pTopAtoLineId
2129: and bcol.line_id = bcso.line_id
2130: and bcso.cost_rollup = 'Y'
2131: and ( ( bcso.organization_type in (3,5) and bcol.config_creation in ( 1,2) )

Line 2156: , mtl_parameters mp1

2152: select distinct -- bug 3931290
2153: bcso.config_item_id
2154: , mp1.cost_organization_id rollup_org_id
2155: from bom_cto_src_orgs bcso
2156: , mtl_parameters mp1
2157: , mtl_parameters mp2
2158: , cst_item_costs cic
2159: where bcso.top_model_line_id = pTopAtoLineId
2160: and bcso.cost_rollup = 'Y'

Line 2157: , mtl_parameters mp2

2153: bcso.config_item_id
2154: , mp1.cost_organization_id rollup_org_id
2155: from bom_cto_src_orgs bcso
2156: , mtl_parameters mp1
2157: , mtl_parameters mp2
2158: , cst_item_costs cic
2159: where bcso.top_model_line_id = pTopAtoLineId
2160: and bcso.cost_rollup = 'Y'
2161: and bcso.organization_id = mp2.organization_id

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

2224: l_cost_update_required varchar2(1) := 'N'; --bug 6717614
2225:
2226: -- bug 13106676
2227: --
2228: v_primary_cost_method mtl_parameters.primary_cost_method%type := null ;
2229: v_is_cst_updatable BOOLEAN := TRUE;
2230: BEGIN
2231: lStmtNumber := 10;
2232:

Line 2540: mtl_parameters mp ,

2536: sysdate,
2537: gUserId
2538: from bom_cto_src_orgs bcso,
2539: mtl_system_items msi,
2540: mtl_parameters mp ,
2541: cst_item_costs cic
2542: where bcso.top_model_line_id = pTopAtoLineId
2543: and bcso.cost_rollup = 'Y'
2544: and bcso.config_item_id = msi.inventory_item_id

Line 2898: from mtl_parameters mp1

2894:
2895: -- bug 13106676
2896: --
2897: select mp1.primary_cost_method into v_primary_cost_method
2898: from mtl_parameters mp1
2899: where mp1.organization_id = c_organization_id ;
2900:
2901: IF PG_DEBUG <> 0 THEN
2902: oe_debug_pub.add('Cost_Rollup_ML: ' || 'v_primary_cost_method = '||v_primary_cost_method);