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 2565: FROM wsh_delivery_assignments_v wda

2561:
2562: -- Bug 1729723 : Updating number_of_lpn for delivery
2563: CURSOR number_of_lpn(l_delivery_id NUMBER) IS
2564: SELECT count(distinct wda.delivery_detail_id)
2565: FROM wsh_delivery_assignments_v wda
2566: WHERE wda.parent_delivery_detail_id is null
2567: AND LEVEL > 1
2568: CONNECT BY PRIOR wda.parent_delivery_detail_id = wda.delivery_detail_id
2569: START WITH wda.delivery_id = l_delivery_id;

Line 2638: wsh_delivery_assignments_v da

2634: dd.locator_id,
2635: dd.source_code, /*Bug 2096052 for OKE */
2636: dd.source_line_id -- Consolidation of BO Delivery Details project
2637: FROM wsh_delivery_details dd,
2638: wsh_delivery_assignments_v da
2639: WHERE da.delivery_id = v_delivery_id AND
2640: da.delivery_id IS NOT NULL AND
2641: da.delivery_detail_id = dd.delivery_detail_id AND
2642: dd.container_flag = 'N';

Line 2657: FROM wsh_delivery_assignments_v

2653: AND wts.trip_id=wt.trip_id;
2654:
2655: CURSOR Get_Containers (v_delivery_detail_id NUMBER) IS
2656: SELECT delivery_detail_id
2657: FROM wsh_delivery_assignments_v
2658: WHERE delivery_detail_id <> v_delivery_detail_id
2659: START WITH delivery_detail_id = v_delivery_detail_id
2660: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2661:

Line 2664: FROM wsh_delivery_assignments_v da,

2660: CONNECT BY PRIOR parent_delivery_detail_id = delivery_detail_id;
2661:
2662: CURSOR get_empty_containers(v_delivery_id NUMBER) IS
2663: SELECT da.delivery_detail_id
2664: FROM wsh_delivery_assignments_v da,
2665: WSH_DELIVERY_DETAILS dd
2666: WHERE da.delivery_id = v_delivery_id
2667: AND da.delivery_detail_id = dd.delivery_detail_id
2668: AND dd.container_flag = 'Y'

Line 2671: FROM wsh_delivery_assignments_v da2

2667: AND da.delivery_detail_id = dd.delivery_detail_id
2668: AND dd.container_flag = 'Y'
2669: AND NOT EXISTS(
2670: SELECT delivery_detail_id
2671: FROM wsh_delivery_assignments_v da2
2672: WHERE da2.parent_delivery_detail_id = da.delivery_detail_id) ;
2673:
2674: -- Bug 2713285, added batch_id
2675: CURSOR get_delivery_name(v_delivery_id NUMBER) IS

Line 7482: from wsh_delivery_assignments_v wda,

7478: cursor l_get_cnt_attr_csr(p_delivery_id IN NUMBER) is
7479: select wdd.organization_id organization_id,
7480: nvl(wdd.line_direction,'O') line_direction,
7481: wdd.delivery_detail_id delivery_detail_id
7482: from wsh_delivery_assignments_v wda,
7483: wsh_delivery_details wdd
7484: where wda.delivery_detail_id = wdd.delivery_detail_id
7485: and wdd.container_flag IN ('Y','C')
7486: and nvl(wdd.line_direction,'O') IN ('O', 'IO')

Line 7660: FROM wsh_delivery_assignments_v

7656: last_updated_by = l_user_id,
7657: last_update_login = l_login_id
7658: WHERE delivery_detail_id IN (
7659: SELECT delivery_Detail_id
7660: FROM wsh_delivery_assignments_v
7661: WHERE delivery_id = p_in_rec.delivery_id
7662: )
7663: AND released_status <> 'D'
7664: RETURNING delivery_detail_id,client_id BULK COLLECT INTO l_detail_tab,l_client_id_tab; -- Added for DBI Project, LSP PROJECT :Added l_client_id_tab

Line 9192: 'wsh_delivery_assignments_v da '||

9188: -- Bug 1421549: Changed the logic for load sequencing
9189: cont_str VARCHAR2(1000) :=
9190: 'SELECT dd.delivery_detail_id '||
9191: 'FROM wsh_delivery_details dd, '||
9192: 'wsh_delivery_assignments_v da '||
9193: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9194: 'da.parent_delivery_detail_id = :cont_id AND '||
9195: 'container_flag = ''N'' '||
9196: 'ORDER BY customer_prod_seq ';

Line 9208: 'wsh_delivery_assignments_v da '||

9204: 'SELECT da.parent_delivery_detail_id, '||
9205: 'avg(customer_prod_seq) avg_prod_seq, '||
9206: 'count(*) '||
9207: 'FROM wsh_delivery_details dd, '||
9208: 'wsh_delivery_assignments_v da '||
9209: 'WHERE dd.delivery_detail_id = da.delivery_detail_id AND '||
9210: 'dd.customer_prod_seq IS NOT NULL AND '||
9211: 'dd.container_flag = ''N'' AND '||
9212: 'da.parent_delivery_detail_id IS NOT NULL AND '||

Line 9609: wsh_delivery_assignments_v wda

9605: CURSOR line_csr (p_delivery_id IN NUMBER)
9606: IS
9607: SELECT distinct freight_terms_code
9608: FROM wsh_delivery_details wdd,
9609: wsh_delivery_assignments_v wda
9610: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
9611: AND wda.delivery_id = p_delivery_id
9612: AND NVL(wdd.container_flag,'N') = 'N';
9613: --

Line 10122: FROM wsh_delivery_assignments_v

10118: last_updated_by = FND_GLOBAL.USER_ID,
10119: last_update_login = FND_GLOBAL.LOGIN_ID
10120: WHERE delivery_detail_id IN (
10121: SELECT delivery_detail_id
10122: FROM wsh_delivery_assignments_v
10123: WHERE delivery_id = p_delivery_id
10124: );
10125: --
10126: --

Line 10261: FROM wsh_delivery_assignments_v

10257: last_updated_by = FND_GLOBAL.USER_ID,
10258: last_update_login = FND_GLOBAL.LOGIN_ID
10259: WHERE delivery_detail_id IN (
10260: SELECT delivery_detail_id
10261: FROM wsh_delivery_assignments_v
10262: WHERE delivery_id = pickup_dlvy_rec.delivery_id
10263: );
10264: --
10265: --

Line 10629: should always use wsh_delivery_legs instead of wsh_delivery_assignments.

10625: IS
10626:
10627: /*
10628: When we query for a parent delivery of a delivery we
10629: should always use wsh_delivery_legs instead of wsh_delivery_assignments.
10630: If the child delivery does not have any lines attached to it,
10631: it will not have record in wda, whereas a console delivery and
10632: its children will always have a trip, and a record in wdl.
10633: */

Line 10709: wsh_delivery_assignments wda

10705:
10706: CURSOR c_get_ship_to_site IS
10707: SELECT DISTINCT wdd.ship_to_site_use_id
10708: FROM wsh_delivery_details wdd,
10709: wsh_delivery_assignments wda
10710: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10711: AND wda.delivery_id = p_delivery_id
10712: AND wdd.ship_to_site_use_id IS NOT NULL;
10713:

Line 10859: wsh_delivery_assignments wda

10855: hz_cust_acct_sites_all hcas
10856: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
10857: AND hcsu.site_use_id IN (SELECT DISTINCT wdd.ship_to_site_use_id
10858: FROM wsh_delivery_details wdd,
10859: wsh_delivery_assignments wda
10860: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
10861: AND wda.delivery_id = p_delivery_id);
10862:
10863:

Line 13032: from wsh_delivery_assignments a

13028:
13029:
13030: cursor c_get_top_child_details(p_delivery_id in number) is
13031: select a.delivery_detail_id
13032: from wsh_delivery_assignments a
13033: where a.delivery_id is not null
13034: and a.delivery_id = p_delivery_id
13035: and a.type = 'O'
13036: and a.parent_delivery_detail_id is null

Line 13039: from wsh_delivery_assignments b

13035: and a.type = 'O'
13036: and a.parent_delivery_detail_id is null
13037: and not exists
13038: (select '1'
13039: from wsh_delivery_assignments b
13040: where a.delivery_detail_id = b.delivery_detail_id
13041: and b.type = 'C');
13042:
13043: -- This cursor selects all the trips that are

Line 13290: update wsh_delivery_assignments

13286: RETURN;
13287: --
13288: END;
13289: FORALL i in 1..l_valid_children_tab.count
13290: update wsh_delivery_assignments
13291: set type = 'O'
13292: where delivery_id = l_valid_children_tab(i)
13293: and delivery_id is not null
13294: and nvl(type, 'S') = 'S'

Line 13305: INSERT INTO wsh_delivery_assignments (

13301: INTO l_child_details_tab;
13302: CLOSE c_get_top_child_details;
13303:
13304: Forall k in 1..l_child_details_tab.count
13305: INSERT INTO wsh_delivery_assignments (
13306: delivery_id,
13307: parent_delivery_id,
13308: delivery_detail_id,
13309: parent_delivery_detail_id,

Line 13337: wsh_delivery_assignments_s.nextval,

13333: NULL,
13334: NULL,
13335: NULL,
13336: NULL,
13337: wsh_delivery_assignments_s.nextval,
13338: 'C'
13339: );
13340:
13341:

Line 13832: from wsh_delivery_assignments

13828: and l1.pick_up_stop_id = s.stop_id;
13829:
13830: CURSOR check_consol_lpns(p_delivery_id in number) is
13831: select parent_delivery_detail_id
13832: from wsh_delivery_assignments
13833: where delivery_id = p_delivery_id
13834: and delivery_id is not null
13835: and parent_delivery_detail_id IS NOT NULL
13836: and type = 'C'

Line 14007: delete wsh_delivery_assignments

14003: END;
14004: -- Delete the consolidation record for the child
14005:
14006: FORALL i in 1..l_assigned_dels_tab.count
14007: delete wsh_delivery_assignments
14008: where type = 'C'
14009: and delivery_id in l_assigned_dels_tab(i);
14010:
14011: -- Update the child deliveries record to indicate no consolidation.

Line 14014: update wsh_delivery_assignments

14010:
14011: -- Update the child deliveries record to indicate no consolidation.
14012:
14013: FORALL i in 1..l_assigned_dels_tab.count
14014: update wsh_delivery_assignments
14015: set type = 'S'
14016: where delivery_id in l_assigned_dels_tab(i)
14017: and type = 'O';
14018:

Line 14292: from wsh_delivery_assignments da,

14288:
14289:
14290: CURSOR c_get_child_lpn_number(p_delivery_id IN NUMBER) IS
14291: select count(*)
14292: from wsh_delivery_assignments da,
14293: wsh_delivery_details dd
14294: where da.type = 'C'
14295: and da.parent_delivery_detail_id IS NULL
14296: and da.delivery_detail_id = dd.delivery_detail_id

Line 14303: from wsh_delivery_assignments

14299: and da.parent_delivery_id IS NOT NULL;
14300:
14301: CURSOR c_get_consol_lpn_number(p_delivery_id in NUMBER) IS
14302: select count(*)
14303: from wsh_delivery_assignments
14304: where type = 'S'
14305: and delivery_id = p_delivery_id;
14306:
14307: -- bug 4505105

Line 14761: FROM wsh_delivery_assignments wda,

14757: FUNCTION IS_DELIVERY_EMPTY (p_delivery_id IN NUMBER) RETURN VARCHAR2 IS
14758:
14759: CURSOR c_delivery_detail_count(p_del_id IN NUMBER) IS
14760: SELECT 1
14761: FROM wsh_delivery_assignments wda,
14762: wsh_delivery_details wdd
14763: WHERE wda.delivery_id = p_del_id
14764: AND wda.delivery_detail_id = wdd.delivery_detail_id
14765: AND wdd.container_flag = 'N';