APPS.WSH_REPORT_QUANTITIES dependencies on SO_PICKING_LINE_DETAILS

Line 64: , SO_PICKING_LINE_DETAILS PLD

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
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

Line 97: -- SO_PICKING_LINE_DETAILS

93: -- group by component code
94:
95: -- Building main picking lines cursor to resolve a performance problem with
96: -- the old cursor statement which was causing a full table scan on
97: -- SO_PICKING_LINE_DETAILS
98:
99: l_sql_statement := 'SELECT PLD.DEPARTURE_ID'||
100: ', PLD.DELIVERY_ID'||
101: ', D.ASN_SEQ_NUMBER'||

Line 119: ', SO_PICKING_LINE_DETAILS PLD '||

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 '||
122: 'AND PLD.DELIVERY_ID = D.DELIVERY_ID ';
123: