DBA Data[Home] [Help]

APPS.JAI_OM_RMA_PKG dependencies on WSH_NEW_DELIVERIES

Line 130: wsh_new_deliveries wnd

126: confirm_date
127: FROM
128: wsh_delivery_details wdd,
129: wsh_delivery_assignments wda,
130: wsh_new_deliveries wnd
131: WHERE
132: wdd.delivery_detail_id = (p_delivery_Detail_id)
133: AND
134: wda.delivery_detail_id = wdd.delivery_detail_id

Line 619: wsh_new_deliveries wnd

615: FOR pick_lrec IN (SELECT wdd.delivery_detail_id,
616: wnd.confirm_date
617: FROM wsh_delivery_details wdd,
618: wsh_delivery_assignments wda,
619: wsh_new_deliveries wnd
620: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
621: AND wda.delivery_detail_id = wdd.delivery_detail_id
622: AND wnd.delivery_id = wda.delivery_id)
623: LOOP