View: CZ_MODEL_BOMREF_COUNTS_V

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

View Text

SELECT GET_BOM_REFS.MODEL_ID
, GET_BOM_REFS.MODEL_TYPE
, GET_BOM_REFS.NAME
, GET_BOM_REFS.BOMREFS
, SIGN (GET_BOM_REFS.BOMREFS) AS HAS_BOM_REFS
FROM ( SELECT PRJ.DEVL_PROJECT_ID AS MODEL_ID
, PRJ.MODEL_TYPE
, PRJ.NAME
, ( SELECT COUNT (*)
FROM CZ_MODEL_REF_EXPLS CLIMBEXPLS
WHERE CLIMBEXPLS.DELETED_FLAG = '0'
AND CLIMBEXPLS.PARENT_EXPL_NODE_ID IS NULL START WITH CLIMBEXPLS.DELETED_FLAG = '0'
AND CLIMBEXPLS.PS_NODE_TYPE != 264
AND CLIMBEXPLS.MODEL_ID = PRJ.DEVL_PROJECT_ID
AND EXISTS ( SELECT 1
FROM CZ_DEVL_PROJECTS BOMMODELS
WHERE CLIMBEXPLS.COMPONENT_ID = BOMMODELS.DEVL_PROJECT_ID
AND BOMMODELS.MODEL_TYPE IN ('A'
, 'P')
AND BOMMODELS.DELETED_FLAG = '0' ) CONNECT BY CLIMBEXPLS.MODEL_REF_EXPL_ID = PRIOR CLIMBEXPLS.PARENT_EXPL_NODE_ID
AND CLIMBEXPLS.MODEL_ID = PRIOR CLIMBEXPLS.MODEL_ID
AND CLIMBEXPLS.PS_NODE_TYPE != 264
AND CLIMBEXPLS.DELETED_FLAG = '0' ) BOMREFS
FROM CZ_DEVL_PROJECTS PRJ
WHERE PRJ.DELETED_FLAG = '0' ) GET_BOM_REFS

Columns