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

Line 1145: , wsh_delivery_assignments wda

1141: SELECT wdd.delivery_detail_id
1142: , wdd.container_flag
1143: , wdacnt.delivery_id
1144: FROM wsh_delivery_details wdd
1145: , wsh_delivery_assignments wda
1146: , wsh_delivery_assignments wdacnt
1147: WHERE wda.delivery_id IS NULL
1148: AND wda.delivery_detail_id = v_delivery_detail_id
1149: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 1146: , wsh_delivery_assignments wdacnt

1142: , wdd.container_flag
1143: , wdacnt.delivery_id
1144: FROM wsh_delivery_details wdd
1145: , wsh_delivery_assignments wda
1146: , wsh_delivery_assignments wdacnt
1147: WHERE wda.delivery_id IS NULL
1148: AND wda.delivery_detail_id = v_delivery_detail_id
1149: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
1150: AND wdacnt.parent_delivery_detail_id = wda.parent_delivery_detail_id

Line 1157: , wsh_delivery_assignments wda

1153: SELECT wdd.delivery_detail_id
1154: , wdd.container_flag
1155: , wda.delivery_id
1156: FROM wsh_delivery_details wdd
1157: , wsh_delivery_assignments wda
1158: , wsh_delivery_assignments wdacnt
1159: WHERE wda.delivery_detail_id = v_delivery_detail_id
1160: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
1161: AND wda.delivery_id IS NOT NULL

Line 1158: , wsh_delivery_assignments wdacnt

1154: , wdd.container_flag
1155: , wda.delivery_id
1156: FROM wsh_delivery_details wdd
1157: , wsh_delivery_assignments wda
1158: , wsh_delivery_assignments wdacnt
1159: WHERE wda.delivery_detail_id = v_delivery_detail_id
1160: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
1161: AND wda.delivery_id IS NOT NULL
1162: AND wdacnt.delivery_id IS NULL

Line 2087: FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda

2083:
2084: CURSOR Check_Detail (v_detail_id NUMBER) IS
2085: SELECT wdd.delivery_detail_id, wdd.container_flag,wdd.released_status,
2086: wdd.organization_id ,wda.delivery_id
2087: FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda
2088: WHERE wdd.delivery_detail_id = v_detail_id
2089: AND wdd.delivery_detail_id = wda.delivery_detail_id
2090: AND nvl(wdd.line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH
2091: