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 1179: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE

1175:
1176: l_routine CONSTANT VARCHAR2(30) := 'calc_pmac_for_interorg';
1177:
1178: l_stmt_num NUMBER;
1179: TYPE t_txn_id_tbl IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
1180: INDEX BY BINARY_INTEGER;
1181: TYPE t_txn_category_tbl IS TABLE OF CST_PAC_PERIOD_BALANCES.txn_category%TYPE
1182: INDEX BY BINARY_INTEGER;
1183: l_last_txn_id_tbl t_txn_id_tbl;

Line 1225: FROM mtl_pac_actual_cost_details mpacd

1221: l_stmt_num := 10;
1222: SELECT distinct cost_layer_id, mpacd.transaction_id
1223: BULK COLLECT
1224: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl
1225: FROM mtl_pac_actual_cost_details mpacd
1226: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
1227: FROM mtl_pac_actual_cost_details mpacd1
1228: WHERE mpacd1.txn_category = 8
1229: AND mpacd1.inventory_item_id = mpacd.inventory_item_id

Line 1227: FROM mtl_pac_actual_cost_details mpacd1

1223: BULK COLLECT
1224: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl
1225: FROM mtl_pac_actual_cost_details mpacd
1226: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
1227: FROM mtl_pac_actual_cost_details mpacd1
1228: WHERE mpacd1.txn_category = 8
1229: AND mpacd1.inventory_item_id = mpacd.inventory_item_id
1230: AND mpacd1.pac_period_id = p_pac_period_id
1231: AND mpacd1.cost_group_id = p_cost_group_id)

Line 1246: FROM mtl_pac_actual_cost_details mpacd

1242: l_stmt_num := 20;
1243: SELECT distinct cost_layer_id, mpacd.transaction_id
1244: BULK COLLECT
1245: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl
1246: FROM mtl_pac_actual_cost_details mpacd
1247: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
1248: FROM mtl_pac_actual_cost_details mpacd1
1249: WHERE mpacd1.txn_category = 8
1250: AND mpacd1.inventory_item_id = mpacd.inventory_item_id

Line 1248: FROM mtl_pac_actual_cost_details mpacd1

1244: BULK COLLECT
1245: INTO l_cost_layer_id_tbl, l_last_txn_id_tbl
1246: FROM mtl_pac_actual_cost_details mpacd
1247: WHERE mpacd.transaction_id = (SELECT max(mpacd1.transaction_id)
1248: FROM mtl_pac_actual_cost_details mpacd1
1249: WHERE mpacd1.txn_category = 8
1250: AND mpacd1.inventory_item_id = mpacd.inventory_item_id
1251: AND mpacd1.pac_period_id = p_pac_period_id
1252: AND mpacd1.cost_group_id = p_cost_group_id)

Line 1271: UPDATE mtl_pac_actual_cost_details mpacd

1267: processed.
1268: ****************************************************************************/
1269: l_stmt_num := 30;
1270: FORALL l_index IN l_cost_layer_id_tbl.FIRST..l_cost_layer_id_tbl.LAST
1271: UPDATE mtl_pac_actual_cost_details mpacd
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)

Line 1760: FROM mtl_pac_actual_cost_details mpacd,

1756: p_prg_appid,
1757: p_prg_id,
1758: sysdate,
1759: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1760: FROM mtl_pac_actual_cost_details mpacd,
1761: mtl_material_transactions mmt
1762: WHERE mpacd.txn_category = 8
1763: AND mpacd.inventory_item_id = p_inventory_item_id
1764: AND mpacd.pac_period_id = p_pac_period_id

Line 1775: FROM mtl_pac_actual_cost_details mpacd

