DBA Data[Home] [Help]

APPS.CLN_WSH_SHIP_ORDER_OUT_PKG dependencies on WSH_NEW_DELIVERIES

Line 311: FROM WSH_NEW_DELIVERIES WND,

307: END IF;
308:
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

Line 389: FROM WSH_NEW_DELIVERIES WND,

385: END IF;
386:
387: SELECT WND.ORGANIZATION_ID
388: INTO l_org_id
389: FROM WSH_NEW_DELIVERIES WND,
390: WSH_TRANSACTIONS_HISTORY WTH
391: WHERE WTH.ENTITY_NUMBER = WND.NAME
392: AND WTH.ENTITY_TYPE ='DLVY'
393: AND WTH.DOCUMENT_DIRECTION = 'O'

Line 461: FROM WSH_NEW_DELIVERIES WND,

457: END IF;
458:
459: SELECT WND.INITIAL_PICKUP_LOCATION_ID
460: INTO l_loc_id
461: FROM WSH_NEW_DELIVERIES WND,
462: WSH_TRANSACTIONS_HISTORY WTH
463: WHERE WTH.ENTITY_NUMBER = WND.NAME
464: AND WTH.ENTITY_TYPE ='DLVY'
465: AND WTH.DOCUMENT_DIRECTION = 'O'