APPS.WSH_DELIVERY_DETAILS_GRP dependencies on DUAL

Line 4982: FROM DUAL;

4978: WHERE ORGANIZATION_ID = v_organization_id;
4979:
4980: CURSOR c_get_wms_next_seq IS
4981: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.nextval
4982: FROM DUAL;
4983: CURSOR c_get_wms_curr_seq IS
4984: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.currval
4985: FROM DUAL;
4986:

Line 4985: FROM DUAL;

4981: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.nextval
4982: FROM DUAL;
4983: CURSOR c_get_wms_curr_seq IS
4984: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.currval
4985: FROM DUAL;
4986:
4987: l_lpn_starting_num NUMBER;
4988: l_wms_sequence NUMBER;
4989:

Line 8711: FROM DUAL;

8707: ELSIF l_detail_ser_qty > 1
8708: THEN
8709: SELECT mtl_material_transactions_s.NEXTVAL
8710: INTO l_transaction_id
8711: FROM DUAL;
8712: END IF;
8713:
8714: -- Bug 3628620. We allow update of serial number attributes only if the
8715: -- serial number exists (implies shipped qty = 1) in wdd and the user is

Line 8743: FROM DUAL;

8739: END IF;
8740: --
8741: SELECT mtl_material_transactions_s.NEXTVAL
8742: INTO l_transaction_id
8743: FROM DUAL;
8744: --
8745: l_update_attributes := TRUE;
8746: --}
8747: ELSE

Line 8756: FROM DUAL;

8752: 'generate transaction temp id');
8753: END IF;
8754: SELECT mtl_material_transactions_s.NEXTVAL
8755: INTO l_transaction_id
8756: FROM DUAL;
8757: END IF;
8758: --}
8759: END IF;
8760: --}

Line 10955: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;

10951:
10952: IF NOT l_match_found THEN
10953: --{
10954: l_group_match_seq_tbl(i).match_group_id :=l_attr_tab(i).group_id;
10955: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;
10956: --}
10957: End IF;
10958:
10959: x_grouping_rows(i) := l_group_match_seq_tbl(i).delivery_group_id;