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.CSD_MIGRATE_FROM_115X_PKG3 dependencies on WSH_SERIAL_NUMBERS

Line 3422: -- Included wsh_serial_numbers table in from clause as serial_number may not be captured

3418: and rcvt.oe_order_header_id = p_order_header_Id
3419: and rcvt.oe_order_line_id = p_Order_Line_Id ;
3420:
3421: -- Define a cursor which gets all delivery details records for parent order line id
3422: -- Included wsh_serial_numbers table in from clause as serial_number may not be captured
3423: -- in wsh_delivery_details.
3424: Cursor Delivery_details_cur (p_order_header_Id Number, p_Order_Line_Id Number) IS
3425: Select wdt.delivery_detail_id, wdt.shipped_quantity,wdt.locator_id ,
3426: Nvl(wdt.serial_number, wsn.fm_serial_number) serial_number

Line 3428: Wsh_Serial_Numbers wsn

3424: Cursor Delivery_details_cur (p_order_header_Id Number, p_Order_Line_Id Number) IS
3425: Select wdt.delivery_detail_id, wdt.shipped_quantity,wdt.locator_id ,
3426: Nvl(wdt.serial_number, wsn.fm_serial_number) serial_number
3427: From wsh_delivery_details wdt,
3428: Wsh_Serial_Numbers wsn
3429: Where wdt.Released_Status in ( 'C', 'I')
3430: and wdt.source_header_id = p_order_header_Id
3431: and wdt.source_line_id in ( Select line_id from oe_order_lines_all
3432: start with line_id = p_Order_Line_Id

Line 3442: wsh_serial_numbers wsn

3438: Cursor Single_Delivery_details_cur (p_order_header_Id Number, p_Order_Line_Id Number) IS
3439: Select wdt.delivery_detail_id, wdt.shipped_quantity, wdt.locator_id ,
3440: Nvl(wdt.serial_number, wsn.fm_serial_number) serial_number
3441: From wsh_delivery_details wdt,
3442: wsh_serial_numbers wsn
3443: Where wdt.Released_Status in ( 'C', 'I')
3444: and wdt.source_header_id = p_order_header_Id
3445: and wdt.source_line_id = p_Order_Line_Id
3446: and wdt.delivery_detail_id = wsn.delivery_detail_id(+);

Line 3775: wsh_serial_numbers wsn

3771: Select wdt.shipped_quantity, wdt.locator_id ,
3772: Nvl(wdt.serial_number, wsn.fm_serial_number) Serial_number
3773: Into v_Quantity_Shipped(j), v_Locator_Id(j) , v_Source_Serial_Number(j)
3774: From wsh_delivery_details wdt,
3775: wsh_serial_numbers wsn
3776: Where wdt.Released_Status in ( 'C', 'I')
3777: and wdt.source_header_id = v_order_header_id(j)
3778: and wdt.source_line_id = v_order_line_id(j)
3779: and wdt.delivery_detail_id = wsn.delivery_detail_id(+)