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_ACT_CST_DTL_TEMP

Line 285: -- cursor to get actual cost from MTL_PAC_ACT_CST_DTL_TEMP

281: IS
282:
283: l_routine CONSTANT VARCHAR2(30) := 'Get_Correspond_Pmac_Cost';
284:
285: -- cursor to get actual cost from MTL_PAC_ACT_CST_DTL_TEMP
286: CURSOR new_pwac_cost_cur( c_transaction_id NUMBER
287: , c_period_id NUMBER
288: , c_cost_type_id NUMBER
289: , c_cost_group_id NUMBER

Line 295: mtl_pac_act_cst_dtl_temp

291: IS
292: SELECT
293: SUM(actual_cost)
294: FROM
295: mtl_pac_act_cst_dtl_temp
296: WHERE cost_group_id = c_cost_group_id
297: AND cost_type_id = c_cost_type_id
298: AND pac_period_id <= c_period_id
299: AND transaction_id = c_transaction_id;

Line 445: -- cursor to get actual cost from MTL_PAC_ACT_CST_DTL_TEMP

441: IS
442:
443: l_routine CONSTANT VARCHAR2(30) := 'Get_Correspond_Pwac_New_Cost';
444:
445: -- cursor to get actual cost from MTL_PAC_ACT_CST_DTL_TEMP
446: CURSOR new_pwac_cost_cur( c_transaction_id NUMBER
447: , c_period_id NUMBER
448: , c_cost_type_id NUMBER
449: , c_cost_group_id NUMBER

Line 457: mtl_pac_act_cst_dtl_temp

453: IS
454: SELECT
455: actual_cost
456: FROM
457: mtl_pac_act_cst_dtl_temp
458: WHERE cost_group_id = c_cost_group_id
459: AND pac_period_id <= c_period_id
460: AND cost_type_id = c_cost_type_id
461: AND transaction_id = c_transaction_id

Line 629: mtl_pac_act_cst_dtl_temp

625: SELECT
626: actual_cost
627: , new_cost
628: FROM
629: mtl_pac_act_cst_dtl_temp
630: WHERE cost_group_id = c_cost_group_id
631: AND pac_period_id <= c_period_id
632: AND cost_type_id = c_cost_type_id
633: AND transaction_id = c_opp_transaction_id

Line 650: mtl_pac_act_cst_dtl_temp

646: IS
647: SELECT
648: actual_cost
649: FROM
650: mtl_pac_act_cst_dtl_temp
651: WHERE cost_group_id = c_cost_group_id
652: AND pac_period_id <= c_period_id
653: AND cost_type_id = c_cost_type_id
654: AND transaction_id = c_transaction_id

Line 866: mtl_pac_act_cst_dtl_temp

862: , cost_element_id
863: , level_type
864: , actual_cost
865: FROM
866: mtl_pac_act_cst_dtl_temp
867: WHERE pac_period_id = c_period_id
868: AND cost_group_id = c_cost_group_id
869: AND transaction_id = c_transaction_id
870: AND inventory_item_id = c_inventory_item_id

Line 1060: UPDATE MTL_PAC_ACT_CST_DTL_TEMP

1056:
1057: -- Update moh absorption cost in pac txn temp table
1058: IF pac_bal_txn_idx.cost_element_id = 2 AND l_moh_absorption_cost <> 0 THEN
1059:
1060: UPDATE MTL_PAC_ACT_CST_DTL_TEMP
1061: SET moh_absorption_cost = l_moh_absorption_cost
1062: WHERE CURRENT OF pac_bal_txn_cursor;
1063:
1064: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1169: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP

1165: IF l_interorg_receipt_flag = 'Y' AND l_interorg_shipment_flag = 'Y' THEN
1166:
1167:
1168:
1169: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP
1170: -- Cost owned transactions
1171: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP
1172: ( COST_GROUP_ID
1173: , TRANSACTION_ID

Line 1171: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP

1167:
1168:
1169: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP
1170: -- Cost owned transactions
1171: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP
1172: ( COST_GROUP_ID
1173: , TRANSACTION_ID
1174: , PAC_PERIOD_ID
1175: , COST_TYPE_ID

Line 2042: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt

2038: , FND_GLOBAL.prog_appl_id
2039: , FND_GLOBAL.conc_program_id
2040: , SYSDATE
2041: , FND_GLOBAL.login_id
2042: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt
2043: ,CST_PAC_INTERORG_TXNS_TMP cpitt
2044: WHERE mpacdt.pac_period_id = p_pac_period_id
2045: AND mpacdt.inventory_item_id = p_inventory_item_id
2046: AND mpacdt.cost_group_id = nvl(p_cost_group_id, mpacdt.cost_group_id)

Line 4130: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP only if the iteration

4126: FND_MSG_PUB.Add;
4127: RAISE FND_API.G_EXC_ERROR;
4128: END IF;
4129:
4130: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP only if the iteration
4131: -- process flag is enabled with more than 1 iteration
4132:
4133: IF p_iteration_proc_flag = 'Y' AND p_end_iteration_num > 1 THEN
4134:

Line 4136: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP

4132:
4133: IF p_iteration_proc_flag = 'Y' AND p_end_iteration_num > 1 THEN
4134:
4135: -- Cost owned transactions
4136: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP
4137: ( COST_GROUP_ID
4138: , TRANSACTION_ID
4139: , PAC_PERIOD_ID
4140: , COST_TYPE_ID

Line 4183: ,'After inserting mtl_pac_act_cst_dtl_temp:'||

4179:
4180: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4181: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4182: ,G_MODULE_HEAD || l_routine || '.After_ins_MPACD_TEMP'
4183: ,'After inserting mtl_pac_act_cst_dtl_temp:'||
4184: l_group1_interorg_tab(i).transaction_id
4185: );
4186: END IF;
4187:

Line 4189: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP

4185: );
4186: END IF;
4187:
4188: -- Bug 5593086 Pad with nonexistent rows
4189: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP
4190: ( COST_GROUP_ID
4191: , TRANSACTION_ID
4192: , PAC_PERIOD_ID
4193: , COST_TYPE_ID

Line 4239: FROM mtl_pac_act_cst_dtl_temp mpacdt

4235: UNION
4236: SELECT 2 level_type FROM DUAL) lt
4237: WHERE NOT EXISTS
4238: (SELECT 1
4239: FROM mtl_pac_act_cst_dtl_temp mpacdt
4240: WHERE mpacdt.cost_group_id = p_cost_group_id
4241: AND mpacdt.transaction_id = l_group1_interorg_tab(i).transaction_id
4242: AND mpacdt.pac_period_id = p_period_id
4243: AND mpacdt.cost_type_id = p_cost_type_id

Line 4250: ,'After padding mtl_pac_act_cst_dtl_temp:'||

4246:
4247: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4248: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4249: ,G_MODULE_HEAD || l_routine || '.After_pad_MPACD_TEMP'
4250: ,'After padding mtl_pac_act_cst_dtl_temp:'||
4251: l_group1_interorg_tab(i).transaction_id
4252: );
4253: END IF;
4254:

Line 4351: UPDATE MTL_PAC_ACT_CST_DTL_TEMP

4347: AND cost_group_id = p_cost_group_id
4348: AND inventory_item_id = p_inventory_item_id;
4349:
4350: FORALL l_mpacd_idx IN l_txn_id_tbl.FIRST .. l_txn_id_tbl.LAST
4351: UPDATE MTL_PAC_ACT_CST_DTL_TEMP
4352: SET variance_amount = l_variance_amt_tbl(l_mpacd_idx)
4353: WHERE pac_period_id = p_period_id
4354: AND cost_type_id = p_cost_type_id
4355: AND cost_group_id = p_cost_group_id

Line 4603: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP only if the iteration

4599: FND_MSG_PUB.Add;
4600: RAISE FND_API.G_EXC_ERROR;
4601: END IF;
4602:
4603: -- Insert into MTL_PAC_ACT_CST_DTL_TEMP only if the iteration
4604: -- process flag is enabled and consecutive iterations exist
4605:
4606: IF p_iteration_proc_flag = 'Y' AND p_end_iteration_num > 1 THEN
4607:

Line 4609: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP

4605:
4606: IF p_iteration_proc_flag = 'Y' AND p_end_iteration_num > 1 THEN
4607:
4608: -- Cost derived transactions
4609: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP
4610: ( COST_GROUP_ID
4611: , TRANSACTION_ID
4612: , PAC_PERIOD_ID
4613: , COST_TYPE_ID

Line 4654: ,'After inserting mtl_pac_act_cst_dtl_temp:' ||

4650:
4651: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4652: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4653: ,G_MODULE_HEAD || l_routine || '.after_ins_gp2'
4654: ,'After inserting mtl_pac_act_cst_dtl_temp:' ||
4655: l_group2_interorg_tab(i).transaction_id
4656: );
4657: END IF;
4658:

Line 4660: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP

4656: );
4657: END IF;
4658:
4659: -- Bug 5593086 Pad with nonexistent rows
4660: INSERT INTO MTL_PAC_ACT_CST_DTL_TEMP
4661: ( COST_GROUP_ID
4662: , TRANSACTION_ID
4663: , PAC_PERIOD_ID
4664: , COST_TYPE_ID

Line 4708: FROM mtl_pac_act_cst_dtl_temp mpacdt

4704: UNION
4705: SELECT 2 level_type FROM DUAL) lt
4706: WHERE NOT EXISTS
4707: (SELECT 1
4708: FROM mtl_pac_act_cst_dtl_temp mpacdt
4709: WHERE mpacdt.cost_group_id = p_cost_group_id
4710: AND mpacdt.transaction_id = l_group2_interorg_tab(i).transaction_id
4711: AND mpacdt.pac_period_id = p_period_id
4712: AND mpacdt.cost_type_id = p_cost_type_id

Line 4720: ,'After padding mtl_pac_act_cst_dtl_temp:'||

4716:
4717: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4718: FND_LOG.string(FND_LOG.LEVEL_STATEMENT
4719: ,G_MODULE_HEAD || l_routine || '.after_pad_gp2'
4720: ,'After padding mtl_pac_act_cst_dtl_temp:'||
4721: l_group2_interorg_tab(i).transaction_id
4722: );
4723: END IF;
4724:

Line 4957: mtl_pac_act_cst_dtl_temp

4953: , transportation_cost
4954: , moh_absorption_cost
4955: , new_buy_quantity
4956: FROM
4957: mtl_pac_act_cst_dtl_temp
4958: WHERE pac_period_id = c_period_id
4959: AND cost_group_id = c_cost_group_id
4960: AND transaction_id = c_transaction_id
4961: AND inventory_item_id = c_inventory_item_id

Line 4983: mtl_pac_act_cst_dtl_temp

4979: IS
4980: SELECT
4981: nvl(actual_cost,0) actual_cost
4982: FROM
4983: mtl_pac_act_cst_dtl_temp
4984: WHERE pac_period_id = c_pac_period_id
4985: AND cost_group_id = c_cost_group_id
4986: AND inventory_item_id = c_inventory_item_id
4987: AND transaction_id = c_transaction_id

Line 5290: UPDATE MTL_PAC_ACT_CST_DTL_TEMP

5286: -- + moh_absorption_cost
5287: -- For all other cost elements, actual_cost will be New Cost of
5288: -- corresponding transaction
5289: -- =======================================================================
5290: UPDATE MTL_PAC_ACT_CST_DTL_TEMP
5291: SET actual_cost = decode(cost_element_id, 2,
5292: decode(level_type,1, (l_new_correspond_cost + l_unit_transfer_cost +
5293: (transportation_cost/l_txn_quantity) + moh_absorption_cost), l_new_correspond_cost),l_new_correspond_cost)
5294: , transfer_cost = DECODE(cost_element_id, 2, decode(level_type,1, l_unit_transfer_cost,0),0)

Line 5366: UPDATE mtl_pac_act_cst_dtl_temp

5362: -- ===============================================
5363: l_period_new_balance :=
5364: G_PWAC_NEW_COST_TBL(l_cost_element_id)(l_level_type).period_new_balance;
5365:
5366: UPDATE mtl_pac_act_cst_dtl_temp
5367: SET variance_amount = decode(sign(l_period_quantity),
5368: 0, l_period_new_balance,
5369: (-1 * sign(l_period_new_balance)),
5370: l_period_new_balance,0)

Line 5573: update mtl_pac_act_cst_dtl_temp mpacdt

5569: -- bind variables before handing over to SQL Engine. With function, it'll have
5570: -- to switch for each record
5571: -- ===========================================================================
5572:
5573: update mtl_pac_act_cst_dtl_temp mpacdt
5574: set mpacdt.actual_cost = (select (CASE mpacdt.level_type
5575: WHEN 1 THEN
5576: (CASE mpacdt.cost_element_id
5577: WHEN 1 THEN G_PWAC_NEW_COST_TBL(1)(1).final_new_cost

Line 6190: -- mtl_pac_act_cst_dtl_temp of an interorg item

6186: END IF;
6187:
6188: -- ===================================================================
6189: -- Delete MPACD for the corresponding inserted pac transactions in
6190: -- mtl_pac_act_cst_dtl_temp of an interorg item
6191: -- Only if the iteration process flag is enabled and consecutive
6192: -- iterations exist
6193: -- ===================================================================
6194: IF l_iteration_num = 1 AND p_iteration_proc_flag = 'Y' THEN

Line 6206: FROM mtl_pac_act_cst_dtl_temp

6202: and pac_period_id = p_period_id
6203: and interorg_receipt_flag = 'Y')
6204: AND transaction_id IN (
6205: SELECT transaction_id
6206: FROM mtl_pac_act_cst_dtl_temp
6207: WHERE pac_period_id = p_period_id
6208: AND inventory_item_id = l_inventory_item_id);
6209:
6210: