MOT_QM_QUOTA_PLANS

Details

Schema: FUSION
Object owner: MOT
Object type: VIEW

Columns

Name
QUOTA_PLAN_ID CALENDAR_ID QUOTA_PLAN_NAME QUOTA_PLAN_DESCRIPTION PLAN_START_DATE PLAN_END_DATE ACTIVATION_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PERIOD_YEAR REQUEST_ID STATUS_CODE DEFAULT_PREDICTION_FLAG TRACK_QUOTA_PLAN_FLAG JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE COPY_QUOTA_PLAN_ID PAD_THRESHOLD_PERCENT SEASONALITY_FACTOR_DEFN_ID COPY_PREDICTION_FLAG LAST_SYNC_TIME SYNC_STATUS

Name

QUOTA_PLAN_ID

CALENDAR_ID

QUOTA_PLAN_NAME

QUOTA_PLAN_DESCRIPTION

PLAN_START_DATE

PLAN_END_DATE

ACTIVATION_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

PERIOD_YEAR

REQUEST_ID

STATUS_CODE

DEFAULT_PREDICTION_FLAG

TRACK_QUOTA_PLAN_FLAG

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

COPY_QUOTA_PLAN_ID

PAD_THRESHOLD_PERCENT

SEASONALITY_FACTOR_DEFN_ID

COPY_PREDICTION_FLAG

LAST_SYNC_TIME

SYNC_STATUS

Query

SQL_Statement
SELECT MOT_QM_QUOTA_PLANS_B.QUOTA_PLAN_ID QUOTA_PLAN_ID, MOT_QM_QUOTA_PLANS_B.CALENDAR_ID, MOT_QM_QUOTA_PLANS_TL.QUOTA_PLAN_NAME QUOTA_PLAN_NAME, MOT_QM_QUOTA_PLANS_TL.QUOTA_PLAN_DESCRIPTION QUOTA_PLAN_DESCRIPTION, MOT_QM_QUOTA_PLANS_B.PLAN_START_DATE, MOT_QM_QUOTA_PLANS_B.PLAN_END_DATE, MOT_QM_QUOTA_PLANS_B.ACTIVATION_DATE, MOT_QM_QUOTA_PLANS_B.CREATED_BY, MOT_QM_QUOTA_PLANS_B.CREATION_DATE, MOT_QM_QUOTA_PLANS_B.LAST_UPDATED_BY, MOT_QM_QUOTA_PLANS_B.LAST_UPDATE_DATE, MOT_QM_QUOTA_PLANS_B.LAST_UPDATE_LOGIN, MOT_QM_QUOTA_PLANS_B.OBJECT_VERSION_NUMBER, MOT_QM_QUOTA_PLANS_B.PERIOD_YEAR, MOT_QM_QUOTA_PLANS_B.REQUEST_ID, MOT_QM_QUOTA_PLANS_B.STATUS_CODE STATUS_CODE, MOT_QM_QUOTA_PLANS_B.DEFAULT_PREDICTION_FLAG DEFAULT_PREDICTION_FLAG, MOT_QM_QUOTA_PLANS_B.TRACK_QUOTA_PLAN_FLAG TRACK_QUOTA_PLAN_FLAG, MOT_QM_QUOTA_PLANS_B.JOB_DEFINITION_NAME, MOT_QM_QUOTA_PLANS_B.JOB_DEFINITION_PACKAGE, MOT_QM_QUOTA_PLANS_B.COPY_QUOTA_PLAN_ID COPY_QUOTA_PLAN_ID, MOT_QM_QUOTA_PLANS_B.PAD_THRESHOLD_PERCENT, MOT_QM_QUOTA_PLANS_B.SEASONALITY_FACTOR_DEFN_ID, MOT_QM_QUOTA_PLANS_B.COPY_PREDICTION_FLAG, MOT_QM_QUOTA_PLANS_B.LAST_SYNC_TIME, MOT_QM_QUOTA_PLANS_B.SYNC_STATUS FROM MOT_QM_QUOTA_PLANS_B, MOT_QM_QUOTA_PLANS_TL WHERE MOT_QM_QUOTA_PLANS_B.QUOTA_PLAN_ID = MOT_QM_QUOTA_PLANS_TL.QUOTA_PLAN_ID AND MOT_QM_QUOTA_PLANS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

MOT_QM_QUOTA_PLANS_B.QUOTA_PLAN_ID QUOTA_PLAN_ID,

MOT_QM_QUOTA_PLANS_B.CALENDAR_ID,

MOT_QM_QUOTA_PLANS_TL.QUOTA_PLAN_NAME QUOTA_PLAN_NAME,

MOT_QM_QUOTA_PLANS_TL.QUOTA_PLAN_DESCRIPTION QUOTA_PLAN_DESCRIPTION,

MOT_QM_QUOTA_PLANS_B.PLAN_START_DATE,

MOT_QM_QUOTA_PLANS_B.PLAN_END_DATE,

MOT_QM_QUOTA_PLANS_B.ACTIVATION_DATE,

MOT_QM_QUOTA_PLANS_B.CREATED_BY,

MOT_QM_QUOTA_PLANS_B.CREATION_DATE,

MOT_QM_QUOTA_PLANS_B.LAST_UPDATED_BY,

MOT_QM_QUOTA_PLANS_B.LAST_UPDATE_DATE,

MOT_QM_QUOTA_PLANS_B.LAST_UPDATE_LOGIN,

MOT_QM_QUOTA_PLANS_B.OBJECT_VERSION_NUMBER,

MOT_QM_QUOTA_PLANS_B.PERIOD_YEAR,

MOT_QM_QUOTA_PLANS_B.REQUEST_ID,

MOT_QM_QUOTA_PLANS_B.STATUS_CODE STATUS_CODE,

MOT_QM_QUOTA_PLANS_B.DEFAULT_PREDICTION_FLAG DEFAULT_PREDICTION_FLAG,

MOT_QM_QUOTA_PLANS_B.TRACK_QUOTA_PLAN_FLAG TRACK_QUOTA_PLAN_FLAG,

MOT_QM_QUOTA_PLANS_B.JOB_DEFINITION_NAME,

MOT_QM_QUOTA_PLANS_B.JOB_DEFINITION_PACKAGE,

MOT_QM_QUOTA_PLANS_B.COPY_QUOTA_PLAN_ID COPY_QUOTA_PLAN_ID,

MOT_QM_QUOTA_PLANS_B.PAD_THRESHOLD_PERCENT,

MOT_QM_QUOTA_PLANS_B.SEASONALITY_FACTOR_DEFN_ID,

MOT_QM_QUOTA_PLANS_B.COPY_PREDICTION_FLAG,

MOT_QM_QUOTA_PLANS_B.LAST_SYNC_TIME,

MOT_QM_QUOTA_PLANS_B.SYNC_STATUS

FROM

MOT_QM_QUOTA_PLANS_B,

MOT_QM_QUOTA_PLANS_TL

WHERE

MOT_QM_QUOTA_PLANS_B.QUOTA_PLAN_ID = MOT_QM_QUOTA_PLANS_TL.QUOTA_PLAN_ID AND MOT_QM_QUOTA_PLANS_TL.LANGUAGE = USERENV('LANG')