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_NEW_DELIVERY_ACTIONS dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 88: FROM wsh_delivery_assignments_v

84: IS
85:
86: CURSOR get_container(detail_id NUMBER) IS
87: SELECT parent_delivery_detail_id
88: FROM wsh_delivery_assignments_v
89: WHERE delivery_detail_id = detail_id;
90:
91: CURSOR get_lines (cont_id NUMBER) IS
92: SELECT delivery_detail_id

Line 93: FROM wsh_delivery_assignments_v

89: WHERE delivery_detail_id = detail_id;
90:
91: CURSOR get_lines (cont_id NUMBER) IS
92: SELECT delivery_detail_id
93: FROM wsh_delivery_assignments_v
94: START WITH parent_delivery_detail_id = cont_id
95: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
96:
97: l_container_id NUMBER := NULL;

Line 390: from wsh_delivery_assignments_v wda,

386:
387: cursor l_del_contents_csr (p_del_id IN NUMBER,
388: p_cnt_flag IN VARCHAR2) is
389: select 'N'
390: from wsh_delivery_assignments_v wda,
391: wsh_delivery_details wdd,
392: mtl_system_items msi
393: where wda.delivery_detail_id = wdd.delivery_detail_id
394: and wdd.inventory_item_id = msi.inventory_item_id

Line 667: wsh_delivery_assignments_v wda

663:
664: Cursor c_num_of_staged_lines(p_delivery_id NUMBER) IS
665: SELECT count(wdd.delivery_detail_id)
666: FROM wsh_delivery_details wdd,
667: wsh_delivery_assignments_v wda
668: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
669: wda.delivery_id = p_delivery_id AND
670: wda.delivery_id is not NULL AND
671: wdd.container_flag = 'N' AND

Line 679: wsh_delivery_assignments_v wda

675:
676: Cursor c_get_line_status_in_delivery(p_delivery_id NUMBER) IS
677: SELECT wdd.released_status
678: FROM wsh_delivery_details wdd,
679: wsh_delivery_assignments_v wda
680: WHERE wdd.delivery_detail_id = wda.delivery_detail_id AND
681: wda.delivery_id = p_delivery_id AND
682: wda.delivery_id is not NULL AND
683: wdd.container_flag = 'N' AND

Line 2534: FROM wsh_delivery_assignments_v wda

2530:
2531: -- Bug 1729723 : Updating number_of_lpn for delivery
2532: CURSOR number_of_lpn(l_delivery_id NUMBER) IS
2533: SELECT count(distinct wda.delivery_detail_id)
2534: FROM wsh_delivery_assignments_v wda
2535: WHERE wda.parent_delivery_detail_id is null
2536: AND LEVEL > 1
2537: CONNECT BY PRIOR wda.parent_delivery_detail_id = wda.delivery_detail_id
2538: START WITH wda.delivery_id = l_delivery_id;

Line 2605: wsh_delivery_assignments_v da

2601: dd.locator_id,
2602: dd.source_code, /*Bug 2096052 for OKE */
2603: dd.source_line_id -- Consolidation of BO Delivery Details project
2604: FROM wsh_delivery_details dd,
2605: wsh_delivery_assignments_v da
2606: WHERE da.delivery_id = v_delivery_id AND
2607: da.delivery_id IS NOT NULL AND
2608: da.delivery_detail_id = dd.delivery_detail_id AND
2609: dd.container_flag = 'N';

Line 2624: FROM wsh_delivery_assignments_v

2620: AND wts.trip_id=wt.trip_id;
2621:
2622: CURSOR Get_Containers (v_delivery_detail_id NUMBER) IS
2623: SELECT delivery_detail_id
2624: FROM wsh_delivery_assignments_v
2625: WHERE delivery_detail_id <> v_delivery_detail_id
2626: START WITH delivery_detail_id = v_delivery_detail_id
2627: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2628:

Line 2631: FROM wsh_delivery_assignments_v da,

2627: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2628:
2629: CURSOR get_empty_containers(v_delivery_id NUMBER) IS
2630: SELECT da.delivery_detail_id
2631: FROM wsh_delivery_assignments_v da,
2632: WSH_DELIVERY_DETAILS dd
2633: WHERE da.delivery_id = v_delivery_id
2634: AND da.delivery_detail_id = dd.delivery_detail_id
2635: AND dd.container_flag = 'Y'

Line 2638: FROM wsh_delivery_assignments_v da2

2634: AND da.delivery_detail_id = dd.delivery_detail_id
2635: AND dd.container_flag = 'Y'
2636: AND NOT EXISTS(
2637: SELECT delivery_detail_id
2638: FROM wsh_delivery_assignments_v da2
2639: WHERE da2.parent_delivery_detail_id = da.delivery_detail_id) ;
2640:
2641: -- Bug 2713285, added batch_id
2642: CURSOR get_delivery_name(v_delivery_id NUMBER) IS

Line 7342: from wsh_delivery_assignments_v wda,

7338: cursor l_get_cnt_attr_csr(p_delivery_id IN NUMBER) is
7339: select wdd.organization_id organization_id,
7340: nvl(wdd.line_direction,'O') line_direction,
7341: wdd.delivery_detail_id delivery_detail_id
7342: from wsh_delivery_assignments_v wda,
7343: wsh_delivery_details wdd
7344: where wda.delivery_detail_id = wdd.delivery_detail_id
7345: and wdd.container_flag IN ('Y','C')
7346: and nvl(wdd.line_direction,'O') IN ('O', 'IO')

Line 7510: FROM wsh_delivery_assignments_v

7506: last_updated_by = l_user_id,
7507: last_update_login = l_login_id
7508: WHERE delivery_detail_id IN (
7509: SELECT delivery_Detail_id
7510: FROM wsh_delivery_assignments_v
7511: WHERE delivery_id = p_in_rec.delivery_id
7512: )
7513: AND released_status <> 'D'
7514: RETURNING delivery_detail_id BULK COLLECT INTO l_detail_tab; -- Added for DBI Project

Line 8996: 'wsh_delivery_assignments_v da '||

8992: -- Bug 1421549: Changed the logic for load sequencing
8993: cont_str VARCHAR2(1000) :=
8994: 'SELECT dd.delivery_detail_id '||
8995: 'FROM wsh_delivery_details dd, '||
8996: 'wsh_delivery_assignments_v da '||
8997: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
8998: 'da.parent_delivery_detail_id = :cont_id AND '||
8999: 'container_flag = ''N'' '||
9000: 'ORDER BY customer_prod_seq ';

Line 9012: 'wsh_delivery_assignments_v da '||

9008: 'SELECT da.parent_delivery_detail_id, '||
9009: 'avg(customer_prod_seq) avg_prod_seq, '||
9010: 'count(*) '||
9011: 'FROM wsh_delivery_details dd, '||
9012: 'wsh_delivery_assignments_v da '||
9013: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9014: 'dd.customer_prod_seq IS NOT NULL AND '||
9015: 'dd.container_flag = ''N'' AND '||
9016: 'da.parent_delivery_detail_id IS NOT NULL AND '||

Line 9413: wsh_delivery_assignments_v wda

9409: CURSOR line_csr (p_delivery_id IN NUMBER)
9410: IS
9411: SELECT distinct freight_terms_code
9412: FROM wsh_delivery_details wdd,
9413: wsh_delivery_assignments_v wda
9414: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
9415: AND wda.delivery_id = p_delivery_id
9416: AND NVL(wdd.container_flag,'N') = 'N';
9417: --

Line 9926: FROM wsh_delivery_assignments_v

9922: last_updated_by = FND_GLOBAL.USER_ID,
9923: last_update_login = FND_GLOBAL.LOGIN_ID
9924: WHERE delivery_detail_id IN (
9925: SELECT delivery_detail_id
9926: FROM wsh_delivery_assignments_v
9927: WHERE delivery_id = p_delivery_id
9928: );
9929: --
9930: --

Line 10065: FROM wsh_delivery_assignments_v

10061: last_updated_by = FND_GLOBAL.USER_ID,
10062: last_update_login = FND_GLOBAL.LOGIN_ID
10063: WHERE delivery_detail_id IN (
10064: SELECT delivery_detail_id
10065: FROM wsh_delivery_assignments_v
10066: WHERE delivery_id = pickup_dlvy_rec.delivery_id
10067: );
10068: --
10069: --

Line 10433: should always use wsh_delivery_legs instead of wsh_delivery_assignments.

10429: IS
10430:
10431: /*
10432: When we query for a parent delivery of a delivery we
10433: should always use wsh_delivery_legs instead of wsh_delivery_assignments.
10434: If the child delivery does not have any lines attached to it,
10435: it will not have record in wda, whereas a console delivery and
10436: its children will always have a trip, and a record in wdl.
10437: */

Line 10513: wsh_delivery_assignments wda

10509:
10510: CURSOR c_get_ship_to_site IS
10511: SELECT DISTINCT wdd.ship_to_site_use_id
10512: FROM wsh_delivery_details wdd,
10513: wsh_delivery_assignments wda
10514: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10515: AND wda.delivery_id = p_delivery_id
10516: AND wdd.ship_to_site_use_id IS NOT NULL;
10517:

Line 10663: wsh_delivery_assignments wda

