DBA Data[Home] [Help]

APPS.WSH_WSHRDBOL_XMLP_PKG dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 283: WSH_DELIVERY_ASSIGNMENTS_V WDA

279: DISTINCT
280: ( WDD.CUSTOMER_DOCK_CODE )
281: FROM
282: WSH_DELIVERY_DETAILS WDD,
283: WSH_DELIVERY_ASSIGNMENTS_V WDA
284: WHERE WDA.DELIVERY_ID = DELIVERY_ID3
285: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
286: AND NVL(WDD.CONTAINER_FLAG
287: ,'N') = 'N'

Line 456: WSH_DELIVERY_ASSIGNMENTS WDA

452: WHERE WDD.DELIVERY_DETAIL_ID IN (
453: SELECT
454: WDA.DELIVERY_DETAIL_ID
455: FROM
456: WSH_DELIVERY_ASSIGNMENTS WDA
457: START WITH WDA.DELIVERY_DETAIL_ID = C_DELIVERY_DETAIL_ID
458: CONNECT BY prior WDA.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID )
459: AND WDD.CONTAINER_FLAG = 'N';
460: BEGIN

Line 491: WSH_DELIVERY_ASSIGNMENTS WDA

487: WDD.SOURCE_LINE_ID,
488: WDD.TOP_MODEL_LINE_ID
489: FROM
490: WSH_DELIVERY_DETAILS WDD,
491: WSH_DELIVERY_ASSIGNMENTS WDA
492: WHERE WDA.DELIVERY_ID = C_DELIVERY_ID
493: AND WDA.DELIVERY_DETAIL_ID = WDD.DELIVERY_DETAIL_ID
494: AND WDD.INVENTORY_ITEM_ID = C_INV_ITEM_ID
495: AND WDD.ORGANIZATION_ID = C_INV_ORG_ID