APPS.WSH_DELIVERY_DETAILS_GRP dependencies on DUAL

Line 4972: FROM DUAL;

4968: WHERE ORGANIZATION_ID = v_organization_id;
4969:
4970: CURSOR c_get_wms_next_seq IS
4971: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.nextval
4972: FROM DUAL;
4973: CURSOR c_get_wms_curr_seq IS
4974: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.currval
4975: FROM DUAL;
4976:

Line 4975: FROM DUAL;

4971: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.nextval
4972: FROM DUAL;
4973: CURSOR c_get_wms_curr_seq IS
4974: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.currval
4975: FROM DUAL;
4976:
4977: l_lpn_starting_num NUMBER;
4978: l_wms_sequence NUMBER;
4979:

Line 8592: FROM DUAL;

8588: ELSIF l_detail_ser_qty > 1
8589: THEN
8590: SELECT mtl_material_transactions_s.NEXTVAL
8591: INTO l_transaction_id
8592: FROM DUAL;
8593: END IF;
8594:
8595: -- Bug 3628620. We allow update of serial number attributes only if the
8596: -- serial number exists (implies shipped qty = 1) in wdd and the user is

Line 8624: FROM DUAL;

8620: END IF;
8621: --
8622: SELECT mtl_material_transactions_s.NEXTVAL
8623: INTO l_transaction_id
8624: FROM DUAL;
8625: --
8626: l_update_attributes := TRUE;
8627: --}
8628: ELSE

Line 8637: FROM DUAL;

8633: 'generate transaction temp id');
8634: END IF;
8635: SELECT mtl_material_transactions_s.NEXTVAL
8636: INTO l_transaction_id
8637: FROM DUAL;
8638: END IF;
8639: --}
8640: END IF;
8641: --}

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

10831:
10832: IF NOT l_match_found THEN
10833: --{
10834: l_group_match_seq_tbl(i).match_group_id :=l_attr_tab(i).group_id;
10835: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;
10836: --}
10837: End IF;
10838:
10839: x_grouping_rows(i) := l_group_match_seq_tbl(i).delivery_group_id;