APPS.OE_QUERY dependencies on SO_ORDER_HOLDS_ALL

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

569:
570:
571:
572: ------------------------------------------------------------------------
573: -- Check any hold from line or header in the table SO_ORDER_HOLDS_ALL.
574: -----------------------------------------------------------------------
575: function HOLD(
576: ORDER_LINE_ID IN NUMBER DEFAULT NULL
577: , ORDER_HEADER_ID IN NUMBER DEFAULT NULL

Line 586: FROM SO_ORDER_HOLDS_ALL

582: BEGIN
583: SELECT DECODE( NVL(SUM(DECODE( HOLD_RELEASE_ID, NULL, 1, 0)),0),
584: 0,'N', 'Y')
585: INTO HOLD_FLAG
586: FROM SO_ORDER_HOLDS_ALL
587: WHERE LINE_ID = ORDER_LINE_ID
588: OR (LINE_ID IS NULL AND HEADER_ID = ORDER_HEADER_ID);
589:
590: RETURN( HOLD_FLAG );