DBA Data[Home] [Help]

APPS.CLN_WSH_SHIP_ORDER_OUT_PKG dependencies on WSH_DELIVERY_DETAILS

Line 313: WSH_DELIVERY_DETAILS WDD,

309: SELECT WDD.CUST_PO_NUMBER, WDD.CUSTOMER_ID, WND.CREATION_DATE
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'