FOD_SALES_SETUP_VALIDN_VL

Details

  • Schema: FUSION

  • Object owner: FOD

  • Object type: VIEW

Columns

Name

RULE_CODE

SEQUENCE

SEED_DATA_SOURCE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

RULE_DESC

RULE_NAME

Query

SQL_Statement

SELECT

base.RULE_CODE,

base.SEQUENCE,

base.SEED_DATA_SOURCE,

base.CREATED_BY,

base.CREATION_DATE,

base.LAST_UPDATED_BY,

base.LAST_UPDATE_DATE,

base.LAST_UPDATE_LOGIN,

base.OBJECT_VERSION_NUMBER,

tl.RULE_DESC,

tl.RULE_NAME

FROM

fod_sales_setup_validn_b base

JOIN fod_sales_setup_validn_tl tl on base.RULE_CODE = tl.RULE_CODE

WHERE

tl.LANGUAGE = USERENV ('LANG')