APPS.WSH_WSHRDBDR_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 408: WSH_DELIVERY_DETAILS

404: SUM(NVL(SHIPPED_QUANTITY
405: ,0))
406: INTO L_SHIPPED_QTY
407: FROM
408: WSH_DELIVERY_DETAILS
409: WHERE SOURCE_HEADER_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_HEADER_ID
410: AND SOURCE_LINE_SET_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_LINE_SET_ID
411: AND RELEASED_STATUS = 'C'
412: AND SOURCE_CODE = P_SOURCE_SYSTEM

Line 422: WSH_DELIVERY_DETAILS WDD

418: SUM(NVL(SHIPPED_QUANTITY
419: ,0))
420: INTO L_SHIPPED_QTY
421: FROM
422: WSH_DELIVERY_DETAILS WDD
423: WHERE SOURCE_LINE_ID = CF_LINE_SHIPPED_QTYFORMULA.SOURCE_LINE_SET_ID
424: AND RELEASED_STATUS = 'C'
425: AND SOURCE_CODE = P_SOURCE_SYSTEM
426: GROUP BY

Line 476: WSH_DELIVERY_DETAILS

472: SUM(NVL(REQUESTED_QUANTITY
473: ,0))
474: INTO BO_QTY
475: FROM
476: WSH_DELIVERY_DETAILS
477: WHERE SOURCE_HEADER_ID = CF_LINE_BO_QTYFORMULA.SOURCE_HEADER_ID
478: AND SOURCE_LINE_SET_ID = CF_LINE_BO_QTYFORMULA.SOURCE_LINE_SET_ID
479: AND RELEASED_STATUS = 'B'
480: AND replenishment_status IS NULL -- bug#6689448 (replenishment project)

Line 491: WSH_DELIVERY_DETAILS

487: SUM(NVL(REQUESTED_QUANTITY
488: ,0))
489: INTO BO_QTY
490: FROM
491: WSH_DELIVERY_DETAILS
492: WHERE SOURCE_LINE_ID = CF_LINE_BO_QTYFORMULA.SOURCE_LINE_SET_ID
493: AND RELEASED_STATUS = 'B'
494: AND replenishment_status IS NULL -- bug#6689448 (replenishment project)
495: AND SOURCE_CODE = P_SOURCE_SYSTEM;