APPS.GME_LPN_MOBILE_TXN dependencies on WMS_LICENSE_PLATE_NUMBERS
Line 93: FROM wms_license_plate_numbers
89:
90: OPEN x_line_cursor FOR
91: SELECT license_plate_number,
92: lpn_id 93: FROM wms_license_plate_numbers 94: WHERE organization_id = p_org_id
95: AND license_plate_number LIKE LTRIM(RTRIM('%'||p_lpn_no||'%'))
96: -- Bug 8603061: LPN Context should be 'Pre-generated', 'Resides in WIP' or 'Resides in Inventory'
97: AND lpn_context in (1, 2, 5)