APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on WSH_DELIVERY_DETAILS

Line 3040: WSH_DELIVERY_DETAILS WSH,

3036: SELECT HIST.rowid,
3037: HROU.name,
3038: WSH.subinventory
3039: FROM CSD_REPAIR_HISTORY HIST,
3040: WSH_DELIVERY_DETAILS WSH,
3041: HR_ALL_ORGANIZATION_UNITS_VL HROU
3042: WHERE HIST.EVENT_CODE = 'PS'
3043: AND HIST.REPAIR_HISTORY_ID >= v_min
3044: AND HIST.REPAIR_HISTORY_ID <= v_max

Line 3423: -- in wsh_delivery_details.

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
3427: From wsh_delivery_details wdt,

Line 3427: From wsh_delivery_details wdt,

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
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

Line 3441: From wsh_delivery_details wdt,

3437: -- Following cursor definition is used when order line quantity is 1
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

Line 3774: From wsh_delivery_details wdt,

3770: l_procedure_Event := ' Getting Shipping details for serial controlled item' ;
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)