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 Comments
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:

SchemaCSP
TableCSP_PLANNING_PARAMETERS
CSP.CSP_PLANNING_PARAMETERS# is referenced by following:

SchemaAPPS
SynonymCSP_PLANNING_PARAMETERS
TriggerCSP_PLANNING_PARAMETERS+