APPS.OE_SO_LIN_VALIDATE dependencies on SO_LINE_DETAILS

Line 10: FROM SO_LINE_DETAILS

6: begin
7:
8: SELECT SUM ( NVL ( QUANTITY , 0 ) )
9: INTO DB_Res_Qty
10: FROM SO_LINE_DETAILS
11: WHERE SCHEDULE_STATUS_CODE = 'RESERVED'
12: AND LINE_ID = X_Line_Id
13: AND NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N';
14:

Line 103: FROM so_line_details

99: BEGIN
100:
101: SELECT min(1)
102: INTO complexDetails
103: FROM so_line_details
104: WHERE line_id = x_line_id
105: AND NVL( released_flag, 'N') = 'N'
106: GROUP BY component_code
107: HAVING COUNT( DISTINCT warehouse_id) > 1

Line 283: FROM so_line_details

279: INTO X_Configuration_Item_Exists
280: FROM dual
281: WHERE exists
282: (SELECT 'CONFIG_ITEM'
283: FROM so_line_details
284: WHERE line_id = X_Line_Id
285: AND NVl(configuration_item_flag, 'N') = 'Y');
286:
287: else

Line 320: FROM so_line_details

316: INTO X_Supply_Res_Details
317: FROM dual
318: WHERE exists
319: (SELECT 'SUPPLY_RESERVED'
320: FROM so_line_details
321: WHERE line_id = X_Line_id
322: AND schedule_status_code = 'SUPPLY RESERVED');
323:
324: