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

Line 72: FROM wsh_delivery_details wdd,

68: wdd.shipping_control,
69: wdd.vendor_id,
70: wdd.party_id,
71: wdd.wv_frozen_flag -- WV changes
72: FROM wsh_delivery_details wdd,
73: wsh_delivery_assignments_v wda
74: WHERE
75: (
76: wdd.source_code = x_plan_source_code

Line 1020: from wsh_delivery_details a,

1016: -- outbound: this cursor checks if the delivery detail or other delivery
1017: -- details in its order line are available (not canceled or shipped).
1018: cursor c_check_detail_valid (p_delivery_detail_id in number) is
1019: select a.released_status, a.delivery_detail_id
1020: from wsh_delivery_details a,
1021: wsh_delivery_details b
1022: where b.delivery_detail_id = p_delivery_detail_id
1023: and b.released_status = 'D'
1024: and a.source_code = b.source_code

Line 1021: wsh_delivery_details b

1017: -- details in its order line are available (not canceled or shipped).
1018: cursor c_check_detail_valid (p_delivery_detail_id in number) is
1019: select a.released_status, a.delivery_detail_id
1020: from wsh_delivery_details a,
1021: wsh_delivery_details b
1022: where b.delivery_detail_id = p_delivery_detail_id
1023: and b.released_status = 'D'
1024: and a.source_code = b.source_code
1025: and a.source_line_id = b.source_line_id

Line 1031: from wsh_delivery_details

1027: and a.released_status NOT IN ('C', 'D')
1028: and rownum = 1
1029: UNION
1030: select released_status, delivery_detail_id
1031: from wsh_delivery_details
1032: where released_status NOT IN ('C', 'D')
1033: and delivery_detail_id = p_delivery_detail_id;
1034:
1035: -- outbound: this cursor checks if the line set can be found

Line 1040: from wsh_delivery_details a,

1036: -- for the delivery detail where delivery
1037: -- details in this set are available (not canceled or shipped).
1038: cursor c_check_set_valid (p_delivery_detail_id in number) is
1039: select a.released_status, a.delivery_detail_id
1040: from wsh_delivery_details a,
1041: wsh_delivery_details b
1042: where b.delivery_detail_id = p_delivery_detail_id
1043: and a.source_code = b.source_code
1044: and a.source_header_id = b.source_header_id

Line 1041: wsh_delivery_details b

1037: -- details in this set are available (not canceled or shipped).
1038: cursor c_check_set_valid (p_delivery_detail_id in number) is
1039: select a.released_status, a.delivery_detail_id
1040: from wsh_delivery_details a,
1041: wsh_delivery_details b
1042: where b.delivery_detail_id = p_delivery_detail_id
1043: and a.source_code = b.source_code
1044: and a.source_header_id = b.source_header_id
1045: and a.source_line_set_id IN (

Line 1047: FROM WSH_DELIVERY_DETAILS c

1043: and a.source_code = b.source_code
1044: and a.source_header_id = b.source_header_id
1045: and a.source_line_set_id IN (
1046: SELECT c.source_line_set_id
1047: FROM WSH_DELIVERY_DETAILS c
1048: WHERE c.source_code = b.source_code
1049: AND c.source_line_id = b.source_line_id
1050: AND c.source_line_set_id IS NOT NULL)
1051: and a.delivery_detail_id <> b.delivery_detail_id

Line 1061: from wsh_delivery_details wdd

1057: cursor c_find_line (p_source_code in varchar2,
1058: p_source_header_id in number,
1059: p_source_line_id in number) is
1060: select wdd.delivery_detail_id
1061: from wsh_delivery_details wdd
1062: where wdd.source_code = p_source_code
1063: and wdd.source_header_id = p_source_header_id
1064: and wdd.source_line_id = p_source_line_id
1065: and wdd.container_flag = 'N'

Line 1075: from wsh_delivery_details wdd

1071: cursor c_get_line_set (p_source_code in varchar2,
1072: p_source_header_id in number,
1073: p_source_line_id in number) is
1074: select wdd.source_line_set_id
1075: from wsh_delivery_details wdd
1076: where wdd.source_code = p_source_code
1077: and wdd.source_header_id = p_source_header_id
1078: and wdd.source_line_id = p_source_line_id
1079: and wdd.container_flag = 'N'

Line 1089: from wsh_delivery_details wdd

1085: cursor c_find_set (p_source_code in varchar2,
1086: p_source_header_id in number,
1087: p_source_line_set_id in number) is
1088: select wdd.delivery_detail_id
1089: from wsh_delivery_details wdd
1090: where wdd.source_code = p_source_code
1091: and wdd.source_header_id = p_source_header_id
1092: and wdd.source_line_set_id = p_source_line_set_id
1093: and wdd.container_flag = 'N'

Line 1103: from wsh_delivery_details a,

1099: -- details in its order line are available (viz., po line shipment has
1100: -- a detail with released status 'X')
1101: cursor c_check_inbound_detail_valid (p_delivery_detail_id in number) is
1102: select a.delivery_detail_id
1103: from wsh_delivery_details a,
1104: wsh_delivery_details b
1105: where b.delivery_detail_id = p_delivery_detail_id
1106: and a.source_code = b.source_code
1107: and a.source_line_id = b.source_line_id

Line 1104: wsh_delivery_details b

1100: -- a detail with released status 'X')
1101: cursor c_check_inbound_detail_valid (p_delivery_detail_id in number) is
1102: select a.delivery_detail_id
1103: from wsh_delivery_details a,
1104: wsh_delivery_details b
1105: where b.delivery_detail_id = p_delivery_detail_id
1106: and a.source_code = b.source_code
1107: and a.source_line_id = b.source_line_id
1108: and a.po_shipment_line_id = b.po_shipment_line_id

Line 1114: from wsh_delivery_details

1110: and a.released_status = 'X'
1111: and rownum = 1
1112: UNION
1113: select delivery_detail_id
1114: from wsh_delivery_details
1115: where released_status = 'X'
1116: and delivery_detail_id = p_delivery_detail_id;
1117:
1118:

Line 1287: from wsh_delivery_details wdd

1283: FORALL i in 1..l_dd_interface_id.count
1284: UPDATE wsh_del_details_interface
1285: SET (source_line_id, source_line_set_id, source_header_id) =
1286: (select wdd.source_line_id, wdd.source_line_set_id, wdd.source_header_id
1287: from wsh_delivery_details wdd
1288: where wdd.delivery_detail_id = l_dd_id(i))
1289: WHERE delivery_detail_interface_id = l_dd_interface_id(i);
1290:
1291: END IF;

Line 1352: from wsh_delivery_details wdd

1348: FORALL i in 1..l_dd_interface_id.count
1349: UPDATE wsh_del_details_interface
1350: SET (source_line_id, source_line_set_id, source_header_id, po_shipment_line_id, po_shipment_line_number) =
1351: (select wdd.source_line_id, wdd.source_line_set_id, wdd.source_header_id, po_shipment_line_id, po_shipment_line_number
1352: from wsh_delivery_details wdd
1353: where wdd.delivery_detail_id = l_dd_id(i))
1354: WHERE delivery_detail_interface_id = l_dd_interface_id(i);
1355:
1356: END IF;

Line 1527: l_current_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE := NULL;

1523: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GENERATE_LOCK_CANDIDATES';
1524: --
1525: l_debug_on BOOLEAN;
1526:
1527: l_current_source_code WSH_DELIVERY_DETAILS.SOURCE_CODE%TYPE := NULL;
1528: l_current_line_set_id NUMBER := NULL;
1529: l_current_line_id NUMBER := NULL;
1530: l_current_po_shipment_line_id NUMBER := NULL;
1531: l_current_used_details used_details_tab_type;

Line 1552: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

1548: l_target_delivery_interface_id NUMBER := 0;
1549: l_dummy_dd_id NUMBER;
1550:
1551: -- HW OPMCONV - Removed OPM local variables and added l_item_info
1552: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
1553: l_msg_data VARCHAR2(4000);
1554: l_msg_count NUMBER;
1555: l_last_interface_id NUMBER;
1556: l_stop_index NUMBER;

Line 1904: FROM WSH_DELIVERY_DETAILS wdd

1900: -- it is not yet staged.
1901: CURSOR c_being_staged(p_source_code IN VARCHAR2,
1902: p_source_line_id IN VARCHAR2) IS
1903: SELECT wdd.delivery_detail_id
1904: FROM WSH_DELIVERY_DETAILS wdd
1905: WHERE wdd.source_code = p_source_code
1906: AND wdd.source_line_id = p_source_line_id
1907: AND wdd.released_status IN ('B', 'S', 'Y', 'C')
1908: AND rownum = 1;

Line 1920: FROM wsh_delivery_details wdd

1916: p_source_line_id IN NUMBER,
1917: p_ship_from_location_id IN NUMBER,
1918: p_ship_to_location_id IN NUMBER) IS
1919: SELECT wdd.delivery_detail_id
1920: FROM wsh_delivery_details wdd
1921: WHERE
1922: (
1923: wdd.source_code = p_source_code
1924: AND wdd.source_header_id = p_source_header_id

Line 1940: FROM wsh_delivery_details wdd

1936: CURSOR c_ignored(p_source_code IN VARCHAR2,
1937: p_source_header_id IN VARCHAR2,
1938: p_source_line_id IN NUMBER) IS
1939: SELECT wdd.delivery_detail_id
1940: FROM wsh_delivery_details wdd
1941: WHERE
1942: (
1943: wdd.source_code = p_source_code
1944: AND wdd.source_header_id = p_source_header_id

Line 1950: FROM wsh_delivery_details wdd2

1946: )
1947: AND wdd.released_status IN ('N', 'R', 'B', 'S', 'Y', 'X')
1948: AND wdd.ignore_for_planning = 'Y'
1949: AND NOT EXISTS (SELECT 'planning'
1950: FROM wsh_delivery_details wdd2
1951: WHERE wdd2.source_code = p_source_code
1952: AND wdd2.source_header_id = p_source_header_id
1953: AND wdd2.source_line_id = p_source_line_id
1954: AND nvl(wdd2.ignore_for_planning, 'N') = 'N')

Line 2156: wsh_delivery_details_pkg.lock_detail_no_compare(

2152: RETURN;
2153: END;
2154:
2155: BEGIN
2156: wsh_delivery_details_pkg.lock_detail_no_compare(
2157: p_delivery_id => idel.delivery_id);
2158: EXCEPTION
2159: WHEN OTHERS THEN
2160: stamp_interface_error(

Line 2463: wsh_delivery_details_pkg.lock_detail_no_compare(

2459:
2460: IF NOT l_match_found THEN --{
2461: -- delivery detail is new. Lock it and add it to the list of used details.
2462: BEGIN
2463: wsh_delivery_details_pkg.lock_detail_no_compare(
2464: p_delivery_detail_id => candidate.delivery_detail_id);
2465: EXCEPTION
2466: WHEN OTHERS THEN
2467: stamp_interface_error(

Line 2645: WSH_DELIVERY_DETAILS_INV.Get_item_information

2641:
2642: -- HW OPMCONV - Removed branching and replaced old OPM API call
2643: -- to check for item with new WSH API
2644:
2645: WSH_DELIVERY_DETAILS_INV.Get_item_information
2646: (
2647: p_organization_id => candidate.organization_id
2648: , p_inventory_item_id => candidate.inventory_item_id
2649: , x_mtl_system_items_rec => l_item_info

Line 2863: FROM wsh_delivery_details wdd

2859: wdd.container_flag,
2860: wdd.lpn_id,
2861: wdd.released_status,
2862: wdd.source_code
2863: FROM wsh_delivery_details wdd
2864: WHERE delivery_detail_id = p_detail_id;
2865:
2866: BEGIN
2867: -- l_cont_index and l_cont_found have been set up

Line 2901: wsh_delivery_details_pkg.lock_detail_no_compare(

2897: x_track_conts(l_cont_index).source_code := c.source_code;
2898: END IF;
2899:
2900: BEGIN
2901: wsh_delivery_details_pkg.lock_detail_no_compare(
2902: p_delivery_detail_id => c.delivery_detail_id);
2903: EXCEPTION
2904: WHEN OTHERS THEN
2905: stamp_interface_error(

Line 4892: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(

4888: -- invoke unassignment only if there are outbound details
4889: l_dd_action_prms.caller := 'WSH_TP_RELEASE';
4890: l_dd_action_prms.action_code := 'UNASSIGN';
4891:
4892: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
4893: p_api_version_number => 1.0,
4894: p_init_msg_list => FND_API.G_TRUE,
4895: p_commit => FND_API.G_FALSE,
4896: x_return_status => l_return_status,

Line 5259: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(

5255: END IF;
5256: END IF;
5257:
5258:
5259: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5260: p_api_version_number => 1.0,
5261: p_init_msg_list => FND_API.G_TRUE,
5262: p_commit => FND_API.G_FALSE,
5263: x_return_status => l_return_status,

Line 5384: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(

5380: l_dd_action_prms.caller := 'WSH_TP_RELEASE';
5381: l_dd_action_prms.action_code := 'UNASSIGN';
5382: l_dd_action_prms.split_quantity := NULL;
5383:
5384: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5385: p_api_version_number => 1.0,
5386: p_init_msg_list => FND_API.G_TRUE,
5387: p_commit => FND_API.G_FALSE,
5388: x_return_status => l_return_status,

Line 5428: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(

5424: l_dd_action_prms.action_code := 'SPLIT_DELIVERY';
5425: l_dd_action_prms.split_quantity := NULL;
5426: l_dd_action_prms.delivery_id := NULL;
5427:
5428: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5429: p_api_version_number => 1.0,
5430: p_init_msg_list => FND_API.G_TRUE,
5431: p_commit => FND_API.G_FALSE,
5432: x_return_status => l_return_status,

Line 5575: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(

5571: l_dd_action_prms.action_code := 'UNASSIGN';
5572: l_dd_action_prms.split_quantity := NULL;
5573: l_dd_action_prms.delivery_id := NULL;
5574:
5575: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5576: p_api_version_number => 1.0,
5577: p_init_msg_list => FND_API.G_TRUE,
5578: p_commit => FND_API.G_FALSE,
5579: x_return_status => l_return_status,

Line 5702: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(

5698:
5699: l_work_index := l_next_index;
5700: END LOOP;
5701:
5702: WSH_DELIVERY_DETAILS_GRP.delivery_detail_action(
5703: p_api_version_number => 1.0,
5704: p_init_msg_list => FND_API.G_TRUE,
5705: p_commit => FND_API.G_FALSE,
5706: x_return_status => l_return_status,

Line 5813: UPDATE wsh_delivery_details

5809:
5810: -- avoid overhead of calling group API to update one column
5811: l_index := x_plan_details.FIRST;
5812: WHILE l_index IS NOT NULL LOOP
5813: UPDATE wsh_delivery_details
5814: SET tp_delivery_detail_id = x_plan_details(l_index).tp_delivery_detail_id,
5815: last_update_date = SYSDATE,
5816: last_updated_by = FND_GLOBAL.USER_ID
5817: WHERE delivery_detail_id = x_plan_details(l_index).delivery_detail_id;

Line 6649: from wsh_delivery_details wdd,

6645: select wdd.delivery_detail_id,
6646: wdd.ship_from_location_id,
6647: wdd.earliest_pickup_date,
6648: wdd.latest_dropoff_date
6649: from wsh_delivery_details wdd,
6650: wsh_new_deliveries wnd,
6651: wsh_delivery_assignments_v wda
6652: where wdd.delivery_detail_id = wda.delivery_detail_id
6653: and wda.delivery_id = wnd.delivery_id

Line 7858: FROM wsh_delivery_assignments_v a, wsh_delivery_details d

7854:
7855: -- check for any line in this delivery
7856: CURSOR c_has_line(p_delivery_id IN NUMBER) IS
7857: SELECT d.delivery_detail_id
7858: FROM wsh_delivery_assignments_v a, wsh_delivery_details d
7859: WHERE a.parent_delivery_detail_id is NULL
7860: AND a.delivery_id = p_delivery_id
7861: AND a.delivery_id IS NOT NULL
7862: AND a.delivery_detail_id = d.delivery_detail_id

Line 7872: FROM wsh_delivery_assignments_v a, wsh_delivery_details d

7868: CURSOR c_dangling_lpns(p_delivery_id IN NUMBER) IS
7869: SELECT d.delivery_detail_id,
7870: d.container_name,
7871: a.parent_delivery_detail_id
7872: FROM wsh_delivery_assignments_v a, wsh_delivery_details d
7873: WHERE a.delivery_id = p_delivery_id
7874: AND a.delivery_id IS NOT NULL
7875: AND a.delivery_detail_id = d.delivery_detail_id
7876: AND d.container_flag = 'Y'

Line 8142: FROM wsh_delivery_assignments_v a, wsh_delivery_details d

8138: d.container_flag,
8139: d.source_code,
8140: d.released_status,
8141: d.lpn_id
8142: FROM wsh_delivery_assignments_v a, wsh_delivery_details d
8143: WHERE a.parent_delivery_detail_id is NULL
8144: AND a.delivery_id = p_delivery_id
8145: AND a.delivery_id IS NOT NULL
8146: AND a.delivery_detail_id = d.delivery_detail_id

Line 8173: FROM wsh_delivery_details wdd

8169: -- since it causes 2 full table scan on wsh_delivery_assignments
8170:
8171: CURSOR c_has_content(p_container_id IN NUMBER) IS
8172: SELECT wdd.delivery_detail_id
8173: FROM wsh_delivery_details wdd
8174: WHERE wdd.container_flag = 'N'
8175: AND wdd.released_status <> 'D' -- 4322654
8176: AND wdd.delivery_detail_id IN
8177: (SELECT wda.delivery_detail_id

Line 8191: FROM wsh_delivery_details wdd

8187: -- since it causes 2 full table scan on wsh_delivery_assignments
8188:
8189: CURSOR c_staged_content(p_container_id IN NUMBER) IS
8190: SELECT wdd.delivery_detail_id
8191: FROM wsh_delivery_details wdd
8192: WHERE wdd.container_flag = 'N'
8193: AND wdd.released_status = 'Y'
8194: AND wdd.delivery_detail_id IN
8195: (SELECT wda.delivery_detail_id