APPS.OE_SHIP_CONFIRMATION_PUB dependencies on WSH_DELIVERY_DETAILS

Line 141: FROM WSH_DELIVERY_DETAILS WDD

137: SELECT WDD.LOT_NUMBER,
138: -- WDD.SUBLOT_NUMBER, INVCONV
139: WDD.SHIPPED_QUANTITY
140:
141: FROM WSH_DELIVERY_DETAILS WDD
142:
143: WHERE WDD.SOURCE_LINE_ID = p_line_Id
144: AND WDD.RELEASED_STATUS ='C'
145: AND WDD.SOURCE_CODE='OE'

Line 620: -- we need to retrieve the information from wsh_delivery_details

616: oe_debug_pub.add( 'DUAL ITEM - SHIPPING UPDATE ' , 1 ) ;
617: END IF;
618:
619: -- HW OPM BUG#:2415731 Since OM does not save lot and sublot information and shipping does,
620: -- we need to retrieve the information from wsh_delivery_details
621:
622: l_temp_dual_shipped_qty := 0;
623:
624: -- Fetch lot information from shipping table

Line 1770: FROM wsh_delivery_details

1766: IF p_requested_line_rec.item_type_code(I) = 'STANDARD' THEN
1767:
1768: SELECT count(*)
1769: INTO l_wdd_count
1770: FROM wsh_delivery_details
1771: WHERE source_line_id = p_requested_line_rec.line_id(I)
1772: AND released_status <> 'D'
1773: AND source_code = 'OE'
1774: AND oe_interfaced_flag = 'N';

Line 2603: FROM wsh_delivery_details

2599: BEGIN
2600: -- getting delivery details
2601: SELECT count(*)
2602: INTO l_wdd_count
2603: FROM wsh_delivery_details
2604: WHERE source_line_id = p_ship_line_rec.line_id(p_index)
2605: AND released_status <> 'D'
2606: AND source_code = 'OE'
2607: AND oe_interfaced_flag = 'N';

Line 3352: FROM wsh_delivery_details

3348: AND open_flag = 'Y'
3349: AND shipped_quantity is NULL
3350: AND line_id in
3351: (SELECT source_line_id
3352: FROM wsh_delivery_details
3353: WHERE source_header_id = oe.header_id);
3354:
3355: I NUMBER := 0;
3356: --

Line 3371: FROM wsh_delivery_details

3367: LOOP
3368:
3369: SELECT count(*)
3370: INTO l_count
3371: FROM wsh_delivery_details
3372: WHERE source_line_id = line_rec.line_id
3373: AND released_status <> 'D';
3374:
3375: IF l_count > 0 THEN

Line 5571: FROM wsh_delivery_details

5567: END IF;
5568: l_count := 0;
5569: SELECT Count(1)
5570: INTO l_count
5571: FROM wsh_delivery_details
5572: WHERE source_line_id = p_line_id
5573: AND released_status = 'C';
5574:
5575: IF (l_count > 0 )