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

2600: dd.subinventory ,
2601: dd.locator_id,
2602: dd.source_code, /*Bug 2096052 for OKE */
2603: dd.source_line_id -- Consolidation of BO Delivery Details project
2604: FROM wsh_delivery_details dd,
2605: wsh_delivery_assignments_v da
2606: WHERE da.delivery_id = v_delivery_id AND
2607: da.delivery_id IS NOT NULL AND
2608: da.delivery_detail_id = dd.delivery_detail_id AND

Line 2632: WSH_DELIVERY_DETAILS dd

2628:
2629: CURSOR get_empty_containers(v_delivery_id NUMBER) IS
2630: SELECT da.delivery_detail_id
2631: FROM wsh_delivery_assignments_v da,
2632: WSH_DELIVERY_DETAILS dd
2633: WHERE da.delivery_id = v_delivery_id
2634: AND da.delivery_detail_id = dd.delivery_detail_id
2635: AND dd.container_flag = 'Y'
2636: AND NOT EXISTS(

Line 2754: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

2750: l_dd_org_ids wsh_util_core.id_tab_type; -- list of details org ids
2751: l_item_ids wsh_util_core.id_tab_type; -- list of details inventory_item_ids
2752:
2753: -- for non-transactable items
2754: l_inv_controls_rec WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
2755: dft_subinv VARCHAR2(30);
2756: loc_restricted_flag VARCHAR2(1);
2757: dft_loc_id NUMBER;
2758: org_loc_ctl NUMBER;

Line 2763: g_line_inv_rec WSH_DELIVERY_DETAILS_INV.line_inv_info;

2759: sub_loc_ctl NUMBER;
2760: item_loc_ctl NUMBER;
2761: loc_ctl_code NUMBER;
2762:
2763: g_line_inv_rec WSH_DELIVERY_DETAILS_INV.line_inv_info;
2764: l_details_flag BOOLEAN;
2765:
2766: l_ship_from_location NUMBER;
2767: l_ship_to_location NUMBER;

Line 3070: wsh_delivery_details wdd

3066: -- LPN CONV rv
3067: cursor l_delete_wms_empty_cnt_csr is
3068: select distinct wwst.delivery_detail_id
3069: from wsh_wms_sync_tmp wwst,
3070: wsh_delivery_details wdd
3071: where wwst.operation_type = 'DELETE'
3072: and wdd.delivery_detail_id = wwst.delivery_detail_id
3073: and wdd.container_flag = 'Y'
3074: and wdd.lpn_id is not null;

Line 3935: p_table_name => 'WSH_DELIVERY_DETAILS',

3931: WSH_DEBUG_SV.logmsg(l_module_name,'Calling WSH_FLEXFIELD_UTILS.VALIDATE_DFF to validate delivery details DFF',WSH_DEBUG_SV.C_PROC_LEVEL);
3932: END IF;
3933: --
3934: WSH_FLEXFIELD_UTILS.Validate_DFF(
3935: p_table_name => 'WSH_DELIVERY_DETAILS',
3936: p_primary_id => l_delivery_detail_id,
3937: x_return_status => x_return_status);
3938:
3939: --

Line 4003: FROM wsh_delivery_details

3999: /*end of Bug 2096052 added for OKE */
4000:
4001: BEGIN
4002: SELECT delivery_detail_id INTO l_dummy_detail_id
4003: FROM wsh_delivery_details
4004: WHERE delivery_detail_id = l_delivery_detail_id
4005: FOR UPDATE NOWAIT;
4006:
4007: EXCEPTION

Line 4067: UPDATE WSH_DELIVERY_DETAILS

4063: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4064: wsh_util_core.add_message(x_return_status);
4065: l_num_warn := l_num_warn + 1;
4066:
4067: UPDATE WSH_DELIVERY_DETAILS
4068: SET INSPECTION_FLAG = 'I'
4069: WHERE DELIVERY_DETAIL_ID = l_dummy_detail_id ;
4070:
4071: END IF ;

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

4399: --
4400: -- Debug Statements
4401: --
4402: IF l_debug_on THEN
4403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4404: END IF;
4405: --
4406: wsh_delivery_details_actions.split_delivery_details(
4407: p_from_detail_id => l_assigned_line_ids( j ),

Line 4406: wsh_delivery_details_actions.split_delivery_details(

4402: IF l_debug_on THEN
4403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.SPLIT_DELIVERY_DETAILS',WSH_DEBUG_SV.C_PROC_LEVEL);
4404: END IF;
4405: --
4406: wsh_delivery_details_actions.split_delivery_details(
4407: p_from_detail_id => l_assigned_line_ids( j ),
4408: p_req_quantity => l_stage_quantity,
4409: x_new_detail_id => l_new_detail_id,
4410: x_return_status => x_return_status,

Line 4511: UPDATE wsh_delivery_Details

4507:
4508: -- 8. Update quantities based on p_action_flag for null values (shipped and cycle count)
4509:
4510: FORALL tmp_counter IN 1..l_shp_dd_ids.count
4511: UPDATE wsh_delivery_Details
4512: SET shipped_quantity = l_shp_dd_shipped_qtys(tmp_counter),
4513: shipped_quantity2 = l_shp_dd_shipped_qtys2(tmp_counter),
4514: cycle_count_quantity = l_shp_dd_cc_qtys(tmp_counter),
4515: cycle_count_quantity2 = l_shp_dd_cc_qtys2(tmp_counter)

Line 4556: UPDATE WSH_DELIVERY_DETAILS

4552: -- csun, Bug 2823512, if the transaction_temp_id is not NULL
4553: -- set the shipped_quantity to be requested_quantity
4554:
4555: FORALL tmp_counter IN 1..l_stage_rows.count
4556: UPDATE WSH_DELIVERY_DETAILS
4557: SET -- TRACKING_NUMBER = NULL, Bug# 3632485
4558: SHIPPED_QUANTITY = DECODE (SERIAL_NUMBER, NULL,
4559: DECODE(TRANSACTION_TEMP_ID, NULL, NULL, PICKED_QUANTITY),
4560: PICKED_QUANTITY),

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

4775: --
4776: -- Debug Statements
4777: --
4778: IF l_debug_on THEN
4779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4780: END IF;
4781: --
4782: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),
4783: l_shp_dd_items( dd_count ),

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

4778: IF l_debug_on THEN
4779: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_SUBINVENTORY',WSH_DEBUG_SV.C_PROC_LEVEL);
4780: END IF;
4781: --
4782: WSH_DELIVERY_DETAILS_INV.Default_Subinventory ( l_shp_dd_orgs ( dd_count ),
4783: l_shp_dd_items( dd_count ),
4784: dft_subinv,
4785: x_return_status);
4786: IF ( l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ) THEN

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

4796: --
4797: -- Debug Statements
4798: --
4799: IF l_debug_on THEN
4800: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
4801: END IF;
4802: --
4803: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));
4804:

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

4799: IF l_debug_on THEN
4800: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_ORG_LOC',WSH_DEBUG_SV.C_PROC_LEVEL);
4801: END IF;
4802: --
4803: org_loc_ctl := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_shp_dd_orgs ( dd_count ));
4804:
4805: --
4806: -- Debug Statements
4807: --

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

