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_TXN_REQUEST_LINES

Line 791: FROM mtl_txn_request_lines

787: l_subinventory_code,
788: l_transfer_subinventory,
789: l_from_locator_id,
790: l_to_locator_id
791: FROM mtl_txn_request_lines
792: WHERE line_id = l_line_id;
793: END IF;
794:
795: IF l_transfer_organization_id IS NOT NULL THEN

Line 1024: print_debug('update the mtl_txn_request_lines with cost group ' ||

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
1023: IF (l_debug = 1) THEN
1024: print_debug('update the mtl_txn_request_lines with cost group ' ||
1025: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1026: END IF;
1027: update mtl_txn_request_lines
1028: set from_cost_Group_id = l_cost_group_id,

Line 1027: update mtl_txn_request_lines

1023: IF (l_debug = 1) THEN
1024: print_debug('update the mtl_txn_request_lines with cost group ' ||
1025: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1026: END IF;
1027: update mtl_txn_request_lines
1028: set from_cost_Group_id = l_cost_group_id,
1029: to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1030: where line_id = l_line_id;
1031: end if;

Line 1063: print_debug('update the mtl_txn_request_lines with to cost group null');

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
1063: print_debug('update the mtl_txn_request_lines with to cost group null');
1064: END IF;
1065: UPDATE mtl_txn_request_lines
1066: SET to_cost_group_id = null
1067: WHERE line_id = l_line_id;

Line 1065: UPDATE mtl_txn_request_lines

1061: ELSIF p_input_type = G_INPUT_MOLINE THEN
1062: IF (l_debug = 1) THEN
1063: print_debug('update the mtl_txn_request_lines with to cost group null');
1064: END IF;
1065: UPDATE mtl_txn_request_lines
1066: SET to_cost_group_id = null
1067: WHERE line_id = l_line_id;
1068: END IF;
1069: ELSE

Line 1105: print_debug('update the mtl_txn_request_lines with cost group ' ||

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
1105: print_debug('update the mtl_txn_request_lines with cost group ' ||
1106: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1107: END IF;
1108: UPDATE mtl_txn_request_lines
1109: SET from_cost_group_id = l_cost_group_id

Line 1108: UPDATE mtl_txn_request_lines

1104: IF (l_debug = 1) THEN
1105: print_debug('update the mtl_txn_request_lines with cost group ' ||
1106: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1107: END IF;
1108: UPDATE mtl_txn_request_lines
1109: SET from_cost_group_id = l_cost_group_id
1110: WHERE line_id = l_line_id;
1111: END IF;
1112: END IF;-- for org transfer ,dest locator is project

Line 1157: print_debug('update the mtl_txn_request_lines with cost group ' || 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
1156: IF (l_debug = 1) THEN
1157: print_debug('update the mtl_txn_request_lines with cost group ' || l_cost_group_id);
1158: END IF;
1159: UPDATE mtl_txn_request_lines
1160: SET from_cost_group_id = l_cost_group_id
1161: --to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)

Line 1159: UPDATE mtl_txn_request_lines

1155: ELSIF p_input_type = G_INPUT_MOLINE THEN
1156: IF (l_debug = 1) THEN
1157: print_debug('update the mtl_txn_request_lines with cost group ' || l_cost_group_id);
1158: END IF;
1159: UPDATE mtl_txn_request_lines
1160: SET from_cost_group_id = l_cost_group_id
1161: --to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1162: WHERE line_id = l_line_id;
1163: END IF;

Line 1179: print_debug('update the mtl_txn_request_lines with cost group ' ||

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
1178: IF (l_debug = 1) THEN
1179: print_debug('update the mtl_txn_request_lines with cost group ' ||
1180: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1181: END IF;
1182: UPDATE mtl_txn_request_lines
1183: SET from_cost_group_id = l_cost_group_id,

Line 1182: UPDATE mtl_txn_request_lines

1178: IF (l_debug = 1) THEN
1179: print_debug('update the mtl_txn_request_lines with cost group ' ||
1180: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1181: END IF;
1182: UPDATE mtl_txn_request_lines
1183: SET from_cost_group_id = l_cost_group_id,
1184: to_cost_group_id = Nvl(to_cost_group_id, l_transfer_cost_group_id)
1185: WHERE line_id = l_line_id;
1186: END IF;

Line 1239: print_debug('update the mtl_txn_request_lines with from cost group null');

1235: WHERE transaction_temp_id = l_line_id;
1236:
1237: ELSIF p_input_type = G_INPUT_MOLINE THEN
1238: IF (l_debug = 1) THEN
1239: print_debug('update the mtl_txn_request_lines with from cost group null');
1240: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1241: END IF;
1242:
1243: UPDATE mtl_txn_request_lines

Line 1240: print_debug('update the mtl_txn_request_lines with tfr cost group null');

1236:
1237: ELSIF p_input_type = G_INPUT_MOLINE THEN
1238: IF (l_debug = 1) THEN
1239: print_debug('update the mtl_txn_request_lines with from cost group null');
1240: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1241: END IF;
1242:
1243: UPDATE mtl_txn_request_lines
1244: SET to_cost_group_id = NULL,

Line 1243: UPDATE mtl_txn_request_lines

1239: print_debug('update the mtl_txn_request_lines with from cost group null');
1240: print_debug('update the mtl_txn_request_lines with tfr cost group null');
1241: END IF;
1242:
1243: UPDATE mtl_txn_request_lines
1244: SET to_cost_group_id = NULL,
1245: from_cost_group_id = null
1246: WHERE line_id = l_line_id;
1247: END IF;

Line 1261: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');

1257: END IF;
1258:
1259: IF (p_input_type = g_input_moline) THEN -- Input type is MMTT
1260: IF (l_debug = 1) THEN
1261: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');
1262: END IF;
1263: wms_costgroupengine_pvt.assign_cost_group
1264: (p_api_version => 1.0,
1265: p_init_msg_list => fnd_api.g_false,

Line 1289: UPDATE mtl_txn_request_lines

1285: IF (l_debug = 1) THEN
1286: print_debug('Setting from cost group as null ');
1287: END IF;
1288:
1289: UPDATE mtl_txn_request_lines
1290: SET
1291: from_cost_group_id = null
1292: WHERE line_id = l_line_id;
1293:

Line 1346: UPDATE mtl_txn_request_lines

1342: IF (l_debug = 1) THEN
1343: print_debug('Setting cost group as null ');
1344: END IF;
1345:
1346: UPDATE mtl_txn_request_lines
1347: SET
1348: from_cost_group_id = null
1349: WHERE line_id = l_line_id;
1350:

Line 1382: print_debug('update the mtl_txn_request_lines with transfer cost group null');

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
1382: print_debug('update the mtl_txn_request_lines with transfer cost group null');
1383: END IF;
1384: UPDATE mtl_txn_request_lines
1385: SET to_cost_group_id = null
1386: WHERE line_id = l_line_id;

Line 1384: UPDATE mtl_txn_request_lines

1380: ELSIF p_input_type = G_INPUT_MOLINE THEN
1381: IF (l_debug = 1) THEN
1382: print_debug('update the mtl_txn_request_lines with transfer cost group null');
1383: END IF;
1384: UPDATE mtl_txn_request_lines
1385: SET to_cost_group_id = null
1386: WHERE line_id = l_line_id;
1387: END IF;
1388: -- Added by cjandhya

Line 1495: print_debug('update the mtl_txn_request_lines with cost group ' ||

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
1495: print_debug('update the mtl_txn_request_lines with cost group ' ||
1496: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1497: END IF;
1498: UPDATE mtl_txn_request_lines
1499: SET to_cost_group_id = l_transfer_cost_group_id

Line 1498: UPDATE mtl_txn_request_lines

1494: IF (l_debug = 1) THEN
1495: print_debug('update the mtl_txn_request_lines with cost group ' ||
1496: l_cost_group_id || ' and ' || l_transfer_cost_group_id);
1497: END IF;
1498: UPDATE mtl_txn_request_lines
1499: SET to_cost_group_id = l_transfer_cost_group_id
1500: WHERE line_id = l_line_id;
1501: END IF;
1502: END IF;

Line 1615: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');

1611: END IF;
1612: END IF;
1613: ELSIF (p_input_type = g_input_moline) THEN
1614: IF (l_debug = 1) THEN
1615: print_debug('before calling wms_costgroupengine_pvt for mtl_txn_request_lines record');
1616: END IF;
1617: wms_costgroupengine_pvt.assign_cost_group
1618: (
1619: p_api_version => 1.0,