View: CZ_RP_BOM_MODELS_V

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

View Text

SELECT CZ_DEVL_PROJECTS.INVENTORY_ITEM_ID
, CZ_DEVL_PROJECTS.ORGANIZATION_ID
, CZ_RP_ENTRIES.NAME
, CZ_INTL_TEXTS.TEXT_STR
, CZ_DEVELOPER_UTILS_PVT.GET_REPOSITORY_PATH(CZ_RP_ENTRIES.OBJECT_ID
, 'PRJ')
, CZ_DEVL_PROJECTS.LAST_UPDATE_DATE
, CZ_XFR_PROJECT_BILLS.LAST_IMPORT_DATE
, TO_CHAR(NULL)
, TO_CHAR(NULL)
FROM CZ_RP_ENTRIES
, CZ_DEVL_PROJECTS
, CZ_XFR_PROJECT_BILLS
, CZ_PS_NODES
, CZ_INTL_TEXTS
WHERE CZ_RP_ENTRIES.DELETED_FLAG = '0'
AND CZ_RP_ENTRIES.OBJECT_TYPE = 'PRJ'
AND CZ_RP_ENTRIES.OBJECT_ID = CZ_DEVL_PROJECTS.DEVL_PROJECT_ID
AND CZ_DEVL_PROJECTS.DELETED_FLAG = '0'
AND CZ_DEVL_PROJECTS.INVENTORY_ITEM_ID IS NOT NULL
AND CZ_DEVL_PROJECTS.ORGANIZATION_ID IS NOT NULL
AND CZ_DEVL_PROJECTS.DEVL_PROJECT_ID = CZ_XFR_PROJECT_BILLS.MODEL_PS_NODE_ID
AND CZ_DEVL_PROJECTS.DEVL_PROJECT_ID = CZ_PS_NODES.DEVL_PROJECT_ID
AND CZ_PS_NODES.PARENT_ID IS NULL
AND CZ_PS_NODES.DELETED_FLAG = '0'
AND CZ_PS_NODES.INTL_TEXT_ID = CZ_INTL_TEXTS.INTL_TEXT_ID
AND CZ_INTL_TEXTS.DELETED_FLAG = '0'

Columns