DBA Data[Home] [Help]

APPS.WSH_REPORT_QUANTITIES dependencies on WSH_DELIVERIES

Line 65: , WSH_DELIVERIES D

61: FROM SO_PICKING_HEADERS_ALL PH
62: , SO_PICKING_LINES_ALL PL2
63: , SO_PICKING_LINES_ALL PL1
64: , SO_PICKING_LINE_DETAILS PLD
65: , WSH_DELIVERIES D
66: WHERE PH.PICKING_HEADER_ID = PL2.PICKING_HEADER_ID
67: AND PL2.PICKING_LINE_ID = PLD.PICKING_LINE_ID
68: AND PL1.PICKING_LINE_ID = l_pl_id
69: AND PL1.ORDER_LINE_ID = PL2.ORDER_LINE_ID

Line 116: 'FROM WSH_DELIVERIES D'||

112: ', NVL(SUM(DECODE(:p_upd_ship,''Y'','||
113: ' DECODE(PH.STATUS_CODE,''PENDING'',0,''OPEN'',0, PLD.SHIPPED_QUANTITY),'||
114: ' PLD.SHIPPED_QUANTITY)),'||
115: ' 0)'||
116: 'FROM WSH_DELIVERIES D'||
117: ', SO_PICKING_HEADERS_ALL PH'||
118: ', SO_PICKING_LINES_ALL PL'||
119: ', SO_PICKING_LINE_DETAILS PLD '||
120: 'WHERE PH.PICKING_HEADER_ID = PL.PICKING_HEADER_ID '||