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 1098: , cst_item_costs cic

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

Line 1126: , cst_item_costs cic

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

Line 1152: , cst_item_costs cic

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

Line 1162: v_item_cost cst_item_costs.item_cost%type ;

1158: and msi.inventory_item_id = xcfg_itm_id
1159: and msi.organization_id = xcfg_org_id;
1160:
1161:
1162: v_item_cost cst_item_costs.item_cost%type ;
1163: v_cto_cost cst_item_costs.item_cost%type ;
1164: v_material_cost cst_item_costs.material_cost%type ;
1165: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1166: v_resource_cost cst_item_costs.resource_cost%type ;

Line 1163: v_cto_cost cst_item_costs.item_cost%type ;

1159: and msi.organization_id = xcfg_org_id;
1160:
1161:
1162: v_item_cost cst_item_costs.item_cost%type ;
1163: v_cto_cost cst_item_costs.item_cost%type ;
1164: v_material_cost cst_item_costs.material_cost%type ;
1165: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1166: v_resource_cost cst_item_costs.resource_cost%type ;
1167: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;

Line 1164: v_material_cost cst_item_costs.material_cost%type ;

1160:
1161:
1162: v_item_cost cst_item_costs.item_cost%type ;
1163: v_cto_cost cst_item_costs.item_cost%type ;
1164: v_material_cost cst_item_costs.material_cost%type ;
1165: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1166: v_resource_cost cst_item_costs.resource_cost%type ;
1167: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1168: v_overhead_cost cst_item_costs.overhead_cost%type ;

Line 1165: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;

1161:
1162: v_item_cost cst_item_costs.item_cost%type ;
1163: v_cto_cost cst_item_costs.item_cost%type ;
1164: v_material_cost cst_item_costs.material_cost%type ;
1165: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1166: v_resource_cost cst_item_costs.resource_cost%type ;
1167: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1168: v_overhead_cost cst_item_costs.overhead_cost%type ;
1169:

Line 1166: v_resource_cost cst_item_costs.resource_cost%type ;

1162: v_item_cost cst_item_costs.item_cost%type ;
1163: v_cto_cost cst_item_costs.item_cost%type ;
1164: v_material_cost cst_item_costs.material_cost%type ;
1165: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1166: v_resource_cost cst_item_costs.resource_cost%type ;
1167: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1168: v_overhead_cost cst_item_costs.overhead_cost%type ;
1169:
1170: v_cost_updateable BOOLEAN := false ;

Line 1167: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;

1163: v_cto_cost cst_item_costs.item_cost%type ;
1164: v_material_cost cst_item_costs.material_cost%type ;
1165: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1166: v_resource_cost cst_item_costs.resource_cost%type ;
1167: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1168: v_overhead_cost cst_item_costs.overhead_cost%type ;
1169:
1170: v_cost_updateable BOOLEAN := false ;
1171:

Line 1168: v_overhead_cost cst_item_costs.overhead_cost%type ;

1164: v_material_cost cst_item_costs.material_cost%type ;
1165: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
1166: v_resource_cost cst_item_costs.resource_cost%type ;
1167: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
1168: v_overhead_cost cst_item_costs.overhead_cost%type ;
1169:
1170: v_cost_updateable BOOLEAN := false ;
1171:
1172:

Line 1457: from cst_item_costs

1453:
1454: /* Check whether buy cost exists for the item */
1455: begin
1456: select item_cost into v_buy_cost
1457: from cst_item_costs
1458: where cost_type_id = v_buy_cost_type_id
1459: and organization_id = c_org_id
1460: and inventory_item_id = c_config_item_id ;
1461:

Line 1624: select item_cost into v_cto_cost from cst_item_costs

1620:
1621: lStmtNumber := 38;
1622: begin
1623:
1624: select item_cost into v_cto_cost from cst_item_costs
1625: where inventory_item_id = c_match_config_item_id
1626: and organization_id = c_organization_id
1627: and cost_type_id = v_cto_cost_type_id ;
1628:

Line 1686: cst_item_costs cic

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

Line 1868: delete from cst_item_costs

1864: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);
1865: END IF;
1866:
1867:
1868: delete from cst_item_costs
1869: where inventory_item_id = c_config_item_id
1870: and organization_id = c_organization_id
1871: and cost_type_id = 1 ;
1872:

