1. Tables and Views for SCM
  2. MSC_BUSINESS_OBJECTS_VL

MSC_BUSINESS_OBJECTS_VL

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

BUSINESS_OBJECT

SUPPORTED_VERSIONS

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

XREF_AVAILABILITY_FLAG

STG_COLL_AVL_FLAG

PLANNING_BO_TYPE

PIM_TCA_FLAG

DEPENDENT_BO_LIST

BO_DISPLAY_NAME

Query

SQL_Statement

SELECT

MSC_BUSINESS_OBJECTS_B.BUSINESS_OBJECT BUSINESS_OBJECT,

MSC_BUSINESS_OBJECTS_B.SUPPORTED_VERSIONS SUPPORTED_VERSIONS,

MSC_BUSINESS_OBJECTS_B.CREATED_BY CREATED_BY,

MSC_BUSINESS_OBJECTS_B.CREATION_DATE CREATION_DATE,

MSC_BUSINESS_OBJECTS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

MSC_BUSINESS_OBJECTS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MSC_BUSINESS_OBJECTS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MSC_BUSINESS_OBJECTS_B.XREF_AVAILABILITY_FLAG XREF_AVAILABILITY_FLAG,

MSC_BUSINESS_OBJECTS_B.STG_COLL_AVL_FLAG STG_COLL_AVL_FLAG,

MSC_BUSINESS_OBJECTS_B.PLANNING_BO_TYPE PLANNING_BO_TYPE,

MSC_BUSINESS_OBJECTS_B.PIM_TCA_FLAG PIM_TCA_FLAG,

MSC_BUSINESS_OBJECTS_B.DEPENDENT_BO_LIST DEPENDENT_BO_LIST,

MSC_BUSINESS_OBJECTS_TL.BO_DISPLAY_NAME BO_DISPLAY_NAME

FROM

MSC_BUSINESS_OBJECTS_B,

MSC_BUSINESS_OBJECTS_TL

WHERE

MSC_BUSINESS_OBJECTS_B.BUSINESS_OBJECT =MSC_BUSINESS_OBJECTS_TL.BUSINESS_OBJECT AND MSC_BUSINESS_OBJECTS_TL.LANGUAGE = USERENV('LANG')