[Home] [Help] [Dependency Information]

TABLE: CSP.CSP_PLANNING_PARAMETERS

Object Details

Object Name:	CSP_PLANNING_PARAMETERS
Object Type:	TABLE
Owner:	CSP
FND Design Data:	CSP.CSP_PLANNING_PARAMETERS
Subobject Name:
Status:	VALID

CSP_PLANNING_PARAMETERS stores information about parameters used in Authorised Stock List planning for Organizations and Subinventories. ORGANIZATION_TYPE identifies if the Organization is Warehouse or Field Engineer Organization. FORECAST_RULE_ID identifies the Forecast rule to be used when generating Authorised Stock List recommendations. CALCULATION_RULE_ID identifies the calculation rule used. EXCESS_RULE_ID identifies the Excess Parts Rule used. SERVICE_LEVEL identifies the Service Level required for an Organization or Subinventory. EDQ_FACTOR identifies the Economic Delivery Quantity value. ASL_FLAG identifies if Authorised Stock List is applicable for an Organization or Subinventory. SAFETY_STOCK_FLAG identifies if Safety Stock needs to be used for the Organization/Subinventory. CONIDTION_TYPE identifies the condition of the Subinventory. PLANNER_CODE identifies the responsible planner for the Organization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CSP_PLANNING_PARAMETERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLANNING_PARAMETERS_ID
CSP_PLANNING_PARAMETERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEVEL_ID
CSP_PLANNING_PARAMETERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORECAST_RULE_ID
CSP_PLANNING_PARAMETERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCESS_RULE_ID
CSP_PLANNING_PARAMETERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALCULATION_RULE_ID
CSP_PLANNING_PARAMETERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID SECONDARY_INVENTORY
CSP_PLANNING_PARAMETERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NODE_TYPE

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT PLANNING_PARAMETERS_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FORECAST_RULE_ID
,      CALCULATION_RULE_ID
,      ORGANIZATION_TYPE
,      ORGANIZATION_ID
,      SECONDARY_INVENTORY
,      SERVICE_LEVEL
,      EDQ_FACTOR
,      PLANNER_CODE
,      CONDITION_TYPE
,      ASL_FLAG
,      SAFETY_STOCK_FLAG
,      EXCESS_RULE_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      RECOMMEND_METHOD
,      EDQ_MULTIPLE
,      MINIMUM_VALUE
,      USABLE_ASSIGNMENT_SET_ID
,      DEFECTIVE_ASSIGNMENT_SET_ID
,      PRODUCT_NORM
,      DEFAULT_FORECAST_RULE_ID
,      DEFAULT_SERVICE_LEVEL
,      DEFAULT_EDQ_FACTOR
,      DEFAULT_PLANNER_CODE
,      DEFAULT_CONDITION_TYPE
,      DEFAULT_ASL_FLAG
,      DEFAULT_SAFETY_STOCK_FLAG
,      DEFAULT_EXCESS_RULE_ID
,      DEFAULT_CATEGORY_SET_ID
,      DEFAULT_CATEGORY_ID
,      DEFAULT_RECOMMEND_METHOD
,      OVERRIDE_FORECAST_RULE_ID
,      OVERRIDE_SERVICE_LEVEL
,      OVERRIDE_EDQ_FACTOR
,      OVERRIDE_PLANNER_CODE
,      OVERRIDE_CONDITION_TYPE
,      OVERRIDE_ASL_FLAG
,      OVERRIDE_SAFETY_STOCK_FLAG
,      OVERRIDE_EXCESS_RULE_ID
,      OVERRIDE_CATEGORY_SET_ID
,      OVERRIDE_CATEGORY_ID
,      OVERRIDE_RECOMMEND_METHOD
,      NODE_TYPE
,      NODE_NAME
,      PARENT_NODE_ID
,      LEVEL_ID
,      PRODUCT_NORM_NODE_ID
,      USAGE_WEIGHT1
,      USAGE_WEIGHT2
,      USAGE_WEIGHT3
,      USAGE_WEIGHT4
,      DEFAULT_USAGE_WEIGHT1
,      DEFAULT_USAGE_WEIGHT2
,      DEFAULT_USAGE_WEIGHT3
,      DEFAULT_USAGE_WEIGHT4
,      OVERRIDE_USAGE_WEIGHT1
,      OVERRIDE_USAGE_WEIGHT2
,      OVERRIDE_USAGE_WEIGHT3
,      OVERRIDE_USAGE_WEIGHT4
,      DEFAULT_PRODUCT_NORM_NODE_ID
,      RECOMMENDATION_RULE_ID
,      REPAIR_ASSIGNMENT_SET_ID
,      DEFAULT_REC_RULE_ID
,      OVERRIDE_REC_RULE_ID
,      NOTIFICATION_RULE_ID
,      EXCESS_EDQ_FACTOR
,      REPAIR_EDQ_FACTOR
,      NEWBUY_EDQ_FACTOR
,      EXCESS_SERVICE_LEVEL
,      REPAIR_SERVICE_LEVEL
,      NEWBUY_SERVICE_LEVEL
,      RESCHEDULE_RULE_ID
,      WRP_RULE_ID
FROM CSP.CSP_PLANNING_PARAMETERS;

Dependencies

[top of page]

CSP.CSP_PLANNING_PARAMETERS does not reference any database object

CSP.CSP_PLANNING_PARAMETERS is referenced by following:

APPS

CSP_PLANNING_PARAMETERS

CSP_SUP_DEM_PN_MV

CSP_USAGE_ORG_MV

CSP_USAGE_REG_MV