10659: hz_cust_acct_sites_all hcas
10660: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
10661: AND hcsu.site_use_id IN (SELECT DISTINCT wdd.ship_to_site_use_id
10662: FROM wsh_delivery_details wdd,
10663: wsh_delivery_assignments wda
10664: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10665: AND wda.delivery_id = p_delivery_id);
10666:
10667:

Line 12835: from wsh_delivery_assignments a

12831:
12832:
12833: cursor c_get_top_child_details(p_delivery_id in number) is
12834: select a.delivery_detail_id
12835: from wsh_delivery_assignments a
12836: where a.delivery_id is not null
12837: and a.delivery_id = p_delivery_id
12838: and a.type = 'O'
12839: and a.parent_delivery_detail_id is null

Line 12842: from wsh_delivery_assignments b

12838: and a.type = 'O'
12839: and a.parent_delivery_detail_id is null
12840: and not exists
12841: (select '1'
12842: from wsh_delivery_assignments b
12843: where a.delivery_detail_id = b.delivery_detail_id
12844: and b.type = 'C');
12845:
12846: -- This cursor selects all the trips that are

Line 13093: update wsh_delivery_assignments

13089: RETURN;
13090: --
13091: END;
13092: FORALL i in 1..l_valid_children_tab.count
13093: update wsh_delivery_assignments
13094: set type = 'O'
13095: where delivery_id = l_valid_children_tab(i)
13096: and delivery_id is not null
13097: and nvl(type, 'S') = 'S'

Line 13108: INSERT INTO wsh_delivery_assignments (

13104: INTO l_child_details_tab;
13105: CLOSE c_get_top_child_details;
13106:
13107: Forall k in 1..l_child_details_tab.count
13108: INSERT INTO wsh_delivery_assignments (
13109: delivery_id,
13110: parent_delivery_id,
13111: delivery_detail_id,
13112: parent_delivery_detail_id,

Line 13140: wsh_delivery_assignments_s.nextval,

13136: NULL,
13137: NULL,
13138: NULL,
13139: NULL,
13140: wsh_delivery_assignments_s.nextval,
13141: 'C'
13142: );
13143:
13144:

Line 13635: from wsh_delivery_assignments

13631: and l1.pick_up_stop_id = s.stop_id;
13632:
13633: CURSOR check_consol_lpns(p_delivery_id in number) is
13634: select parent_delivery_detail_id
13635: from wsh_delivery_assignments
13636: where delivery_id = p_delivery_id
13637: and delivery_id is not null
13638: and parent_delivery_detail_id IS NOT NULL
13639: and type = 'C'

Line 13810: delete wsh_delivery_assignments

13806: END;
13807: -- Delete the consolidation record for the child
13808:
13809: FORALL i in 1..l_assigned_dels_tab.count
13810: delete wsh_delivery_assignments
13811: where type = 'C'
13812: and delivery_id in l_assigned_dels_tab(i);
13813:
13814: -- Update the child deliveries record to indicate no consolidation.

Line 13817: update wsh_delivery_assignments

13813:
13814: -- Update the child deliveries record to indicate no consolidation.
13815:
13816: FORALL i in 1..l_assigned_dels_tab.count
13817: update wsh_delivery_assignments
13818: set type = 'S'
13819: where delivery_id in l_assigned_dels_tab(i)
13820: and type = 'O';
13821:

Line 14095: from wsh_delivery_assignments da,

14091:
14092:
14093: CURSOR c_get_child_lpn_number(p_delivery_id IN NUMBER) IS
14094: select count(*)
14095: from wsh_delivery_assignments da,
14096: wsh_delivery_details dd
14097: where da.type = 'C'
14098: and da.parent_delivery_detail_id IS NULL
14099: and da.delivery_detail_id = dd.delivery_detail_id

Line 14106: from wsh_delivery_assignments

14102: and da.parent_delivery_id IS NOT NULL;
14103:
14104: CURSOR c_get_consol_lpn_number(p_delivery_id in NUMBER) IS
14105: select count(*)
14106: from wsh_delivery_assignments
14107: where type = 'S'
14108: and delivery_id = p_delivery_id;
14109:
14110: -- bug 4505105

Line 14564: FROM wsh_delivery_assignments wda,

14560: FUNCTION IS_DELIVERY_EMPTY (p_delivery_id IN NUMBER) RETURN VARCHAR2 IS
14561:
14562: CURSOR c_delivery_detail_count(p_del_id IN NUMBER) IS
14563: SELECT 1
14564: FROM wsh_delivery_assignments wda,
14565: wsh_delivery_details wdd
14566: WHERE wda.delivery_id = p_del_id
14567: AND wda.delivery_detail_id = wdd.delivery_detail_id
14568: AND wdd.container_flag = 'N';