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.

[Home] [Help]

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

3292:
3293:
3294: CURSOR Outer_LPNS(p_delivery_detail_id IN NUMBER) IS
3295: SELECT parent_delivery_detail_id
3296: FROM wsh_delivery_assignments_v
3297: START WITH delivery_detail_id = p_delivery_detail_id
3298: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
3299:
3300: CURSOR isContainer(p_delivery_detail_id IN NUMBER) IS

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