APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_DELIVERY_DETAILS

Line 79: FROM wsh_delivery_details wdd,

75: , wdd.PARTY_ID
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

Line 110: FROM wsh_delivery_details wdd,

106: , wdd.PARTY_ID
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

Line 143: FROM wsh_delivery_details wdd,

139: , wdd.PARTY_ID
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,

Line 256: FROM wsh_delivery_details wdd,

252: , wdd.PARTY_ID
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;

Line 283: FROM wsh_delivery_details wdd,

279: , wdd.PARTY_ID
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

Line 14387: FROM WSH_DELIVERY_DETAILS wdd,

14383: wdd.CONTAINER_FLAG,wdd.DATE_REQUESTED,wdd.DATE_SCHEDULED,wdd.SHIP_METHOD_CODE,
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;

Line 14401: FROM WSH_DELIVERY_DETAILS wdd

14397: wdd.CONTAINER_FLAG,wdd.DATE_REQUESTED,wdd.DATE_SCHEDULED,wdd.SHIP_METHOD_CODE,
14398: wdd.CARRIER_ID,wdd.party_id,nvl(wdd.line_direction,'O')
14399: ,nvl(wdd.shipping_control,'BUYER'),NULL
14400: --DUM_LOC
14401: FROM WSH_DELIVERY_DETAILS wdd
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

Line 17436: FROM wsh_delivery_details wdd,

17432: , wdd.PARTY_ID
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;