DBA Data[Home] [Help]

APPS.WSH_WSHRDBOL_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 294: WSH_DELIVERY_ASSIGNMENTS_V WDA

290: DISTINCT
291: ( WDD.CUSTOMER_DOCK_CODE )
292: FROM
293: WSH_DELIVERY_DETAILS WDD,
294: WSH_DELIVERY_ASSIGNMENTS_V WDA
295: WHERE WDA.DELIVERY_ID = DELIVERY_ID3
296: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
297: AND NVL(WDD.CONTAINER_FLAG
298: ,'N') = 'N'

Line 467: WSH_DELIVERY_ASSIGNMENTS WDA

463: WHERE WDD.DELIVERY_DETAIL_ID IN (
464: SELECT
465: WDA.DELIVERY_DETAIL_ID
466: FROM
467: WSH_DELIVERY_ASSIGNMENTS WDA
468: START WITH WDA.DELIVERY_DETAIL_ID = C_DELIVERY_DETAIL_ID
469: CONNECT BY prior WDA.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID )
470: AND WDD.CONTAINER_FLAG = 'N';
471: BEGIN

Line 502: WSH_DELIVERY_ASSIGNMENTS WDA

498: WDD.SOURCE_LINE_ID,
499: WDD.TOP_MODEL_LINE_ID
500: FROM
501: WSH_DELIVERY_DETAILS WDD,
502: WSH_DELIVERY_ASSIGNMENTS WDA
503: WHERE WDA.DELIVERY_ID = C_DELIVERY_ID
504: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
505: AND WDD.INVENTORY_ITEM_ID = C_INV_ITEM_ID
506: AND WDD.ORGANIZATION_ID = C_INV_ORG_ID