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_COSTS

Line 925: CST_PAC_ITEM_COSTS

921: IS
922: SELECT
923: cost_layer_id
924: FROM
925: CST_PAC_ITEM_COSTS
926: WHERE pac_period_id = c_period_id
927: AND cost_group_id = c_opp_cost_group_id
928: AND inventory_item_id = c_inventory_item_id;
929:

Line 1382: FROM cst_pac_item_costs cpic,

1378: SET variance_amount = (SELECT decode (sign(l_period_quantity),
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

Line 1462: FROM cst_pac_item_costs cpic

1458: decode (sign (l_period_quantity),
1459: 0, 0,
1460: (-1 * sign(cpicd.item_balance)), 0,
1461: cpicd.make_balance)
1462: FROM cst_pac_item_costs cpic
1463: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
1464: WHERE cpicd.cost_layer_id IN (select cost_layer_id
1465: from cst_pac_item_costs
1466: where inventory_item_id = p_inventory_item_id

Line 1465: from cst_pac_item_costs

1461: cpicd.make_balance)
1462: FROM cst_pac_item_costs cpic
1463: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
1464: WHERE cpicd.cost_layer_id IN (select cost_layer_id
1465: from cst_pac_item_costs
1466: where inventory_item_id = p_inventory_item_id
1467: and pac_period_id = p_pac_period_id
1468: and cost_group_id = p_cost_group_id)
1469: AND EXISTS (SELECT 1

Line 1484: UPDATE cst_pac_item_costs cpic

1480: AND cpllc.cost_group_id = p_cost_group_id
1481: AND cpllc.inventory_item_id = p_inventory_item_id);
1482:
1483: l_stmt_num := 60;
1484: UPDATE cst_pac_item_costs cpic
1485: SET (last_updated_by,
1486: last_update_date,
1487: last_update_login,
1488: request_id,

Line 1621: FROM cst_pac_item_costs cpic

1617: decode (sign (l_period_quantity),
1618: 0, 0,
1619: (-1 * sign(cpicd.item_balance)), 0,
1620: cpicd.make_balance)
1621: FROM cst_pac_item_costs cpic
1622: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
1623: WHERE cpicd.cost_layer_id IN (select cost_layer_id
1624: from cst_pac_item_costs
1625: where inventory_item_id = p_inventory_item_id

Line 1624: from cst_pac_item_costs

1620: cpicd.make_balance)
1621: FROM cst_pac_item_costs cpic
1622: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
1623: WHERE cpicd.cost_layer_id IN (select cost_layer_id
1624: from cst_pac_item_costs
1625: where inventory_item_id = p_inventory_item_id
1626: and pac_period_id = p_pac_period_id
1627: and cost_group_id = p_cost_group_id)
1628: AND EXISTS (SELECT 1

Line 1644: UPDATE cst_pac_item_costs cpic

1640: AND cpllc.cost_group_id = p_cost_group_id
1641: );
1642:
1643: l_stmt_num := 80;
1644: UPDATE cst_pac_item_costs cpic
1645: SET (last_updated_by,
1646: last_update_date,
1647: last_update_login,
1648: request_id,

Line 1900: cst_pac_item_costs cpic

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
1904: AND cppb.level_type = cpicd.level_type)

Line 2249: UPDATE cst_pac_item_costs cpic

2245: -- =================================================================
2246: -- Update layer costs information
2247: -- =================================================================
2248:
2249: UPDATE cst_pac_item_costs cpic
2250: SET (last_updated_by
2251: ,last_update_date
2252: ,last_update_login
2253: ,request_id

Line 3686: FROM cst_pac_item_costs cpic, cst_pac_intorg_itms_temp cos

3682: row_number() over (partition by cos.inventory_item_id order by cos.sequence_num
3683: ,nvl(cpic.total_layer_quantity,0)
3684: ,cos.cost_group_id
3685: ) sequence_num
3686: FROM cst_pac_item_costs cpic, cst_pac_intorg_itms_temp cos
3687: WHERE cpic.inventory_item_id(+) = cos.inventory_item_id
3688: AND cpic.cost_group_id(+) = cos.cost_group_id
3689: AND cpic.pac_period_id(+) = cos.pac_period_id
3690: AND cos.pac_period_id = p_period_id) Q

Line 4388: FROM cst_pac_item_costs cpic

4384:
4385: -- Set PWAC Item Cost in interorg items temp table
4386: UPDATE CST_PAC_INTORG_ITMS_TEMP
4387: SET item_cost = (SELECT nvl(item_cost,0)
4388: FROM cst_pac_item_costs cpic
4389: WHERE cpic.pac_period_id = p_period_id
4390: AND cpic.cost_group_id = p_cost_group_id
4391: AND cpic.inventory_item_id = p_inventory_item_id)
4392: WHERE pac_period_id = p_period_id

Line 6071: FROM cst_pac_item_costs cpic

6067: -- Set PWAC Item Cost in interorg items temp table
6068: -- after PCU value change
6069: UPDATE CST_PAC_INTORG_ITMS_TEMP
6070: SET item_cost = (SELECT nvl(item_cost,0)
6071: FROM cst_pac_item_costs cpic
6072: WHERE cpic.pac_period_id = p_period_id
6073: AND cpic.cost_group_id = l_optimal_cg_idx.cost_group_id
6074: AND cpic.inventory_item_id = l_inventory_item_id)
6075: WHERE pac_period_id = p_period_id