APPS.OEXVWLIN dependencies on SO_ORDER_HOLDS_ALL

Line 162: -- Check any hold from line or header in the table SO_ORDER_HOLDS_ALL.

158: END ;
159:
160:
161: ------------------------------------------------------------------------
162: -- Check any hold from line or header in the table SO_ORDER_HOLDS_ALL.
163: -----------------------------------------------------------------------
164: function HOLD(
165: ORDER_LINE_ID IN NUMBER DEFAULT NULL
166: , ORDER_HEADER_ID IN NUMBER DEFAULT NULL

Line 175: FROM SO_ORDER_HOLDS_ALL

171: BEGIN
172: SELECT DECODE( NVL(SUM(DECODE( HOLD_RELEASE_ID, NULL, 1, 0)),0),
173: 0,'N', 'Y')
174: INTO HOLD_FLAG
175: FROM SO_ORDER_HOLDS_ALL
176: WHERE LINE_ID = ORDER_LINE_ID
177: OR (LINE_ID IS NULL AND HEADER_ID = ORDER_HEADER_ID);
178:
179: RETURN( HOLD_FLAG );