APPS.WSH_REPORT_QUANTITIES dependencies on SO_PICKING_HEADERS_ALL

Line 61: FROM SO_PICKING_HEADERS_ALL PH

57: l_pl_id IN NUMBER) IS
58: SELECT NVL(SUM(DECODE(p_upd_ship,'Y',
59: DECODE(PH.STATUS_CODE,'PENDING',0,'OPEN',0, PLD.SHIPPED_QUANTITY), PLD.SHIPPED_QUANTITY)), 0) SHIPPED_TD,
60: NVL(SUM(DECODE(D.ASN_SEQ_NUMBER,l_asn_num,0, DECODE(p_upd_ship,'Y', DECODE(PH.STATUS_CODE,'PENDING',0,'OPEN',0, PLD. SHIPPED_QUANTITY), PLD.SHIPPED_QUANTITY))), 0) ALREADY_SHIPPED
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

Line 117: ', SO_PICKING_HEADERS_ALL PH'||

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 '||
121: 'AND PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID '||