APPS.CTO_UPDATE_ITEMS_PK dependencies on CST_ITEM_COST_DETAILS

Line 41: | cst_item_cost_details

37: | 07-SEP-2004 Kiran Konada
38: | bugfix 3877097
39: | at lStmtNumber := 40,60,70,80
40: | during the insert into cst_item_costs and
41: | cst_item_cost_details
42: | mp1.cost_organization_id was being inserted
43: | BUT the NOT EXISTS condition was checking
44: | for mp1.organization_id.
45: | Fixed the above problem by using

Line 1402: cst_item_cost_details CICD,

1398: l_rt_cicd_summary.overhead_cost
1399: from
1400: mtl_parameters MP1,
1401: cst_item_costs C,
1402: cst_item_cost_details CICD,
1403: bom_cto_order_lines_upg bcolu
1404: where
1405: C.organization_id = MP1.organization_id
1406: and C.inventory_item_id = bcolu.inventory_item_id -- pModelId

Line 1880: Insert rows into the cst_item_cost_details table

1876:
1877:
1878:
1879: /*------ ----------------------------------------------+
1880: Insert rows into the cst_item_cost_details table
1881: +-----------------------------------------------------*/
1882:
1883: lStmtNumber := 70;
1884:

Line 1885: insert into cst_item_cost_details

1881: +-----------------------------------------------------*/
1882:
1883: lStmtNumber := 70;
1884:
1885: insert into cst_item_cost_details
1886: (inventory_item_id,
1887: cost_type_id,
1888: last_update_date,
1889: last_updated_by,

Line 1977: cst_item_cost_details C,

1973: C.attribute14,
1974: C.attribute15
1975: from
1976: mtl_parameters MP1,
1977: cst_item_cost_details C,
1978: mtl_system_items S,
1979: bom_cto_src_orgs bcso,
1980: bom_cto_order_lines_upg bcolu
1981: where bcolu.config_item_id is not null

Line 1995: from cst_item_cost_details

1991: and C.COST_TYPE_ID IN ( MP1.primary_cost_method, MP1.avg_rates_cost_type_id)
1992: and mp1.organization_id = bcso.organization_id
1993: and NOT EXISTS
1994: (select NULL
1995: from cst_item_cost_details
1996: where inventory_item_id = bcolu.config_item_id
1997: and organization_id = mp1.cost_organization_id --bugfix 3877097
1998: and COST_TYPE_ID IN (MP1.primary_cost_method, MP1.avg_rates_cost_type_id));
1999:

Line 2000: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);

1996: where inventory_item_id = bcolu.config_item_id
1997: and organization_id = mp1.cost_organization_id --bugfix 3877097
1998: and COST_TYPE_ID IN (MP1.primary_cost_method, MP1.avg_rates_cost_type_id));
1999:
2000: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);
2001:
2002:
2003: /* For standard costing orgs, we will copy model's user-defined
2004: cost in Frozen to the config in CTO cost type. */

Line 2007: insert into cst_item_cost_details

2003: /* For standard costing orgs, we will copy model's user-defined
2004: cost in Frozen to the config in CTO cost type. */
2005:
2006: lStmtNumber := 80;
2007: insert into cst_item_cost_details
2008: (inventory_item_id,
2009: cost_type_id,
2010: last_update_date,
2011: last_updated_by,

Line 2099: cst_item_cost_details C,

2095: C.attribute14,
2096: C.attribute15
2097: from
2098: mtl_parameters MP1,
2099: cst_item_cost_details C,
2100: mtl_system_items S,
2101: bom_cto_src_orgs bcso,
2102: bom_cto_order_lines_upg bcolu
2103: where bcolu.config_item_id is not null

Line 2118: from cst_item_cost_details

2114: and C.cost_type_id = 1
2115: and mp1.organization_id = bcso.organization_id
2116: and NOT EXISTS
2117: (select NULL
2118: from cst_item_cost_details
2119: where inventory_item_id = bcolu.config_item_id
2120: and organization_id = mp1.cost_organization_id --bugfix 3877097
2121: and COST_TYPE_ID = l_cto_cost_type_id);
2122: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);

Line 2122: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);

2118: from cst_item_cost_details
2119: where inventory_item_id = bcolu.config_item_id
2120: and organization_id = mp1.cost_organization_id --bugfix 3877097
2121: and COST_TYPE_ID = l_cto_cost_type_id);
2122: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);
2123:
2124:
2125: lStmtNumber := 90;
2126: