APPS.WSH_REPORT_QUANTITIES dependencies on SO_LINES_ALL

Line 341: , SO_LINES_ALL L

337: , H.PURCHASE_ORDER_NUM
338: , H.CURRENCY_CODE
339: FROM SO_LINE_DETAILS LD
340: , SO_HEADERS_ALL H
341: , SO_LINES_ALL L
342: WHERE H.HEADER_ID = L.HEADER_ID
343: AND L.LINE_ID = LD.LINE_ID
344: AND LD.LINE_ID = R.LINE_ID
345: AND LD.INVENTORY_ITEM_ID+0 = R.INVENTORY_ITEM_ID

Line 527: FROM SO_LINES_ALL L

523: AND LD.SHIPPABLE_FLAG = 'N'
524: AND RT.REPORT_TEMP_ID = l_rep_id
525: -- make sure the non shipable line detail is not an order line.
526: AND NOT EXISTS (SELECT 'ORDERED LINE'
527: FROM SO_LINES_ALL L
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'

Line 806: FROM SO_LINES_ALL L

802: , L.ORDERED_QUANTITY
803: , L.SELLING_PRICE
804: , L.UNIT_CODE
805: , NVL(L.ATO_FLAG,'N')
806: FROM SO_LINES_ALL L
807: WHERE L.LINE_ID = l_id
808: AND L.LINE_TYPE_CODE IN ('DETAIL','REGULAR')
809: AND NOT EXISTS (SELECT 'ALREADY EXISTS IN TEMP TABLE'
810: FROM WSH_REPORT_TEMP T

Line 953: FROM SO_LINES_ALL L

949: , L.ORDERED_QUANTITY
950: , L.SELLING_PRICE
951: , L.UNIT_CODE
952: , L.LINE_ID
953: FROM SO_LINES_ALL L
954: WHERE L.ATO_LINE_ID = l_id
955: AND L.LINE_TYPE_CODE IN ('DETAIL','REGULAR')
956: AND NOT EXISTS (SELECT 'ALREADY EXISTS IN TEMP TABLE'
957: FROM WSH_REPORT_TEMP T