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 14388: wsh_delivery_assignments_v wda

14384: wdd.CARRIER_ID,wdd.party_id,nvl(wdd.line_direction,'O')
14385: ,nvl(wdd.shipping_control,'BUYER'),NULL
14386:
14387: FROM WSH_DELIVERY_DETAILS wdd,
14388: wsh_delivery_assignments_v wda
14389: WHERE wda.DELIVERY_DETAIL_ID = wdd.DELIVERY_DETAIL_ID
14390: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
14391: AND wda.PARENT_DELIVERY_DETAIL_ID = c_container_id;
14392:

Line 14406: FROM wsh_delivery_assignments_v wda

14402: WHERE wdd.DELIVERY_DETAIL_ID = c_detail_id;
14403:
14404: CURSOR c_getdelivery(c_detail_id IN NUMBER) IS
14405: SELECT wda.DELIVERY_ID
14406: FROM wsh_delivery_assignments_v wda
14407: WHERE wda.delivery_detail_id = c_detail_id;
14408:
14409: i NUMBER:=0;
14410: j NUMBER:=0;

Line 17437: wsh_delivery_assignments_v wda

17433: , nvl(wdd.LINE_DIRECTION,'O')
17434: , nvl(wdd.SHIPPING_CONTROL,'BUYER')
17435: , NULL
17436: FROM wsh_delivery_details wdd,
17437: wsh_delivery_assignments_v wda
17438: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
17439: AND nvl(wdd.shipping_control,'BUYER') <> 'SUPPLIER'
17440: AND wda.delivery_id = c_delivery_id;
17441: