1. Tables and Views for Sales, Fusion Service, and Field Service
  2. ZCA_SALES_MOTION_DT_VL

ZCA_SALES_MOTION_DT_VL

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: VIEW

Columns

Name

SALES_MOTION_DT_ID

NAME

DESC_TEXT

OBJECT_CODE

STATUS_CODE

DELETED_FLAG

CREATION_DATE

OBJECT_VERSION_NUMBER

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT

B.SALES_MOTION_DT_ID,

T.NAME NAME,

T.DESC_TEXT DESC_TEXT,

B.OBJECT_CODE,

B.STATUS_CODE,

B.DELETED_FLAG,

B.CREATION_DATE,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN

FROM

ZCA_SALES_MOTION_DT_B B,

ZCA_SALES_MOTION_DT_TL T

WHERE

B.SALES_MOTION_DT_ID = T.SALES_MOTION_DT_ID

AND T.LANGUAGE = USERENV('LANG')