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_DELIVERY_VALIDATIONS dependencies on WSH_DELIVERY_LEGS

Line 1733: FROM wsh_delivery_legs dg,

1729: dg.net_weight,
1730: dg.weight_uom_code,
1731: dg.volume,
1732: dg.volume_uom_code
1733: FROM wsh_delivery_legs dg,
1734: wsh_new_deliveries dl
1735: WHERE dl.delivery_id = dg.delivery_id AND
1736: dg.delivery_leg_id = p_delivery_leg_id;
1737:

Line 3760: wsh_delivery_legs dg,

3756:
3757: CURSOR stop_status IS
3758: SELECT st.status_code
3759: FROM wsh_trip_stops st,
3760: wsh_delivery_legs dg,
3761: wsh_new_deliveries dl
3762: WHERE dl.delivery_id = p_delivery_id AND
3763: dg.delivery_id = dl.delivery_id AND
3764: st.stop_id = dg.pick_up_stop_id AND

Line 3906: wsh_delivery_legs dg,

3902: CURSOR dropoff_stop_info (l_delivery_id NUMBER) IS
3903: SELECT dg.drop_off_stop_id,
3904: st.stop_location_id
3905: FROM wsh_new_deliveries dl,
3906: wsh_delivery_legs dg,
3907: wsh_trip_stops st
3908: WHERE dl.delivery_id = l_delivery_id AND
3909: dl.delivery_id = dg.delivery_id AND
3910: dg.drop_off_stop_id = st.stop_id AND

Line 3912: /Refer POD Information from WSH_DELIVERY_LEGS. Bug#1918342/

3908: WHERE dl.delivery_id = l_delivery_id AND
3909: dl.delivery_id = dg.delivery_id AND
3910: dg.drop_off_stop_id = st.stop_id AND
3911: dl.ultimate_dropoff_location_id = st.stop_location_id;
3912: /*Refer POD Information from WSH_DELIVERY_LEGS. Bug#1918342*/
3913: CURSOR check_POD (l_stop_id NUMBER, l_delivery_id NUMBER) IS
3914: SELECT dg.pod_flag
3915: FROM wsh_delivery_legs dg,
3916: wsh_document_instances di

Line 3915: FROM wsh_delivery_legs dg,

3911: dl.ultimate_dropoff_location_id = st.stop_location_id;
3912: /*Refer POD Information from WSH_DELIVERY_LEGS. Bug#1918342*/
3913: CURSOR check_POD (l_stop_id NUMBER, l_delivery_id NUMBER) IS
3914: SELECT dg.pod_flag
3915: FROM wsh_delivery_legs dg,
3916: wsh_document_instances di
3917: WHERE dg.drop_off_stop_id = l_stop_id AND
3918: di.entity_id = dg.delivery_leg_id AND
3919: di.entity_name = 'WSH_DELIVERY_LEGS' AND

Line 3919: di.entity_name = 'WSH_DELIVERY_LEGS' AND

3915: FROM wsh_delivery_legs dg,
3916: wsh_document_instances di
3917: WHERE dg.drop_off_stop_id = l_stop_id AND
3918: di.entity_id = dg.delivery_leg_id AND
3919: di.entity_name = 'WSH_DELIVERY_LEGS' AND
3920: di.document_type = 'BOL' AND
3921: dg.pod_flag = 'Y' AND
3922: dg.pod_date IS NULL AND
3923: di.status IN ('OPEN','PLANNED');

Line 3933: FROM wsh_delivery_legs

3929: AND rownum = 1;
3930:
3931: CURSOR have_legs(l_delivery_id NUMBER) IS
3932: SELECT delivery_leg_id
3933: FROM wsh_delivery_legs
3934: WHERE delivery_id = l_delivery_id;
3935:
3936: CURSOR delivery_leg_stops(l_delivery_id NUMBER) IS
3937: SELECT dg.pick_up_stop_id,

Line 3941: FROM wsh_delivery_legs dg,

3937: SELECT dg.pick_up_stop_id,
3938: pu_stop.status_code pu_status,
3939: dg.drop_off_stop_id,
3940: do_stop.status_code do_status
3941: FROM wsh_delivery_legs dg,
3942: wsh_trip_stops pu_stop,
3943: wsh_trip_stops do_stop
3944: WHERE dg.delivery_id = l_delivery_id
3945: AND pu_stop.stop_id = dg.pick_up_stop_id

Line 3950: FROM wsh_delivery_legs dg, wsh_new_deliveries nd

3946: AND do_stop.stop_id = dg.drop_off_stop_id;
3947:
3948: CURSOR shared_stops(l_delivery_id NUMBER, l_stop_id NUMBER) IS
3949: SELECT dg.delivery_leg_id
3950: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3951: WHERE dg.pick_up_stop_id = l_stop_id
3952: AND dg.delivery_id <> l_delivery_id
3953: AND dg.delivery_id = nd.delivery_id
3954: AND nd.delivery_type = 'STANDARD'

Line 3957: FROM wsh_delivery_legs dg, wsh_new_deliveries nd

3953: AND dg.delivery_id = nd.delivery_id
3954: AND nd.delivery_type = 'STANDARD'
3955: UNION
3956: SELECT dg.delivery_leg_id
3957: FROM wsh_delivery_legs dg, wsh_new_deliveries nd
3958: WHERE dg.drop_off_stop_id = l_stop_id
3959: AND dg.delivery_id <> l_delivery_id
3960: AND dg.delivery_id = nd.delivery_id
3961: AND nd.delivery_type = 'STANDARD';

Line 3970: wsh_delivery_legs dg

3966: -- A drop off stop being closed implies that pick up stop is closed.
3967: CURSOR stops_not_closed(l_delivery_id NUMBER) IS
3968: SELECT ts.stop_id
3969: FROM wsh_trip_stops ts,
3970: wsh_delivery_legs dg
3971: WHERE dg.delivery_id = l_delivery_id
3972: AND ts.stop_id = dg.drop_off_stop_id
3973: AND ts.status_code in ('OP', 'AR')
3974: AND rownum = 1;

Line 3978: l_pod_flag wsh_delivery_legs.pod_flag%TYPE;

3974: AND rownum = 1;
3975:
3976: l_stop_id NUMBER;
3977: l_stop_location_id NUMBER;
3978: l_pod_flag wsh_delivery_legs.pod_flag%TYPE;
3979: leg delivery_leg_stops%ROWTYPE;
3980: num NUMBER;
3981: shared_flag BOOLEAN;
3982:

Line 4251: wsh_delivery_legs dg

4247: -- A drop off stop being closed implies that pick up stop is closed.
4248: CURSOR stops_not_closed(p_delivery_id NUMBER, p_stop_id NUMBER) IS
4249: SELECT 1
4250: FROM wsh_trip_stops ts,
4251: wsh_delivery_legs dg
4252: WHERE dg.delivery_id = p_delivery_id
4253: AND ts.stop_id = dg.drop_off_stop_id
4254: AND ts.stop_id <> p_stop_id
4255: AND ts.status_code in ('OP', 'AR')

Line 4259: /Refer POD Information from WSH_DELIVERY_LEGS. Bug#1918342/

4255: AND ts.status_code in ('OP', 'AR')
4256: AND rownum = 1;
4257: --
4258: --
4259: /*Refer POD Information from WSH_DELIVERY_LEGS. Bug#1918342*/
4260: --
4261: -- Check if POD has been pending (pod_date null)
4262: --
4263: CURSOR check_POD (p_stop_id NUMBER) IS

Line 4265: FROM wsh_delivery_legs dg,

4261: -- Check if POD has been pending (pod_date null)
4262: --
4263: CURSOR check_POD (p_stop_id NUMBER) IS
4264: SELECT 1
4265: FROM wsh_delivery_legs dg,
4266: wsh_document_instances di
4267: WHERE dg.drop_off_stop_id = p_stop_id
4268: AND di.entity_id = dg.delivery_leg_id
4269: AND di.entity_name = 'WSH_DELIVERY_LEGS'

Line 4269: AND di.entity_name = 'WSH_DELIVERY_LEGS'

4265: FROM wsh_delivery_legs dg,
4266: wsh_document_instances di
4267: WHERE dg.drop_off_stop_id = p_stop_id
4268: AND di.entity_id = dg.delivery_leg_id
4269: AND di.entity_name = 'WSH_DELIVERY_LEGS'
4270: AND di.document_type = 'BOL'
4271: AND dg.pod_flag = 'Y'
4272: AND dg.pod_date IS NULL
4273: AND di.status IN ('OPEN','PLANNED');

Line 4285: FROM wsh_delivery_legs

4281: --
4282: --
4283: CURSOR have_legs (p_delivery_id NUMBER) IS
4284: SELECT 1
4285: FROM wsh_delivery_legs
4286: WHERE delivery_id = p_delivery_id
4287: AND rownum = 1;
4288: --
4289: --

Line 4296: FROM wsh_delivery_legs wdl,

4292: --
4293: CURSOR shared_stops_csr (p_delivery_id NUMBER)
4294: IS
4295: SELECT 1
4296: FROM wsh_delivery_legs wdl,
4297: wsh_Trip_stops wts
4298: WHERE wdl.delivery_id = p_delivery_id
4299: AND (
4300: wdl.pick_up_stop_id = wts.stop_id

Line 4307: FROM wsh_delivery_legs wdl1, wsh_new_deliveries wnd

4303: AND wts.status_code <> 'CL'
4304: AND EXISTS
4305: (
4306: SELECT 1
4307: FROM wsh_delivery_legs wdl1, wsh_new_deliveries wnd
4308: WHERE wdl1.delivery_id <> p_delivery_id
4309: AND wdl1.delivery_id = wnd.delivery_id
4310: AND wnd.delivery_type = 'STANDARD'
4311: AND (

Line 4681: FROM wsh_delivery_legs

4677: FOR UPDATE NOWAIT;
4678:
4679: CURSOR leg_info IS
4680: SELECT delivery_leg_id
4681: FROM wsh_delivery_legs
4682: WHERE delivery_id = p_delivery_id
4683: FOR UPDATE NOWAIT;
4684:
4685: CURSOR freight_costs_exist IS

Line 5132: FROM wsh_delivery_legs

5128:
5129: CURSOR has_delivery_legs
5130: IS
5131: SELECT delivery_leg_id
5132: FROM wsh_delivery_legs
5133: WHERE delivery_id = p_delivery_id
5134: AND ROWNUM=1;
5135:
5136: l_detail_id NUMBER;

Line 6303: FROM wsh_delivery_legs

6299: ) RETURN VARCHAR2 IS
6300:
6301: cursor check_assigned(c_delivery_id in number) is
6302: select delivery_id
6303: FROM wsh_delivery_legs
6304: WHERE delivery_id = c_delivery_id
6305: AND rownum = 1;
6306:
6307: l_delivery_id NUMBER;

Line 6473: from wsh_delivery_legs pleg,

6469: l_delivery_type wsh_new_deliveries.delivery_type%type;
6470:
6471: CURSOR cur_check_consol_delivery (p_delivery_id IN NUMBER) IS
6472: select 1
6473: from wsh_delivery_legs pleg,
6474: wsh_delivery_legs cleg
6475: where pleg.delivery_leg_id = cleg.parent_delivery_leg_id
6476: and cleg.delivery_id = p_delivery_id;
6477:

Line 6474: wsh_delivery_legs cleg

6470:
6471: CURSOR cur_check_consol_delivery (p_delivery_id IN NUMBER) IS
6472: select 1
6473: from wsh_delivery_legs pleg,
6474: wsh_delivery_legs cleg
6475: where pleg.delivery_leg_id = cleg.parent_delivery_leg_id
6476: and cleg.delivery_id = p_delivery_id;
6477:
6478: --RTV changes

Line 10854: wsh_delivery_legs wdl,

10850: cursor l_pick_up_leg_csr( p_del_id IN VARCHAR2,
10851: p_pickup_locn_id IN NUMBER) is
10852: select wt.name, wnd.name
10853: from wsh_new_deliveries wnd,
10854: wsh_delivery_legs wdl,
10855: wsh_trip_stops wts,
10856: wsh_trips wt
10857: where wnd.delivery_id = p_del_id
10858: and wnd.delivery_id = wdl.delivery_id

Line 10871: wsh_delivery_legs wdl,

10867: cursor l_drop_off_leg_csr( p_del_id IN VARCHAR2,
10868: p_dropoff_locn_id IN NUMBER) is
10869: select wt.name, wnd.name
10870: from wsh_new_deliveries wnd,
10871: wsh_delivery_legs wdl,
10872: wsh_trip_stops wts,
10873: wsh_trips wt
10874: where wnd.delivery_id = p_del_id
10875: and wnd.delivery_id = wdl.delivery_id

Line 12953: wsh_delivery_legs wdl,

12949: SELECT wt.trip_id,
12950: wt.name,
12951: wt.status_code
12952: FROM wsh_trip_stops wts,
12953: wsh_delivery_legs wdl,
12954: wsh_trips wt,
12955: wsh_new_deliveries wnd
12956: WHERE wnd.delivery_id = p_del_id
12957: AND wdl.delivery_id = wnd.delivery_id