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 1099: , mtl_parameters mp1

1095: , nvl(org.operating_unit,0) oper_unit
1096: from inv_organization_info_v org
1097: , mtl_system_items msi
1098: , cst_item_costs cic
1099: , mtl_parameters mp1
1100: where org.organization_id = msi.organization_id
1101: and cic.inventory_item_id = msi.inventory_item_id
1102: and cic.organization_id = mp1.cost_organization_id --3116778
1103: and cic.based_on_rollup_flag = 1

Line 1127: , mtl_parameters mp

1123: , cic.cost_type_id
1124: , cic.item_cost
1125: from mtl_system_items msi
1126: , cst_item_costs cic
1127: , mtl_parameters mp
1128: where msi.organization_id = cic.organization_id
1129: and msi.inventory_item_id = cic.inventory_item_id
1130: and msi.organization_id = mp.organization_id
1131: and mp.primary_cost_method = cic.cost_type_id

Line 1151: , mtl_parameters mp

1147: is
1148: select msi.inventory_item_id
1149: , mp.cost_organization_id rollup_org_id
1150: from mtl_system_items msi
1151: , mtl_parameters mp
1152: , cst_item_costs cic
1153: where msi.organization_id = mp.organization_id
1154: and mp.primary_cost_method = 1
1155: and cic.inventory_item_id = msi.inventory_item_id

Line 1177: c_primary_cost_method mtl_parameters.primary_cost_method%type ;

1173: v_group_id bom_explosion_temp.group_id%type ;
1174: x_return_status varchar2(200) ;
1175:
1176:
1177: c_primary_cost_method mtl_parameters.primary_cost_method%type ;
1178: c_valuation_cost number;
1179:
1180:
1181: l_token CTO_MSG_PUB.token_tbl;

Line 1685: mtl_parameters mp ,

1681: gUserId,
1682: sysdate,
1683: gUserId
1684: from mtl_system_items msi,
1685: mtl_parameters mp ,
1686: cst_item_costs cic
1687: where msi.costing_enabled_flag = 'Y'
1688: and mp.organization_id = msi.organization_id
1689: and cic.inventory_item_id = msi.base_item_id

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

1978: v_buy_cost number ;
1979: c_line_id bom_cto_src_orgs.line_id%type ;
1980: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
1981: c_config_item_id bom_cto_src_orgs.model_item_id%type ;
1982: c_cost_org_id mtl_parameters.cost_organization_id%type ; -- 3116778
1983: c_organization_id bom_cto_src_orgs.organization_id%type ;
1984: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;
1985: c_oper_unit inv_organization_info_v.operating_unit%type ;
1986:

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

2001: , bom_cto_order_lines bcol
2002: , financials_system_params_all fsp
2003: , inv_organization_info_v org
2004: , cst_item_costs cic
2005: , mtl_parameters mp1 /* master organization */
2006: , mtl_parameters mp2
2007: where bcso.top_model_line_id = pTopAtoLineId
2008: and bcol.line_id = bcso.line_id
2009: and bcso.cost_rollup = 'Y'

Line 2006: , mtl_parameters mp2

2002: , financials_system_params_all fsp
2003: , inv_organization_info_v org
2004: , cst_item_costs cic
2005: , mtl_parameters mp1 /* master organization */
2006: , mtl_parameters mp2
2007: where bcso.top_model_line_id = pTopAtoLineId
2008: and bcol.line_id = bcso.line_id
2009: and bcso.cost_rollup = 'Y'
2010: and ( ( bcso.organization_type in (3,5) and bcol.config_creation in ( 1,2) )

Line 2035: , mtl_parameters mp1

2031: select distinct -- bug 3931290
2032: bcso.config_item_id
2033: , mp1.cost_organization_id rollup_org_id
2034: from bom_cto_src_orgs bcso
2035: , mtl_parameters mp1
2036: , mtl_parameters mp2
2037: , cst_item_costs cic
2038: where bcso.top_model_line_id = pTopAtoLineId
2039: and bcso.cost_rollup = 'Y'

Line 2036: , mtl_parameters mp2

2032: bcso.config_item_id
2033: , mp1.cost_organization_id rollup_org_id
2034: from bom_cto_src_orgs bcso
2035: , mtl_parameters mp1
2036: , mtl_parameters mp2
2037: , cst_item_costs cic
2038: where bcso.top_model_line_id = pTopAtoLineId
2039: and bcso.cost_rollup = 'Y'
2040: and bcso.organization_id = mp2.organization_id

Line 2415: mtl_parameters mp ,

2411: sysdate,
2412: gUserId
2413: from bom_cto_src_orgs bcso,
2414: mtl_system_items msi,
2415: mtl_parameters mp ,
2416: cst_item_costs cic
2417: where bcso.top_model_line_id = pTopAtoLineId
2418: and bcso.cost_rollup = 'Y'
2419: and bcso.config_item_id = msi.inventory_item_id