APPS.INV_EXPRESS_PICK_PUB dependencies on DUAL

Line 1066: FROM dual;

1062: print_debug('getting serial numbers based on reservation_id ','INV_Express_pick.Pick_release');
1063: if g_transaction_temp_id is NULL then
1064: print_debug('get new Transaction_temp_id ','Inv_Express_pick.Pick_release');
1065: SELECT mtl_material_transactions_s.NEXTVAL into g_transaction_temp_id
1066: FROM dual;
1067: end if;
1068: IF (x_available_sl_qty >= p_required_sl_qty) THEN
1069: EXIT;
1070: END IF;

Line 1149: FROM dual;

1145: --dbms_output.put_line('inside loop ');
1146: if g_transaction_temp_id is NULL then
1147: print_debug('get new Transaction_temp_id ','Inv_Express_pick.Pick_release');
1148: SELECT mtl_material_transactions_s.NEXTVAL into g_transaction_temp_id
1149: FROM dual;
1150: end if;
1151: IF (x_available_sl_qty >= p_required_sl_qty) THEN
1152: EXIT;
1153: END IF;