DBA Data[Home] [Help]

APPS.CLN_WSH_SHIP_ORDER_OUT_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 314: WSH_DELIVERY_ASSIGNMENTS WDA

310: INTO x_customer_po_number, x_customer_id, x_delivery_creation_date
311: FROM WSH_NEW_DELIVERIES WND,
312: WSH_TRANSACTIONS_HISTORY WTH,
313: WSH_DELIVERY_DETAILS WDD,
314: WSH_DELIVERY_ASSIGNMENTS WDA
315: WHERE WTH.ENTITY_NUMBER = WND.NAME
316: AND WTH.ENTITY_TYPE ='DLVY'
317: AND WTH.DOCUMENT_DIRECTION = 'O'
318: AND WTH.DOCUMENT_NUMBER = P_DOCUMENT_NUMBER