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.WSH_DELIVERY_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS

Line 41: FROM wsh_delivery_details dd,

37: x_return_status OUT NOCOPY VARCHAR2) IS
38:
39: CURSOR check_ship_set IS
40: SELECT dd.delivery_detail_id
41: FROM wsh_delivery_details dd,
42: wsh_delivery_assignments_v da
43: WHERE ((NVL(da.delivery_id, -1) <> p_delivery_id) OR
44: (da.delivery_id = p_delivery_id AND dd.requested_quantity > dd.shipped_quantity
45: AND da.delivery_id IS NOT NULL AND dd.shipped_quantity <> 0)) AND

Line 52: FROM wsh_delivery_details dd,

48: dd.container_flag <> 'Y' AND
49: dd.source_code = 'OE' AND
50: (dd.ship_set_id, dd.source_header_id) IN
51: (SELECT DISTINCT dd.ship_set_id, dd.source_header_id
52: FROM wsh_delivery_details dd,
53: wsh_delivery_assignments_v da
54: WHERE da.delivery_id = p_delivery_id AND
55: da.delivery_id IS NOT NULL AND
56: da.delivery_detail_id = dd.delivery_detail_id AND

Line 62: FROM wsh_delivery_details dd,

58: dd.source_code = 'OE' AND
59: dd.ship_set_id IS NOT NULL );
60: CURSOR check_all_lines_imported IS
61: SELECT DISTINCT dd.source_code, dd.ship_set_id, dd.source_header_id
62: FROM wsh_delivery_details dd,
63: wsh_delivery_assignments_v da
64: WHERE da.delivery_id = p_delivery_id AND
65: da.delivery_id IS NOT NULL AND
66: da.delivery_detail_id = dd.delivery_detail_id AND

Line 75: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;

71: l_detail_id NUMBER;
72: l_status BOOLEAN;
73: l_ship_set_id NUMBER;
74: l_source_header_id NUMBER;
75: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;
76: others exception;
77:
78: --
79: l_debug_on BOOLEAN;

Line 177: FROM WSH_DELIVERY_DETAILS WDD, OE_ORDER_LINES_ALL OEL, wsh_delivery_assignments_v WDA

173: -- Bug 2284000
174: CURSOR check_smc(top_model_line NUMBER) IS
175: SELECT MAX(OEL.ORDERED_QUANTITY) child_ord_qty, SUM(NVL(WDD.SHIPPED_QUANTITY,0)) child_shp_qty,
176: OEL.LINE_ID
177: FROM WSH_DELIVERY_DETAILS WDD, OE_ORDER_LINES_ALL OEL, wsh_delivery_assignments_v WDA
178: WHERE OEL.LINE_ID = WDD.SOURCE_LINE_ID
179: AND WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
180: AND WDD.SHIP_MODEL_COMPLETE_FLAG = 'Y'
181: AND WDD.SOURCE_CODE = 'OE'

Line 191: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da, oe_order_lines_all oe

187: check_smc_rec check_smc%rowtype;
188:
189: cursor get_top_model IS
190: SELECT DISTINCT dd.top_model_line_id, dd.source_header_id , oe.ordered_quantity
191: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da, oe_order_lines_all oe
192: WHERE da.delivery_id = p_delivery_id
193: AND da.delivery_id IS NOT NULL
194: AND dd.ship_model_complete_flag = 'Y'
195: AND da.delivery_detail_id = dd.delivery_detail_id

Line 212: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da

208: ( ato_line_id IS NOT NULL AND item_type_code = 'CONFIG' )
209: )
210: MINUS
211: SELECT source_line_id
212: FROM wsh_delivery_details dd, wsh_delivery_assignments_v da
213: WHERE dd.source_header_id = header_id
214: AND dd.source_code = 'OE'
215: AND dd.container_flag <> 'Y'
216: AND da.delivery_id IS NOT NULL

Line 391: FROM wsh_delivery_details dd,

387: CURSOR check_arrival_set IS
388: SELECT 1 from dual
389: WHERE exists (
390: SELECT 1
391: FROM wsh_delivery_details dd,
392: wsh_delivery_assignments_v da
393: WHERE ((NVL(da.delivery_id, -1) <> p_delivery_id) OR
394: (da.delivery_id = p_delivery_id AND dd.requested_quantity > dd.shipped_quantity
395: AND da.delivery_id IS NOT NULL AND dd.shipped_quantity <> 0))

Line 401: FROM wsh_delivery_details dd,

397: AND dd.container_flag <> 'Y'
398: AND dd.source_code = 'OE'
399: AND (dd.arrival_set_id, dd.source_header_id) IN
400: (SELECT DISTINCT dd.arrival_set_id, dd.source_header_id
401: FROM wsh_delivery_details dd,
402: wsh_delivery_assignments_v da
403: WHERE da.delivery_id = p_delivery_id
404: AND da.delivery_id IS NOT NULL
405: AND da.delivery_detail_id = dd.delivery_detail_id

Line 1188: wsh_delivery_details dd

1184:
1185: CURSOR delivery_details IS
1186: SELECT da.delivery_detail_id
1187: FROM wsh_delivery_assignments_v da,
1188: wsh_delivery_details dd
1189: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
1190: da.delivery_id = p_delivery_id AND
1191: da.delivery_id IS NOT NULL AND
1192: nvl(dd.container_flag,'N') <> 'Y';

Line 2553: wsh_delivery_details dd

2549:
2550: CURSOR detail_info IS
2551: SELECT da.parent_delivery_detail_id
2552: FROM wsh_delivery_assignments_v da,
2553: wsh_delivery_details dd
2554: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
2555: da.delivery_id = p_delivery_id AND
2556: da.delivery_id IS NOT NULL AND
2557: dd.container_flag = 'N';

Line 2783: x_line_inv_flag_rec OUT NOCOPY wsh_delivery_details_inv.inv_control_flag_rec,

2779: --
2780: -----------------------------------------------------------------------------
2781: PROCEDURE Check_Detail_for_Confirm ( p_detail_id IN NUMBER,
2782: p_check_credit_init_flag IN BOOLEAN, -- 2343058
2783: x_line_inv_flag_rec OUT NOCOPY wsh_delivery_details_inv.inv_control_flag_rec,
2784: x_return_status OUT NOCOPY VARCHAR2) IS
2785:
2786: CURSOR detail_info IS
2787: SELECT delivery_detail_id,

Line 2809: FROM wsh_delivery_details

2805: picked_quantity2,
2806: requested_quantity_uom,
2807: requested_quantity_uom2,
2808: line_direction
2809: FROM wsh_delivery_details
2810: WHERE delivery_detail_id = p_detail_id;
2811:
2812:
2813: /************************MATERIAL STATUS CONTROL ********/

Line 2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;

2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2835: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2836: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2837: l_details_flag BOOLEAN;
2838:

Line 2835: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;

2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2835: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2836: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2837: l_details_flag BOOLEAN;
2838:
2839: l_source_line_id NUMBER;

Line 2836: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;

2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2835: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2836: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2837: l_details_flag BOOLEAN;
2838:
2839: l_source_line_id NUMBER;
2840: l_source_header_id NUMBER;

Line 2841: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;

2837: l_details_flag BOOLEAN;
2838:
2839: l_source_line_id NUMBER;
2840: l_source_header_id NUMBER;
2841: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;
2842: l_picked_quantity2 NUMBER;
2843: l_temp_status VARCHAR2(1);
2844: l_transaction_type_id NUMBER;
2845: l_wms_enabled VARCHAR2(10);

Line 2954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);

2950: AND (NVL(l_line_inv_rec.picked_quantity2,0) = 0) THEN
2951:
2952:
2953: IF l_debug_on THEN
2954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);
2955: END IF;
2956:
2957: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights
2958: (p_line_inv_rec => l_line_inv_rec,

Line 2957: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights

2953: IF l_debug_on THEN
2954: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);
2955: END IF;
2956:
2957: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights
2958: (p_line_inv_rec => l_line_inv_rec,
2959: x_return_status => x_return_status);
2960:
2961: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 2984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);

