eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_DIRECT_SHIP_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 8251: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE

8247: , quantity wms_lpn_contents.quantity%TYPE
8248: , revision_control VARCHAR2(5)
8249: , lot_control VARCHAR2(5)
8250: , serial_control VARCHAR2(5)
8251: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
8252: , reservable_type mtl_system_items_b.reservable_type%TYPE
8253: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
8254: , ont_pricing_qty_source VARCHAR2(30)
8255: );

Line 8252: , reservable_type mtl_system_items_b.reservable_type%TYPE

8248: , revision_control VARCHAR2(5)
8249: , lot_control VARCHAR2(5)
8250: , serial_control VARCHAR2(5)
8251: , serial_control_code mtl_system_items_b.serial_number_control_code%TYPE
8252: , reservable_type mtl_system_items_b.reservable_type%TYPE
8253: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
8254: , ont_pricing_qty_source VARCHAR2(30)
8255: );
8256: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;

Line 8394: ' , mtl_system_items_b msi ' ||

8390:
8391: l_sql_query := l_sql_query ||
8392: ' FROM wms_lpn_contents wlc ' ||
8393: ' , wms_license_plate_numbers wlpn ' ||
8394: ' , mtl_system_items_b msi ' ||
8395: ' , (SELECT lpn_id ' ||
8396: ' , revision ' ||
8397: ' , lot_number ' ||
8398: ' , inventory_item_id ' ||