APPS.WSH_TRANSACTIONS_UTIL dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 123: wsh_delivery_assignments_v wda1,

119: -- This cursor checks if the delivery contains all the delivery details associated their corresponding source_line_ids.
120: cursor valid_del_cur(p_delivery_id IN NUMBER) is
121: select distinct 'X'
122: from wsh_delivery_details wdd1,
123: wsh_delivery_assignments_v wda1,
124: wsh_delivery_details wdd2,
125: wsh_delivery_assignments_v wda2
126: where
127: wdd1.source_line_id = wdd2.source_line_id

Line 125: wsh_delivery_assignments_v wda2

121: select distinct 'X'
122: from wsh_delivery_details wdd1,
123: wsh_delivery_assignments_v wda1,
124: wsh_delivery_details wdd2,
125: wsh_delivery_assignments_v wda2
126: where
127: wdd1.source_line_id = wdd2.source_line_id
128: and wdd1.delivery_detail_id = wda1.delivery_detail_id
129: and wdd1.container_flag='N'

Line 141: wsh_delivery_assignments_v wda

137: -- associated to the correnponding delivery are eligible to be to sent out.
138: cursor rel_status_tpw_cur(p_delivery_id IN NUMBER) is
139: select distinct 'X'
140: from wsh_delivery_details wdd,
141: wsh_delivery_assignments_v wda
142: where wdd.delivery_detail_id = wda.delivery_detail_id
143: and wdd.container_flag = 'N'
144: and wdd.released_status not in ('X', 'R', 'B')
145: and wda.delivery_id =p_delivery_id;

Line 150: wsh_delivery_assignments_v wda

146:
147: cursor rel_status_cms_cur(p_delivery_id IN NUMBER) is
148: select distinct 'X'
149: from wsh_delivery_details wdd,
150: wsh_delivery_assignments_v wda
151: where wdd.delivery_detail_id = wda.delivery_detail_id
152: and wdd.container_flag = 'N'
153: and wdd.released_status not in ('X','Y')
154: and wda.delivery_id =p_delivery_id;

Line 174: wsh_delivery_assignments_v wda

170:
171: cursor det_pack_cms_cur(p_delivery_id IN NUMBER) is
172: select distinct 'X'
173: from wsh_delivery_details wdd,
174: wsh_delivery_assignments_v wda
175: where wda.delivery_id = p_delivery_id
176: and wda.parent_delivery_detail_id is null
177: and wda.delivery_detail_id = wdd.delivery_detail_id
178: and wdd.container_flag='N';

Line 187: wsh_delivery_assignments_v wda

183: select wdd.delivery_detail_id,
184: wdd.source_header_id,
185: wdd.source_line_id
186: from wsh_delivery_details wdd,
187: wsh_delivery_assignments_v wda
188: where wda.delivery_id = p_delivery_id
189: and wda.delivery_detail_id = wdd.delivery_detail_id
190: and wdd.container_flag = 'N'
191: and wda.delivery_id IS NOT NULL;