MOO_SALES_METHOD_VL
Details
-
Schema: FUSION
-
Object owner: MOO
-
Object type: VIEW
Columns
Name |
---|
SALES_METHOD_ID SET_ID OPPORTUNITY_TYPE OPTY_CLOSE_WINDOW NAME DESC_TEXT CONFLICT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER USER_LAST_UPDATE_DATE SALES_METHOD_NUMBER DELETED_FLAG REVN_LINE_SET_ENABLED_FLAG |
Query
SQL_Statement |
---|
SELECT B.SALES_METHOD_ID, B.SET_ID, B.OPPORTUNITY_TYPE, B.OPTY_CLOSE_WINDOW, T.NAME, T.DESC_TEXT, B.CONFLICT_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.USER_LAST_UPDATE_DATE, B.SALES_METHOD_NUMBER, B.DELETED_FLAG, B.REVN_LINE_SET_ENABLED_FLAG FROM MOO_SALES_METHOD_B B, MOO_SALES_METHOD_TL T WHERE B.SALES_METHOD_ID = T.SALES_METHOD_ID AND T.LANGUAGE = USERENV('LANG') |