APPS.WSH_REPORT_QUANTITIES dependencies on SO_PICKING_LINES_ALL

Line 62: , SO_PICKING_LINES_ALL PL2

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
66: WHERE PH.PICKING_HEADER_ID = PL2.PICKING_HEADER_ID

Line 63: , SO_PICKING_LINES_ALL PL1

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
66: WHERE PH.PICKING_HEADER_ID = PL2.PICKING_HEADER_ID
67: AND PL2.PICKING_LINE_ID = PLD.PICKING_LINE_ID

Line 118: ', SO_PICKING_LINES_ALL PL'||

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

Line 532: from so_picking_lines_all

528: WHERE L.LINE_ID = LD.LINE_ID
529: AND L.COMPONENT_CODE = LD.COMPONENT_CODE);
530: /**** always select non shippable lines irrespective if any component lines where pick releases
531: and exists (select 'shipped component line'
532: from so_picking_lines_all
533: where order_line_id in (select line_id from wsh_report_temp where report_temp_id= rep_id)
534: and component_code != ld.component_code
535: and component_code like ld.component_code||'%')
536: ***/