APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 80: wsh_delivery_assignments_v wda,

76: , nvl(wdd.LINE_DIRECTION,'O')
77: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
78: , NULL -- AGDUMMY
79: FROM wsh_delivery_details wdd,
80: wsh_delivery_assignments_v wda,
81: wsh_delivery_legs wdl,
82: wsh_trip_stops wts1
83: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
84: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'

Line 111: wsh_delivery_assignments_v wda,

107: , nvl(wdd.LINE_DIRECTION,'O')
108: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
109: , NULL -- AGDUMMY
110: FROM wsh_delivery_details wdd,
111: wsh_delivery_assignments_v wda,
112: wsh_delivery_legs wdl,
113: wsh_trip_stops wts1,
114: wsh_new_deliveries wnd
115: WHERE wdd.delivery_detail_id = wda.delivery_detail_id

Line 144: wsh_delivery_assignments_v wda,

140: , nvl(wdd.LINE_DIRECTION,'O')
141: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
142: , NULL -- AGDUMMY
143: FROM wsh_delivery_details wdd,
144: wsh_delivery_assignments_v wda,
145: wsh_trip_stops wts1,
146: wsh_delivery_legs wdl1,
147: wsh_delivery_legs wdl2,
148: wsh_new_deliveries wnd

Line 257: wsh_delivery_assignments_v wda

253: , nvl(wdd.LINE_DIRECTION,'O')
254: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
255: , NULL --AGDUMMY
256: FROM wsh_delivery_details wdd,
257: wsh_delivery_assignments_v wda
258: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
259: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
260: AND wda.delivery_id = c_delivery_id;
261:

Line 284: wsh_delivery_assignments_v wda,

280: , nvl(wdd.LINE_DIRECTION,'O')
281: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
282: , NULL --AGDUMMY
283: FROM wsh_delivery_details wdd,
284: wsh_delivery_assignments_v wda,
285: wsh_delivery_legs wdl1,
286: wsh_delivery_legs wdl2
287: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
288: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'

Line 14393: wsh_delivery_assignments_v wda

14389: wdd.CARRIER_ID,wdd.party_id,nvl(wdd.line_direction,'O')
14390: ,nvl(wdd.shipping_control,'BUYER'),NULL
14391:
14392: FROM WSH_DELIVERY_DETAILS wdd,
14393: wsh_delivery_assignments_v wda
14394: WHERE wda.DELIVERY_DETAIL_ID = wdd.DELIVERY_DETAIL_ID
14395: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
14396: AND wda.PARENT_DELIVERY_DETAIL_ID = c_container_id;
14397:

Line 14411: FROM wsh_delivery_assignments_v wda

14407: WHERE wdd.DELIVERY_DETAIL_ID = c_detail_id;
14408:
14409: CURSOR c_getdelivery(c_detail_id IN NUMBER) IS
14410: SELECT wda.DELIVERY_ID
14411: FROM wsh_delivery_assignments_v wda
14412: WHERE wda.delivery_detail_id = c_detail_id;
14413:
14414: i NUMBER:=0;
14415: j NUMBER:=0;

Line 17442: wsh_delivery_assignments_v wda

17438: , nvl(wdd.LINE_DIRECTION,'O')
17439: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
17440: , NULL
17441: FROM wsh_delivery_details wdd,
17442: wsh_delivery_assignments_v wda
17443: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
17444: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
17445: AND wda.delivery_id = c_delivery_id;
17446: