MSC_POLICY_PARAMS

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
POLICY_ID POLICY_TYPE POLICY_SPEC EX_PERCENTAGE MIN_OVERRIDE MAX_QTY ORD_QTY HISTORY_DATA_DAYS CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SS_CALC_METHOD SS_DAYS_OF_COVERAGE SS_OVERRIDE MAX_CALC_METHOD DEF_CARRYING_COST DEF_ORDERING_COST DEF_STANDARD_COST EOQ_OVERRIDE MAX_OVERRIDE DEF_DAILY_DEMAND POLICY_CODE POLICY_PROFILE_NAME POLICY_DESCRIPTION

Name

POLICY_ID

POLICY_TYPE

POLICY_SPEC

EX_PERCENTAGE

MIN_OVERRIDE

MAX_QTY

ORD_QTY

HISTORY_DATA_DAYS

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

SS_CALC_METHOD

SS_DAYS_OF_COVERAGE

SS_OVERRIDE

MAX_CALC_METHOD

DEF_CARRYING_COST

DEF_ORDERING_COST

DEF_STANDARD_COST

EOQ_OVERRIDE

MAX_OVERRIDE

DEF_DAILY_DEMAND

POLICY_CODE

POLICY_PROFILE_NAME

POLICY_DESCRIPTION

Query

SQL_Statement
SELECT MSC_POLICY_PARAMS_B.POLICY_ID POLICY_ID, MSC_POLICY_PARAMS_B.POLICY_TYPE POLICY_TYPE, MSC_POLICY_PARAMS_B.POLICY_SPEC POLICY_SPEC, MSC_POLICY_PARAMS_B.EX_PERCENTAGE EX_PERCENTAGE, MSC_POLICY_PARAMS_B.MIN_OVERRIDE MIN_OVERRIDE, MSC_POLICY_PARAMS_B.MAX_QTY MAX_QTY, MSC_POLICY_PARAMS_B.ORD_QTY ORD_QTY, MSC_POLICY_PARAMS_B.HISTORY_DATA_DAYS HISTORY_DATA_DAYS, MSC_POLICY_PARAMS_B.CREATED_BY CREATED_BY, MSC_POLICY_PARAMS_B.CREATION_DATE CREATION_DATE, MSC_POLICY_PARAMS_B.LAST_UPDATED_BY LAST_UPDATED_BY, MSC_POLICY_PARAMS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, MSC_POLICY_PARAMS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MSC_POLICY_PARAMS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MSC_POLICY_PARAMS_B.SS_CALC_METHOD SS_CALC_METHOD, MSC_POLICY_PARAMS_B.SS_DAYS_OF_COVERAGE SS_DAYS_OF_COVERAGE, MSC_POLICY_PARAMS_B.SS_OVERRIDE SS_OVERRIDE, MSC_POLICY_PARAMS_B.MAX_CALC_METHOD MAX_CALC_METHOD, MSC_POLICY_PARAMS_B.DEF_CARRYING_COST DEF_CARRYING_COST, MSC_POLICY_PARAMS_B.DEF_ORDERING_COST DEF_ORDERING_COST, MSC_POLICY_PARAMS_B.DEF_STANDARD_COST DEF_STANDARD_COST, MSC_POLICY_PARAMS_B.EOQ_OVERRIDE EOQ_OVERRIDE, MSC_POLICY_PARAMS_B.MAX_OVERRIDE MAX_OVERRIDE, MSC_POLICY_PARAMS_B.DEF_DAILY_DEMAND DEF_DAILY_DEMAND, MSC_POLICY_PARAMS_B.POLICY_CODE, MSC_POLICY_PARAMS_TL.POLICY_PROFILE_NAME POLICY_PROFILE_NAME, MSC_POLICY_PARAMS_TL.POLICY_DESCRIPTION POLICY_DESCRIPTION FROM MSC_POLICY_PARAMS_B, MSC_POLICY_PARAMS_TL WHERE MSC_POLICY_PARAMS_B.POLICY_ID = MSC_POLICY_PARAMS_TL.POLICY_ID AND MSC_POLICY_PARAMS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

MSC_POLICY_PARAMS_B.POLICY_ID POLICY_ID,

MSC_POLICY_PARAMS_B.POLICY_TYPE POLICY_TYPE,

MSC_POLICY_PARAMS_B.POLICY_SPEC POLICY_SPEC,

MSC_POLICY_PARAMS_B.EX_PERCENTAGE EX_PERCENTAGE,

MSC_POLICY_PARAMS_B.MIN_OVERRIDE MIN_OVERRIDE,

MSC_POLICY_PARAMS_B.MAX_QTY MAX_QTY,

MSC_POLICY_PARAMS_B.ORD_QTY ORD_QTY,

MSC_POLICY_PARAMS_B.HISTORY_DATA_DAYS HISTORY_DATA_DAYS,

MSC_POLICY_PARAMS_B.CREATED_BY CREATED_BY,

MSC_POLICY_PARAMS_B.CREATION_DATE CREATION_DATE,

MSC_POLICY_PARAMS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

MSC_POLICY_PARAMS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

MSC_POLICY_PARAMS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

MSC_POLICY_PARAMS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

MSC_POLICY_PARAMS_B.SS_CALC_METHOD SS_CALC_METHOD,

MSC_POLICY_PARAMS_B.SS_DAYS_OF_COVERAGE SS_DAYS_OF_COVERAGE,

MSC_POLICY_PARAMS_B.SS_OVERRIDE SS_OVERRIDE,

MSC_POLICY_PARAMS_B.MAX_CALC_METHOD MAX_CALC_METHOD,

MSC_POLICY_PARAMS_B.DEF_CARRYING_COST DEF_CARRYING_COST,

MSC_POLICY_PARAMS_B.DEF_ORDERING_COST DEF_ORDERING_COST,

MSC_POLICY_PARAMS_B.DEF_STANDARD_COST DEF_STANDARD_COST,

MSC_POLICY_PARAMS_B.EOQ_OVERRIDE EOQ_OVERRIDE,

MSC_POLICY_PARAMS_B.MAX_OVERRIDE MAX_OVERRIDE,

MSC_POLICY_PARAMS_B.DEF_DAILY_DEMAND DEF_DAILY_DEMAND,

MSC_POLICY_PARAMS_B.POLICY_CODE,

MSC_POLICY_PARAMS_TL.POLICY_PROFILE_NAME POLICY_PROFILE_NAME,

MSC_POLICY_PARAMS_TL.POLICY_DESCRIPTION POLICY_DESCRIPTION

FROM

MSC_POLICY_PARAMS_B,

MSC_POLICY_PARAMS_TL

WHERE

MSC_POLICY_PARAMS_B.POLICY_ID = MSC_POLICY_PARAMS_TL.POLICY_ID AND MSC_POLICY_PARAMS_TL.LANGUAGE = USERENV('LANG')