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 486: UPDATE mtl_material_transactions_temp

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

Line 602: UPDATE mtl_material_transactions_temp

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

Line 1017: update mtl_material_transactions_temp

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

Line 1057: UPDATE mtl_material_transactions_temp

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

Line 1099: UPDATE mtl_material_transactions_temp

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

Line 1124: UPDATE mtl_material_transactions_temp

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

Line 1150: UPDATE mtl_material_transactions_temp

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

Line 1172: UPDATE mtl_material_transactions_temp

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

Line 1231: UPDATE mtl_material_transactions_temp

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

Line 1324: UPDATE mtl_material_transactions_temp

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

Line 1356: UPDATE mtl_material_transactions_temp

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

Line 1375: UPDATE mtl_material_transactions_temp

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

Line 1425: UPDATE mtl_material_transactions_temp

1421: IF p_input_type = G_INPUT_MMTT THEN
1422: IF (l_debug = 1) THEN
1423: print_debug('update the mmtt with cost group');
1424: END IF;
1425: UPDATE mtl_material_transactions_temp
1426: SET transfer_cost_group_id = l_transfer_cost_group_id
1427: WHERE transaction_temp_id = l_line_id;
1428: ELSIF p_input_type = G_INPUT_MOLINE THEN
1429: IF (l_debug = 1) THEN

Line 1516: UPDATE mtl_material_transactions_temp

1512: p_mmtt_rec.transfer_cost_group_id IS NULL THEN
1513: IF (l_debug = 1) THEN
1514: print_debug('update the mmtt with cost group');
1515: END IF;
1516: UPDATE mtl_material_transactions_temp
1517: SET transfer_cost_group_id = l_transfer_cost_group_id
1518: WHERE transaction_temp_id = l_line_id;
1519: END IF;
1520: