View: CZ_MODEL_ARCHIVES_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_MODEL_ARCHIVES_V

View Text

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

Columns