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.INV_COST_GROUP_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 170: FROM Mtl_Material_Transactions_Temp

166:
167: SELECT inventory_item_id, organization_id,transfer_organization,cost_group_id, nvl(transfer_cost,0),
168: abs(primary_quantity), transaction_action_id
169: INTO l_item_id,l_org_id,l_xfer_org_id, l_cg_id,l_transfer_cost,l_pri_qty, l_trx_action_id
170: FROM Mtl_Material_Transactions_Temp
171: WHERE transaction_temp_id = p_mmtt_temp_id;
172:
173: IF ( l_debug = 1) THEN
174: print_debug('item id:'||l_item_id||'org id:'|| l_org_id ||', xfer org id :'|| l_xfer_org_id ||',CG:'||l_cg_id||',xfrcost:'||l_transfer_cost);

Line 228: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP

224: IF (l_debug = 1) THEN
225: print_debug('Calculate_Transfer_Cost : item_cost :'|| l_item_cost || ',transfer_cost :'||l_transfer_cost);
226: END IF;
227:
228: UPDATE MTL_MATERIAL_TRANSACTIONS_TEMP
229: SET TRANSFER_COST = l_transfer_cost
230: WHERE TRANSACTION_TEMP_ID = p_mmtt_temp_id;
231:
232: IF (l_debug = 1) THEN

Line 280: from mtl_material_transactions_temp mmtt

276: l_to_project_id NUMBER := NULL;
277: l_comingling_occurs VARCHAR2(1) := 'N';
278: cursor trx_cursor is
279: select mmtt.*
280: from mtl_material_transactions_temp mmtt
281: WHERE
282: transaction_header_id = p_transaction_header_id
283: AND PROCESS_FLAG = 'Y'
284: AND NVL(TRANSACTION_STATUS,1) <> 2 ; /* 2STEP */

Line 304: UPDATE mtl_material_transactions_temp

300:
301:
302: -- Update all the rows which have null transaction_temp_id for this
303: -- transaction_header_id
304: UPDATE mtl_material_transactions_temp
305: SET transaction_temp_id = mtl_material_transactions_s.NEXTVAL
306: WHERE transaction_header_id = p_transaction_header_id
307: AND transaction_temp_id IS NULL;
308:

Line 376: ,p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE DEFAULT NULL

372: x_return_status OUT NOCOPY VARCHAR2
373: ,x_msg_count OUT NOCOPY NUMBER
374: ,x_msg_data OUT NOCOPY VARCHAR2
375: ,p_organization_id IN NUMBER
376: ,p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE DEFAULT NULL
377: ,p_fob_point IN mtl_interorg_parameters.fob_point%TYPE DEFAULT NULL
378: ,p_line_id IN NUMBER
379: ,p_input_type IN VARCHAR2
380: ,x_cost_group_id OUT NOCOPY NUMBER

Line 487: UPDATE mtl_material_transactions_temp

483: print_debug('After selecting the default transfer cost group');
484: print_debug('Transfer cost group ID' || l_tfr_org_cost_group_id);
485: print_debug('Return Status before update' ||x_return_status );
486:
487: UPDATE mtl_material_transactions_temp
488: SET cost_group_id = l_org_cost_group_id,
489: transfer_cost_group_id = l_tfr_org_cost_group_id
490: WHERE transaction_temp_id = p_mmtt_rec.transaction_temp_id;
491:

Line 603: UPDATE mtl_material_transactions_temp

599: --after updating the transfer_cost_group_id as null
600: l_process_txn := 'N';
601:
602: BEGIN
603: UPDATE mtl_material_transactions_temp
604: SET transfer_cost_group_id = NULL
605: WHERE
606: transaction_temp_id = p_mmtt_rec.transaction_temp_id;
607: EXCEPTION

Line 1018: update mtl_material_transactions_temp

1014: IF p_input_type = g_input_mmtt then
1015: IF (l_debug = 1) THEN
1016: print_debug('update the mmtt with cost group');
1017: END IF;
1018: update mtl_material_transactions_temp
1019: set cost_Group_id = l_cost_group_id,
1020: transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1021: where transaction_temp_id = l_line_id;
1022: ELSIF p_input_type = G_INPUT_MOLINE THEN

Line 1058: UPDATE mtl_material_transactions_temp

1054: IF p_input_type = G_INPUT_MMTT THEN
1055: IF (l_debug = 1) THEN
1056: print_debug('update the mmtt with transfer cost group null');
1057: END IF;
1058: UPDATE mtl_material_transactions_temp
1059: SET transfer_cost_group_id = NULL
1060: WHERE transaction_temp_id = l_line_id;
1061: ELSIF p_input_type = G_INPUT_MOLINE THEN
1062: IF (l_debug = 1) THEN

Line 1100: UPDATE mtl_material_transactions_temp

1096: IF p_input_type = G_INPUT_MMTT THEN
1097: IF (l_debug = 1) THEN
1098: print_debug('update the mmtt with cost group');
1099: END IF;
1100: UPDATE mtl_material_transactions_temp
1101: SET cost_group_id = l_cost_group_id
1102: WHERE transaction_temp_id = l_line_id;
1103: ELSIF p_input_type = G_INPUT_MOLINE THEN
1104: IF (l_debug = 1) THEN

Line 1125: UPDATE mtl_material_transactions_temp

1121: IF p_input_type = G_INPUT_MMTT THEN
1122: IF (l_debug = 1) THEN
1123: print_debug('update the mmtt with cost group');
1124: END IF;
1125: UPDATE mtl_material_transactions_temp
1126: SET cost_Group_id = l_cost_group_id,
1127: transfer_cost_group_id = l_transfer_cost_group_id
1128: WHERE transaction_temp_id = l_line_id;
1129: END IF;

Line 1151: UPDATE mtl_material_transactions_temp

1147: IF p_input_type = G_INPUT_MMTT THEN
1148: IF (l_debug = 1) THEN
1149: print_debug('update the mmtt with cost group '|| l_cost_group_id);
1150: END IF;
1151: UPDATE mtl_material_transactions_temp
1152: SET cost_group_id = l_cost_group_id
1153: --transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1154: WHERE transaction_temp_id = l_line_id;
1155: ELSIF p_input_type = G_INPUT_MOLINE THEN

Line 1173: UPDATE mtl_material_transactions_temp

1169: IF p_input_type = G_INPUT_MMTT THEN
1170: IF (l_debug = 1) THEN
1171: print_debug('update the mmtt with cost group');
1172: END IF;
1173: UPDATE mtl_material_transactions_temp
1174: SET cost_group_id = l_cost_group_id,
1175: transfer_cost_group_id = Nvl(transfer_cost_group_id, l_transfer_cost_group_id)
1176: WHERE transaction_temp_id = l_line_id;
1177: ELSIF p_input_type = G_INPUT_MOLINE THEN

Line 1232: UPDATE mtl_material_transactions_temp

1228: IF (l_debug = 1) THEN
1229: print_debug('update the mmtt with from cost group of null');
1230: print_debug('update the mmtt with tfr cost group of null');
1231: END IF;
1232: UPDATE mtl_material_transactions_temp
1233: SET cost_group_id = NULL,
1234: transfer_cost_group_id = null
1235: WHERE transaction_temp_id = l_line_id;
1236:

Line 1325: UPDATE mtl_material_transactions_temp

1321: IF (l_debug = 1) THEN
1322: print_debug('Setting from cost group as null ');
1323: END IF;
1324:
1325: UPDATE mtl_material_transactions_temp
1326: SET cost_group_id = NULL
1327: WHERE transaction_temp_id = l_line_id;
1328: end if; -- input type
1329:

Line 1357: UPDATE mtl_material_transactions_temp

1353: IF (l_debug = 1) THEN
1354: print_debug('Setting cost group as null ');
1355: END IF;
1356:
1357: UPDATE mtl_material_transactions_temp
1358: SET cost_group_id = NULL
1359: WHERE transaction_temp_id = l_line_id;
1360:
1361: end if; -- input type

Line 1377: UPDATE mtl_material_transactions_temp

1373: IF p_input_type = G_INPUT_MMTT THEN
1374: IF (l_debug = 1) THEN
1375: print_debug('update the mmtt with transfer cost group null');
1376: END IF;
1377: UPDATE mtl_material_transactions_temp
1378: SET transfer_cost_group_id = NULL
1379: WHERE transaction_temp_id = l_line_id;
1380: ELSIF p_input_type = G_INPUT_MOLINE THEN
1381: IF (l_debug = 1) THEN

Line 1443: UPDATE mtl_material_transactions_temp

1439: print_debug('After calculate transfer cost group: l_transfer_cost_group_id of is ' ||l_transfer_cost_group_id);
1440: END IF;
1441: END IF;
1442:
1443: UPDATE mtl_material_transactions_temp
1444: SET transfer_cost_group_id = l_transfer_cost_group_id
1445: WHERE transaction_temp_id = l_line_id;
1446:
1447: IF (l_debug = 1) THEN

Line 1490: UPDATE mtl_material_transactions_temp

1486: IF p_input_type = G_INPUT_MMTT THEN
1487: IF (l_debug = 1) THEN
1488: print_debug('update the mmtt with cost group');
1489: END IF;
1490: UPDATE mtl_material_transactions_temp
1491: SET transfer_cost_group_id = l_transfer_cost_group_id
1492: WHERE transaction_temp_id = l_line_id;
1493: ELSIF p_input_type = G_INPUT_MOLINE THEN
1494: IF (l_debug = 1) THEN

Line 1581: UPDATE mtl_material_transactions_temp

1577: p_mmtt_rec.transfer_cost_group_id IS NULL THEN
1578: IF (l_debug = 1) THEN
1579: print_debug('update the mmtt with cost group');
1580: END IF;
1581: UPDATE mtl_material_transactions_temp
1582: SET transfer_cost_group_id = l_transfer_cost_group_id
1583: WHERE transaction_temp_id = l_line_id;
1584: END IF;
1585: