DBA Data[Home] [Help]

APPS.RCV_DCP_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 760: wms_license_plate_numbers wlpn

756: , wlpn.lpn_context
757: FROM mtl_serial_numbers msn,
758: rcv_transactions_interface rti,
759: mtl_serial_numbers_temp msnt,
760: wms_license_plate_numbers wlpn
761: WHERE rti.interface_transaction_id = p_interface_transaction_id
762: AND msnt.product_code = 'RCV'
763: AND msnt.product_transaction_id = rti.interface_transaction_id
764: AND msn.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 782: wms_license_plate_numbers wlpn

778: , wlpn.lpn_context
779: FROM mtl_serial_numbers msn,
780: rcv_transactions rt,
781: mtl_unit_transactions mut,
782: wms_license_plate_numbers wlpn
783: WHERE rt.interface_transaction_id = p_interface_transaction_id
784: AND mut.product_code ='RCV'
785: AND mut.product_transaction_id = rt.transaction_id
786: AND msn.serial_number = mut.serial_number