DBA Data[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on WSH_DELIVERY_DETAILS

Line 139: FROM WSH_DELIVERY_DETAILS WDD

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

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

603: oe_debug_pub.add( 'DUAL ITEM - SHIPPING UPDATE ' , 1 ) ;
604: END IF;
605:
606: -- HW OPM BUG#:2415731 Since OM does not save lot and sublot information and shipping does,
607: -- we need to retrieve the information from wsh_delivery_details
608:
609: l_temp_dual_shipped_qty := 0;
610:
611: -- Fetch lot information from shipping table

Line 1676: FROM wsh_delivery_details

1672: IF p_requested_line_rec.item_type_code(I) = 'STANDARD' THEN
1673:
1674: SELECT count(*)
1675: INTO l_wdd_count
1676: FROM wsh_delivery_details
1677: WHERE source_line_id = p_requested_line_rec.line_id(I)
1678: AND released_status <> 'D'
1679: AND source_code = 'OE'
1680: AND oe_interfaced_flag = 'N';

Line 2455: FROM wsh_delivery_details

2451: BEGIN
2452: -- getting delivery details
2453: SELECT count(*)
2454: INTO l_wdd_count
2455: FROM wsh_delivery_details
2456: WHERE source_line_id = p_ship_line_rec.line_id(p_index)
2457: AND released_status <> 'D'
2458: AND source_code = 'OE'
2459: AND oe_interfaced_flag = 'N';

Line 3174: FROM wsh_delivery_details

3170: AND open_flag = 'Y'
3171: AND shipped_quantity is NULL
3172: AND line_id in
3173: (SELECT source_line_id
3174: FROM wsh_delivery_details
3175: WHERE source_header_id = oe.header_id);
3176:
3177:
3178: I NUMBER := 0;

Line 3194: FROM wsh_delivery_details

3190: LOOP
3191:
3192: SELECT count(*)
3193: INTO l_count
3194: FROM wsh_delivery_details
3195: WHERE source_line_id = line_rec.line_id
3196: AND released_status <> 'D';
3197:
3198: IF l_count > 0 THEN

Line 5191: FROM wsh_delivery_details

5187: END IF;
5188: l_count := 0;
5189: SELECT Count(1)
5190: INTO l_count
5191: FROM wsh_delivery_details
5192: WHERE source_line_id = p_line_id
5193: AND released_status = 'C';
5194:
5195: IF (l_count > 0 )