Line 2004: , cst_item_costs cic

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

Line 2037: , cst_item_costs cic

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

Line 2062: from cst_item_costs cst, cst_item_cost_details cicd

2058: cursor c1_cst (c_inventory_item_id number) is
2059: select cst.inventory_item_id, cst.organization_id, cst.cost_type_id,
2060: cst.item_cost , cst.material_cost, cst.material_overhead_cost,
2061: cicd.cost_element_id ,cicd.item_cost cicd_item_cost
2062: from cst_item_costs cst, cst_item_cost_details cicd
2063: where cst.inventory_item_id = cicd.inventory_item_id
2064: and cst.organization_id = cicd.organization_id
2065: and cst.cost_type_id = cicd.cost_type_id
2066: and cst.inventory_item_id = c_inventory_item_id ;

Line 2076: v_item_cost cst_item_costs.item_cost%type ;

2072:
2073: -- debug 3116778
2074:
2075:
2076: v_item_cost cst_item_costs.item_cost%type ;
2077: v_material_cost cst_item_costs.material_cost%type ;
2078: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2079: v_resource_cost cst_item_costs.resource_cost%type ;
2080: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;

Line 2077: v_material_cost cst_item_costs.material_cost%type ;

2073: -- debug 3116778
2074:
2075:
2076: v_item_cost cst_item_costs.item_cost%type ;
2077: v_material_cost cst_item_costs.material_cost%type ;
2078: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2079: v_resource_cost cst_item_costs.resource_cost%type ;
2080: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2081: v_overhead_cost cst_item_costs.overhead_cost%type ;

Line 2078: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;

2074:
2075:
2076: v_item_cost cst_item_costs.item_cost%type ;
2077: v_material_cost cst_item_costs.material_cost%type ;
2078: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2079: v_resource_cost cst_item_costs.resource_cost%type ;
2080: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2081: v_overhead_cost cst_item_costs.overhead_cost%type ;
2082:

Line 2079: v_resource_cost cst_item_costs.resource_cost%type ;

2075:
2076: v_item_cost cst_item_costs.item_cost%type ;
2077: v_material_cost cst_item_costs.material_cost%type ;
2078: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2079: v_resource_cost cst_item_costs.resource_cost%type ;
2080: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2081: v_overhead_cost cst_item_costs.overhead_cost%type ;
2082:
2083: v_cost_updateable BOOLEAN := false ;

Line 2080: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;

2076: v_item_cost cst_item_costs.item_cost%type ;
2077: v_material_cost cst_item_costs.material_cost%type ;
2078: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2079: v_resource_cost cst_item_costs.resource_cost%type ;
2080: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2081: v_overhead_cost cst_item_costs.overhead_cost%type ;
2082:
2083: v_cost_updateable BOOLEAN := false ;
2084:

Line 2081: v_overhead_cost cst_item_costs.overhead_cost%type ;

2077: v_material_cost cst_item_costs.material_cost%type ;
2078: v_material_overhead_cost cst_item_costs.material_overhead_cost%type ;
2079: v_resource_cost cst_item_costs.resource_cost%type ;
2080: v_outside_processing_cost cst_item_costs.outside_processing_cost%type ;
2081: v_overhead_cost cst_item_costs.overhead_cost%type ;
2082:
2083: v_cost_updateable BOOLEAN := false ;
2084:
2085:

Line 2238: from cst_item_costs

2234:
2235: /* Check whether buy cost exists for the item */
2236: begin
2237: select item_cost into v_buy_cost
2238: from cst_item_costs
2239: where cost_type_id = v_buy_cost_type_id
2240: and organization_id = c_cost_org_id -- 3116778
2241: and inventory_item_id = c_config_item_id ;
2242:

Line 2416: cst_item_costs cic

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

Line 2795: delete from cst_item_costs

2791: oe_debug_pub.add('deleted details ' || SQL%ROWCOUNT , 1);
2792: END IF;
2793:
2794:
2795: delete from cst_item_costs
2796: where inventory_item_id = c_config_item_id
2797: and organization_id = c_organization_id
2798: and cost_type_id = 1 ;
2799: