DBA Data[Home] [Help]

APPS.JAI_OM_RMA_PKG dependencies on WSH_NEW_DELIVERIES

Line 148: wsh_new_deliveries wnd

144: confirm_date
145: FROM
146: wsh_delivery_details wdd,
147: wsh_delivery_assignments wda,
148: wsh_new_deliveries wnd
149: WHERE
150: wdd.delivery_detail_id = (p_delivery_Detail_id)
151: AND
152: wda.delivery_detail_id = wdd.delivery_detail_id

Line 855: wsh_new_deliveries wnd

851: FOR pick_lrec IN (SELECT wdd.delivery_detail_id,
852: wnd.confirm_date
853: FROM wsh_delivery_details wdd,
854: wsh_delivery_assignments wda,
855: wsh_new_deliveries wnd
856: WHERE wdd.delivery_detail_id = TO_NUMBER(pn_delivery_detail_id)
857: AND wda.delivery_detail_id = wdd.delivery_detail_id
858: AND wnd.delivery_id = wda.delivery_id)
859: LOOP