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_NEW_DELIVERY_ACTIONS dependencies on WSH_DELIVERY_DETAILS

Line 391: wsh_delivery_details wdd,

387: cursor l_del_contents_csr (p_del_id IN NUMBER,
388: p_cnt_flag IN VARCHAR2) is
389: select 'N'
390: from wsh_delivery_assignments_v wda,
391: wsh_delivery_details wdd,
392: mtl_system_items msi
393: where wda.delivery_detail_id = wdd.delivery_detail_id
394: and wdd.inventory_item_id = msi.inventory_item_id
395: and wdd.organization_id = msi.organization_id

Line 666: FROM wsh_delivery_details wdd,

662: NVL(wnd.shipment_direction,'O') in ('O','IO');
663:
664: Cursor c_num_of_staged_lines(p_delivery_id NUMBER) IS
665: SELECT count(wdd.delivery_detail_id)
666: FROM wsh_delivery_details wdd,
667: wsh_delivery_assignments_v wda
668: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
669: wda.delivery_id = p_delivery_id AND
670: wda.delivery_id is not NULL AND

Line 678: FROM wsh_delivery_details wdd,

674: NVL(wdd.line_direction,'O') in ('O','IO');
675:
676: Cursor c_get_line_status_in_delivery(p_delivery_id NUMBER) IS
677: SELECT wdd.released_status
678: FROM wsh_delivery_details wdd,
679: wsh_delivery_assignments_v wda
680: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
681: wda.delivery_id = p_delivery_id AND
682: wda.delivery_id is not NULL AND

Line 693: l_released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE;

689: l_delfirm VARCHAR2(1);
690: l_organization_id WSH_SHIPPING_PARAMETERS.ORGANIZATION_ID%TYPE;
691: l_planned_flag WSH_NEW_DELIVERIES.PLANNED_FLAG%TYPE;
692: l_initial_pickup_location_id WSH_NEW_DELIVERIES.INITIAL_PICKUP_LOCATION_ID%TYPE;
693: l_released_status WSH_DELIVERY_DETAILS.RELEASED_STATUS%TYPE;
694: l_num_of_staged_lines NUMBER := 0;
695: l_ignore_count NUMBER := 0;
696: l_delivery_detail_count NUMBER := 0;
697: l_delivery_id NUMBER := 0;

Line 2637: FROM wsh_delivery_details dd,

2633: dd.subinventory ,
2634: dd.locator_id,
2635: dd.source_code, /*Bug 2096052 for OKE */
2636: dd.source_line_id -- Consolidation of BO Delivery Details project
2637: FROM wsh_delivery_details dd,
2638: wsh_delivery_assignments_v da
2639: WHERE da.delivery_id = v_delivery_id AND
2640: da.delivery_id IS NOT NULL AND
2641: da.delivery_detail_id = dd.delivery_detail_id AND

Line 2665: WSH_DELIVERY_DETAILS dd

2661:
2662: CURSOR get_empty_containers(v_delivery_id NUMBER) IS
2663: SELECT da.delivery_detail_id
2664: FROM wsh_delivery_assignments_v da,
2665: WSH_DELIVERY_DETAILS dd
2666: WHERE da.delivery_id = v_delivery_id
2667: AND da.delivery_detail_id = dd.delivery_detail_id
2668: AND dd.container_flag = 'Y'
2669: AND NOT EXISTS(

Line 2792: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

2788: l_dd_org_ids wsh_util_core.id_tab_type; -- list of details org ids
2789: l_item_ids wsh_util_core.id_tab_type; -- list of details inventory_item_ids
2790:
2791: -- for non-transactable items
2792: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
2793: dft_subinv VARCHAR2(30);
2794: loc_restricted_flag VARCHAR2(1);
2795: dft_loc_id NUMBER;
2796: org_loc_ctl NUMBER;

Line 2801: g_line_inv_rec WSH_DELIVERY_DETAILS_INV.line_inv_info;

2797: sub_loc_ctl NUMBER;
2798: item_loc_ctl NUMBER;
2799: loc_ctl_code NUMBER;
2800:
2801: g_line_inv_rec WSH_DELIVERY_DETAILS_INV.line_inv_info;
2802: l_details_flag BOOLEAN;
2803:
2804: l_ship_from_location NUMBER;
2805: l_ship_to_location NUMBER;

Line 3110: wsh_delivery_details wdd

3106: -- LPN CONV rv
3107: cursor l_delete_wms_empty_cnt_csr is
3108: select distinct wwst.delivery_detail_id
3109: from wsh_wms_sync_tmp wwst,
3110: wsh_delivery_details wdd
3111: where wwst.operation_type = 'DELETE'
3112: and wdd.delivery_detail_id = wwst.delivery_detail_id
3113: and wdd.container_flag = 'Y'
3114: and wdd.lpn_id is not null;

Line 3988: p_table_name => 'WSH_DELIVERY_DETAILS',

3984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FLEXFIELD_UTILS.VALIDATE_DFF to validate delivery details DFF',WSH_DEBUG_SV.C_PROC_LEVEL);
3985: END IF;
3986: --
3987: WSH_FLEXFIELD_UTILS.Validate_DFF(
3988: p_table_name => 'WSH_DELIVERY_DETAILS',
3989: p_primary_id => l_delivery_detail_id,
3990: x_return_status => x_return_status);
3991:
3992: --

Line 4056: FROM wsh_delivery_details

4052: /*end of Bug 2096052 added for OKE */
4053:
4054: BEGIN
4055: SELECT delivery_detail_id INTO l_dummy_detail_id
4056: FROM wsh_delivery_details
4057: WHERE delivery_detail_id = l_delivery_detail_id
4058: FOR UPDATE NOWAIT;
4059:
4060: EXCEPTION

Line 4120: UPDATE WSH_DELIVERY_DETAILS

4116: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4117: wsh_util_core.add_message(x_return_status);
4118: l_num_warn := l_num_warn + 1;
4119:
4120: UPDATE WSH_DELIVERY_DETAILS
4121: SET INSPECTION_FLAG = 'I'
4122: WHERE DELIVERY_DETAIL_ID = l_dummy_detail_id ;
4123:
4124: END IF ;

Line 4473: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);

4469: --
4470: -- Debug Statements
4471: --
4472: IF l_debug_on THEN
4473: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4474: END IF;
4475: --
4476: wsh_delivery_details_actions.split_delivery_details(
4477: p_from_detail_id => l_assigned_line_ids( j ),

Line 4476: wsh_delivery_details_actions.split_delivery_details(

4472: IF l_debug_on THEN
4473: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4474: END IF;
4475: --
4476: wsh_delivery_details_actions.split_delivery_details(
4477: p_from_detail_id => l_assigned_line_ids( j ),
4478: p_req_quantity => l_stage_quantity,
4479: x_new_detail_id => l_new_detail_id,
4480: x_return_status => x_return_status,

Line 4593: UPDATE wsh_delivery_Details

4589:
4590: -- 8. Update quantities based on p_action_flag for null values (shipped and cycle count)
4591:
4592: FORALL tmp_counter IN 1..l_shp_dd_ids.count
4593: UPDATE wsh_delivery_Details
4594: SET shipped_quantity = l_shp_dd_shipped_qtys(tmp_counter),
4595: shipped_quantity2 = l_shp_dd_shipped_qtys2(tmp_counter),
4596: cycle_count_quantity = l_shp_dd_cc_qtys(tmp_counter),
4597: cycle_count_quantity2 = l_shp_dd_cc_qtys2(tmp_counter)

Line 4638: UPDATE WSH_DELIVERY_DETAILS

4634: -- csun, Bug 2823512, if the transaction_temp_id is not NULL
4635: -- set the shipped_quantity to be requested_quantity
4636:
4637: FORALL tmp_counter IN 1..l_stage_rows.count
4638: UPDATE WSH_DELIVERY_DETAILS
4639: SET -- TRACKING_NUMBER = NULL, Bug# 3632485
4640: SHIPPED_QUANTITY = DECODE (SERIAL_NUMBER, NULL,
4641: DECODE(TRANSACTION_TEMP_ID, NULL, NULL, PICKED_QUANTITY),
4642: PICKED_QUANTITY),

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

4859: --
4860: -- Debug Statements
4861: --
4862: IF l_debug_on THEN
4863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4864: END IF;
4865: --
4866: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),
4867: l_shp_dd_items( dd_count ),

Line 4866: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),

4862: IF l_debug_on THEN
4863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4864: END IF;
4865: --
4866: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),
4867: l_shp_dd_items( dd_count ),
4868: dft_subinv,
4869: x_return_status);
4870: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN

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

4880: --
4881: -- Debug Statements
4882: --
4883: IF l_debug_on THEN
4884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
4885: END IF;
4886: --
4887: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));
4888:

Line 4887: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));

4883: IF l_debug_on THEN
4884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
4885: END IF;
4886: --
4887: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));
4888:
4889: --
4890: -- Debug Statements
4891: --

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

4889: --
4890: -- Debug Statements
4891: --
4892: IF l_debug_on THEN
4893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
4894: END IF;
4895: --
4896: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
4897: nvl(l_shp_dd_subs ( dd_count ),dft_subinv),

Line 4896: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (

4892: IF l_debug_on THEN
4893: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
4894: END IF;
4895: --
4896: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
4897: nvl(l_shp_dd_subs ( dd_count ),dft_subinv),
4898: l_shp_dd_orgs ( dd_count ));
4899:
4900: item_loc_ctl := l_inv_controls_rec.location_control_code;

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

4901: --
4902: -- Debug Statements
4903: --
4904: IF l_debug_on THEN
4905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
4906: END IF;
4907: --
4908: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
4909: l_shp_dd_orgs ( dd_count ),

Line 4908: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(

4904: IF l_debug_on THEN
4905: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
4906: END IF;
4907: --
4908: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
4909: l_shp_dd_orgs ( dd_count ),
4910: l_inv_controls_rec.restrict_loc,
4911: org_loc_ctl,
4912: sub_loc_ctl,

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

4922: --
4923: -- Debug Statements
4924: --
4925: IF l_debug_on THEN
4926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4927: END IF;
4928: --
4929: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
4930: l_shp_dd_orgs ( dd_count ),

Line 4929: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (

4925: IF l_debug_on THEN
4926: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4927: END IF;
4928: --
4929: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
4930: l_shp_dd_orgs ( dd_count ),
4931: l_shp_dd_items ( dd_count ),
4932: NVL(l_shp_dd_subs ( dd_count ), dft_subinv),
4933: loc_restricted_flag);

Line 4944: update wsh_delivery_details set

4940: WSH_DEBUG_SV.logmsg(l_module_name, 'updating subinv/locator');
4941: WSH_DEBUG_SV.log(l_module_name, 'dft_subinv', dft_subinv);
4942: WSH_DEBUG_SV.log(l_module_name, 'dft_loc_id', dft_loc_id);
4943: END IF;
4944: update wsh_delivery_details set
4945: subinventory = NVL(subinventory, dft_subinv),
4946: locator_id = NVL(locator_id, dft_loc_id)
4947: where delivery_detail_id = l_shp_dd_ids ( dd_count );
4948: END IF;

Line 5148: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);

5144: --
5145: -- Debug Statements
5146: --
5147: IF l_debug_on THEN
5148: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
5149: END IF;
5150:
5151: -- Unassign the lines marked for unassigning.
5152: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(

Line 5152: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(

5148: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
5149: END IF;
5150:
5151: -- Unassign the lines marked for unassigning.
5152: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(
5153: p_ids_tobe_unassigned => l_unassign_dds ,
5154: p_validate_flag => 'N', -- want it to succeed in case of Planned Deliveries
5155: x_return_status => l_return_status
5156: );

Line 5195: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);

5191: --
5192: -- Debug Statements
5193: --
5194: IF l_debug_on THEN
5195: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
5196: END IF;
5197: -- Unassign Containers or Staged Lines using new API
5198: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(
5199: p_ids_tobe_unassigned => x_unassigned_cont ,

Line 5198: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(

5194: IF l_debug_on THEN
5195: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
5196: END IF;
5197: -- Unassign Containers or Staged Lines using new API
5198: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(
5199: p_ids_tobe_unassigned => x_unassigned_cont ,
5200: p_validate_flag => 'N', -- want it to succeed for Planned Deliveries too
5201: x_return_status => l_return_status
5202: );

Line 7483: wsh_delivery_details wdd

7479: select wdd.organization_id organization_id,
7480: nvl(wdd.line_direction,'O') line_direction,
7481: wdd.delivery_detail_id delivery_detail_id
7482: from wsh_delivery_assignments_v wda,
7483: wsh_delivery_details wdd
7484: where wda.delivery_detail_id = wdd.delivery_detail_id
7485: and wdd.container_flag IN ('Y','C')
7486: and nvl(wdd.line_direction,'O') IN ('O', 'IO')
7487: and wda.delivery_id = p_delivery_id;

Line 7650: UPDATE wsh_Delivery_details

7646: END IF;
7647: --}
7648: END IF;
7649: -- LPN CONV. rv
7650: UPDATE wsh_Delivery_details
7651: SET released_Status = 'C',
7652: shipped_quantity = DECODE(container_flag, 'Y', 1, shipped_quantity),
7653: inv_interfaced_flag = DECODE(container_flag, 'N', NVL(inv_interfaced_flag,'N'), NULL),
7654: oe_interfaced_flag = DECODE(container_flag, 'N', NVL(oe_interfaced_flag, 'N'), NULL),

Line 7672: -- Update of wsh_delivery_details where requested_quantity/released_status

7668: END IF;
7669: --
7670: --
7671: -- DBI Project
7672: -- Update of wsh_delivery_details where requested_quantity/released_status
7673: -- are changed, call DBI API after the update.
7674: -- DBI API will check if DBI is installed
7675: IF l_debug_on THEN
7676: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);

Line 8766: in wsh_new_deliveries and wsh_delivery_details */

8762: -- Following is old procedure as of I, which is replaced by proc. above in J
8763: -- remove after ut
8764:
8765: /* bug 2335270 Included last_update_date,last_updated_by and last_update_login
8766: in wsh_new_deliveries and wsh_delivery_details */
8767:
8768: -- J-IB-HEALI---{
8769: PROCEDURE Complete_Leg_Sequence
8770: ( p_delivery_id IN NUMBER,

Line 9191: 'FROM wsh_delivery_details dd, '||

9187:
9188: -- Bug 1421549: Changed the logic for load sequencing
9189: cont_str VARCHAR2(1000) :=
9190: 'SELECT dd.delivery_detail_id '||
9191: 'FROM wsh_delivery_details dd, '||
9192: 'wsh_delivery_assignments_v da '||
9193: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9194: 'da.parent_delivery_detail_id = :cont_id AND '||
9195: 'container_flag = ''N'' '||

Line 9207: 'FROM wsh_delivery_details dd, '||

9203: stmt_str VARCHAR2(1000) :=
9204: 'SELECT da.parent_delivery_detail_id, '||
9205: 'avg(customer_prod_seq) avg_prod_seq, '||
9206: 'count(*) '||
9207: 'FROM wsh_delivery_details dd, '||
9208: 'wsh_delivery_assignments_v da '||
9209: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9210: 'dd.customer_prod_seq IS NOT NULL AND '||
9211: 'dd.container_flag = ''N'' AND '||

Line 9337: UPDATE wsh_delivery_details

9333: EXIT WHEN continfo_cv%NOTFOUND;
9334:
9335: l_cnt := l_cnt + 1;
9336:
9337: UPDATE wsh_delivery_details
9338: SET load_seq_number = l_cnt
9339: WHERE delivery_detail_id = l_delivery_detail_id;
9340:
9341: END LOOP;

Line 9608: FROM wsh_delivery_details wdd,

9604: --
9605: CURSOR line_csr (p_delivery_id IN NUMBER)
9606: IS
9607: SELECT distinct freight_terms_code
9608: FROM wsh_delivery_details wdd,
9609: wsh_delivery_assignments_v wda
9610: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
9611: AND wda.delivery_id = p_delivery_id
9612: AND NVL(wdd.container_flag,'N') = 'N';

Line 10115: UPDATE WSH_DELIVERY_DETAILS

10111: WHERE delivery_id = p_delivery_id;
10112: */
10113: --
10114: --
10115: UPDATE WSH_DELIVERY_DETAILS
10116: SET SHIP_FROM_LOCATION_ID = p_location_id,
10117: last_update_date = SYSDATE,
10118: last_updated_by = FND_GLOBAL.USER_ID,
10119: last_update_login = FND_GLOBAL.LOGIN_ID

Line 10254: UPDATE WSH_DELIVERY_DETAILS

10250: last_update_login = FND_GLOBAL.LOGIN_ID
10251: WHERE delivery_id = pickup_dlvy_rec.delivery_id;
10252: --
10253: --
10254: UPDATE WSH_DELIVERY_DETAILS
10255: SET SHIP_FROM_LOCATION_ID = p_location_id,
10256: last_update_date = SYSDATE,
10257: last_updated_by = FND_GLOBAL.USER_ID,
10258: last_update_login = FND_GLOBAL.LOGIN_ID

Line 10708: FROM wsh_delivery_details wdd,

10704: IS
10705:
10706: CURSOR c_get_ship_to_site IS
10707: SELECT DISTINCT wdd.ship_to_site_use_id
10708: FROM wsh_delivery_details wdd,
10709: wsh_delivery_assignments wda
10710: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10711: AND wda.delivery_id = p_delivery_id
10712: AND wdd.ship_to_site_use_id IS NOT NULL;

Line 10858: FROM wsh_delivery_details wdd,

10854: FROM hz_cust_site_uses_all hcsu,
10855: hz_cust_acct_sites_all hcas
10856: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
10857: AND hcsu.site_use_id IN (SELECT DISTINCT wdd.ship_to_site_use_id
10858: FROM wsh_delivery_details wdd,
10859: wsh_delivery_assignments wda
10860: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10861: AND wda.delivery_id = p_delivery_id);
10862:

Line 13270: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_id => l_valid_children_tab(i));

13266: END IF;
13267:
13268: BEGIN
13269: FOR i in 1..l_valid_children_tab.count LOOP
13270: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_id => l_valid_children_tab(i));
13271: END LOOP;
13272:
13273: EXCEPTION
13274: WHEN OTHERS THEN

Line 13985: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_id => l_assigned_dels_tab(i));

13981:
13982: BEGIN
13983:
13984: FOR i in 1..l_assigned_dels_tab.count LOOP
13985: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_id => l_assigned_dels_tab(i));
13986: END LOOP;
13987:
13988: EXCEPTION
13989: WHEN OTHERS THEN

Line 14293: wsh_delivery_details dd

14289:
14290: CURSOR c_get_child_lpn_number(p_delivery_id IN NUMBER) IS
14291: select count(*)
14292: from wsh_delivery_assignments da,
14293: wsh_delivery_details dd
14294: where da.type = 'C'
14295: and da.parent_delivery_detail_id IS NULL
14296: and da.delivery_detail_id = dd.delivery_detail_id
14297: and dd.container_flag = 'Y'

Line 14762: wsh_delivery_details wdd

14758:
14759: CURSOR c_delivery_detail_count(p_del_id IN NUMBER) IS
14760: SELECT 1
14761: FROM wsh_delivery_assignments wda,
14762: wsh_delivery_details wdd
14763: WHERE wda.delivery_id = p_del_id
14764: AND wda.delivery_detail_id = wdd.delivery_detail_id
14765: AND wdd.container_flag = 'N';
14766: