DBA Data[Home] [Help]

APPS.EAM_TEXT_INDEX_PVT dependencies on CTX_INDEXES

Line 900: FROM ctxsys.ctx_indexes

896: -- Check the created index status
897:
898: SELECT idx_docid_count, idx_status
899: INTO l_idx_docid_count, l_idx_status
900: FROM ctxsys.ctx_indexes
901: WHERE idx_owner = g_Prod_Schema AND idx_name = 'EAM_ASSET_TEXT_CTX1'
902: AND idx_table = 'EAM_ASSET_TEXT';
903:
904: IF NOT( l_idx_status = 'INDEXED' ) THEN

Line 1623: FROM ctxsys.ctx_indexes

1619: -- Check the created index status
1620:
1621: SELECT idx_docid_count, idx_status
1622: INTO l_idx_docid_count, l_idx_status
1623: FROM ctxsys.ctx_indexes
1624: WHERE idx_owner = g_Prod_Schema AND idx_name = 'EAM_WORK_ORDER_TEXT_CTX1'
1625: AND idx_table = 'EAM_WORK_ORDER_TEXT';
1626:
1627: IF NOT( l_idx_status = 'INDEXED' ) THEN