APPS.WSH_TRANSACTIONS_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 122: from wsh_delivery_details wdd1,

118:
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

Line 124: wsh_delivery_details wdd2,

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
128: and wdd1.delivery_detail_id = wda1.delivery_detail_id

Line 140: from wsh_delivery_details wdd,

136: -- The cursors rel_status_tpw_cur, rel_status_cms_cur are used to ensure that the delivery details
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')

Line 149: from wsh_delivery_details wdd,

145: and wda.delivery_id =p_delivery_id;
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')

Line 173: from wsh_delivery_details wdd,

169: );
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

Line 186: from wsh_delivery_details wdd,

182: cursor get_delivery_details(p_delivery_id IN NUMBER) is
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'