APPS.WMS_WIP_INTEGRATION dependencies on DUAL

Line 124: FROM dual ;

120:
121: --Get value from sequence for next transaction_header_id
122: SELECT mtl_material_transactions_s.NEXTVAL
123: INTO l_next_transaction_header_id
124: FROM dual ;
125:
126: IF (l_debug = 1) THEN
127: mydebug('Backflush: header_id: ' || l_next_transaction_header_id);
128: END IF;

Line 142: FROM dual ;

138:
139: --Get value from sequence for next transaction_temp_id
140: SELECT mtl_material_transactions_s.NEXTVAL
141: INTO l_next_transaction_temp_id
142: FROM dual ;
143:
144: IF (l_debug = 1) THEN
145: mydebug('Backflush: temp_id '||l_next_transaction_temp_id);
146: END IF;

Line 660: FROM dual;

656:
657: --Get value from sequence for next serial_transaction_temp_id
658: SELECT mtl_material_transactions_s.NEXTVAL
659: INTO l_next_ser_tran_temp_id
660: FROM dual;
661:
662: --Update MTLT line
663: UPDATE mtl_transaction_lots_temp
664: SET serial_transaction_temp_id = l_next_ser_tran_temp_id

Line 1498: select mtl_gen_object_id_s.nextval into l_object_id from dual;

1494: where serial_number = p_serial_number
1495: and inventory_item_id = l_item_id;
1496:
1497: if( l_object_id is null ) then
1498: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1499: end if;
1500:
1501: UPDATE mtl_serial_numbers
1502: SET

Line 1627: select mtl_gen_object_id_s.nextval into l_object_id from dual;

1623:
1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1625:
1626: -- Lot number does not exist
1627: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1628:
1629: INSERT INTO mtl_lot_numbers
1630: (INVENTORY_ITEM_ID
1631: ,ORGANIZATION_ID

Line 2703: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;

2699: l_msg VARCHAR2(5100);
2700: l_ts VARCHAR2(30);
2701: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2702: BEGIN
2703: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
2704: -- l_msg:=l_ts||' '||msg;
2705:
2706: l_msg := msg;
2707: