DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WMS_LICENSE_PLATE_NUMBERS_S2

Line 4981: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.nextval

4977: FROM mtl_parameters
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;

Line 4984: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.currval

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:
4987: l_lpn_starting_num NUMBER;
4988: l_wms_sequence NUMBER;