PSP Post Upgrade Bad Data Copy link
Description
- Categories
- BI Publisher
- Application
- Labor Distribution
- Source
- PSP: Post Upgrade Bad Data Report (XML)
- Short Name
- PSPUPREP_XML
- DB package
- PSP_PSPUPREP_XMLP_PKG
SQL 14 lines
SELECT TABLE_NAME, ROW_COUNT, ROW_IND FROM (SELECT '------------------------------' TABLE_NAME, 1 ROW_COUNT, 1 ROW_IND FROM DUAL WHERE 1 = 2 &p_invalid_tables_query1 &p_invalid_tables_query2 &p_invalid_tables_query3 &p_invalid_tables_query4) psp_invalid_tables WHERE row_count > 0 |