1771: l_period_quantity,
1772: l_period_quantity * cpicd.item_cost,
1773: cpicd.item_cost,
1774: (SELECT sum (nvl (mpacd.variance_amount, 0))
1775: FROM mtl_pac_actual_cost_details mpacd
1776: WHERE mpacd.txn_category = 8
1777: AND mpacd.inventory_item_id = p_inventory_item_id
1778: AND mpacd.pac_period_id = p_pac_period_id
1779: AND mpacd.cost_group_id = l_cost_group_id

Line 1802: FROM mtl_pac_actual_cost_details mpacd,

1798:
1799: UPDATE CST_PAC_PERIOD_BALANCES cppb
1800: SET txn_category_value =
1801: (SELECT sum (nvl (mpacd.actual_cost, 0) * nvl(mmt.periodic_primary_quantity,0))
1802: FROM mtl_pac_actual_cost_details mpacd,
1803: mtl_material_transactions mmt
1804: WHERE mpacd.txn_category = 9
1805: AND mpacd.inventory_item_id = cppb.inventory_item_id
1806: AND mpacd.pac_period_id = cppb.pac_period_id

Line 1875: INSERT INTO MTL_PAC_ACTUAL_COST_DETAILS

1871: , l_routine || '<'
1872: );
1873: END IF;
1874:
1875: INSERT INTO MTL_PAC_ACTUAL_COST_DETAILS
1876: ( COST_GROUP_ID
1877: , TRANSACTION_ID
1878: , PAC_PERIOD_ID
1879: , COST_TYPE_ID

Line 1993: FROM mtl_pac_actual_cost_details mpacd, cst_pac_intorg_itms_temp cpiit

1989: DISTINCT mpacd.cost_layer_id
1990: , mpacd.cost_group_id
1991: , mpacd.cost_element_id
1992: , mpacd.level_type
1993: FROM mtl_pac_actual_cost_details mpacd, cst_pac_intorg_itms_temp cpiit
1994: WHERE cpiit.pac_period_id = c_pac_period_id
1995: AND cpiit.inventory_item_id = c_inventory_item_id
1996: AND cpiit.cost_group_id = nvl(c_cost_group_id, cpiit.cost_group_id)
1997: AND cpiit.diverging_flag = 'N'

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

3750: l_error_msg VARCHAR2(240);
3751: l_return_status VARCHAR2(1);
3752: l_txn_category NUMBER;
3753:
3754: TYPE t_txn_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3755: INDEX BY BINARY_INTEGER;
3756: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE
3757: INDEX BY BINARY_INTEGER;
3758: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE

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

3752: l_txn_category NUMBER;
3753:
3754: TYPE t_txn_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3755: INDEX BY BINARY_INTEGER;
3756: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE
3757: INDEX BY BINARY_INTEGER;
3758: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE
3759: INDEX BY BINARY_INTEGER;
3760: TYPE t_variance_amt_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.variance_amount%TYPE

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

3754: TYPE t_txn_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.transaction_id%TYPE
3755: INDEX BY BINARY_INTEGER;
3756: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE
3757: INDEX BY BINARY_INTEGER;
3758: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE
3759: INDEX BY BINARY_INTEGER;
3760: TYPE t_variance_amt_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.variance_amount%TYPE
3761: INDEX BY BINARY_INTEGER;
3762:

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

3756: TYPE t_cost_element_id_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.cost_element_id%TYPE
3757: INDEX BY BINARY_INTEGER;
3758: TYPE t_level_type_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.level_type%TYPE
3759: INDEX BY BINARY_INTEGER;
3760: TYPE t_variance_amt_tbl_type IS TABLE OF MTL_PAC_ACTUAL_COST_DETAILS.variance_amount%TYPE
3761: INDEX BY BINARY_INTEGER;
3762:
3763: l_txn_id_tbl t_txn_id_tbl_type;
3764: l_cost_element_id_tbl t_cost_element_id_tbl_type;

Line 3941: FROM MTL_PAC_ACTUAL_COST_DETAILS

3937: , l_group1_interorg_tab(i).transfer_transaction_id
3938: , decode(cost_element_id,2,
3939: decode(level_type,1,l_group1_interorg_tab(i).transportation_cost,0),0)
3940: , 0
3941: FROM MTL_PAC_ACTUAL_COST_DETAILS
3942: WHERE transaction_id = l_group1_interorg_tab(i).transaction_id
3943: AND cost_group_id = p_cost_group_id
3944: AND pac_period_id = p_period_id
3945: AND cost_type_id = p_cost_type_id;

Line 3994: FROM MTL_PAC_ACTUAL_COST_DETAILS

3990: , l_group1_interorg_tab(i).transfer_transaction_id
3991: , 0
3992: , 0
3993: FROM (SELECT *
3994: FROM MTL_PAC_ACTUAL_COST_DETAILS
3995: WHERE transaction_id = l_group1_interorg_tab(i).transaction_id
3996: AND cost_group_id = p_cost_group_id
3997: AND pac_period_id = p_period_id
3998: AND cost_type_id = p_cost_type_id

Line 4111: FROM MTL_PAC_ACTUAL_COST_DETAILS

4107: -- =====================================
4108: SELECT transaction_id, cost_element_id, level_type,variance_amount
4109: BULK COLLECT
4110: INTO l_txn_id_tbl, l_cost_element_id_tbl, l_level_type_tbl,l_variance_amt_tbl
4111: FROM MTL_PAC_ACTUAL_COST_DETAILS
4112: WHERE pac_period_id = p_period_id
4113: AND cost_type_id = p_cost_type_id
4114: AND cost_group_id = p_cost_group_id
4115: AND inventory_item_id = p_inventory_item_id;

Line 4412: FROM MTL_PAC_ACTUAL_COST_DETAILS

4408: , l_group2_interorg_tab(i).transfer_transaction_id
4409: , decode(cost_element_id,2,
4410: decode(level_type,1,l_group2_interorg_tab(i).transportation_cost,0),0)
4411: , 0
4412: FROM MTL_PAC_ACTUAL_COST_DETAILS
4413: WHERE transaction_id = l_group2_interorg_tab(i).transaction_id
4414: AND cost_group_id = p_cost_group_id
4415: AND pac_period_id = p_period_id
4416: AND cost_type_id = p_cost_type_id;

Line 4463: FROM MTL_PAC_ACTUAL_COST_DETAILS

4459: , l_group2_interorg_tab(i).transfer_transaction_id
4460: , 0
4461: , 0
4462: FROM (SELECT *
4463: FROM MTL_PAC_ACTUAL_COST_DETAILS
4464: WHERE transaction_id = l_group2_interorg_tab(i).transaction_id
4465: AND cost_group_id = p_cost_group_id
4466: AND pac_period_id = p_period_id
4467: AND cost_type_id = p_cost_type_id

Line 5690: DELETE FROM mtl_pac_actual_cost_details mpacd

5686: -- iterations exist
5687: -- ===================================================================
5688: IF l_iteration_num = 1 AND p_iteration_proc_flag = 'Y' THEN
5689:
5690: DELETE FROM mtl_pac_actual_cost_details mpacd
5691: WHERE mpacd.pac_period_id = p_period_id
5692: AND EXISTS (select 'X'
5693: from cst_pac_intorg_itms_temp
5694: where cost_group_id = mpacd.cost_group_id