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'