DBA Data[Home] [Help]

APPS.WMS_RCV_PUP_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 816: FROM wms_license_plate_numbers wlpn

812: mmtt.move_order_line_id = mtrl.line_id AND
813: mmtt.organization_id = p_organization_id AND
814: mtrl.organization_id = p_organization_id AND
815: mtrl.lpn_id IN (SELECT wlpn.lpn_id
816: FROM wms_license_plate_numbers wlpn
817: START WITH wlpn.lpn_id = p_lpn_id
818: CONNECT BY wlpn.parent_lpn_id = PRIOR wlpn.lpn_id ) ;
819: EXCEPTION
820: WHEN OTHERS THEN

Line 2552: FROM wms_license_plate_numbers

2548: AND wdt.organization_id = l_tmp_mmtt_rec.organization_id
2549: AND wdt.task_type = 2
2550: AND wdt.status = 4
2551: AND mmtt.lpn_id IN (SELECT lpn_id
2552: FROM wms_license_plate_numbers
2553: START WITH lpn_id = l_tmp_mmtt_rec.transfer_lpn_id
2554: CONNECT BY PRIOR lpn_id = parent_lpn_id
2555: )
2556: );