APPS.OEXVWLIN dependencies on SO_LINE_DETAILS

Line 113: FROM SO_LINE_DETAILS SLD

109: 'DEMANDED' ),
110: 'SUPPLY RESERVED' ),
111: 'RESERVED' )
112: INTO schedule_status_code
113: FROM SO_LINE_DETAILS SLD
114: WHERE SLD.LINE_ID = ORDER_LINE_ID;
115:
116: if ( schedule_status_code is not null )
117: then

Line 134: -- from So_Line_DETAILS table to get all reserved details quantity

130: end ;
131:
132:
133: ------------------------------------------------------------------------
134: -- from So_Line_DETAILS table to get all reserved details quantity
135: ------------------------------------------------------------------------
136: function RESERVED_QUANTITY(
137: ORDER_LINE_ID IN NUMBER DEFAULT NULL
138: )

Line 148: from SO_LINE_DETAILS

144: select sum( decode( SCHEDULE_STATUS_CODE,
145: 'RESERVED', QUANTITY,
146: 0))
147: into RESERVED_QTY
148: from SO_LINE_DETAILS
149: where line_id = ORDER_LINE_ID
150: and NVL(INCLUDED_ITEM_FLAG, 'N')='N';
151:
152: return( RESERVED_QTY);