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.CST_PAC_ITERATION_PROCESS_PVT dependencies on CST_PAC_ITEM_COST_DETAILS

Line 1383: cst_pac_item_cost_details cpicd

1379: 0, cpicd.item_balance,
1380: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
1381: 0)
1382: FROM cst_pac_item_costs cpic,
1383: cst_pac_item_cost_details cpicd
1384: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
1385: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
1386: AND cpicd.cost_element_id = mpacd.cost_element_id
1387: AND cpicd.level_type = mpacd.level_type),

Line 1400: FROM cst_pac_item_cost_details cpicd

1396: AND mpacd.cost_group_id = p_cost_group_id
1397: AND mpacd.pac_period_id = p_pac_period_id
1398: AND mpacd.cost_layer_id = l_cost_layer_id_tbl(l_index)
1399: AND (cost_element_id, level_type) = (SELECT cost_element_id, level_type
1400: FROM cst_pac_item_cost_details cpicd
1401: WHERE cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
1402: AND cpicd.cost_element_id = mpacd.cost_element_id
1403: AND cpicd.level_type = mpacd.level_type);
1404:

Line 1411: UPDATE cst_pac_item_cost_details cpicd

1407: l_stmt_num := 50;
1408:
1409: IF (p_low_level_code = -1) THEN
1410: -- Items that do not have completion
1411: UPDATE cst_pac_item_cost_details cpicd
1412: SET (last_update_date,
1413: last_updated_by,
1414: last_update_login,
1415: request_id,

Line 1544: FROM cst_pac_item_cost_details cpicd

1540: SUM(item_buy_cost) ,
1541: SUM(item_make_cost),
1542: SUM(DECODE(cost_element_id,2,DECODE(level_type,2,item_cost,0),item_cost)) ,
1543: SUM(DECODE(cost_element_id,2,DECODE(level_type,1,item_cost,0),0))
1544: FROM cst_pac_item_cost_details cpicd
1545: WHERE cpicd.cost_layer_id = cpic.cost_layer_id)
1546: WHERE cpic.pac_period_id = p_pac_period_id
1547: AND cpic.cost_group_id = p_cost_group_id
1548: AND cpic.inventory_item_id = p_inventory_item_id

Line 1562: FROM cst_pac_item_cost_details cpicd

1558: AND cpllc.pac_period_id = p_pac_period_id
1559: AND cpllc.cost_group_id = p_cost_group_id)
1560: AND EXISTS
1561: (SELECT 'there is detail cost'
1562: FROM cst_pac_item_cost_details cpicd
1563: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
1564:
1565:
1566: ELSE

Line 1570: UPDATE cst_pac_item_cost_details cpicd

1566: ELSE
1567: -- low_level_code <> -1; items having completion
1568:
1569: l_stmt_num := 70;
1570: UPDATE cst_pac_item_cost_details cpicd
1571: SET (last_update_date,
1572: last_updated_by,
1573: last_update_login,
1574: request_id,

Line 1704: FROM cst_pac_item_cost_details cpicd

1700: SUM(item_buy_cost) ,
1701: SUM(item_make_cost),
1702: SUM(DECODE(cost_element_id,2,DECODE(level_type,2,item_cost,0),item_cost)) ,
1703: SUM(DECODE(cost_element_id,2,DECODE(level_type,1,item_cost,0),0))
1704: FROM cst_pac_item_cost_details cpicd
1705: WHERE cpicd.cost_layer_id = cpic.cost_layer_id)
1706: WHERE cpic.pac_period_id = p_pac_period_id
1707: AND cpic.cost_group_id = p_cost_group_id
1708: AND cpic.inventory_item_id = p_inventory_item_id

Line 1723: FROM cst_pac_item_cost_details cpicd

1719: AND cpllc.pac_period_id = p_pac_period_id
1720: AND cpllc.cost_group_id = p_cost_group_id)
1721: AND EXISTS
1722: (SELECT 'there is detail cost'
1723: FROM cst_pac_item_cost_details cpicd
1724: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
1725: END IF;
1726:
1727: FND_FILE.put_line

Line 1899: FROM cst_pac_item_cost_details cpicd,

1895: AND mpacd.cost_group_id = l_cost_group_id
1896: AND mpacd.cost_layer_id = cppb.cost_layer_id
1897: AND mpacd.cost_element_id = cppb.cost_element_id
1898: AND mpacd.level_type = cppb.level_type)
1899: FROM cst_pac_item_cost_details cpicd,
1900: cst_pac_item_costs cpic
1901: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
1902: AND cppb.cost_layer_id = cpicd.cost_layer_id
1903: AND cppb.cost_element_id = cpicd.cost_element_id

Line 1910: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

1906: AND cppb.cost_group_id = l_cost_group_id
1907: AND cppb.inventory_item_id = p_inventory_item_id
1908: AND cppb.txn_category = 8
1909: AND EXISTS (SELECT 1
1910: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
1911: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
1912: AND cppb.cost_element_id = cpicd1.cost_element_id
1913: AND cppb.level_type = cpicd1.level_type);
1914:

Line 1934: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

1930: AND cppb.cost_group_id = l_cost_group_id
1931: AND cppb.inventory_item_id = p_inventory_item_id
1932: AND cppb.txn_category = 9
1933: AND EXISTS (SELECT 1
1934: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
1935: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
1936: AND cppb.cost_element_id = cpicd1.cost_element_id
1937: AND cppb.level_type = cpicd1.level_type);
1938:

Line 2092: -- To update corresponding layers in cst_pac_item_cost_details

2088: -- PROCEDURE: Update_Cpicd_With_New_Values PRIVATE UTILITY
2089: -- PARAMETERS: p_pac_period_id
2090: -- p_inventory_item_id interorg item id
2091: -- COMMENT:
2092: -- To update corresponding layers in cst_pac_item_cost_details
2093: -- with new cost, new buy cost, new make cost from MPACD for the period
2094: -- To update layer cost information in CPIC
2095: -- NOTE: PAC Transactions belongs to current BOM level interorg item
2096: -- PRE-COND: none

Line 2180: UPDATE cst_pac_item_cost_details cpicd

2176:
2177: -- ========================================================
2178: -- Update cpicd with new cost, new buy cost, new make cost
2179: -- ========================================================
2180: UPDATE cst_pac_item_cost_details cpicd
2181: SET last_update_date = SYSDATE
2182: ,last_updated_by = FND_GLOBAL.user_id
2183: ,last_update_login = FND_GLOBAL.login_id
2184: ,request_id = FND_GLOBAL.conc_request_id

Line 2202: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd

2198: );
2199: END IF;
2200:
2201:
2202: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd
2203: (cost_layer_id,
2204: cost_element_id,
2205: level_type,
2206: last_update_date,

Line 2241: FROM cst_pac_item_cost_details cpicd1

2237: 0,
2238: 0
2239: FROM dual
2240: WHERE NOT EXISTS (SELECT 1
2241: FROM cst_pac_item_cost_details cpicd1
2242: WHERE cpicd1.cost_layer_id = mpacd_idx.cost_layer_id
2243: AND cpicd1.cost_element_id = mpacd_idx.cost_element_id
2244: AND cpicd1.level_type = mpacd_idx.level_type));
2245: -- =================================================================

Line 2310: FROM cst_pac_item_cost_details cpicd

2306: , SUM(item_buy_cost)
2307: , SUM(item_make_cost)
2308: , SUM(DECODE(cost_element_id,2,DECODE(level_type,2,item_cost,0),item_cost))
2309: , SUM(DECODE(cost_element_id,2,DECODE(level_type,1,item_cost,0),0))
2310: FROM cst_pac_item_cost_details cpicd
2311: WHERE cpicd.cost_layer_id = mpacd_idx.cost_layer_id
2312: GROUP BY cpicd.cost_layer_id)
2313: WHERE cpic.cost_layer_id = mpacd_idx.cost_layer_id
2314: AND EXISTS

Line 2316: FROM cst_pac_item_cost_details cpicd

2312: GROUP BY cpicd.cost_layer_id)
2313: WHERE cpic.cost_layer_id = mpacd_idx.cost_layer_id
2314: AND EXISTS
2315: (SELECT 'there is detail cost'
2316: FROM cst_pac_item_cost_details cpicd
2317: WHERE cpicd.cost_layer_id = mpacd_idx.cost_layer_id);
2318:
2319:
2320: END LOOP; -- end of mpacd temp loop