APPS.WSH_WSHRDBDR_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 430: WSH_DELIVERY_DETAILS

426: SUM(NVL(SHIPPED_QUANTITY
427: ,0))
428: INTO L_SHIPPED_QTY
429: FROM
430: WSH_DELIVERY_DETAILS
431: WHERE SOURCE_HEADER_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_HEADER_ID
432: AND SOURCE_LINE_SET_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_LINE_SET_ID
433: AND RELEASED_STATUS = 'C'
434: AND SOURCE_CODE = P_SOURCE_SYSTEM

Line 444: WSH_DELIVERY_DETAILS WDD

440: SUM(NVL(SHIPPED_QUANTITY
441: ,0))
442: INTO L_SHIPPED_QTY
443: FROM
444: WSH_DELIVERY_DETAILS WDD
445: WHERE SOURCE_LINE_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_LINE_SET_ID
446: AND RELEASED_STATUS = 'C'
447: AND SOURCE_CODE = P_SOURCE_SYSTEM
448: GROUP BY

Line 498: WSH_DELIVERY_DETAILS

494: SUM(NVL(REQUESTED_QUANTITY
495: ,0))
496: INTO BO_QTY
497: FROM
498: WSH_DELIVERY_DETAILS
499: WHERE SOURCE_HEADER_ID = CF_LINE_BO_QTYFORMULA.SOURCE_HEADER_ID
500: AND SOURCE_LINE_SET_ID = CF_LINE_BO_QTYFORMULA.SOURCE_LINE_SET_ID
501: AND RELEASED_STATUS = 'B'
502: AND replenishment_status IS NULL -- bug#6689448 (replenishment project)

Line 513: WSH_DELIVERY_DETAILS

509: SUM(NVL(REQUESTED_QUANTITY
510: ,0))
511: INTO BO_QTY
512: FROM
513: WSH_DELIVERY_DETAILS
514: WHERE SOURCE_LINE_ID = CF_LINE_BO_QTYFORMULA.SOURCE_LINE_SET_ID
515: AND RELEASED_STATUS = 'B'
516: AND replenishment_status IS NULL -- bug#6689448 (replenishment project)
517: AND SOURCE_CODE = P_SOURCE_SYSTEM;