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

Line 98: FROM wsh_delivery_details dd,

94:
95: CURSOR c_get_lines(p_delid NUMBER) IS
96: SELECT dd.delivery_detail_id, dd.ignore_for_planning, dd.source_code, dd.container_flag,
97: nvl(dd.line_direction,'O') line_direction, organization_id -- LPN CONV. rv
98: FROM wsh_delivery_details dd,
99: wsh_delivery_assignments_v da
100: WHERE da.delivery_id = p_delid AND
101: da.delivery_id IS NOT NULL AND
102: da.delivery_detail_id = dd.delivery_detail_id;

Line 106: from wsh_delivery_details

102: da.delivery_detail_id = dd.delivery_detail_id;
103:
104: CURSOR c_get_det_org (p_detid NUMBER) IS
105: select organization_id, source_code, container_flag
106: from wsh_delivery_details
107: where delivery_detail_id=p_detid;
108:
109: CURSOR c_get_del_org (p_delid NUMBER) IS
110: select organization_id, name delivery_name, delivery_type

Line 118: from wsh_delivery_details

114: CURSOR c_get_container (p_detailid NUMBER) IS
115: select container_flag, container_name,
116: organization_id,
117: nvl(line_direction,'O') line_direction -- LPN CONV. rv
118: from wsh_delivery_details
119: where delivery_detail_id=p_detailid
120: and container_flag='Y';
121:
122: CURSOR c_get_cont_lines(p_detailid NUMBER) IS

Line 132: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

128:
129: --see if detail is assigned to a container and a diff ignore/include plan action is being performed. if so, ask user to do it from topmost entity.
130: CURSOR c_get_det_ignoreflag_diff_cont (p_detailid NUMBER, p_ignoreplan VARCHAR2) IS
131: SELECT 'Y'
132: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
133: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND
134: wda.parent_delivery_detail_id IS NOT NULL AND
135: wdd.delivery_detail_id=p_detailid AND
136: nvl(wdd.ignore_for_planning,'N')<>p_ignoreplan;

Line 148: l_container_name wsh_delivery_details.container_name%TYPE;

144: l_tmp_det_ids wsh_util_core.id_tab_type;
145: l_tmp_detail_ids wsh_util_core.id_tab_type;
146: l_ignoreplan VARCHAR2(1);
147: l_is_container VARCHAR2(1);
148: l_container_name wsh_delivery_details.container_name%TYPE;
149: l_num_error NUMBER :=0;
150: l_warn NUMBER :=0;
151: l_return_status VARCHAR2 (1);
152: l_wh_type VARCHAR2(3);

Line 471: UPDATE wsh_delivery_details

467:
468: --update details
469: IF l_tmp_detail_ids is not null and l_tmp_detail_ids.COUNT>0 THEN
470: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
471: UPDATE wsh_delivery_details
472: SET ignore_for_planning = l_ignoreplan,
473: last_update_date = sysdate,
474: last_updated_by = FND_GLOBAL.USER_ID
475: WHERE delivery_detail_id=l_tmp_detail_ids(i);

Line 788: UPDATE wsh_delivery_details

784: END IF;
785: IF NVL(WSH_DELIVERIES_GRP.G_ACTION,'UPDATE') <> 'CONFIRM' THEN
786: IF l_tmp_detail_ids is not null and l_tmp_detail_ids.COUNT>0 THEN
787: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
788: UPDATE wsh_delivery_details
789: SET ignore_for_planning = l_ignoreplan,
790: last_update_date = sysdate,
791: last_updated_by = FND_GLOBAL.USER_ID
792: WHERE delivery_detail_id=l_tmp_detail_ids(i);

Line 1115: UPDATE wsh_delivery_details

1111:
1112: --update all details in hierarchy
1113: IF l_tmp_detail_ids is not null and l_tmp_detail_ids.COUNT>0 THEN
1114: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
1115: UPDATE wsh_delivery_details
1116: SET ignore_for_planning=l_ignoreplan,
1117: last_update_date = sysdate,
1118: last_updated_by = FND_GLOBAL.USER_ID
1119: WHERE delivery_detail_id=l_tmp_detail_ids(i)

Line 1268: UPDATE wsh_delivery_details

1264: END IF;
1265: END IF;
1266: ELSE --not a container
1267:
1268: UPDATE wsh_delivery_details
1269: SET ignore_for_planning = l_ignoreplan,
1270: last_update_date = sysdate,
1271: last_updated_by = FND_GLOBAL.USER_ID
1272: WHERE delivery_detail_id=p_in_ids(i);

Line 1943: FROM WSH_DELIVERY_DETAILS

1939: WHERE line_id = p_source_line_id;
1940:
1941: CURSOR c_dd_item_id(p_source_line_id IN NUMBER,p_source_code IN VARCHAR2) IS
1942: SELECT organization_id,inventory_item_id,delivery_detail_id,split_from_delivery_detail_id,creation_date
1943: FROM WSH_DELIVERY_DETAILS
1944: WHERE source_line_id = p_source_line_id
1945: AND source_code = p_source_code;
1946:
1947: CURSOR c_min_ddcreation_date(p_source_line_id IN NUMBER,p_source_code IN VARCHAR2) IS

Line 1949: FROM WSH_DELIVERY_DETAILS

1945: AND source_code = p_source_code;
1946:
1947: CURSOR c_min_ddcreation_date(p_source_line_id IN NUMBER,p_source_code IN VARCHAR2) IS
1948: SELECT min(creation_date)
1949: FROM WSH_DELIVERY_DETAILS
1950: WHERE source_line_id = p_source_line_id
1951: AND source_code = p_source_code;
1952:
1953: CURSOR c_atp_flag_info(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER) IS

Line 2424: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda

2420:
2421:
2422: CURSOR c_MasterLPN_del_id(p_delivery_detail_id IN NUMBER) IS
2423: SELECT wda.parent_delivery_detail_id,wda.delivery_id,container_flag
2424: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
2425: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2426: AND wda.delivery_detail_id = p_delivery_detail_id;
2427:
2428: l_entity_id NUMBER;

Line 2616: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda

2612:
2613:
2614: CURSOR get_LPNS(p_delivery_id IN NUMBER) IS
2615: SELECT wdd.delivery_detail_id,wda.delivery_id
2616: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
2617: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2618: AND wdd.container_flag = 'Y'
2619: -- AND wda.parent_delivery_detail_id IS NULL
2620: AND wda.delivery_id = p_delivery_id;

Line 2627: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda

2623: CURSOR max_min_det_deltp_dates(p_delivery_id IN NUMBER) IS
2624: SELECT max(wdd.earliest_pickup_date),max(wdd.earliest_dropoff_date),
2625: min(wdd.latest_pickup_date),min(wdd.latest_dropoff_date),
2626: min(wdd.date_scheduled), min(wdd.date_requested), max(wdd.date_scheduled)
2627: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
2628: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2629: AND wda.parent_delivery_detail_id IS NULL
2630: AND wda.delivery_id = p_delivery_id;
2631:

Line 2635: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda

2631:
2632:
2633: CURSOR max_min_om_deltp_dates(p_delivery_id IN NUMBER) IS
2634: SELECT max(date_scheduled) , min(date_scheduled),min(date_requested),max(date_requested)
2635: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
2636: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2637: AND delivery_id =p_delivery_id;
2638:
2639: CURSOR is_inbound_dropshp(p_delivery_id IN NUMBER) IS

Line 3155: FROM wsh_delivery_details

3151: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
3152:
3153: CURSOR isContainer(p_delivery_detail_id IN NUMBER) IS
3154: SELECT Container_flag
3155: FROM wsh_delivery_details
3156: WHERE delivery_detail_id = p_delivery_detail_id;
3157:
3158: OTHERS EXCEPTION;
3159: BEGIN

Line 3267: FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd

3263:
3264:
3265: CURSOR max_min_tp_dates(c_delivery_detail_id IN NUMBER) IS
3266: SELECT max(earliest_pickup_date),max(earliest_dropoff_date),min(latest_pickup_date),min(latest_dropoff_date)
3267: FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd
3268: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3269: AND parent_delivery_detail_id = c_delivery_detail_id;
3270:
3271: -- K LPN CONV. rv

Line 3319: UPDATE WSH_DELIVERY_DETAILS

3315: l_latest_mdropoff_date := NULL;
3316: END IF;
3317:
3318: -- Bug 5234326: Update TP dates in WDD only if there is a change
3319: UPDATE WSH_DELIVERY_DETAILS
3320: SET earliest_pickup_date = l_earliest_mpickup_date,
3321: earliest_dropoff_date = l_earliest_mdropoff_date,
3322: latest_pickup_date = l_latest_mpickup_date,
3323: latest_dropoff_date = l_latest_mdropoff_date,

Line 3423: FROM wsh_delivery_details wdd

3419: ) IS
3420:
3421: CURSOR c_det_location_id(p_delivery_detail_id IN NUMBER) IS
3422: SELECT ship_from_location_id
3423: FROM wsh_delivery_details wdd
3424: WHERE delivery_detail_id = p_delivery_detail_id;
3425:
3426: CURSOR c_del_location_id(p_delivery_id IN NUMBER) IS
3427: SELECT wdd.ship_from_location_id

Line 3428: FROM wsh_delivery_details wdd ,wsh_delivery_assignments_v wda

3424: WHERE delivery_detail_id = p_delivery_detail_id;
3425:
3426: CURSOR c_del_location_id(p_delivery_id IN NUMBER) IS
3427: SELECT wdd.ship_from_location_id
3428: FROM wsh_delivery_details wdd ,wsh_delivery_assignments_v wda
3429: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
3430: AND delivery_id = p_delivery_id
3431: AND ROWNUM = 1;
3432:

Line 3534: FROM wsh_delivery_details wdd ,

3530: x_return_status OUT NOCOPY VARCHAR2) IS
3531:
3532: CURSOR c_check_ignore_for_planning(c_delivery_detail_id NUMBER) IS
3533: SELECT wdd.ignore_for_planning,a.ship_from_location_id
3534: FROM wsh_delivery_details wdd ,
3535: (SELECT source_code,source_header_id,ship_set_id,ship_from_location_id
3536: FROM wsh_delivery_details
3537: WHERE delivery_detail_id = c_delivery_detail_id) a
3538: WHERE

Line 3536: FROM wsh_delivery_details

3532: CURSOR c_check_ignore_for_planning(c_delivery_detail_id NUMBER) IS
3533: SELECT wdd.ignore_for_planning,a.ship_from_location_id
3534: FROM wsh_delivery_details wdd ,
3535: (SELECT source_code,source_header_id,ship_set_id,ship_from_location_id
3536: FROM wsh_delivery_details
3537: WHERE delivery_detail_id = c_delivery_detail_id) a
3538: WHERE
3539: wdd.delivery_detail_id <> c_delivery_detail_id AND
3540: nvl(wdd.ignore_for_planning,'N') <> p_ignore_for_planning AND