VIEW: APPS.CZ_MODEL_ARCHIVES_V

Source

View Text - Preformatted

SELECT PRJ.DEVL_PROJECT_ID AS MODEL_ID, to_number (SUBSTR (MIN (TO_CHAR (ORDMODEL.SEQ_NBR, '000000000000000') || '%' || TO_CHAR (ORDMODEL.MODEL_ID)), 18)) AS REFERRING_MODEL_ID, MIN (ORDMODEL.SEQ_NBR) AS REFERRING_MODEL_SEQ_NBR, to_number (SUBSTR (MIN (TO_CHAR (ORDMODEL.SEQ_NBR, '000000000000000') || '%' || TO_CHAR (ARCREF.SEQ_NBR)), 18)) AS SEQ_NBR, ARCREF.ARCHIVE_ID FROM CZ_ARCHIVE_REFS ARCREF, CZ_DEVL_PROJECTS PRJ, table (cast (cz_model_util_pvt.GET_REFERENCED_MODELS (PRJ.DEVL_PROJECT_ID) as "SYSTEM".cz_model_order_tbl_type)) ORDMODEL WHERE PRJ.DELETED_FLAG = '0' AND ARCREF.DELETED_FLAG = '0' AND ARCREF.DEVL_PROJECT_ID = ORDMODEL.MODEL_ID GROUP BY PRJ.DEVL_PROJECT_ID, ARCREF.ARCHIVE_ID

View Text - HTML Formatted

SELECT PRJ.DEVL_PROJECT_ID AS MODEL_ID
, TO_NUMBER (SUBSTR (MIN (TO_CHAR (ORDMODEL.SEQ_NBR
, '000000000000000') || '%' || TO_CHAR (ORDMODEL.MODEL_ID))
, 18)) AS REFERRING_MODEL_ID
, MIN (ORDMODEL.SEQ_NBR) AS REFERRING_MODEL_SEQ_NBR
, TO_NUMBER (SUBSTR (MIN (TO_CHAR (ORDMODEL.SEQ_NBR
, '000000000000000') || '%' || TO_CHAR (ARCREF.SEQ_NBR))
, 18)) AS SEQ_NBR
, ARCREF.ARCHIVE_ID
FROM CZ_ARCHIVE_REFS ARCREF
, CZ_DEVL_PROJECTS PRJ
, TABLE (CAST (CZ_MODEL_UTIL_PVT.GET_REFERENCED_MODELS (PRJ.DEVL_PROJECT_ID) AS "SYSTEM".CZ_MODEL_ORDER_TBL_TYPE)) ORDMODEL
WHERE PRJ.DELETED_FLAG = '0'
AND ARCREF.DELETED_FLAG = '0'
AND ARCREF.DEVL_PROJECT_ID = ORDMODEL.MODEL_ID GROUP BY PRJ.DEVL_PROJECT_ID
, ARCREF.ARCHIVE_ID