2980: --
2981: -- Debug Statements
2982: --
2983: IF l_debug_on THEN
2984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
2985: END IF;
2986: --
2987: wsh_delivery_details_inv.fetch_inv_controls(
2988: p_delivery_detail_id => l_line_inv_rec.delivery_detail_id,

Line 2987: wsh_delivery_details_inv.fetch_inv_controls(

2983: IF l_debug_on THEN
2984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
2985: END IF;
2986: --
2987: wsh_delivery_details_inv.fetch_inv_controls(
2988: p_delivery_detail_id => l_line_inv_rec.delivery_detail_id,
2989: p_inventory_item_id => l_line_inv_rec.inventory_item_id,
2990: p_organization_id => l_line_inv_rec.organization_id,
2991: p_subinventory => l_line_inv_rec.subinventory,

Line 3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);

3009: --
3010: -- Debug Statements
3011: --
3012: IF l_debug_on THEN
3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3014: END IF;
3015: --
3016: wsh_delivery_details_inv.Details_Required (
3017: p_line_inv_rec => l_line_inv_rec,

Line 3016: wsh_delivery_details_inv.Details_Required (

3012: IF l_debug_on THEN
3013: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3014: END IF;
3015: --
3016: wsh_delivery_details_inv.Details_Required (
3017: p_line_inv_rec => l_line_inv_rec,
3018: p_set_default => FALSE,
3019: x_line_inv_rec => g_line_inv_rec,
3020: x_details_required => l_details_flag,

Line 3070: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(

3066: select DECODE(wsh_util_validate.Check_Wms_Org(l_line_inv_rec.organization_id),'Y','TRUE','FALSE')
3067: into l_wms_enabled
3068: from dual;
3069:
3070: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
3071: p_source_line_id => l_line_inv_rec.source_line_id,
3072: p_source_code => l_line_inv_rec.source_code,
3073: x_transaction_type_id => L_TRANSACTION_TYPE_ID ,
3074: x_return_status => x_return_status);

Line 3148: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,

3144: return;
3145: END IF;
3146:
3147: ELSE
3148: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,
3149: p_lot_number => l_line_inv_rec.lot_number,
3150: p_organization_id => l_line_inv_rec.organization_id ,
3151: p_inventory_item_id => l_line_inv_rec.inventory_item_id ,
3152: p_subinventory => l_line_inv_rec.subinventory ,

Line 4878: wsh_delivery_details dd

4874:
4875: CURSOR detail_info IS
4876: SELECT count(*)
4877: FROM wsh_delivery_assignments_v da,
4878: wsh_delivery_details dd
4879: WHERE da.delivery_id = p_delivery_id AND
4880: da.delivery_id IS NOT NULL AND
4881: da.delivery_detail_id = dd.delivery_detail_id AND
4882: dd.ship_method_code IS NULL AND

Line 5750: wsh_Delivery_details dd

5746: dd.ship_tolerance_below, -- Bug 2181132
5747: dd.requested_quantity_uom, -- Bug 2181132
5748: dd.requested_quantity_uom2 -- Bug 2181132
5749: from wsh_delivery_assignments_v da,
5750: wsh_Delivery_details dd
5751: where dd.delivery_detail_id = da.delivery_detail_id
5752: and da.delivery_id = v_delivery_id
5753: and dd.container_flag = 'N'
5754: and dd.released_status <> 'D'

Line 5763: from wsh_delivery_details

5759: select sum( nvl(requested_quantity,0)) requested_quantity,
5760: sum( nvl(requested_quantity2,0)) requested_quantity2,
5761: ship_tolerance_above,
5762: ship_tolerance_below
5763: from wsh_delivery_details
5764: where source_code = v_source_code and
5765: source_line_id = v_source_line_id and
5766: container_flag = 'N'
5767: group by ship_tolerance_above,

Line 5772: l_source_header_number WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;

5768: ship_tolerance_below;
5769: l_detail_lines c_detail_lines%ROWTYPE;
5770:
5771:
5772: l_source_header_number WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
5773: l_source_header_type_name WSH_DELIVERY_DETAILS.SOURCE_HEADER_TYPE_NAME%TYPE;
5774:
5775: -- HW OPM added qty2
5776: -- HW OPM added qty2 in the group by

Line 5773: l_source_header_type_name WSH_DELIVERY_DETAILS.SOURCE_HEADER_TYPE_NAME%TYPE;

5769: l_detail_lines c_detail_lines%ROWTYPE;
5770:
5771:
5772: l_source_header_number WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
5773: l_source_header_type_name WSH_DELIVERY_DETAILS.SOURCE_HEADER_TYPE_NAME%TYPE;
5774:
5775: -- HW OPM added qty2
5776: -- HW OPM added qty2 in the group by
5777: CURSOR c_total_line_quantities (v_source_line_id in number, v_source_code in varchar2, v_source_header_id IN NUMBER) is

Line 5791: from wsh_delivery_details

5787: requested_quantity_uom ,
5788: src_requested_quantity_uom2 ,
5789: requested_quantity_uom2 ,
5790: inventory_item_id
5791: from wsh_delivery_details
5792: where source_line_id = v_source_line_id
5793: and released_status <> 'D'
5794: and source_code = v_source_code
5795: and container_flag = 'N'

Line 5825: from wsh_delivery_details wdd,

5821: wdd.requested_quantity_uom ,
5822: wdd.src_requested_quantity_uom2 ,
5823: wdd.requested_quantity_uom2 ,
5824: wdd.inventory_item_id
5825: from wsh_delivery_details wdd,
5826: wsh_delivery_assignments_v wda
5827: where wdd.source_line_id = v_source_line_id
5828: and wdd.released_status <> ('D')
5829: and wdd.source_code = v_source_code

Line 5867: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

5863: -- 2181132
5864: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
5865: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
5866: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
5867: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
5868: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
5869:
5870: others EXCEPTION;
5871: tolerance_exceeded EXCEPTION;

Line 5868: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;

5864: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
5865: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
5866: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
5867: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
5868: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
5869:
5870: others EXCEPTION;
5871: tolerance_exceeded EXCEPTION;
5872: -- HW OPM

Line 6243: from wsh_delivery_details wdd,

6239: ) IS
6240:
6241: cursor del_to_det_cur( p_delivery_id IN NUMBER ) is
6242: select distinct 'X'
6243: from wsh_delivery_details wdd,
6244: wsh_delivery_assignments_v wda
6245: where wda.delivery_id = p_delivery_id
6246: and wdd.delivery_detail_id = wda.delivery_detail_id
6247: and wdd.source_code = 'WSH'

Line 6268: from wsh_delivery_details wdd,

6264: and action_type = 'A';
6265:
6266: cursor det_stat_cur( p_delivery_id IN NUMBER) is
6267: select distinct 'X'
6268: from wsh_delivery_details wdd,
6269: wsh_delivery_assignments_v wda
6270: where wdd.source_code = 'WSH'
6271: and wdd.container_flag = 'N'
6272: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 11052: FROM wsh_delivery_details wdd,

11048: --
11049: CURSOR line_csr (p_delivery_id IN NUMBER)
11050: IS
11051: SELECT 'Y'
11052: FROM wsh_delivery_details wdd,
11053: wsh_delivery_assignments_v wda
11054: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
11055: AND wda.delivery_id = p_delivery_id
11056: AND NVL(wdd.container_flag,'N') = 'N'

Line 11396: FROM wsh_delivery_details wdd,

11392: --
11393: CURSOR line_csr(p_delivery_id NUMBER)
11394: IS
11395: SELECT 'Y'
11396: FROM wsh_delivery_details wdd,
11397: wsh_delivery_assignments_v wda
11398: WHERE wda.delivery_id = p_delivery_id
11399: AND wdd.delivery_detail_id = wda.delivery_detail_id
11400: AND NVL(wdd.container_flag,'N') = 'N'

Line 12598: from wsh_delivery_details wdd,

12594: IS
12595:
12596: cursor c_detail (p_delivery_id NUMBER) is
12597: select 1
12598: from wsh_delivery_details wdd,
12599: wsh_delivery_assignments_v wda
12600: where wdd.delivery_detail_id = wda.delivery_detail_id
12601: and wdd.released_status in ('R','B','X')
12602: and nvl(wdd.replenishment_status,'C') = 'C' --bug# 6719369 (replenishment project)