DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 3801: WMS_LICENSE_PLATE_NUMBERS WHERE lpn_id = p_sample.lpn_id;

3797: -- 7027149
3798: cursor get_lpn is
3799: SELECT 1
3800: FROM
3801: WMS_LICENSE_PLATE_NUMBERS WHERE lpn_id = p_sample.lpn_id;
3802:
3803: CURSOR get_wms_flag IS
3804: SELECT wms_enabled_flag
3805: FROM mtl_parameters

Line 5329: FROM wms_license_plate_numbers

5325:
5326: --RLNAGARA LPN ME 7027149 Added cursor to get LPN from ID
5327: CURSOR Cur_get_lpn(p_lpn_id NUMBER) IS
5328: SELECT license_plate_number
5329: FROM wms_license_plate_numbers
5330: WHERE lpn_id = p_lpn_id;
5331:
5332: in_sample gmd_samples%ROWTYPE;
5333: out_sample gmd_samples%ROWTYPE;