APPS.OE_LIN_SCH dependencies on SO_LINE_DETAILS

Line 23: FROM SO_LINE_DETAILS

19:
20:
21: SELECT SUM( QUANTITY )
22: INTO P_Reserved_Quantity
23: FROM SO_LINE_DETAILS
24: WHERE SCHEDULE_STATUS_CODE = 'RESERVED'
25: AND LINE_ID = P_Line_Id
26: AND NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N';
27:

Line 61: FROM SO_LINE_DETAILS

57:
58:
59: SELECT NVL ( SUM ( QUANTITY ) , 0 )
60: INTO P_Line_released_Quantity
61: FROM SO_LINE_DETAILS
62: WHERE LINE_ID = P_Line_Id
63: AND NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N'
64: AND NVL ( RELEASED_FLAG , 'Y' ) = 'Y'
65: AND NVL ( CONFIGURATION_ITEM_FLAG , 'N' ) =

Line 102: FROM SO_LINE_DETAILS

98:
99:
100: SELECT COUNT(*)
101: INTO Details_Complexity_Count
102: FROM SO_LINE_DETAILS
103: WHERE LINE_ID = P_Line_Id
104: AND NVL ( RELEASED_FLAG , 'N' ) = 'N'
105: GROUP BY COMPONENT_CODE
106: HAVING COUNT ( DisTINCT WAREHOUSE_ID ) > 1

Line 275: FROM SO_LINE_DETAILS

271: 'DEMANDED' ),
272: 'SUPPLY RESERVED' ),
273: 'RESERVED' )
274: INTO P_Schedule_Status_Code
275: FROM SO_LINE_DETAILS
276: WHERE LINE_ID = P_Line_Id;
277:
278: SELECT MEANING
279: INTO P_Schedule_Status_Name

Line 359: FROM SO_LINE_DETAILS

355:
356:
357: SELECT SUM ( NVL ( QUANTITY , 0 ) )
358: INTO P_RESERVED_QUANTITY
359: FROM SO_LINE_DETAILS
360: WHERE SCHEDULE_STATUS_CODE = 'RESERVED'
361: AND LINE_ID = P_Line_Id
362: AND NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N';
363:

Line 611: FROM SO_LINE_DETAILS

607: end if;
608:
609: SELECT SUM( QUANTITY )
610: INTO P_Reserved_Quantity
611: FROM SO_LINE_DETAILS
612: WHERE SCHEDULE_STATUS_CODE = 'RESERVED'
613: AND LINE_ID = P_Line_Id
614: AND NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N';
615: