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 MTL_PAC_ACTUAL_COST_DETAILS

Line 1275: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE

1271:
1272: l_routine CONSTANT VARCHAR2(30) := 'calc_pmac_for_interorg';
1273:
1274: l_stmt_num NUMBER;
1275: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
1276: INDEX BY BINARY_INTEGER;
1277: TYPE t_txn_category_tbl IS TABLE OF CST_PAC_PERIOD_BALANCES.txn_category%TYPE
1278: INDEX BY BINARY_INTEGER;
1279: l_last_txn_id_tbl t_txn_id_tbl;

Line 1321: FROM mtl_pac_actual_cost_details mpacd

1317: l_stmt_num := 10;
1318: SELECT distinct cost_layer_id, mpacd.transaction_id
1319: BULK COLLECT
1320: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl
1321: FROM mtl_pac_actual_cost_details mpacd
1322: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
1323: FROM mtl_pac_actual_cost_details mpacd1
1324: WHERE mpacd1.txn_category = 8
1325: AND mpacd1.inventory_item_id = mpacd.inventory_item_id

Line 1323: FROM mtl_pac_actual_cost_details mpacd1

1319: BULK COLLECT
1320: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl
1321: FROM mtl_pac_actual_cost_details mpacd
1322: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
1323: FROM mtl_pac_actual_cost_details mpacd1
1324: WHERE mpacd1.txn_category = 8
1325: AND mpacd1.inventory_item_id = mpacd.inventory_item_id
1326: AND mpacd1.pac_period_id = p_pac_period_id
1327: AND mpacd1.cost_group_id = p_cost_group_id)

Line 1342: FROM mtl_pac_actual_cost_details mpacd

1338: l_stmt_num := 20;
1339: SELECT distinct cost_layer_id, mpacd.transaction_id
1340: BULK COLLECT
1341: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl
1342: FROM mtl_pac_actual_cost_details mpacd
1343: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
1344: FROM mtl_pac_actual_cost_details mpacd1
1345: WHERE mpacd1.txn_category = 8
1346: AND mpacd1.inventory_item_id = mpacd.inventory_item_id

Line 1344: FROM mtl_pac_actual_cost_details mpacd1

1340: BULK COLLECT
1341: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl
1342: FROM mtl_pac_actual_cost_details mpacd
1343: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
1344: FROM mtl_pac_actual_cost_details mpacd1
1345: WHERE mpacd1.txn_category = 8
1346: AND mpacd1.inventory_item_id = mpacd.inventory_item_id
1347: AND mpacd1.pac_period_id = p_pac_period_id
1348: AND mpacd1.cost_group_id = p_cost_group_id)

Line 1377: UPDATE mtl_pac_actual_cost_details mpacd

1373: processed.
1374: ****************************************************************************/
1375: l_stmt_num := 30;
1376: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
1377: UPDATE mtl_pac_actual_cost_details mpacd
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)

Line 1876: FROM mtl_pac_actual_cost_details mpacd,

1872: p_prg_appid,
1873: p_prg_id,
1874: sysdate,
1875: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1876: FROM mtl_pac_actual_cost_details mpacd,
1877: mtl_material_transactions mmt
1878: WHERE mpacd.txn_category = 8
1879: AND mpacd.inventory_item_id = p_inventory_item_id
1880: AND mpacd.pac_period_id = p_pac_period_id

Line 1891: FROM mtl_pac_actual_cost_details mpacd

1887: l_period_quantity,
1888: l_period_quantity * cpicd.item_cost,
1889: cpicd.item_cost,
1890: (SELECT sum (nvl (mpacd.variance_amount, 0))
1891: FROM mtl_pac_actual_cost_details mpacd
1892: WHERE mpacd.txn_category = 8
1893: AND mpacd.inventory_item_id = p_inventory_item_id
1894: AND mpacd.pac_period_id = p_pac_period_id
1895: AND mpacd.cost_group_id = l_cost_group_id

Line 1918: FROM mtl_pac_actual_cost_details mpacd,

1914:
1915: UPDATE CST_PAC_PERIOD_BALANCES cppb
1916: SET txn_category_value =
1917: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1918: FROM mtl_pac_actual_cost_details mpacd,
1919: mtl_material_transactions mmt
1920: WHERE mpacd.txn_category = 9
1921: AND mpacd.inventory_item_id = cppb.inventory_item_id
1922: AND mpacd.pac_period_id = cppb.pac_period_id

Line 1993: INSERT INTO MTL_PAC_ACTUAL_COST_DETAILS

1989: , l_routine || '<'
1990: );
1991: END IF;
1992:
1993: INSERT INTO MTL_PAC_ACTUAL_COST_DETAILS
1994: ( COST_GROUP_ID
1995: , TRANSACTION_ID
1996: , PAC_PERIOD_ID
1997: , COST_TYPE_ID

Line 2119: FROM mtl_pac_actual_cost_details mpacd, cst_pac_intorg_itms_temp cpiit

2115: DISTINCT mpacd.cost_layer_id
2116: , mpacd.cost_group_id
2117: , mpacd.cost_element_id
2118: , mpacd.level_type
2119: FROM mtl_pac_actual_cost_details mpacd, cst_pac_intorg_itms_temp cpiit
2120: WHERE cpiit.pac_period_id = c_pac_period_id
2121: AND cpiit.inventory_item_id = c_inventory_item_id
2122: AND cpiit.cost_group_id = nvl(c_cost_group_id, cpiit.cost_group_id)
2123: AND cpiit.diverging_flag = 'N'

Line 3987: TYPE t_txn_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE

3983: l_error_msg VARCHAR2(240);
3984: l_return_status VARCHAR2(1);
3985: l_txn_category NUMBER;
3986:
3987: TYPE t_txn_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3988: INDEX BY BINARY_INTEGER;
3989: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE
3990: INDEX BY BINARY_INTEGER;
3991: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE

Line 3989: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE

3985: l_txn_category NUMBER;
3986:
3987: TYPE t_txn_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3988: INDEX BY BINARY_INTEGER;
3989: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE
3990: INDEX BY BINARY_INTEGER;
3991: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE
3992: INDEX BY BINARY_INTEGER;
3993: TYPE t_variance_amt_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.variance_amount%TYPE

Line 3991: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE

3987: TYPE t_txn_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3988: INDEX BY BINARY_INTEGER;
3989: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE
3990: INDEX BY BINARY_INTEGER;
3991: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE
3992: INDEX BY BINARY_INTEGER;
3993: TYPE t_variance_amt_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.variance_amount%TYPE
3994: INDEX BY BINARY_INTEGER;
3995:

Line 3993: TYPE t_variance_amt_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.variance_amount%TYPE

3989: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE
3990: INDEX BY BINARY_INTEGER;
3991: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE
3992: INDEX BY BINARY_INTEGER;
3993: TYPE t_variance_amt_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.variance_amount%TYPE
3994: INDEX BY BINARY_INTEGER;
3995:
3996: l_txn_id_tbl t_txn_id_tbl_type;
3997: l_cost_element_id_tbl t_cost_element_id_tbl_type;

Line 4174: FROM MTL_PAC_ACTUAL_COST_DETAILS

4170: , l_group1_interorg_tab(i).transfer_transaction_id
4171: , decode(cost_element_id,2,
4172: decode(level_type,1,l_group1_interorg_tab(i).transportation_cost,0),0)
4173: , 0
4174: FROM MTL_PAC_ACTUAL_COST_DETAILS
4175: WHERE transaction_id = l_group1_interorg_tab(i).transaction_id
4176: AND cost_group_id = p_cost_group_id
4177: AND pac_period_id = p_period_id
4178: AND cost_type_id = p_cost_type_id;

Line 4227: FROM MTL_PAC_ACTUAL_COST_DETAILS

4223: , l_group1_interorg_tab(i).transfer_transaction_id
4224: , 0
4225: , 0
4226: FROM (SELECT *
4227: FROM MTL_PAC_ACTUAL_COST_DETAILS
4228: WHERE transaction_id = l_group1_interorg_tab(i).transaction_id
4229: AND cost_group_id = p_cost_group_id
4230: AND pac_period_id = p_period_id
4231: AND cost_type_id = p_cost_type_id

Line 4344: FROM MTL_PAC_ACTUAL_COST_DETAILS

4340: -- =====================================
4341: SELECT transaction_id, cost_element_id, level_type,variance_amount
4342: BULK COLLECT
4343: INTO l_txn_id_tbl, l_cost_element_id_tbl, l_level_type_tbl,l_variance_amt_tbl
4344: FROM MTL_PAC_ACTUAL_COST_DETAILS
4345: WHERE pac_period_id = p_period_id
4346: AND cost_type_id = p_cost_type_id
4347: AND cost_group_id = p_cost_group_id
4348: AND inventory_item_id = p_inventory_item_id;

Line 4645: FROM MTL_PAC_ACTUAL_COST_DETAILS

4641: , l_group2_interorg_tab(i).transfer_transaction_id
4642: , decode(cost_element_id,2,
4643: decode(level_type,1,l_group2_interorg_tab(i).transportation_cost,0),0)
4644: , 0
4645: FROM MTL_PAC_ACTUAL_COST_DETAILS
4646: WHERE transaction_id = l_group2_interorg_tab(i).transaction_id
4647: AND cost_group_id = p_cost_group_id
4648: AND pac_period_id = p_period_id
4649: AND cost_type_id = p_cost_type_id;

Line 4696: FROM MTL_PAC_ACTUAL_COST_DETAILS

4692: , l_group2_interorg_tab(i).transfer_transaction_id
4693: , 0
4694: , 0
4695: FROM (SELECT *
4696: FROM MTL_PAC_ACTUAL_COST_DETAILS
4697: WHERE transaction_id = l_group2_interorg_tab(i).transaction_id
4698: AND cost_group_id = p_cost_group_id
4699: AND pac_period_id = p_period_id
4700: AND cost_type_id = p_cost_type_id

Line 6196: DELETE FROM mtl_pac_actual_cost_details mpacd

6192: -- iterations exist
6193: -- ===================================================================
6194: IF l_iteration_num = 1 AND p_iteration_proc_flag = 'Y' THEN
6195:
6196: DELETE FROM mtl_pac_actual_cost_details mpacd
6197: WHERE mpacd.pac_period_id = p_period_id
6198: AND EXISTS (select 'X'
6199: from cst_pac_intorg_itms_temp
6200: where cost_group_id = mpacd.cost_group_id