APPS.GMD_DISP_PUB dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 248: FROM wms_license_plate_numbers wlpn,

244: ITEM_LPN_NOT_FOUND EXCEPTION;
245:
246: CURSOR c_item_lpn_id IS
247: SELECT distinct wlpn.lpn_id, wlpn.license_plate_number
248: FROM wms_license_plate_numbers wlpn,
249: wms_lpn_contents wlc
250: WHERE wlpn.lpn_id = wlc.parent_lpn_id
251: AND wlpn.organization_id = p_organization_id
252: AND wlpn.parent_lpn_id is null

Line 259: FROM wms_license_plate_numbers wlpn,

255: AND wlpn.lpn_id = x_lpn_id;
256:
257: CURSOR c_item_lpn IS
258: SELECT distinct wlpn.lpn_id, wlpn.license_plate_number
259: FROM wms_license_plate_numbers wlpn,
260: wms_lpn_contents wlc
261: WHERE wlpn.lpn_id = wlc.parent_lpn_id
262: AND wlpn.organization_id = p_organization_id
263: AND wlpn.parent_lpn_id is null

Line 1028: wms_license_plate_numbers d,

1024: l_inventory_item_id,l_parent_lot_number,l_lot_number,l_lpn_id,l_subinventory,l_locator_id,l_locator,l_lpn_id,l_lpn,l_wms_enabled_flag
1025: FROM gmd_samples a,
1026: mtl_system_items_b b,
1027: mtl_item_locations_kfv c,
1028: wms_license_plate_numbers d,
1029: mtl_parameters e
1030: WHERE a.sample_id = l_update_disp_rec.sample_id
1031: AND a.delete_mark = 0
1032: AND a.organization_id = b.organization_id(+)

Line 1173: wms_license_plate_numbers wlpn,

1169: gmd_sampling_events gse,
1170: mtl_system_items_b msi,
1171: gmd_specifications_b gsb,
1172: mtl_item_locations_kfv mil,
1173: wms_license_plate_numbers wlpn,
1174: mtl_parameters mp
1175: WHERE csd.composite_spec_disp_id = l_update_disp_rec.composite_spec_disp_id
1176: AND csd.event_spec_disp_id = esd.event_spec_disp_id
1177: AND esd.sampling_event_id = gse.sampling_event_id