1. Tables and Views for Project Management
  2. PJF_INT_SYNC_RULE_VL

PJF_INT_SYNC_RULE_VL

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: VIEW

Columns

Name

SRLB_RULE_ID

OBJECT_VERSION_NUMBER

SRLB_CODE

SRLB_RULE_TYPE

SRLB_ENABLED_FLAG

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SRLT_NAME

SRLT_DESCRIPTION

Query

SQL_Statement

SELECT

B.SRLB_RULE_ID SRLB_RULE_ID,

B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

B.SRLB_CODE SRLB_CODE,

B.SRLB_RULE_TYPE SRLB_RULE_TYPE,

B.SRLB_ENABLED_FLAG SRLB_ENABLED_FLAG,

B.EFFECTIVE_START_DATE EFFECTIVE_START_DATE,

B.EFFECTIVE_END_DATE EFFECTIVE_END_DATE,

B.CREATED_BY CREATED_BY,

B.CREATION_DATE CREATION_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

TL.SRLT_NAME SRLT_NAME,

TL.SRLT_DESCRIPTION SRLT_DESCRIPTION

FROM

PJF_INT_SYNC_RULE_B B,

PJF_INT_SYNC_RULE_TL TL

WHERE B.SRLB_RULE_ID = TL.SRLB_RULE_ID AND LANGUAGE = USERENV('LANG')