SVC_STD_TXT_TREE_V

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
UNIQUE_IDENTIFIER TYPE NAME PARENT_FOLDER_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SCOPE USER_PARTY_ID DOMAIN SUB_DOMAIN OBJECT STRIPE_CD BU_ORG_ID UNIQUE_NUMBER HTML_FLAG

Query

SQL_Statement

SELECT fldr.folder_id unique_identifier, 'Folder' type, fldr.name, fldr.parent_folder_id parent_folder_id, fldr.created_by, fldr.creation_date, fldr.last_updated_by, fldr.last_update_date, fldr.last_update_login, fldr.object_version_number, 'ORA_SVC_GLOBAL' scope, fldr.user_party_id, domain, NULL sub_domain, NULL object, stripe_cd, bu_org_id, folder_unique_number unique_number, NULL html_flag FROM svc_std_txt_folders fldr UNION ALL SELECT txt.std_txt_id unique_identifier, 'Text' type, txt.stdtxt_name name, txt.folder_id parent_folder_id, txt.created_by, txt.creation_date, txt.last_updated_by, txt.last_update_date, txt.last_update_login, txt.object_version_number, txt.scope, user_party_id, txt.domain, txt.sub_domain, decode(txt.object, 'ServiceRequest', 'ServiceRequestVO', txt.object) object, stripe_cd, bu_org_id, std_txt_unique_number unique_number, txt.html_flag FROM svc_standard_text_vl txt