DBA Data[Home] [Help]

APPS.IEC_STATUS_PVT dependencies on IEO_SVR_RT_INFO

Line 782: FROM IEC_G_RETURN_ENTRIES A, IEO_SVR_RT_INFO B

778:
779: -- Get list of STOPPED servers that have records checked out
780: SELECT DISTINCT B.SERVER_ID
781: BULK COLLECT INTO l_stopped_server_id_col
782: FROM IEC_G_RETURN_ENTRIES A, IEO_SVR_RT_INFO B
783: WHERE A.CHECKOUT_ACTION_ID = B.SERVER_ID
784: AND A.LIST_HEADER_ID = p_list_id
785: AND A.RECORD_OUT_FLAG = 'Y'
786: AND B.STATUS = 1;

Line 876: FROM IEC_G_RETURN_ENTRIES A, IEO_SVR_RT_INFO B

872:
873: -- Get list of STOPPED servers that have records checked out
874: SELECT DISTINCT B.SERVER_ID
875: BULK COLLECT INTO l_stopped_server_id_col
876: FROM IEC_G_RETURN_ENTRIES A, IEO_SVR_RT_INFO B
877: WHERE A.CHECKOUT_ACTION_ID = B.SERVER_ID
878: AND A.LIST_HEADER_ID = l_list_id
879: AND A.RECORD_OUT_FLAG = 'Y'
880: AND B.STATUS = 1;