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 CST_ITEM_COSTS

Line 18: from cst_item_costs cst

14: select cst.inventory_item_id, cst.organization_id, cst.cost_type_id,
15: cst.item_cost , cst.material_cost, cst.material_overhead_cost,
16: cst.resource_cost, cst.outside_processing_cost, cst.overhead_cost
17: --cicd.cost_element_id ,cicd.item_cost cicd_item_cost
18: from cst_item_costs cst
19: where cst.inventory_item_id = c_config_item_id
20: AND cst.organization_id = c_organization_id
21: AND cst.cost_type_id = c_cost_type;
22:

Line 104: Insert a row into the cst_item_costs_table

100: lStmtNumber number;
101: begin
102:
103: /*-------------------------------------------------------+
104: Insert a row into the cst_item_costs_table
105: +------------------------------------------------------- */
106:
107: lStmtNumber := 220;
108:

Line 109: insert into CST_ITEM_COSTS

105: +------------------------------------------------------- */
106:
107: lStmtNumber := 220;
108:
109: insert into CST_ITEM_COSTS
110: (inventory_item_id,
111: organization_id,
112: cost_type_id,
113: last_update_date,

Line 216: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS',2);

212: 0 -- C.attribute15
213: );
214:
215: IF PG_DEBUG <> 0 THEN
216: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS',2);
217:
218: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
219: END IF;
220:

Line 218: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);

214:
215: IF PG_DEBUG <> 0 THEN
216: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS',2);
217:
218: oe_debug_pub.add('populate_buy_cost: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
219: END IF;
220:
221: /*------ ----------------------------------------------+
222: Insert rows into the cst_item_cost_details table

Line 359: Insert a row into the cst_item_costs_table

355: lStmtNumber number;
356: begin
357:
358: /*-------------------------------------------------------+
359: Insert a row into the cst_item_costs_table
360: +------------------------------------------------------- */
361:
362: lStmtNumber := 220;
363: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 365: insert into CST_ITEM_COSTS

361:
362: lStmtNumber := 220;
363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: insert into CST_ITEM_COSTS
366: (inventory_item_id,
367: organization_id,
368: cost_type_id,
369: last_update_date,

Line 472: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS',2);

468: 0 -- C.attribute15
469: );
470:
471: IF PG_DEBUG <> 0 THEN
472: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS',2);
473:
474: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
475: END IF;
476:

Line 474: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);

