DBA Data[Home] [Help]

APPS.FLM_KANBAN_TRANSFER dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 199: wsh_delivery_assignments wda

195: p_line_id IN NUMBER)
196: IS
197: SELECT wdd.delivery_detail_id
198: FROM wsh_delivery_details wdd,
199: wsh_delivery_assignments wda
200: WHERE wdd.source_header_id = p_header_id
201: AND wdd.source_line_id = p_line_id
202: AND wda.delivery_detail_id = wdd.delivery_detail_id
203: AND wda.delivery_id IS NULL;

Line 217: wsh_delivery_assignments wda,

213: wda.delivery_id,
214: wnd.name delivery_name,
215: wnd.ship_method_code
216: FROM wsh_delivery_details wdd,
217: wsh_delivery_assignments wda,
218: wsh_new_deliveries wnd
219: WHERE wdd.source_header_id = p_header_id
220: AND wdd.source_line_id = p_line_id
221: AND wdd.released_status IN ('B', 'R', 'Y')