4805: --
4806: -- Debug Statements
4807: --
4808: IF l_debug_on THEN
4809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
4810: END IF;
4811: --
4812: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
4813: nvl(l_shp_dd_subs ( dd_count ),dft_subinv),

Line 4812: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (

4808: IF l_debug_on THEN
4809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.SUB_LOC_CTL',WSH_DEBUG_SV.C_PROC_LEVEL);
4810: END IF;
4811: --
4812: sub_loc_ctl := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (
4813: nvl(l_shp_dd_subs ( dd_count ),dft_subinv),
4814: l_shp_dd_orgs ( dd_count ));
4815:
4816: item_loc_ctl := l_inv_controls_rec.location_control_code;

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

4817: --
4818: -- Debug Statements
4819: --
4820: IF l_debug_on THEN
4821: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
4822: END IF;
4823: --
4824: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
4825: l_shp_dd_orgs ( dd_count ),

Line 4824: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(

4820: IF l_debug_on THEN
4821: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.LOCATOR_CTL_CODE',WSH_DEBUG_SV.C_PROC_LEVEL);
4822: END IF;
4823: --
4824: loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(
4825: l_shp_dd_orgs ( dd_count ),
4826: l_inv_controls_rec.restrict_loc,
4827: org_loc_ctl,
4828: sub_loc_ctl,

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

4838: --
4839: -- Debug Statements
4840: --
4841: IF l_debug_on THEN
4842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4843: END IF;
4844: --
4845: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
4846: l_shp_dd_orgs ( dd_count ),

Line 4845: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (

4841: IF l_debug_on THEN
4842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.DEFAULT_LOCATOR',WSH_DEBUG_SV.C_PROC_LEVEL);
4843: END IF;
4844: --
4845: dft_loc_id := WSH_DELIVERY_DETAILS_INV.Default_Locator (
4846: l_shp_dd_orgs ( dd_count ),
4847: l_shp_dd_items ( dd_count ),
4848: NVL(l_shp_dd_subs ( dd_count ), dft_subinv),
4849: loc_restricted_flag);

Line 4860: update wsh_delivery_details set

4856: WSH_DEBUG_SV.logmsg(l_module_name, 'updating subinv/locator');
4857: WSH_DEBUG_SV.log(l_module_name, 'dft_subinv', dft_subinv);
4858: WSH_DEBUG_SV.log(l_module_name, 'dft_loc_id', dft_loc_id);
4859: END IF;
4860: update wsh_delivery_details set
4861: subinventory = NVL(subinventory, dft_subinv),
4862: locator_id = NVL(locator_id, dft_loc_id)
4863: where delivery_detail_id = l_shp_dd_ids ( dd_count );
4864: END IF;

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

5060: --
5061: -- Debug Statements
5062: --
5063: IF l_debug_on THEN
5064: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
5065: END IF;
5066:
5067: -- Unassign the lines marked for unassigning.
5068: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(

Line 5068: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(

5064: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
5065: END IF;
5066:
5067: -- Unassign the lines marked for unassigning.
5068: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(
5069: p_ids_tobe_unassigned => l_unassign_dds ,
5070: p_validate_flag => 'N', -- want it to succeed in case of Planned Deliveries
5071: x_return_status => l_return_status
5072: );

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

5107: --
5108: -- Debug Statements
5109: --
5110: IF l_debug_on THEN
5111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
5112: END IF;
5113: -- Unassign Containers or Staged Lines using new API
5114: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(
5115: p_ids_tobe_unassigned => x_unassigned_cont ,

Line 5114: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(

5110: IF l_debug_on THEN
5111: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_UNPACK_EMPTY_CONT',WSH_DEBUG_SV.C_PROC_LEVEL);
5112: END IF;
5113: -- Unassign Containers or Staged Lines using new API
5114: WSH_DELIVERY_DETAILS_ACTIONS.unassign_unpack_empty_cont(
5115: p_ids_tobe_unassigned => x_unassigned_cont ,
5116: p_validate_flag => 'N', -- want it to succeed for Planned Deliveries too
5117: x_return_status => l_return_status
5118: );

Line 7343: wsh_delivery_details wdd

7339: select wdd.organization_id organization_id,
7340: nvl(wdd.line_direction,'O') line_direction,
7341: wdd.delivery_detail_id delivery_detail_id
7342: from wsh_delivery_assignments_v wda,
7343: wsh_delivery_details wdd
7344: where wda.delivery_detail_id = wdd.delivery_detail_id
7345: and wdd.container_flag IN ('Y','C')
7346: and nvl(wdd.line_direction,'O') IN ('O', 'IO')
7347: and wda.delivery_id = p_delivery_id;

Line 7500: UPDATE wsh_Delivery_details

7496: END IF;
7497: --}
7498: END IF;
7499: -- LPN CONV. rv
7500: UPDATE wsh_Delivery_details
7501: SET released_Status = 'C',
7502: shipped_quantity = DECODE(container_flag, 'Y', 1, shipped_quantity),
7503: inv_interfaced_flag = DECODE(container_flag, 'N', NVL(inv_interfaced_flag,'N'), NULL),
7504: oe_interfaced_flag = DECODE(container_flag, 'N', NVL(oe_interfaced_flag, 'N'), NULL),

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

7518: END IF;
7519: --
7520: --
7521: -- DBI Project
7522: -- Update of wsh_delivery_details where requested_quantity/released_status
7523: -- are changed, call DBI API after the update.
7524: -- DBI API will check if DBI is installed
7525: IF l_debug_on THEN
7526: WSH_DEBUG_SV.log(l_module_name,'Calling DBI API.Detail Count-',l_detail_tab.count);

Line 8570: in wsh_new_deliveries and wsh_delivery_details */

8566: -- Following is old procedure as of I, which is replaced by proc. above in J
8567: -- remove after ut
8568:
8569: /* bug 2335270 Included last_update_date,last_updated_by and last_update_login
8570: in wsh_new_deliveries and wsh_delivery_details */
8571:
8572: -- J-IB-HEALI---{
8573: PROCEDURE Complete_Leg_Sequence
8574: ( p_delivery_id IN NUMBER,

Line 8995: 'FROM wsh_delivery_details dd, '||

8991:
8992: -- Bug 1421549: Changed the logic for load sequencing
8993: cont_str VARCHAR2(1000) :=
8994: 'SELECT dd.delivery_detail_id '||
8995: 'FROM wsh_delivery_details dd, '||
8996: 'wsh_delivery_assignments_v da '||
8997: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
8998: 'da.parent_delivery_detail_id = :cont_id AND '||
8999: 'container_flag = ''N'' '||

Line 9011: 'FROM wsh_delivery_details dd, '||

9007: stmt_str VARCHAR2(1000) :=
9008: 'SELECT da.parent_delivery_detail_id, '||
9009: 'avg(customer_prod_seq) avg_prod_seq, '||
9010: 'count(*) '||
9011: 'FROM wsh_delivery_details dd, '||
9012: 'wsh_delivery_assignments_v da '||
9013: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9014: 'dd.customer_prod_seq IS NOT NULL AND '||
9015: 'dd.container_flag = ''N'' AND '||

Line 9141: UPDATE wsh_delivery_details

9137: EXIT WHEN continfo_cv%NOTFOUND;
9138:
9139: l_cnt := l_cnt + 1;
9140:
9141: UPDATE wsh_delivery_details
9142: SET load_seq_number = l_cnt
9143: WHERE delivery_detail_id = l_delivery_detail_id;
9144:
9145: END LOOP;

Line 9412: FROM wsh_delivery_details wdd,

9408: --
9409: CURSOR line_csr (p_delivery_id IN NUMBER)
9410: IS
9411: SELECT distinct freight_terms_code
9412: FROM wsh_delivery_details wdd,
9413: wsh_delivery_assignments_v wda
9414: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
9415: AND wda.delivery_id = p_delivery_id
9416: AND NVL(wdd.container_flag,'N') = 'N';

Line 9919: UPDATE WSH_DELIVERY_DETAILS

9915: WHERE delivery_id = p_delivery_id;
9916: */
9917: --
9918: --
9919: UPDATE WSH_DELIVERY_DETAILS
9920: SET SHIP_FROM_LOCATION_ID = p_location_id,
9921: last_update_date = SYSDATE,
9922: last_updated_by = FND_GLOBAL.USER_ID,
9923: last_update_login = FND_GLOBAL.LOGIN_ID

Line 10058: UPDATE WSH_DELIVERY_DETAILS

10054: last_update_login = FND_GLOBAL.LOGIN_ID
10055: WHERE delivery_id = pickup_dlvy_rec.delivery_id;
10056: --
10057: --
10058: UPDATE WSH_DELIVERY_DETAILS
10059: SET SHIP_FROM_LOCATION_ID = p_location_id,
10060: last_update_date = SYSDATE,
10061: last_updated_by = FND_GLOBAL.USER_ID,
10062: last_update_login = FND_GLOBAL.LOGIN_ID

Line 10512: FROM wsh_delivery_details wdd,

10508: IS
10509:
10510: CURSOR c_get_ship_to_site IS
10511: SELECT DISTINCT wdd.ship_to_site_use_id
10512: FROM wsh_delivery_details wdd,
10513: wsh_delivery_assignments wda
10514: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10515: AND wda.delivery_id = p_delivery_id
10516: AND wdd.ship_to_site_use_id IS NOT NULL;

Line 10662: FROM wsh_delivery_details wdd,

10658: FROM hz_cust_site_uses_all hcsu,
10659: hz_cust_acct_sites_all hcas
10660: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
10661: AND hcsu.site_use_id IN (SELECT DISTINCT wdd.ship_to_site_use_id
10662: FROM wsh_delivery_details wdd,
10663: wsh_delivery_assignments wda
10664: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10665: AND wda.delivery_id = p_delivery_id);
10666:

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

13069: END IF;
13070:
13071: BEGIN
13072: FOR i in 1..l_valid_children_tab.count LOOP
13073: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_id => l_valid_children_tab(i));
13074: END LOOP;
13075:
13076: EXCEPTION
13077: WHEN OTHERS THEN

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

13784:
13785: BEGIN
13786:
13787: FOR i in 1..l_assigned_dels_tab.count LOOP
13788: WSH_DELIVERY_DETAILS_PKG.lock_wda_no_compare(p_delivery_id => l_assigned_dels_tab(i));
13789: END LOOP;
13790:
13791: EXCEPTION
13792: WHEN OTHERS THEN

Line 14096: wsh_delivery_details dd

14092:
14093: CURSOR c_get_child_lpn_number(p_delivery_id IN NUMBER) IS
14094: select count(*)
14095: from wsh_delivery_assignments da,
14096: wsh_delivery_details dd
14097: where da.type = 'C'
14098: and da.parent_delivery_detail_id IS NULL
14099: and da.delivery_detail_id = dd.delivery_detail_id
14100: and dd.container_flag = 'Y'

Line 14565: wsh_delivery_details wdd

14561:
14562: CURSOR c_delivery_detail_count(p_del_id IN NUMBER) IS
14563: SELECT 1
14564: FROM wsh_delivery_assignments wda,
14565: wsh_delivery_details wdd
14566: WHERE wda.delivery_id = p_del_id
14567: AND wda.delivery_detail_id = wdd.delivery_detail_id
14568: AND wdd.container_flag = 'N';
14569: