DBA Data[Home] [Help]

APPS.GML_MOBILE_MOVE_ORDER dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 536: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments wda,

532: p_deliv_num IN VARCHAR2) IS
533: BEGIN
534: OPEN x_delivery FOR
535: SELECT wnd.NAME, wnd.delivery_id
536: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments wda,
537: ic_txn_request_lines ml
538:
539: WHERE wda.delivery_id = wnd.delivery_id
540: AND wda.delivery_detail_id = wdd.delivery_detail_id