RCL_SERVICE_ACTIVITIES_VL

Details

• Schema: FUSION

• Object owner: RCL

• Object type: VIEW

Columns

Name
SERVICE_ACTIVITY_ID OBJECT_VERSION_NUMBER NAME DESCRIPTION SERVICE_ACTIVITY_CODE BUSINESS_PROCESS_CODE LINE_CATEGORY ORDER_LINE_TYPE CREATE_CHARGE_FLAG OM_INTERFACE_FLAG ZERO_CHARGE_FLAG UPDATE_COST_FLAG RESOURCE_ACTIVITY_CODE ORDER_TYPE_CODE ENABLED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT sab.service_activity_id, sab.object_version_number, sat.name, sat.description, sab.service_activity_code, sab.business_process_code, sab.line_category, sab.ORDER_LINE_TYPE, sab.create_charge_flag, sab.om_interface_flag, sab.ZERO_CHARGE_FLAG, sab.UPDATE_COST_FLAG, sab.RESOURCE_ACTIVITY_CODE, sab.ORDER_TYPE_CODE, sab.enabled_flag, sab.created_by, sab.creation_date, sab.last_updated_by, sab.last_update_date, sab.last_update_login FROM rcl_service_activities_b sab, rcl_service_activities_tl sat WHERE sat.service_activity_id = sab.service_activity_id AND sat.language = userenv('LANG')