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 396: FROM wsh_delivery_details dd,

392: CURSOR check_arrival_set IS
393: SELECT 1 from dual
394: WHERE exists (
395: SELECT 1
396: FROM wsh_delivery_details dd,
397: wsh_delivery_assignments_v da
398: WHERE ((NVL(da.delivery_id, -1) <> p_delivery_id) OR
399: (da.delivery_id = p_delivery_id AND dd.requested_quantity > dd.shipped_quantity
400: AND da.delivery_id IS NOT NULL AND dd.shipped_quantity <> 0))

Line 406: FROM wsh_delivery_details dd,

402: AND dd.container_flag <> 'Y'
403: AND dd.source_code = 'OE'
404: AND (dd.arrival_set_id, dd.source_header_id) IN
405: (SELECT DISTINCT dd.arrival_set_id, dd.source_header_id
406: FROM wsh_delivery_details dd,
407: wsh_delivery_assignments_v da
408: WHERE da.delivery_id = p_delivery_id
409: AND da.delivery_id IS NOT NULL
410: AND da.delivery_detail_id = dd.delivery_detail_id

Line 1213: wsh_delivery_details dd

1209:
1210: CURSOR delivery_details IS
1211: SELECT da.delivery_detail_id
1212: FROM wsh_delivery_assignments_v da,
1213: wsh_delivery_details dd
1214: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
1215: da.delivery_id = p_delivery_id AND
1216: da.delivery_id IS NOT NULL AND
1217: nvl(dd.container_flag,'N') <> 'Y';

Line 2593: wsh_delivery_details dd

2589:
2590: CURSOR detail_info IS
2591: SELECT da.parent_delivery_detail_id
2592: FROM wsh_delivery_assignments_v da,
2593: wsh_delivery_details dd
2594: WHERE dd.delivery_detail_id = da.delivery_detail_id AND
2595: da.delivery_id = p_delivery_id AND
2596: da.delivery_id IS NOT NULL AND
2597: dd.container_flag = 'N';

Line 2823: x_line_inv_flag_rec OUT NOCOPY wsh_delivery_details_inv.inv_control_flag_rec,

2819: --
2820: -----------------------------------------------------------------------------
2821: PROCEDURE Check_Detail_for_Confirm ( p_detail_id IN NUMBER,
2822: p_check_credit_init_flag IN BOOLEAN, -- 2343058
2823: x_line_inv_flag_rec OUT NOCOPY wsh_delivery_details_inv.inv_control_flag_rec,
2824: x_return_status OUT NOCOPY VARCHAR2) IS
2825:
2826: CURSOR detail_info IS
2827: SELECT delivery_detail_id,

Line 2849: FROM wsh_delivery_details

2845: picked_quantity2,
2846: requested_quantity_uom,
2847: requested_quantity_uom2,
2848: line_direction
2849: FROM wsh_delivery_details
2850: WHERE delivery_detail_id = p_detail_id;
2851:
2852:
2853: /************************MATERIAL STATUS CONTROL ********/

Line 2876: SELECT wdd1.lpn_id from wsh_delivery_details wdd1,

2872: /************************MATERIAL STATUS CONTROL ********/
2873:
2874: -- 11728970: Cursor to Get the LPN -id
2875: CURSOR C_GET_LPN_ID ( p_detail_id NUMBER) IS
2876: SELECT wdd1.lpn_id from wsh_delivery_details wdd1,
2877: wsh_delivery_details wdd2, wsh_delivery_assignments wda
2878: WHERE wdd2.delivery_detail_id = p_detail_id
2879: AND wdd2.delivery_detail_id = wda.delivery_detail_id
2880: AND wda.parent_delivery_detail_id IS NOT NULL

Line 2877: wsh_delivery_details wdd2, wsh_delivery_assignments wda

2873:
2874: -- 11728970: Cursor to Get the LPN -id
2875: CURSOR C_GET_LPN_ID ( p_detail_id NUMBER) IS
2876: SELECT wdd1.lpn_id from wsh_delivery_details wdd1,
2877: wsh_delivery_details wdd2, wsh_delivery_assignments wda
2878: WHERE wdd2.delivery_detail_id = p_detail_id
2879: AND wdd2.delivery_detail_id = wda.delivery_detail_id
2880: AND wda.parent_delivery_detail_id IS NOT NULL
2881: AND wda.parent_delivery_detail_id = wdd1.delivery_detail_id

Line 2888: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;

2884:
2885: l_lpn_id NUMBER;
2886: -- 11728970: Cursor to Get the LPN -id
2887:
2888: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2889: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2890: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2891: l_details_flag BOOLEAN;
2892:

Line 2889: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;

2885: l_lpn_id NUMBER;
2886: -- 11728970: Cursor to Get the LPN -id
2887:
2888: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2889: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2890: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2891: l_details_flag BOOLEAN;
2892:
2893: l_source_line_id NUMBER;

Line 2890: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;

2886: -- 11728970: Cursor to Get the LPN -id
2887:
2888: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2889: g_line_inv_rec wsh_delivery_details_inv.line_inv_info;
2890: l_line_inv_flag_rec wsh_delivery_details_inv.inv_control_flag_rec;
2891: l_details_flag BOOLEAN;
2892:
2893: l_source_line_id NUMBER;
2894: l_source_header_id NUMBER;

Line 2895: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;

2891: l_details_flag BOOLEAN;
2892:
2893: l_source_line_id NUMBER;
2894: l_source_header_id NUMBER;
2895: l_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE;
2896: l_picked_quantity2 NUMBER;
2897: l_temp_status VARCHAR2(1);
2898: l_transaction_type_id NUMBER;
2899: l_wms_enabled VARCHAR2(10);

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

3006: AND l_line_inv_rec.inventory_item_id IS NOT NULL THEN
3007:
3008:
3009: IF l_debug_on THEN
3010: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);
3011: END IF;
3012:
3013: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights
3014: (p_line_inv_rec => l_line_inv_rec,

Line 3013: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights

3009: IF l_debug_on THEN
3010: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights',WSH_DEBUG_SV.C_PROC_LEVEL);
3011: END IF;
3012:
3013: WSH_DELIVERY_DETAILS_INV.Check_Default_Catch_Weights
3014: (p_line_inv_rec => l_line_inv_rec,
3015: x_return_status => x_return_status);
3016:
3017: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

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

3036: --
3037: -- Debug Statements
3038: --
3039: IF l_debug_on THEN
3040: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
3041: END IF;
3042: --
3043: wsh_delivery_details_inv.fetch_inv_controls(
3044: p_delivery_detail_id => l_line_inv_rec.delivery_detail_id,

Line 3043: wsh_delivery_details_inv.fetch_inv_controls(

3039: IF l_debug_on THEN
3040: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS',WSH_DEBUG_SV.C_PROC_LEVEL);
3041: END IF;
3042: --
3043: wsh_delivery_details_inv.fetch_inv_controls(
3044: p_delivery_detail_id => l_line_inv_rec.delivery_detail_id,
3045: p_inventory_item_id => l_line_inv_rec.inventory_item_id,
3046: p_organization_id => l_line_inv_rec.organization_id,
3047: p_subinventory => l_line_inv_rec.subinventory,

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

3065: --
3066: -- Debug Statements
3067: --
3068: IF l_debug_on THEN
3069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3070: END IF;
3071: --
3072: wsh_delivery_details_inv.Details_Required (
3073: p_line_inv_rec => l_line_inv_rec,

Line 3072: wsh_delivery_details_inv.Details_Required (

3068: IF l_debug_on THEN
3069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DETAILS_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3070: END IF;
3071: --
3072: wsh_delivery_details_inv.Details_Required (
3073: p_line_inv_rec => l_line_inv_rec,
3074: p_set_default => FALSE,
3075: x_line_inv_rec => g_line_inv_rec,
3076: x_details_required => l_details_flag,

Line 3128: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(

3124: select DECODE(wsh_util_validate.Check_Wms_Org(l_line_inv_rec.organization_id),'Y','TRUE','FALSE')
3125: into l_wms_enabled
3126: from dual;
3127:
3128: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
3129: p_source_line_id => l_line_inv_rec.source_line_id,
3130: p_source_code => l_line_inv_rec.source_code,
3131: x_transaction_type_id => L_TRANSACTION_TYPE_ID ,
3132: x_return_status => x_return_status);

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

3218: return;
3219: END IF;
3220:
3221: ELSE
3222: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,
3223: p_lot_number => l_line_inv_rec.lot_number,
3224: p_organization_id => l_line_inv_rec.organization_id ,
3225: p_inventory_item_id => l_line_inv_rec.inventory_item_id ,
3226: p_subinventory => l_line_inv_rec.subinventory ,

Line 4968: wsh_delivery_details dd

4964:
4965: CURSOR detail_info IS
4966: SELECT count(*)
4967: FROM wsh_delivery_assignments_v da,
4968: wsh_delivery_details dd
4969: WHERE da.delivery_id = p_delivery_id AND
4970: da.delivery_id IS NOT NULL AND
4971: da.delivery_detail_id = dd.delivery_detail_id AND
4972: dd.ship_method_code IS NULL AND

Line 5853: wsh_Delivery_details dd

5849: dd.ship_tolerance_below, -- Bug 2181132
5850: dd.requested_quantity_uom, -- Bug 2181132
5851: dd.requested_quantity_uom2 -- Bug 2181132
5852: from wsh_delivery_assignments_v da,
5853: wsh_Delivery_details dd
5854: where dd.delivery_detail_id = da.delivery_detail_id
5855: and da.delivery_id = v_delivery_id
5856: and dd.container_flag = 'N'
5857: and dd.released_status <> 'D'

Line 5866: from wsh_delivery_details

5862: select sum( nvl(requested_quantity,0)) requested_quantity,
5863: sum( nvl(requested_quantity2,0)) requested_quantity2,
5864: ship_tolerance_above,
5865: ship_tolerance_below
5866: from wsh_delivery_details
5867: where source_code = v_source_code and
5868: source_line_id = v_source_line_id and
5869: container_flag = 'N'
5870: group by ship_tolerance_above,

Line 5875: l_source_header_number WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;

5871: ship_tolerance_below;
5872: l_detail_lines c_detail_lines%ROWTYPE;
5873:
5874:
5875: l_source_header_number WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
5876: l_source_header_type_name WSH_DELIVERY_DETAILS.SOURCE_HEADER_TYPE_NAME%TYPE;
5877:
5878: -- HW OPM added qty2
5879: -- HW OPM added qty2 in the group by

Line 5876: l_source_header_type_name WSH_DELIVERY_DETAILS.SOURCE_HEADER_TYPE_NAME%TYPE;

5872: l_detail_lines c_detail_lines%ROWTYPE;
5873:
5874:
5875: l_source_header_number WSH_DELIVERY_DETAILS.SOURCE_HEADER_NUMBER%TYPE;
5876: l_source_header_type_name WSH_DELIVERY_DETAILS.SOURCE_HEADER_TYPE_NAME%TYPE;
5877:
5878: -- HW OPM added qty2
5879: -- HW OPM added qty2 in the group by
5880: CURSOR c_total_line_quantities (v_source_line_id in number, v_source_code in varchar2, v_source_header_id IN NUMBER) is

Line 5894: from wsh_delivery_details

5890: requested_quantity_uom ,
5891: src_requested_quantity_uom2 ,
5892: requested_quantity_uom2 ,
5893: inventory_item_id
5894: from wsh_delivery_details
5895: where source_line_id = v_source_line_id
5896: and released_status <> 'D'
5897: and source_code = v_source_code
5898: and container_flag = 'N'

Line 5928: from wsh_delivery_details wdd,

5924: wdd.requested_quantity_uom ,
5925: wdd.src_requested_quantity_uom2 ,
5926: wdd.requested_quantity_uom2 ,
5927: wdd.inventory_item_id
5928: from wsh_delivery_details wdd,
5929: wsh_delivery_assignments_v wda
5930: where wdd.source_line_id = v_source_line_id
5931: and wdd.released_status <> ('D')
5932: and wdd.source_code = v_source_code

Line 5970: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;

5966: -- 2181132
5967: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
5968: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
5969: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
5970: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
5971: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
5972:
5973: others EXCEPTION;
5974: tolerance_exceeded EXCEPTION;

Line 5971: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;

5967: l_minmaxinrectype WSH_DETAILS_VALIDATIONS.MinMaxInRecType;
5968: l_minmaxinoutrectype WSH_DETAILS_VALIDATIONS.MinMaxInOutRecType;
5969: l_minmaxoutrectype WSH_DETAILS_VALIDATIONS.MinMaxOutRecType;
5970: l_quantity_uom WSH_DELIVERY_DETAILS.requested_quantity_uom%TYPE;
5971: l_quantity_uom2 WSH_DELIVERY_DETAILS.requested_quantity_uom2%TYPE;
5972:
5973: others EXCEPTION;
5974: tolerance_exceeded EXCEPTION;
5975: -- HW OPM

Line 6402: from wsh_delivery_details wdd,

6398: ) IS
6399:
6400: cursor del_to_det_cur( p_delivery_id IN NUMBER ) is
6401: select distinct 'X'
6402: from wsh_delivery_details wdd,
6403: wsh_delivery_assignments_v wda
6404: where wda.delivery_id = p_delivery_id
6405: and wdd.delivery_detail_id = wda.delivery_detail_id
6406: and wdd.source_code = 'WSH'

Line 6427: from wsh_delivery_details wdd,

6423: and action_type = 'A';
6424:
6425: cursor det_stat_cur( p_delivery_id IN NUMBER) is
6426: select distinct 'X'
6427: from wsh_delivery_details wdd,
6428: wsh_delivery_assignments_v wda
6429: where wdd.source_code = 'WSH'
6430: and wdd.container_flag = 'N'
6431: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 6481: from wsh_delivery_details wdd,

6477:
6478: --RTV changes
6479: cursor del_to_det_sc_cur( p_delivery_id IN NUMBER ) is
6480: select 'X'
6481: from wsh_delivery_details wdd,
6482: wsh_delivery_assignments_v wda
6483: where wda.delivery_id = p_delivery_id
6484: and wdd.delivery_detail_id = wda.delivery_detail_id
6485: and wdd.source_code NOT IN ('OE','WSH','OKE')

Line 11324: FROM wsh_delivery_details wdd,

11320: --
11321: CURSOR line_csr (p_delivery_id IN NUMBER)
11322: IS
11323: SELECT 'Y'
11324: FROM wsh_delivery_details wdd,
11325: wsh_delivery_assignments_v wda
11326: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
11327: AND wda.delivery_id = p_delivery_id
11328: AND NVL(wdd.container_flag,'N') = 'N'

Line 11668: FROM wsh_delivery_details wdd,

11664: --
11665: CURSOR line_csr(p_delivery_id NUMBER)
11666: IS
11667: SELECT 'Y'
11668: FROM wsh_delivery_details wdd,
11669: wsh_delivery_assignments_v wda
11670: WHERE wda.delivery_id = p_delivery_id
11671: AND wdd.delivery_detail_id = wda.delivery_detail_id
11672: AND NVL(wdd.container_flag,'N') = 'N'

Line 12877: from wsh_delivery_details wdd,

12873: IS
12874:
12875: cursor c_detail (p_delivery_id NUMBER) is
12876: select 1
12877: from wsh_delivery_details wdd,
12878: wsh_delivery_assignments_v wda
12879: where wdd.delivery_detail_id = wda.delivery_detail_id
12880: and wdd.released_status in ('R','B','X')
12881: and nvl(wdd.replenishment_status,'C') = 'C' --bug# 6719369 (replenishment project)