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_ASSIGNMENTS_V

Line 88: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

84: -- OR t.planned_flag='F'); --change in design - firm check not needed
85:
86: CURSOR c_get_det_ignoreflag_diff_del (p_detailid NUMBER, p_ignoreplan VARCHAR2) IS
87: SELECT wnd.name delivery_name
88: FROM wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
89: WHERE wda.delivery_id = wnd.delivery_id AND
90: wda.delivery_id IS NOT NULL AND
91: wda.delivery_detail_id=p_detailid AND
92: (nvl(wnd.ignore_for_planning, 'N')<>p_ignoreplan);

Line 99: wsh_delivery_assignments_v da

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;
103:

Line 124: FROM wsh_delivery_assignments_v

120: and container_flag='Y';
121:
122: CURSOR c_get_cont_lines(p_detailid NUMBER) IS
123: SELECT delivery_detail_id
124: FROM wsh_delivery_assignments_v
125: START WITH delivery_detail_id =p_detailid
126: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id
127: and rownum < 10;
128:

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 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 3149: FROM wsh_delivery_assignments_v

3145:
3146:
3147: CURSOR Outer_LPNS(p_delivery_detail_id IN NUMBER) IS
3148: SELECT parent_delivery_detail_id
3149: FROM wsh_delivery_assignments_v
3150: START WITH delivery_detail_id = p_delivery_detail_id
3151: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
3152:
3153: CURSOR isContainer(p_delivery_detail_id IN NUMBER) IS

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 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: