1. Tables and Views for Sales and Fusion Service
  2. SVC_WO_LINK_TEMPLATES_VL

SVC_WO_LINK_TEMPLATES_VL

Details

  • Schema: FUSION

  • Object owner: SVC

  • Object type: VIEW

Columns

Name

LINK_TEMPLATE_ID

LINK_TEMPLATE_NUMBER

LINK_TEMPLATE_CAT_CD

MIN_INTERVAL_TYPE_CD

MIN_INTERVAL_MINUTES

MAX_INTERVAL_TYPE_CD

MAX_INTERVAL_MINUTES

ASSIGNMENT_CONSTRAINT_CD

SCHEDULING_CONSTRAINT_CD

LINK_TYPE_LABEL_FIRST

LINK_TYPE_LABEL_SECOND

ACTIVE_FLAG

CREATION_DATE

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

LAST_UPDATE_DATE

LINK_TYPE_NAME_FIRST

LINK_TYPE_NAME_SECOND

Query

SQL_Statement

SELECT

b.LINK_TEMPLATE_ID LINK_TEMPLATE_ID,

b.LINK_TEMPLATE_NUMBER LINK_TEMPLATE_NUMBER,

b.LINK_TEMPLATE_CAT_CD LINK_TEMPLATE_CAT_CD,

b.MIN_INTERVAL_TYPE_CD MIN_INTERVAL_TYPE_CD,

b.MIN_INTERVAL_MINUTES MIN_INTERVAL_MINUTES,

b.MAX_INTERVAL_TYPE_CD MAX_INTERVAL_TYPE_CD,

b.MAX_INTERVAL_MINUTES MAX_INTERVAL_MINUTES,

b.ASSIGNMENT_CONSTRAINT_CD ASSIGNMENT_CONSTRAINT_CD,

b.SCHEDULING_CONSTRAINT_CD SCHEDULING_CONSTRAINT_CD,

b.LINK_TYPE_LABEL_FIRST LINK_TYPE_LABEL_FIRST,

b.LINK_TYPE_LABEL_SECOND LINK_TYPE_LABEL_SECOND,

b.ACTIVE_FLAG ACTIVE_FLAG,

b.CREATION_DATE CREATION_DATE,

b.CREATED_BY CREATED_BY,

b.LAST_UPDATED_BY LAST_UPDATED_BY,

b.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

b.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

b.LAST_UPDATE_DATE LAST_UPDATE_DATE,

tl.LINK_TYPE_NAME_FIRST LINK_TYPE_NAME_FIRST,

tl.LINK_TYPE_NAME_SECOND LINK_TYPE_NAME_SECOND

FROM

svc_wo_link_templates_b b,

svc_wo_link_templates_tl tl

WHERE

b.LINK_TEMPLATE_NUMBER = tl.LINK_TEMPLATE_NUMBER AND tl.LANGUAGE = USERENV('LANG')