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.WMS_DIRECT_SHIP_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 4208: SELECT mtl_material_transactions_s.NEXTVAL

4204: * This Transaction temp id will be associated
4205: * with the delivery line id at the end of processing
4206: * We will use this Transaction temp Id as the group Mark Id aslo.
4207: ********************/
4208: SELECT mtl_material_transactions_s.NEXTVAL
4209: INTO x_transaction_temp_id
4210: FROM DUAL;
4211:
4212: -- Update group_mark_id to reflect newly created transaction_temp_id

Line 5972: SELECT mtl_material_transactions_s.NEXTVAL

5968: DEBUG('The serial number control code is in 2,5', 'stage_lpns');
5969: END IF;
5970:
5971: IF (l_delivery_detail_tab(i).transaction_temp_id IS NULL) THEN
5972: SELECT mtl_material_transactions_s.NEXTVAL
5973: INTO l_delivery_detail_tab(i).transaction_temp_id
5974: FROM DUAL;
5975:
5976: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514

Line 6317: SELECT mtl_material_transactions_s.NEXTVAL

6313: DEBUG('The serial number control code is in 2,5', 'stage_lpns');
6314: END IF;
6315:
6316: IF (l_delivery_detail_tab(i).transaction_temp_id IS NULL) THEN
6317: SELECT mtl_material_transactions_s.NEXTVAL
6318: INTO l_delivery_detail_tab(i).transaction_temp_id
6319: FROM DUAL;
6320:
6321: l_invpcinrectype.transaction_temp_id := l_delivery_detail_tab(i).transaction_temp_id;

Line 6772: SELECT mtl_material_transactions_s.NEXTVAL

6768: DEBUG('The serial number control code is in 2,5', 'stage_lpns');
6769: END IF;
6770:
6771: IF (l_delivery_detail_tab(i).transaction_temp_id IS NULL) THEN
6772: SELECT mtl_material_transactions_s.NEXTVAL
6773: INTO l_delivery_detail_tab(i).transaction_temp_id
6774: FROM DUAL;
6775:
6776: -- update wds with transaction_temp_id, will be used in unload lpn if required bug# 2829514

Line 7042: SELECT mtl_material_transactions_s.NEXTVAL

7038: DEBUG('The serial number control code is in 2,5', 'stage_lpns');
7039: END IF;
7040:
7041: IF (l_delivery_detail_tab(i).transaction_temp_id IS NULL) THEN
7042: SELECT mtl_material_transactions_s.NEXTVAL
7043: INTO l_delivery_detail_tab(i).transaction_temp_id
7044: FROM DUAL;
7045:
7046: l_invpcinrectype.transaction_temp_id := l_delivery_detail_tab(i).transaction_temp_id;

Line 10430: SELECT mtl_material_transactions_s.NEXTVAL

10426: END IF;
10427:
10428: -- get group_id
10429: BEGIN
10430: SELECT mtl_material_transactions_s.NEXTVAL
10431: INTO g_group_id
10432: FROM DUAL;
10433: EXCEPTION
10434: WHEN NO_DATA_FOUND THEN

Line 10507: SELECT mtl_material_transactions_s.NEXTVAL

10503: END IF;
10504:
10505: IF (l_processed_lines_tab(l_temp_index).serial_required_flag = 'Y') THEN
10506: BEGIN
10507: SELECT mtl_material_transactions_s.NEXTVAL
10508: INTO l_trx_temp_id
10509: FROM DUAL;
10510: EXCEPTION
10511: WHEN NO_DATA_FOUND THEN

Line 11922: SELECT mtl_material_transactions_s.NEXTVAL

11918: WHEN NO_DATA_FOUND THEN
11919: -- first time line is being processed
11920: IF (l_serial_required_flag = 'Y') THEN
11921: BEGIN
11922: SELECT mtl_material_transactions_s.NEXTVAL
11923: INTO l_trx_temp_id
11924: FROM DUAL;
11925: EXCEPTION
11926: WHEN NO_DATA_FOUND THEN