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 3299: from wsh_delivery_assignments_v a, wsh_exceptions b

3295: and nvl(TO_CHAR(nvl(p_departure_date_to,nvl(we.departure_date,sysdate)),'YYYY/MM/DD') ,
3296: to_char(nvl(we.departure_date,sysdate),'YYYY/MM/DD') )
3297: and (sysdate - we.creation_date) > nvl(p_data_older_no_of_days,(sysdate - we.creation_date - 1))
3298: and ( (we.delivery_detail_id in (select distinct a.delivery_detail_id
3299: from wsh_delivery_assignments_v a, wsh_exceptions b
3300: where a.delivery_detail_id=b.delivery_detail_id
3301: and a.delivery_id=p_delivery_id)
3302: AND p_delivery_id is not null
3303: AND p_delivery_contents = 'Y')

Line 3305: from wsh_delivery_details a, wsh_delivery_assignments_v b

3301: and a.delivery_id=p_delivery_id)
3302: AND p_delivery_id is not null
3303: AND p_delivery_contents = 'Y')
3304: /*OR (we.container_name in (select distinct a.container_name --LPN Synch Up..samanna
3305: from wsh_delivery_details a, wsh_delivery_assignments_v b
3306: where a.delivery_detail_id = b.delivery_detail_id
3307: and a.container_flag = 'Y'
3308: and b.delivery_id=p_delivery_id)
3309: AND p_delivery_id is not null

Line 3505: FROM wsh_delivery_assignments wda

3501: last_updated_by = FND_GLOBAL.USER_ID,
3502: last_update_login = FND_GLOBAL.USER_ID
3503: WHERE delivery_detail_id IN
3504: (SELECT wda.delivery_detail_id
3505: FROM wsh_delivery_assignments wda
3506: WHERE wda.delivery_id = p_delivery_id)
3507: AND status <> C_STATUS_CLOSED
3508: AND severity <> C_SEVERITY_INFO;
3509:

Line 3532: FROM wsh_delivery_assignments wda

3528: last_updated_by = FND_GLOBAL.USER_ID,
3529: last_update_login = FND_GLOBAL.USER_ID
3530: WHERE delivery_detail_id IN
3531: (SELECT wda.delivery_detail_id
3532: FROM wsh_delivery_assignments wda
3533: WHERE wda.delivery_id = p_delivery_id)
3534: AND status <> C_STATUS_CLOSED;
3535:
3536: l_count := SQL%rowcount;

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

3689: Exceptions_SQL := Exceptions_SQL || ' WE.ROWID IN (';
3690: Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3691: Exceptions_SQL := Exceptions_SQL || ' DELIVERY_DETAIL_ID IN';
3692: Exceptions_SQL := Exceptions_SQL || ' (SELECT DISTINCT a.delivery_detail_id';
3693: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_assignments_v a, wsh_exceptions b';
3694: Exceptions_SQL := Exceptions_SQL || ' WHERE a.delivery_detail_id=b.delivery_detail_id';
3695: Exceptions_SQL := Exceptions_SQL || ' AND a.delivery_id= :p_delivery_id)';
3696: Exceptions_SQL := Exceptions_SQL || ' UNION ALL';
3697: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_delivery_id);

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

3697: bind_col_tab(bind_col_tab.COUNT+1) := TO_CHAR(p_delivery_id);
3698: /*Exceptions_SQL := Exceptions_SQL || Temp_SQL;
3699: Exceptions_SQL := Exceptions_SQL || ' CONTAINER_NAME IN';
3700: Exceptions_SQL := Exceptions_SQL || ' (SELECT DISTINCT a.container_name';
3701: Exceptions_SQL := Exceptions_SQL || ' FROM wsh_delivery_details a, wsh_delivery_assignments_v b';
3702: Exceptions_SQL := Exceptions_SQL || ' WHERE a.delivery_detail_id=b.delivery_detail_id';
3703: Exceptions_SQL := Exceptions_SQL || ' AND a.container_flag = ''Y''';
3704: Exceptions_SQL := Exceptions_SQL || ' AND b.delivery_id= :p_delivery_id)';
3705: Exceptions_SQL := Exceptions_SQL || ' UNION ALL';

Line 3958: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

3954: ORDER BY decode(severity,'HIGH',1,'ERROR',1,'MEDIUM',2,'WARNING',2,3);
3955:
3956: CURSOR Get_Details_Delivery(v_delivery_id NUMBER) IS
3957: SELECT wdd.delivery_detail_id, wdd.container_flag
3958: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
3959: WHERE wda.delivery_id = v_delivery_id
3960: AND wdd.delivery_detail_id = wda.delivery_detail_id
3961: ORDER BY wdd.container_flag;
3962:

Line 3992: FROM wsh_delivery_assignments_v

3988: ORDER BY stop_sequence_number ASC ;
3989:
3990: CURSOR Get_Contents_Container (v_container_id NUMBER) IS
3991: SELECT delivery_detail_id
3992: FROM wsh_delivery_assignments_v
3993: START WITH parent_delivery_detail_id = v_container_id
3994: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
3995:
3996: CURSOR Get_Container_Flag (v_delivery_detail_id NUMBER) IS

Line 4433: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

4429: ) IS
4430:
4431: CURSOR Get_Details_Delivery(v_delivery_id NUMBER) IS
4432: SELECT wdd.delivery_detail_id, wdd.container_flag
4433: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
4434: WHERE wda.delivery_id = v_delivery_id
4435: AND wdd.delivery_detail_id = wda.delivery_detail_id
4436: ORDER BY wdd.container_flag;
4437: