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

Line 3291: from wsh_delivery_assignments_v a, wsh_exceptions b

3287: and nvl(TO_CHAR(nvl(p_departure_date_to,nvl(we.departure_date,sysdate)),'YYYY/MM/DD') ,
3288: to_char(nvl(we.departure_date,sysdate),'YYYY/MM/DD') )
3289: and (sysdate - we.creation_date) > nvl(p_data_older_no_of_days,(sysdate - we.creation_date - 1))
3290: and ( (we.delivery_detail_id in (select distinct a.delivery_detail_id
3291: from wsh_delivery_assignments_v a, wsh_exceptions b
3292: where a.delivery_detail_id=b.delivery_detail_id
3293: and a.delivery_id=p_delivery_id)
3294: AND p_delivery_id is not null
3295: AND p_delivery_contents = 'Y')

Line 3297: from wsh_delivery_details a, wsh_delivery_assignments_v b

3293: and a.delivery_id=p_delivery_id)
3294: AND p_delivery_id is not null
3295: AND p_delivery_contents = 'Y')
3296: /*OR (we.container_name in (select distinct a.container_name --LPN Synch Up..samanna
3297: from wsh_delivery_details a, wsh_delivery_assignments_v b
3298: where a.delivery_detail_id = b.delivery_detail_id
3299: and a.container_flag = 'Y'
3300: and b.delivery_id=p_delivery_id)
3301: AND p_delivery_id is not null

Line 3497: FROM wsh_delivery_assignments wda

3493: last_updated_by = FND_GLOBAL.USER_ID,
3494: last_update_login = FND_GLOBAL.USER_ID
3495: WHERE delivery_detail_id IN
3496: (SELECT wda.delivery_detail_id
3497: FROM wsh_delivery_assignments wda
3498: WHERE wda.delivery_id = p_delivery_id)
3499: AND status <> C_STATUS_CLOSED
3500: AND severity <> C_SEVERITY_INFO;
3501:

Line 3524: FROM wsh_delivery_assignments wda

3520: last_updated_by = FND_GLOBAL.USER_ID,
3521: last_update_login = FND_GLOBAL.USER_ID
3522: WHERE delivery_detail_id IN
3523: (SELECT wda.delivery_detail_id
3524: FROM wsh_delivery_assignments wda
3525: WHERE wda.delivery_id = p_delivery_id)
3526: AND status <> C_STATUS_CLOSED;
3527:
3528: l_count := SQL%rowcount;

Line 3685: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_assignments_v a, wsh_exceptions b';

3681: Exceptions_SQL := Exceptions_SQL || ' WE.ROWID IN (';
3682: Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3683: Exceptions_SQL := Exceptions_SQL || ' DELIVERY_DETAIL_ID IN';
3684: Exceptions_SQL := Exceptions_SQL || ' (SELECT DISTINCT a.delivery_detail_id';
3685: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_assignments_v a, wsh_exceptions b';
3686: Exceptions_SQL := Exceptions_SQL || ' WHERE a.delivery_detail_id=b.delivery_detail_id';
3687: Exceptions_SQL := Exceptions_SQL || ' AND a.delivery_id= :p_delivery_id)';
3688: Exceptions_SQL := Exceptions_SQL || ' UNION ALL';
3689: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_delivery_id);

Line 3693: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_details a, wsh_delivery_assignments_v b';

3689: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_delivery_id);
3690: /*Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3691: Exceptions_SQL := Exceptions_SQL || ' CONTAINER_NAME IN';
3692: Exceptions_SQL := Exceptions_SQL || ' (SELECT DISTINCT a.container_name';
3693: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_details a, wsh_delivery_assignments_v b';
3694: Exceptions_SQL := Exceptions_SQL || ' WHERE a.delivery_detail_id=b.delivery_detail_id';
3695: Exceptions_SQL := Exceptions_SQL || ' AND a.container_flag = ''Y''';
3696: Exceptions_SQL := Exceptions_SQL || ' AND b.delivery_id= :p_delivery_id)';
3697: Exceptions_SQL := Exceptions_SQL || ' UNION ALL';

Line 3950: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

3946: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);
3947:
3948: CURSOR Get_Details_Delivery(v_delivery_id NUMBER) IS
3949: SELECT wdd.delivery_detail_id, wdd.container_flag
3950: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
3951: WHERE wda.delivery_id = v_delivery_id
3952: AND wdd.delivery_detail_id = wda.delivery_detail_id
3953: ORDER BY wdd.container_flag;
3954:

Line 3984: FROM wsh_delivery_assignments_v

3980: ORDER BY stop_sequence_number ASC ;
3981:
3982: CURSOR Get_Contents_Container (v_container_id NUMBER) IS
3983: SELECT delivery_detail_id
3984: FROM wsh_delivery_assignments_v
3985: START WITH parent_delivery_detail_id = v_container_id
3986: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
3987:
3988: CURSOR Get_Container_Flag (v_delivery_detail_id NUMBER) IS

Line 4425: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

4421: ) IS
4422:
4423: CURSOR Get_Details_Delivery(v_delivery_id NUMBER) IS
4424: SELECT wdd.delivery_detail_id, wdd.container_flag
4425: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
4426: WHERE wda.delivery_id = v_delivery_id
4427: AND wdd.delivery_detail_id = wda.delivery_detail_id
4428: ORDER BY wdd.container_flag;
4429: