DBA Data[Home] [Help]

APPS.RCV_DCP_PVT dependencies on MTL_SERIAL_NUMBERS

Line 729: FROM mtl_serial_numbers msn,

725: , rti.transaction_type
726: , msn.last_update_date
727: , msn.current_status
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

Line 731: mtl_serial_numbers_temp msnt,

727: , msn.current_status
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

Line 751: FROM mtl_serial_numbers msn,

747: , rt.transaction_type
748: , msn.last_update_date
749: , msn.current_status
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