eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: CSP.CSP_PLANNING_PARAMETERS#

Object Details

Object Name:	CSP_PLANNING_PARAMETERS#
Object Type:	VIEW
Owner:	CSP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PLANNING_PARAMETERS_ID	NUMBER	(35)	Yes
CREATED_BY	NUMBER	(35)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(35)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(35)
FORECAST_RULE_ID	NUMBER	(35)
CALCULATION_RULE_ID	NUMBER	(35)
ORGANIZATION_TYPE	VARCHAR2	(30)
ORGANIZATION_ID	NUMBER	(35)
SECONDARY_INVENTORY	VARCHAR2	(10)
SERVICE_LEVEL	NUMBER
EDQ_FACTOR	NUMBER
PLANNER_CODE	VARCHAR2	(10)
CONDITION_TYPE	VARCHAR2	(30)
ASL_FLAG	VARCHAR2	(1)
SAFETY_STOCK_FLAG	VARCHAR2	(1)
EXCESS_RULE_ID	NUMBER	(35)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
SECURITY_GROUP_ID	NUMBER	(35)
CATEGORY_SET_ID	NUMBER	(35)
CATEGORY_ID	NUMBER	(35)
RECOMMEND_METHOD	VARCHAR2	(80)
EDQ_MULTIPLE	NUMBER	(35)
MINIMUM_VALUE	NUMBER	(35)
USABLE_ASSIGNMENT_SET_ID	NUMBER
DEFECTIVE_ASSIGNMENT_SET_ID	NUMBER
PRODUCT_NORM	VARCHAR2	(150)
DEFAULT_FORECAST_RULE_ID	VARCHAR2	(200)
DEFAULT_SERVICE_LEVEL	VARCHAR2	(200)
DEFAULT_EDQ_FACTOR	VARCHAR2	(200)
DEFAULT_PLANNER_CODE	VARCHAR2	(200)
DEFAULT_CONDITION_TYPE	VARCHAR2	(200)
DEFAULT_ASL_FLAG	VARCHAR2	(200)
DEFAULT_SAFETY_STOCK_FLAG	VARCHAR2	(200)
DEFAULT_EXCESS_RULE_ID	VARCHAR2	(200)
DEFAULT_CATEGORY_SET_ID	VARCHAR2	(200)
DEFAULT_CATEGORY_ID	VARCHAR2	(200)
DEFAULT_RECOMMEND_METHOD	VARCHAR2	(200)
OVERRIDE_FORECAST_RULE_ID	VARCHAR2	(5)
OVERRIDE_SERVICE_LEVEL	VARCHAR2	(5)
OVERRIDE_EDQ_FACTOR	VARCHAR2	(5)
OVERRIDE_PLANNER_CODE	VARCHAR2	(5)
OVERRIDE_CONDITION_TYPE	VARCHAR2	(5)
OVERRIDE_ASL_FLAG	VARCHAR2	(5)
OVERRIDE_SAFETY_STOCK_FLAG	VARCHAR2	(5)
OVERRIDE_EXCESS_RULE_ID	VARCHAR2	(5)
OVERRIDE_CATEGORY_SET_ID	VARCHAR2	(5)
OVERRIDE_CATEGORY_ID	VARCHAR2	(5)
OVERRIDE_RECOMMEND_METHOD	VARCHAR2	(5)
NODE_TYPE	VARCHAR2	(30)
NODE_NAME	VARCHAR2	(50)
PARENT_NODE_ID	NUMBER	(35)
LEVEL_ID	VARCHAR2	(200)	Yes
PRODUCT_NORM_NODE_ID	NUMBER
USAGE_WEIGHT1	NUMBER
USAGE_WEIGHT2	NUMBER
USAGE_WEIGHT3	NUMBER
USAGE_WEIGHT4	NUMBER
DEFAULT_USAGE_WEIGHT1	VARCHAR2	(200)
DEFAULT_USAGE_WEIGHT2	VARCHAR2	(200)
DEFAULT_USAGE_WEIGHT3	VARCHAR2	(200)
DEFAULT_USAGE_WEIGHT4	VARCHAR2	(200)
OVERRIDE_USAGE_WEIGHT1	VARCHAR2	(5)
OVERRIDE_USAGE_WEIGHT2	VARCHAR2	(5)
OVERRIDE_USAGE_WEIGHT3	VARCHAR2	(5)
OVERRIDE_USAGE_WEIGHT4	VARCHAR2	(5)
DEFAULT_PRODUCT_NORM_NODE_ID	VARCHAR2	(200)
RECOMMENDATION_RULE_ID	NUMBER	(38)
REPAIR_ASSIGNMENT_SET_ID	NUMBER
DEFAULT_REC_RULE_ID	VARCHAR2	(240)
OVERRIDE_REC_RULE_ID	VARCHAR2	(10)
NOTIFICATION_RULE_ID	NUMBER	(38)
EXCESS_EDQ_FACTOR	VARCHAR2	(240)
REPAIR_EDQ_FACTOR	VARCHAR2	(240)
NEWBUY_EDQ_FACTOR	VARCHAR2	(240)
EXCESS_SERVICE_LEVEL	VARCHAR2	(240)
REPAIR_SERVICE_LEVEL	VARCHAR2	(240)
NEWBUY_SERVICE_LEVEL	VARCHAR2	(240)
RESCHEDULE_RULE_ID	NUMBER
WRP_RULE_ID	NUMBER	(38)
STOCKING_SITE_TYPE	VARCHAR2	(30)
CALENDAR_ID	NUMBER	(38)
TIMEZONE_ID	NUMBER	(38)
CONTACT_NAME	VARCHAR2	(150)
CONTACT_PHONE	VARCHAR2	(30)
AH_CONTACT_NAME	VARCHAR2	(150)
AH_CONTACT_PHONE	VARCHAR2	(30)
STOCKING_SITE_EXCL	VARCHAR2	(3)
SPECIAL_INSTRUCTIONS	VARCHAR2	(1996)
MANAGED_BY	VARCHAR2	(30)
HZ_LOCATION_ID	NUMBER	(38)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      STOCKING_SITE_TYPE
,      CALENDAR_ID
,      TIMEZONE_ID
,      CONTACT_NAME
,      CONTACT_PHONE
,      AH_CONTACT_NAME
,      AH_CONTACT_PHONE
,      STOCKING_SITE_EXCL
,      SPECIAL_INSTRUCTIONS
,      MANAGED_BY
,      HZ_LOCATION_ID
,      ZD_EDITION_NAME
FROM CSP.CSP_PLANNING_PARAMETERS#;

Dependencies

[top of page]

CSP.CSP_PLANNING_PARAMETERS# references the following:

CSP: CSP_PLANNING_PARAMETERS

CSP.CSP_PLANNING_PARAMETERS# is referenced by following:

APPS: CSP_PLANNING_PARAMETERS; CSP_PLANNING_PARAMETERS+