APPS.WSH_REPORT_QUANTITIES dependencies on SO_LINE_DETAILS

Line 317: -- Index on the INVENTORY_ITEM_ID for SO_LINE_DETAILS table is turned off

313:
314: dbms_sql.close_cursor(l_cursor);
315:
316: -- Update any detail, line and header attributes
317: -- Index on the INVENTORY_ITEM_ID for SO_LINE_DETAILS table is turned off
318: -- deliberately to make sure the index on LINE_ID is used.
319:
320: UPDATE WSH_REPORT_TEMP R
321: SET

Line 339: FROM SO_LINE_DETAILS LD

335: , L.SELLING_PRICE
336: , H.ORDER_NUMBER
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

Line 494: -- insert any items that are in so_line_details only: ie non option components

490:
491: PROCEDURE ADD_NON_SHIP_LINES (p_report_id IN NUMBER,
492: p_debug IN VARCHAR2 DEFAULT 'OFF') IS
493:
494: -- insert any items that are in so_line_details only: ie non option components
495: -- which are not shippable but a mandatory part of the configuration
496: -- (eg kits in a model, models in a model)
497: -- These are required so as to complete the bill stucture without which the
498: -- bottomup shipped_quantity calulation will not work as well as for printing

Line 520: FROM SO_LINE_DETAILS LD

516: , LD.CUSTOMER_ITEM_ID
517: , LD.CONFIGURATION_ITEM_FLAG
518: , LD.REQUIRED_FOR_REVENUE_FLAG
519: , LD.UNIT_CODE
520: FROM SO_LINE_DETAILS LD
521: , WSH_REPORT_TEMP RT
522: WHERE LD.LINE_ID = RT.LINE_ID
523: AND LD.SHIPPABLE_FLAG = 'N'
524: AND RT.REPORT_TEMP_ID = l_rep_id