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_LEGS_ACTIONS dependencies on WSH_TMP

Line 155: -- for all stop locations populated in wsh_tmp

151: OR (wts1.physical_location_id=wts2.stop_location_id AND wts1.physical_stop_id IS NULL)
152: );
153:
154: -- c_get_seq_numbers will derive the sequence numbers
155: -- for all stop locations populated in wsh_tmp
156: CURSOR c_get_seq_numbers is
157: select id,rownum*10
158: from(
159: select id

Line 160: from wsh_tmp

156: CURSOR c_get_seq_numbers is
157: select id,rownum*10
158: from(
159: select id
160: from wsh_tmp
161: order by to_date(column1,'DD-MM-RRRR HH24:MI:SS'),flag desc
162: );
163:
164: -- Get Previous stops W/V converted to c_wt_uom/c_vol_uom

Line 538: DELETE FROM WSH_TMP;

534:
535: l_pregen_seq := 'Y';
536: l_sysdate := sysdate;
537:
538: DELETE FROM WSH_TMP;
539:
540: IF (p_sc_pickup_date IS NOT NULL) OR (p_sc_dropoff_date IS NOT NULL) THEN --{
541: FORALL i in l_del_rows.FIRST..l_del_rows.LAST
542: INSERT INTO wsh_tmp(

Line 542: INSERT INTO wsh_tmp(

538: DELETE FROM WSH_TMP;
539:
540: IF (p_sc_pickup_date IS NOT NULL) OR (p_sc_dropoff_date IS NOT NULL) THEN --{
541: FORALL i in l_del_rows.FIRST..l_del_rows.LAST
542: INSERT INTO wsh_tmp(
543: ID,
544: FLAG,
545: COLUMN1)
546: SELECT l_pickup_location_id_tbl(i), 'P', to_char(nvl(p_sc_pickup_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS')

Line 550: from wsh_tmp wt1

546: SELECT l_pickup_location_id_tbl(i), 'P', to_char(nvl(p_sc_pickup_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS')
547: FROM dual
548: WHERE NOT EXISTS (
549: select 'x'
550: from wsh_tmp wt1
551: where wt1.id = l_pickup_location_id_tbl(i)
552: and wt1.flag='P'
553: and wt1.column1 = to_char(nvl(p_sc_pickup_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS'))
554: UNION

Line 559: from wsh_tmp wt1

555: SELECT l_dropoff_location_id_tbl(i), 'D', to_char(nvl(p_sc_dropoff_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS')
556: FROM dual
557: WHERE NOT EXISTS (
558: select 'x'
559: from wsh_tmp wt1
560: where wt1.id = l_dropoff_location_id_tbl(i)
561: and wt1.flag='D'
562: and wt1.column1 = to_char(nvl(p_sc_dropoff_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS'));
563: ELSE

Line 565: INSERT INTO wsh_tmp(

561: and wt1.flag='D'
562: and wt1.column1 = to_char(nvl(p_sc_dropoff_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS'));
563: ELSE
564: FORALL i in l_del_rows.FIRST..l_del_rows.LAST
565: INSERT INTO wsh_tmp(
566: ID,
567: FLAG,
568: COLUMN1)
569: SELECT l_pickup_location_id_tbl(i), 'P', to_char(nvl(l_pickup_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS')

Line 573: from wsh_tmp wt1

569: SELECT l_pickup_location_id_tbl(i), 'P', to_char(nvl(l_pickup_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS')
570: FROM dual
571: WHERE NOT EXISTS (
572: select 'x'
573: from wsh_tmp wt1
574: where wt1.id = l_pickup_location_id_tbl(i)
575: and wt1.flag='P'
576: and wt1.column1 = to_char(nvl(l_pickup_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS'))
577: UNION

Line 582: from wsh_tmp wt1

578: SELECT l_dropoff_location_id_tbl(i), 'D', to_char(nvl(l_dropoff_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS')
579: FROM dual
580: WHERE NOT EXISTS (
581: select 'x'
582: from wsh_tmp wt1
583: where wt1.id = l_dropoff_location_id_tbl(i)
584: and wt1.flag='D'
585: and wt1.column1 = to_char(nvl(l_dropoff_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS'));
586: END IF; --}

Line 589: DELETE FROM wsh_tmp wt1

585: and wt1.column1 = to_char(nvl(l_dropoff_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS'));
586: END IF; --}
587:
588: -- For pickups the PAD is min of all initial_pickup_date
589: DELETE FROM wsh_tmp wt1
590: WHERE wt1.flag = 'P'
591: AND exists (
592: select 'x'
593: from wsh_tmp wt2

Line 593: from wsh_tmp wt2

589: DELETE FROM wsh_tmp wt1
590: WHERE wt1.flag = 'P'
591: AND exists (
592: select 'x'
593: from wsh_tmp wt2
594: where wt1.id = wt2.id
595: and wt2.flag = 'P'
596: and to_date(wt2.column1,'DD-MM-RRRR HH24:MI:SS') < to_date(wt1.column1,'DD-MM-RRRR HH24:MI:SS'));
597:

Line 599: DELETE FROM wsh_tmp wt1

595: and wt2.flag = 'P'
596: and to_date(wt2.column1,'DD-MM-RRRR HH24:MI:SS') < to_date(wt1.column1,'DD-MM-RRRR HH24:MI:SS'));
597:
598: -- For dropoffs the PAD is max of all ultimate_dropoff_date
599: DELETE FROM wsh_tmp wt1
600: WHERE wt1.flag = 'D'
601: AND exists (
602: select 'x'
603: from wsh_tmp wt2

Line 603: from wsh_tmp wt2

599: DELETE FROM wsh_tmp wt1
600: WHERE wt1.flag = 'D'
601: AND exists (
602: select 'x'
603: from wsh_tmp wt2
604: where wt1.id = wt2.id
605: and wt2.flag = 'D'
606: and to_date(wt2.column1,'DD-MM-RRRR HH24:MI:SS') > to_date(wt1.column1,'DD-MM-RRRR HH24:MI:SS'));
607:

Line 614: UPDATE wsh_tmp

610: FETCH c_get_seq_numbers BULK COLLECT INTO l_id,l_seq LIMIT 1000;
611:
612: IF l_id.COUNT > 0 THEN
613: FORALL i in l_id.FIRST..l_id.LAST
614: UPDATE wsh_tmp
615: set column2 = l_seq(i)
616: WHERE id = l_id(i);
617: END IF;
618:

Line 832: from wsh_tmp

828: ELSE
829: BEGIN
830: select column2, to_date(column1,'DD-MM-RRRR HH24:MI:SS')
831: into l_pickup_stop_seq,l_tmp_date
832: from wsh_tmp
833: where id = l_pickup_location_id
834: and flag = 'P';
835: EXCEPTION
836: WHEN NO_DATA_FOUND THEN

Line 1240: from wsh_tmp

1236: ELSE
1237: BEGIN
1238: select column2,to_date(column1,'DD-MM-RRRR HH24:MI:SS')
1239: into l_dropoff_stop_seq,l_tmp_date
1240: from wsh_tmp
1241: where id = l_dropoff_location_id
1242: and flag = 'D';
1243: EXCEPTION
1244: WHEN NO_DATA_FOUND THEN