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 1259: cst_item_cost_details CICD,

1255: l_rt_cicd_summary.overhead_cost
1256: from
1257: mtl_parameters MP1,
1258: cst_item_costs C,
1259: cst_item_cost_details CICD,
1260: bom_cto_order_lines_upg bcolu
1261: where
1262: C.organization_id = MP1.organization_id
1263: and C.inventory_item_id = bcolu.inventory_item_id -- pModelId

Line 1737: Insert rows into the cst_item_cost_details table

1733:
1734:
1735:
1736: /*------ ----------------------------------------------+
1737: Insert rows into the cst_item_cost_details table
1738: +-----------------------------------------------------*/
1739:
1740: lStmtNumber := 70;
1741:

Line 1742: insert into cst_item_cost_details

1738: +-----------------------------------------------------*/
1739:
1740: lStmtNumber := 70;
1741:
1742: insert into cst_item_cost_details
1743: (inventory_item_id,
1744: cost_type_id,
1745: last_update_date,
1746: last_updated_by,

Line 1834: cst_item_cost_details C,

1830: C.attribute14,
1831: C.attribute15
1832: from
1833: mtl_parameters MP1,
1834: cst_item_cost_details C,
1835: mtl_system_items S,
1836: bom_cto_src_orgs bcso,
1837: bom_cto_order_lines_upg bcolu
1838: where bcolu.config_item_id is not null

Line 1852: from cst_item_cost_details

1848: and C.COST_TYPE_ID IN ( MP1.primary_cost_method, MP1.avg_rates_cost_type_id)
1849: and mp1.organization_id = bcso.organization_id
1850: and NOT EXISTS
1851: (select NULL
1852: from cst_item_cost_details
1853: where inventory_item_id = bcolu.config_item_id
1854: and organization_id = mp1.cost_organization_id --bugfix 3877097
1855: and COST_TYPE_ID IN (MP1.primary_cost_method, MP1.avg_rates_cost_type_id));
1856:

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

1853: where inventory_item_id = bcolu.config_item_id
1854: and organization_id = mp1.cost_organization_id --bugfix 3877097
1855: and COST_TYPE_ID IN (MP1.primary_cost_method, MP1.avg_rates_cost_type_id));
1856:
1857: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);
1858:
1859:
1860: /* For standard costing orgs, we will copy model's user-defined
1861: cost in Frozen to the config in CTO cost type. */

Line 1864: insert into cst_item_cost_details

1860: /* For standard costing orgs, we will copy model's user-defined
1861: cost in Frozen to the config in CTO cost type. */
1862:
1863: lStmtNumber := 80;
1864: insert into cst_item_cost_details
1865: (inventory_item_id,
1866: cost_type_id,
1867: last_update_date,
1868: last_updated_by,

Line 1956: cst_item_cost_details C,

1952: C.attribute14,
1953: C.attribute15
1954: from
1955: mtl_parameters MP1,
1956: cst_item_cost_details C,
1957: mtl_system_items S,
1958: bom_cto_src_orgs bcso,
1959: bom_cto_order_lines_upg bcolu
1960: where bcolu.config_item_id is not null

Line 1975: from cst_item_cost_details

1971: and C.cost_type_id = 1
1972: and mp1.organization_id = bcso.organization_id
1973: and NOT EXISTS
1974: (select NULL
1975: from cst_item_cost_details
1976: where inventory_item_id = bcolu.config_item_id
1977: and organization_id = mp1.cost_organization_id --bugfix 3877097
1978: and COST_TYPE_ID = l_cto_cost_type_id);
1979: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);

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

1975: from cst_item_cost_details
1976: where inventory_item_id = bcolu.config_item_id
1977: and organization_id = mp1.cost_organization_id --bugfix 3877097
1978: and COST_TYPE_ID = l_cto_cost_type_id);
1979: WriteToLog('Inserted rows into cst_item_cost_details:: '||sql%rowcount,2);
1980:
1981:
1982: lStmtNumber := 90;
1983: