DBA Data[Home] [Help]

APPS.RCV_DCP_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 732: wms_license_plate_numbers wlpn

728: , wlpn.lpn_context
729: FROM mtl_serial_numbers msn,
730: rcv_transactions_interface rti,
731: mtl_serial_numbers_temp msnt,
732: wms_license_plate_numbers wlpn
733: WHERE rti.interface_transaction_id = p_interface_transaction_id
734: AND msnt.product_code = 'RCV'
735: AND msnt.product_transaction_id = rti.interface_transaction_id
736: AND msn.serial_number between msnt.fm_serial_number and msnt.to_serial_number

Line 754: wms_license_plate_numbers wlpn

750: , wlpn.lpn_context
751: FROM mtl_serial_numbers msn,
752: rcv_transactions rt,
753: mtl_unit_transactions mut,
754: wms_license_plate_numbers wlpn
755: WHERE rt.interface_transaction_id = p_interface_transaction_id
756: AND mut.product_code ='RCV'
757: AND mut.product_transaction_id = rt.transaction_id
758: AND msn.serial_number = mut.serial_number