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 861: UPDATE wsh_delivery_details

857: END IF;
858: IF NVL(WSH_DELIVERIES_GRP.G_ACTION,'UPDATE') <> 'CONFIRM' THEN
859: IF l_tmp_detail_ids is not null and l_tmp_detail_ids.COUNT>0 THEN
860: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
861: UPDATE wsh_delivery_details
862: SET ignore_for_planning = l_ignoreplan,
863: last_update_date = sysdate,
864: last_updated_by = FND_GLOBAL.USER_ID
865: WHERE delivery_detail_id=l_tmp_detail_ids(i);

Line 1260: UPDATE wsh_delivery_details

1256:
1257: --update all details in hierarchy
1258: IF l_tmp_detail_ids is not null and l_tmp_detail_ids.COUNT>0 THEN
1259: FORALL i in l_tmp_detail_ids.FIRST..l_tmp_detail_ids.LAST
1260: UPDATE wsh_delivery_details
1261: SET ignore_for_planning=l_ignoreplan,
1262: last_update_date = sysdate,
1263: last_updated_by = FND_GLOBAL.USER_ID
1264: WHERE delivery_detail_id=l_tmp_detail_ids(i)

Line 1413: UPDATE wsh_delivery_details

1409: END IF;
1410: END IF;
1411: ELSE --not a container
1412:
1413: UPDATE wsh_delivery_details
1414: SET ignore_for_planning = l_ignoreplan,
1415: last_update_date = sysdate,
1416: last_updated_by = FND_GLOBAL.USER_ID
1417: WHERE delivery_detail_id=p_in_ids(i);

Line 2088: FROM WSH_DELIVERY_DETAILS

2084: WHERE line_id = p_source_line_id;
2085:
2086: CURSOR c_dd_item_id(p_source_line_id IN NUMBER,p_source_code IN VARCHAR2) IS
2087: SELECT organization_id,inventory_item_id,delivery_detail_id,split_from_delivery_detail_id,creation_date
2088: FROM WSH_DELIVERY_DETAILS
2089: WHERE source_line_id = p_source_line_id
2090: AND source_code = p_source_code;
2091:
2092: CURSOR c_min_ddcreation_date(p_source_line_id IN NUMBER,p_source_code IN VARCHAR2) IS

Line 2094: FROM WSH_DELIVERY_DETAILS

2090: AND source_code = p_source_code;
2091:
2092: CURSOR c_min_ddcreation_date(p_source_line_id IN NUMBER,p_source_code IN VARCHAR2) IS
2093: SELECT min(creation_date)
2094: FROM WSH_DELIVERY_DETAILS
2095: WHERE source_line_id = p_source_line_id
2096: AND source_code = p_source_code;
2097:
2098: CURSOR c_atp_flag_info(p_inventory_item_id IN NUMBER,p_org_id IN NUMBER) IS

Line 2571: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda

2567:
2568:
2569: CURSOR c_MasterLPN_del_id(p_delivery_detail_id IN NUMBER) IS
2570: SELECT wda.parent_delivery_detail_id,wda.delivery_id,container_flag
2571: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
2572: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2573: AND wda.delivery_detail_id = p_delivery_detail_id;
2574:
2575: l_entity_id NUMBER;

Line 2763: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda

2759:
2760:
2761: CURSOR get_LPNS(p_delivery_id IN NUMBER) IS
2762: SELECT wdd.delivery_detail_id,wda.delivery_id
2763: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
2764: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2765: AND wdd.container_flag = 'Y'
2766: -- AND wda.parent_delivery_detail_id IS NULL
2767: AND wda.delivery_id = p_delivery_id;

Line 2774: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda

2770: CURSOR max_min_det_deltp_dates(p_delivery_id IN NUMBER) IS
2771: SELECT max(wdd.earliest_pickup_date),max(wdd.earliest_dropoff_date),
2772: min(wdd.latest_pickup_date),min(wdd.latest_dropoff_date),
2773: min(wdd.date_scheduled), min(wdd.date_requested), max(wdd.date_scheduled)
2774: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
2775: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2776: AND wda.parent_delivery_detail_id IS NULL
2777: AND wda.delivery_id = p_delivery_id;
2778:

Line 2782: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda

2778:
2779:
2780: CURSOR max_min_om_deltp_dates(p_delivery_id IN NUMBER) IS
2781: SELECT max(date_scheduled) , min(date_scheduled),min(date_requested),max(date_requested)
2782: FROM wsh_delivery_details wdd,wsh_delivery_assignments_v wda
2783: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2784: AND delivery_id =p_delivery_id;
2785:
2786: CURSOR is_inbound_dropshp(p_delivery_id IN NUMBER) IS

Line 3302: FROM wsh_delivery_details

3298: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
3299:
3300: CURSOR isContainer(p_delivery_detail_id IN NUMBER) IS
3301: SELECT Container_flag
3302: FROM wsh_delivery_details
3303: WHERE delivery_detail_id = p_delivery_detail_id;
3304:
3305: OTHERS EXCEPTION;
3306: BEGIN

Line 3414: FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd

3410:
3411:
3412: CURSOR max_min_tp_dates(c_delivery_detail_id IN NUMBER) IS
3413: SELECT max(earliest_pickup_date),max(earliest_dropoff_date),min(latest_pickup_date),min(latest_dropoff_date)
3414: FROM wsh_delivery_assignments_v wda,wsh_delivery_details wdd
3415: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
3416: AND parent_delivery_detail_id = c_delivery_detail_id;
3417:
3418: -- K LPN CONV. rv

Line 3466: UPDATE WSH_DELIVERY_DETAILS

3462: l_latest_mdropoff_date := NULL;
3463: END IF;
3464:
3465: -- Bug 5234326: Update TP dates in WDD only if there is a change
3466: UPDATE WSH_DELIVERY_DETAILS
3467: SET earliest_pickup_date = l_earliest_mpickup_date,
3468: earliest_dropoff_date = l_earliest_mdropoff_date,
3469: latest_pickup_date = l_latest_mpickup_date,
3470: latest_dropoff_date = l_latest_mdropoff_date,

Line 3570: FROM wsh_delivery_details wdd

3566: ) IS
3567:
3568: CURSOR c_det_location_id(p_delivery_detail_id IN NUMBER) IS
3569: SELECT ship_from_location_id
3570: FROM wsh_delivery_details wdd
3571: WHERE delivery_detail_id = p_delivery_detail_id;
3572:
3573: CURSOR c_del_location_id(p_delivery_id IN NUMBER) IS
3574: SELECT wdd.ship_from_location_id

Line 3575: FROM wsh_delivery_details wdd ,wsh_delivery_assignments_v wda

3571: WHERE delivery_detail_id = p_delivery_detail_id;
3572:
3573: CURSOR c_del_location_id(p_delivery_id IN NUMBER) IS
3574: SELECT wdd.ship_from_location_id
3575: FROM wsh_delivery_details wdd ,wsh_delivery_assignments_v wda
3576: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
3577: AND delivery_id = p_delivery_id
3578: AND ROWNUM = 1;
3579:

Line 3681: FROM wsh_delivery_details wdd ,

3677: x_return_status OUT NOCOPY VARCHAR2) IS
3678:
3679: CURSOR c_check_ignore_for_planning(c_delivery_detail_id NUMBER) IS
3680: SELECT wdd.ignore_for_planning,a.ship_from_location_id
3681: FROM wsh_delivery_details wdd ,
3682: (SELECT source_code,source_header_id,ship_set_id,ship_from_location_id
3683: FROM wsh_delivery_details
3684: WHERE delivery_detail_id = c_delivery_detail_id) a
3685: WHERE

Line 3683: FROM wsh_delivery_details

3679: CURSOR c_check_ignore_for_planning(c_delivery_detail_id NUMBER) IS
3680: SELECT wdd.ignore_for_planning,a.ship_from_location_id
3681: FROM wsh_delivery_details wdd ,
3682: (SELECT source_code,source_header_id,ship_set_id,ship_from_location_id
3683: FROM wsh_delivery_details
3684: WHERE delivery_detail_id = c_delivery_detail_id) a
3685: WHERE
3686: wdd.delivery_detail_id <> c_delivery_detail_id AND
3687: nvl(wdd.ignore_for_planning,'N') <> p_ignore_for_planning AND