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 918: CST_PAC_ITEM_COSTS

914: IS
915: SELECT
916: cost_layer_id
917: FROM
918: CST_PAC_ITEM_COSTS
919: WHERE pac_period_id = c_period_id
920: AND cost_group_id = c_opp_cost_group_id
921: AND inventory_item_id = c_inventory_item_id;
922:

Line 1276: FROM cst_pac_item_costs cpic,

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

Line 1356: FROM cst_pac_item_costs cpic

1352: decode (sign (l_period_quantity),
1353: 0, 0,
1354: (-1 * sign(cpicd.item_balance)), 0,
1355: cpicd.make_balance)
1356: FROM cst_pac_item_costs cpic
1357: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
1358: WHERE cpicd.cost_layer_id IN (select cost_layer_id
1359: from cst_pac_item_costs
1360: where inventory_item_id = p_inventory_item_id

Line 1359: from cst_pac_item_costs

1355: cpicd.make_balance)
1356: FROM cst_pac_item_costs cpic
1357: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
1358: WHERE cpicd.cost_layer_id IN (select cost_layer_id
1359: from cst_pac_item_costs
1360: where inventory_item_id = p_inventory_item_id
1361: and pac_period_id = p_pac_period_id
1362: and cost_group_id = p_cost_group_id)
1363: AND EXISTS (SELECT 1

Line 1378: UPDATE cst_pac_item_costs cpic

1374: AND cpllc.cost_group_id = p_cost_group_id
1375: AND cpllc.inventory_item_id = p_inventory_item_id);
1376:
1377: l_stmt_num := 60;
1378: UPDATE cst_pac_item_costs cpic
1379: SET (last_updated_by,
1380: last_update_date,
1381: last_update_login,
1382: request_id,

Line 1515: FROM cst_pac_item_costs cpic

1511: decode (sign (l_period_quantity),
1512: 0, 0,
1513: (-1 * sign(cpicd.item_balance)), 0,
1514: cpicd.make_balance)
1515: FROM cst_pac_item_costs cpic
1516: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
1517: WHERE cpicd.cost_layer_id IN (select cost_layer_id
1518: from cst_pac_item_costs
1519: where inventory_item_id = p_inventory_item_id

Line 1518: from cst_pac_item_costs

1514: cpicd.make_balance)
1515: FROM cst_pac_item_costs cpic
1516: WHERE cpic.cost_layer_id = cpicd.cost_layer_id)
1517: WHERE cpicd.cost_layer_id IN (select cost_layer_id
1518: from cst_pac_item_costs
1519: where inventory_item_id = p_inventory_item_id
1520: and pac_period_id = p_pac_period_id
1521: and cost_group_id = p_cost_group_id)
1522: AND EXISTS (SELECT 1

Line 1538: UPDATE cst_pac_item_costs cpic

1534: AND cpllc.cost_group_id = p_cost_group_id
1535: );
1536:
1537: l_stmt_num := 80;
1538: UPDATE cst_pac_item_costs cpic
1539: SET (last_updated_by,
1540: last_update_date,
1541: last_update_login,
1542: request_id,

Line 1784: cst_pac_item_costs cpic

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

Line 2115: UPDATE cst_pac_item_costs cpic

2111: -- =================================================================
2112: -- Update layer costs information
2113: -- =================================================================
2114:
2115: UPDATE cst_pac_item_costs cpic
2116: SET (last_updated_by
2117: ,last_update_date
2118: ,last_update_login
2119: ,request_id

Line 3530: FROM cst_pac_item_costs cpic, cst_pac_intorg_itms_temp cos

3526: row_number() over (partition by cos.inventory_item_id order by cos.sequence_num
3527: ,nvl(cpic.total_layer_quantity,0)
3528: ,cos.cost_group_id
3529: ) sequence_num
3530: FROM cst_pac_item_costs cpic, cst_pac_intorg_itms_temp cos
3531: WHERE cpic.inventory_item_id(+) = cos.inventory_item_id
3532: AND cpic.cost_group_id(+) = cos.cost_group_id
3533: AND cpic.pac_period_id(+) = cos.pac_period_id
3534: AND cos.pac_period_id = p_period_id) Q

Line 4155: FROM cst_pac_item_costs cpic

4151:
4152: -- Set PWAC Item Cost in interorg items temp table
4153: UPDATE CST_PAC_INTORG_ITMS_TEMP
4154: SET item_cost = (SELECT nvl(item_cost,0)
4155: FROM cst_pac_item_costs cpic
4156: WHERE cpic.pac_period_id = p_period_id
4157: AND cpic.cost_group_id = p_cost_group_id
4158: AND cpic.inventory_item_id = p_inventory_item_id)
4159: WHERE pac_period_id = p_period_id