VIEW: APPS.CZ_RP_BOM_MODELS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'