470:
471: IF PG_DEBUG <> 0 THEN
472: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS',2);
473:
474: oe_debug_pub.add('populate_buy_cost_rollup: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
475: END IF;
476:
477: /*------ ----------------------------------------------+
478: Insert rows into the cst_item_cost_details table

Line 603: Insert a row into the cst_item_costs_table

599: l_cost_update number; --Bugfix 6363308
600: begin
601:
602: /*-------------------------------------------------------+
603: Insert a row into the cst_item_costs_table
604: +------------------------------------------------------- */
605:
606: lStmtNumber := 220;
607:

Line 616: insert into CST_ITEM_COSTS

612: --Bugfix 6363308
613:
614: lStmtNumber := 230;
615:
616: insert into CST_ITEM_COSTS
617: (inventory_item_id,
618: organization_id,
619: cost_type_id,
620: last_update_date,

Line 721: cst_item_costs C

717: C.attribute13,
718: C.attribute14,
719: C.attribute15
720: from
721: cst_item_costs C
722: where C.inventory_item_id = p_config_item_id
723: and C.organization_id = p_organization_id
724: and C.cost_type_id = p_cto_cost_type_id;
725:

Line 727: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);

723: and C.organization_id = p_organization_id
724: and C.cost_type_id = p_cto_cost_type_id;
725:
726: IF PG_DEBUG <> 0 THEN
727: oe_debug_pub.add('copy_ctocost_to_frozen: ' || 'after insert:CST_ITEM_COSTS' || sql%rowcount ,2);
728: END IF;
729:
730: /*------ ----------------------------------------------+
731: Insert rows into the cst_item_cost_details table

Line 1117: , cst_item_costs cic

1113: , mp1.cost_organization_id -- 3116778
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

Line 1145: , cst_item_costs cic

1141: , msi.organization_id
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

Line 1171: , cst_item_costs cic

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
1175: and cic.organization_id = msi.organization_id

Line 1181: v_item_cost cst_item_costs.item_cost%type ;

1177: and msi.inventory_item_id = xcfg_itm_id
1178: and msi.organization_id = xcfg_org_id;
1179:
1180:
1181: v_item_cost cst_item_costs.item_cost%type ;
1182: v_cto_cost cst_item_costs.item_cost%type ;
1183: v_material_cost cst_item_costs.material_cost%type ;
1184: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1185: v_resource_cost cst_item_costs.resource_cost%type ;

Line 1182: v_cto_cost cst_item_costs.item_cost%type ;

1178: and msi.organization_id = xcfg_org_id;
1179:
1180:
1181: v_item_cost cst_item_costs.item_cost%type ;
1182: v_cto_cost cst_item_costs.item_cost%type ;
1183: v_material_cost cst_item_costs.material_cost%type ;
1184: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1185: v_resource_cost cst_item_costs.resource_cost%type ;
1186: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;

Line 1183: v_material_cost cst_item_costs.material_cost%type ;

1179:
1180:
1181: v_item_cost cst_item_costs.item_cost%type ;
1182: v_cto_cost cst_item_costs.item_cost%type ;
1183: v_material_cost cst_item_costs.material_cost%type ;
1184: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1185: v_resource_cost cst_item_costs.resource_cost%type ;
1186: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1187: v_overhead_cost cst_item_costs.overhead_cost%type ;

Line 1184: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;

1180:
1181: v_item_cost cst_item_costs.item_cost%type ;
1182: v_cto_cost cst_item_costs.item_cost%type ;
1183: v_material_cost cst_item_costs.material_cost%type ;
1184: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1185: v_resource_cost cst_item_costs.resource_cost%type ;
1186: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1187: v_overhead_cost cst_item_costs.overhead_cost%type ;
1188:

Line 1185: v_resource_cost cst_item_costs.resource_cost%type ;

1181: v_item_cost cst_item_costs.item_cost%type ;
1182: v_cto_cost cst_item_costs.item_cost%type ;
1183: v_material_cost cst_item_costs.material_cost%type ;
1184: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1185: v_resource_cost cst_item_costs.resource_cost%type ;
1186: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1187: v_overhead_cost cst_item_costs.overhead_cost%type ;
1188:
1189: v_cost_updateable BOOLEAN := false ;

Line 1186: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;

1182: v_cto_cost cst_item_costs.item_cost%type ;
1183: v_material_cost cst_item_costs.material_cost%type ;
1184: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1185: v_resource_cost cst_item_costs.resource_cost%type ;
1186: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1187: v_overhead_cost cst_item_costs.overhead_cost%type ;
1188:
1189: v_cost_updateable BOOLEAN := false ;
1190:

Line 1187: v_overhead_cost cst_item_costs.overhead_cost%type ;

1183: v_material_cost cst_item_costs.material_cost%type ;
1184: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1185: v_resource_cost cst_item_costs.resource_cost%type ;
1186: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1187: v_overhead_cost cst_item_costs.overhead_cost%type ;
1188:
1189: v_cost_updateable BOOLEAN := false ;
1190:
1191:

Line 1509: from cst_item_costs

1505:
1506: /* Check whether buy cost exists for the item */
1507: begin
1508: select item_cost into v_buy_cost
1509: from cst_item_costs
1510: where cost_type_id = v_buy_cost_type_id
1511: and organization_id = c_org_id
1512: and inventory_item_id = c_config_item_id ;
1513:

Line 1676: select item_cost into v_cto_cost from cst_item_costs

1672:
1673: lStmtNumber := 38;
1674: begin
1675:
1676: select item_cost into v_cto_cost from cst_item_costs
1677: where inventory_item_id = c_match_config_item_id
1678: and organization_id = c_organization_id
1679: and cost_type_id = v_cto_cost_type_id ;
1680:

Line 1738: cst_item_costs cic

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
1742: and cic.organization_id = mp.cost_organization_id

Line 1960: delete from cst_item_costs

1956: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);
1957: END IF;
1958:
1959:
1960: delete from cst_item_costs
1961: where inventory_item_id = c_config_item_id
1962: and organization_id = c_organization_id
1963: and cost_type_id = 1 ;
1964:

Line 2125: , cst_item_costs cic

2121: from bom_cto_src_orgs bcso
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

Line 2158: , cst_item_costs cic

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
2162: and mp2.cost_organization_id = mp1.organization_id

Line 2183: from cst_item_costs cst, cst_item_cost_details cicd

2179: cursor c1_cst (c_inventory_item_id number) is
2180: select cst.inventory_item_id, cst.organization_id, cst.cost_type_id,
2181: cst.item_cost , cst.material_cost, cst.material_overhead_cost,
2182: cicd.cost_element_id ,cicd.item_cost cicd_item_cost
2183: from cst_item_costs cst, cst_item_cost_details cicd
2184: where cst.inventory_item_id = cicd.inventory_item_id
2185: and cst.organization_id = cicd.organization_id
2186: and cst.cost_type_id = cicd.cost_type_id
2187: and cst.inventory_item_id = c_inventory_item_id ;

Line 2197: v_item_cost cst_item_costs.item_cost%type ;

2193:
2194: -- debug 3116778
2195:
2196:
2197: v_item_cost cst_item_costs.item_cost%type ;
2198: v_material_cost cst_item_costs.material_cost%type ;
2199: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2200: v_resource_cost cst_item_costs.resource_cost%type ;
2201: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;

Line 2198: v_material_cost cst_item_costs.material_cost%type ;

2194: -- debug 3116778
2195:
2196:
2197: v_item_cost cst_item_costs.item_cost%type ;
2198: v_material_cost cst_item_costs.material_cost%type ;
2199: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2200: v_resource_cost cst_item_costs.resource_cost%type ;
2201: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2202: v_overhead_cost cst_item_costs.overhead_cost%type ;

Line 2199: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;

2195:
2196:
2197: v_item_cost cst_item_costs.item_cost%type ;
2198: v_material_cost cst_item_costs.material_cost%type ;
2199: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2200: v_resource_cost cst_item_costs.resource_cost%type ;
2201: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2202: v_overhead_cost cst_item_costs.overhead_cost%type ;
2203:

Line 2200: v_resource_cost cst_item_costs.resource_cost%type ;

2196:
2197: v_item_cost cst_item_costs.item_cost%type ;
2198: v_material_cost cst_item_costs.material_cost%type ;
2199: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2200: v_resource_cost cst_item_costs.resource_cost%type ;
2201: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2202: v_overhead_cost cst_item_costs.overhead_cost%type ;
2203:
2204: v_cost_updateable BOOLEAN := false ;

Line 2201: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;

2197: v_item_cost cst_item_costs.item_cost%type ;
2198: v_material_cost cst_item_costs.material_cost%type ;
2199: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2200: v_resource_cost cst_item_costs.resource_cost%type ;
2201: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2202: v_overhead_cost cst_item_costs.overhead_cost%type ;
2203:
2204: v_cost_updateable BOOLEAN := false ;
2205:

Line 2202: v_overhead_cost cst_item_costs.overhead_cost%type ;

2198: v_material_cost cst_item_costs.material_cost%type ;
2199: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2200: v_resource_cost cst_item_costs.resource_cost%type ;
2201: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2202: v_overhead_cost cst_item_costs.overhead_cost%type ;
2203:
2204: v_cost_updateable BOOLEAN := false ;
2205:
2206:

Line 2363: from cst_item_costs

2359:
2360: /* Check whether buy cost exists for the item */
2361: begin
2362: select item_cost into v_buy_cost
2363: from cst_item_costs
2364: where cost_type_id = v_buy_cost_type_id
2365: and organization_id = c_cost_org_id -- 3116778
2366: and inventory_item_id = c_config_item_id ;
2367:

Line 2541: cst_item_costs cic

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
2545: and bcso.organization_id = msi.organization_id

Line 2955: delete from cst_item_costs

2951: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);
2952: END IF;
2953:
2954:
2955: delete from cst_item_costs
2956: where inventory_item_id = c_config_item_id
2957: and organization_id = c_organization_id
2958: and cost_type_id = 1 ;
2959: