CZ Model Conversion XML Publisher Concurrent Program

Description

Application: Configurator
Source: Model Conversion XML Publisher Concurrent Program
Short Name: CZ_MDLCONV
DB package:

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

SELECT CZ_DEVELOPER_UTILS_PVT.get_Repository_Path( model_id,'PRJ') Folder,
       CZ_DEVELOPER_UTILS_PVT.get_Relative_Model_Path( model_id) model ,
       (select name from cz_devl_projects where devl_project_id=model_id) convmodel ,
       (select count(*) from cz_db_logs inner1 where inner1.model_id=outer1.model_id and urgency=1 ) failure,
       (select count(*) from cz_db_logs inner1 where inner1.model_id=outer1.model_id and urgency=2 ) warning,
       (select count(*) from cz_db_logs inner1 where inner1.model_id=outer1.model_id and urgency=3 ) advisory,
       (select count(*) from cz_db_logs inner1 where inner1.model_id=outer1.model_id and urgency=4 ) info ,
       outer1.model_id MODELID
     FROM cz_db_logs outer1
     WHERE model_conversion_set_id = :p_convSetID
     AND object_type IS NULL
     ORDER BY Folder