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 1277: cst_pac_item_cost_details cpicd

1273: 0, cpicd.item_balance,
1274: (-1 * sign(cpicd.item_balance)), cpicd.item_balance,
1275: 0)
1276: FROM cst_pac_item_costs cpic,
1277: cst_pac_item_cost_details cpicd
1278: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
1279: AND cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
1280: AND cpicd.cost_element_id = mpacd.cost_element_id
1281: AND cpicd.level_type = mpacd.level_type),

Line 1294: FROM cst_pac_item_cost_details cpicd

1290: AND mpacd.cost_group_id = p_cost_group_id
1291: AND mpacd.pac_period_id = p_pac_period_id
1292: AND mpacd.cost_layer_id = l_cost_layer_id_tbl(l_index)
1293: AND (cost_element_id, level_type) = (SELECT cost_element_id, level_type
1294: FROM cst_pac_item_cost_details cpicd
1295: WHERE cpicd.cost_layer_id = l_cost_layer_id_tbl (l_index)
1296: AND cpicd.cost_element_id = mpacd.cost_element_id
1297: AND cpicd.level_type = mpacd.level_type);
1298:

Line 1305: UPDATE cst_pac_item_cost_details cpicd

1301: l_stmt_num := 50;
1302:
1303: IF (p_low_level_code = -1) THEN
1304: -- Items that do not have completion
1305: UPDATE cst_pac_item_cost_details cpicd
1306: SET (last_update_date,
1307: last_updated_by,
1308: last_update_login,
1309: request_id,

Line 1438: FROM cst_pac_item_cost_details cpicd

1434: SUM(item_buy_cost) ,
1435: SUM(item_make_cost),
1436: SUM(DECODE(cost_element_id,2,DECODE(level_type,2,item_cost,0),item_cost)) ,
1437: SUM(DECODE(cost_element_id,2,DECODE(level_type,1,item_cost,0),0))
1438: FROM cst_pac_item_cost_details cpicd
1439: WHERE cpicd.cost_layer_id = cpic.cost_layer_id)
1440: WHERE cpic.pac_period_id = p_pac_period_id
1441: AND cpic.cost_group_id = p_cost_group_id
1442: AND cpic.inventory_item_id = p_inventory_item_id

Line 1456: FROM cst_pac_item_cost_details cpicd

1452: AND cpllc.pac_period_id = p_pac_period_id
1453: AND cpllc.cost_group_id = p_cost_group_id)
1454: AND EXISTS
1455: (SELECT 'there is detail cost'
1456: FROM cst_pac_item_cost_details cpicd
1457: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
1458:
1459:
1460: ELSE

Line 1464: UPDATE cst_pac_item_cost_details cpicd

1460: ELSE
1461: -- low_level_code <> -1; items having completion
1462:
1463: l_stmt_num := 70;
1464: UPDATE cst_pac_item_cost_details cpicd
1465: SET (last_update_date,
1466: last_updated_by,
1467: last_update_login,
1468: request_id,

Line 1598: FROM cst_pac_item_cost_details cpicd

1594: SUM(item_buy_cost) ,
1595: SUM(item_make_cost),
1596: SUM(DECODE(cost_element_id,2,DECODE(level_type,2,item_cost,0),item_cost)) ,
1597: SUM(DECODE(cost_element_id,2,DECODE(level_type,1,item_cost,0),0))
1598: FROM cst_pac_item_cost_details cpicd
1599: WHERE cpicd.cost_layer_id = cpic.cost_layer_id)
1600: WHERE cpic.pac_period_id = p_pac_period_id
1601: AND cpic.cost_group_id = p_cost_group_id
1602: AND cpic.inventory_item_id = p_inventory_item_id

Line 1617: FROM cst_pac_item_cost_details cpicd

1613: AND cpllc.pac_period_id = p_pac_period_id
1614: AND cpllc.cost_group_id = p_cost_group_id)
1615: AND EXISTS
1616: (SELECT 'there is detail cost'
1617: FROM cst_pac_item_cost_details cpicd
1618: WHERE cpicd.cost_layer_id = cpic.cost_layer_id);
1619: END IF;
1620:
1621: FND_FILE.put_line

Line 1783: FROM cst_pac_item_cost_details cpicd,

1779: AND mpacd.cost_group_id = l_cost_group_id
1780: AND mpacd.cost_layer_id = cppb.cost_layer_id
1781: AND mpacd.cost_element_id = cppb.cost_element_id
1782: AND mpacd.level_type = cppb.level_type)
1783: FROM cst_pac_item_cost_details cpicd,
1784: cst_pac_item_costs cpic
1785: WHERE cpic.cost_layer_id = cpicd.cost_layer_id
1786: AND cppb.cost_layer_id = cpicd.cost_layer_id
1787: AND cppb.cost_element_id = cpicd.cost_element_id

Line 1794: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

1790: AND cppb.cost_group_id = l_cost_group_id
1791: AND cppb.inventory_item_id = p_inventory_item_id
1792: AND cppb.txn_category = 8
1793: AND EXISTS (SELECT 1
1794: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
1795: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
1796: AND cppb.cost_element_id = cpicd1.cost_element_id
1797: AND cppb.level_type = cpicd1.level_type);
1798:

Line 1818: FROM CST_PAC_ITEM_COST_DETAILS cpicd1

1814: AND cppb.cost_group_id = l_cost_group_id
1815: AND cppb.inventory_item_id = p_inventory_item_id
1816: AND cppb.txn_category = 9
1817: AND EXISTS (SELECT 1
1818: FROM CST_PAC_ITEM_COST_DETAILS cpicd1
1819: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
1820: AND cppb.cost_element_id = cpicd1.cost_element_id
1821: AND cppb.level_type = cpicd1.level_type);
1822:

Line 1966: -- To update corresponding layers in cst_pac_item_cost_details

1962: -- PROCEDURE: Update_Cpicd_With_New_Values PRIVATE UTILITY
1963: -- PARAMETERS: p_pac_period_id
1964: -- p_inventory_item_id interorg item id
1965: -- COMMENT:
1966: -- To update corresponding layers in cst_pac_item_cost_details
1967: -- with new cost, new buy cost, new make cost from MPACD for the period
1968: -- To update layer cost information in CPIC
1969: -- NOTE: PAC Transactions belongs to current BOM level interorg item
1970: -- PRE-COND: none

Line 2054: UPDATE cst_pac_item_cost_details cpicd

2050:
2051: -- ========================================================
2052: -- Update cpicd with new cost, new buy cost, new make cost
2053: -- ========================================================
2054: UPDATE cst_pac_item_cost_details cpicd
2055: SET last_update_date = SYSDATE
2056: ,last_updated_by = FND_GLOBAL.user_id
2057: ,last_update_login = FND_GLOBAL.login_id
2058: ,request_id = FND_GLOBAL.conc_request_id

Line 2068: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd

2064: WHERE cpicd.cost_layer_id = mpacd_idx.cost_layer_id
2065: AND cpicd.cost_element_id = mpacd_idx.cost_element_id
2066: AND cpicd.level_type = mpacd_idx.level_type;
2067:
2068: INSERT INTO CST_PAC_ITEM_COST_DETAILS cpicd
2069: (cost_layer_id,
2070: cost_element_id,
2071: level_type,
2072: last_update_date,

Line 2107: FROM cst_pac_item_cost_details cpicd1

2103: 0,
2104: 0
2105: FROM dual
2106: WHERE NOT EXISTS (SELECT 1
2107: FROM cst_pac_item_cost_details cpicd1
2108: WHERE cpicd1.cost_layer_id = mpacd_idx.cost_layer_id
2109: AND cpicd1.cost_element_id = mpacd_idx.cost_element_id
2110: AND cpicd1.level_type = mpacd_idx.level_type));
2111: -- =================================================================

Line 2176: FROM cst_pac_item_cost_details cpicd

2172: , SUM(item_buy_cost)
2173: , SUM(item_make_cost)
2174: , SUM(DECODE(cost_element_id,2,DECODE(level_type,2,item_cost,0),item_cost))
2175: , SUM(DECODE(cost_element_id,2,DECODE(level_type,1,item_cost,0),0))
2176: FROM cst_pac_item_cost_details cpicd
2177: WHERE cpicd.cost_layer_id = mpacd_idx.cost_layer_id
2178: GROUP BY cpicd.cost_layer_id)
2179: WHERE cpic.cost_layer_id = mpacd_idx.cost_layer_id
2180: AND EXISTS

Line 2182: FROM cst_pac_item_cost_details cpicd

2178: GROUP BY cpicd.cost_layer_id)
2179: WHERE cpic.cost_layer_id = mpacd_idx.cost_layer_id
2180: AND EXISTS
2181: (SELECT 'there is detail cost'
2182: FROM cst_pac_item_cost_details cpicd
2183: WHERE cpicd.cost_layer_id = mpacd_idx.cost_layer_id);
2184:
2185:
2186: END LOOP; -- end of mpacd temp loop