[Home] [Help] [Dependency Information]

VIEW: APPS.CSP_PLANNING_PARAMETERS_V

Object Details

Object Name:	CSP_PLANNING_PARAMETERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSP.CSP_PLANNING_PARAMETERS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      PLANNING_PARAMETERS_ID
,      ORGANIZATION_TYPE
,      ORGANIZATION_ID
,      FORECAST_RULE_ID
,      FORECAST_RULE_NAME
,      SECONDARY_INVENTORY
,      SERVICE_LEVEL
,      EDQ_FACTOR
,      PLANNER_CODE
,      CONDITION_TYPE
,      CONDITION_TYPE_MEANING
,      ASL_FLAG
,      SAFETY_STOCK_FLAG
,      EXCESS_RULE_ID
,      EXCESS_RULE_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CATEGORY_SET_ID
,      CATEGORY_ID
,      RECOMMEND_METHOD
,      RECOMMEND_METHOD_MEANING
,      EDQ_MULTIPLE
,      MINIMUM_VALUE
,      USABLE_ASSIGNMENT_SET_ID
,      DEFECTIVE_ASSIGNMENT_SET_ID
,      REPAIR_ASSIGNMENT_SET_ID
,      PRODUCT_NORM
,      NOTIFICATION_RULE_ID
,      NOTIFICATION_RULE_NAME
,      RECOMMENDATION_RULE_ID
,      RECOMMENDATION_RULE_NAME
,      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
,      DEFAULT_REC_RULE_ID
,      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
,      OVERRIDE_REC_RULE_ID
,      NODE_TYPE
,      NODE_NAME
,      PARENT_NODE_ID
,      LEVEL_ID
,      PRODUCT_NORM_NODE_ID
,      DEFAULT_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
,      EXCESS_SERVICE_LEVEL
,      REPAIR_SERVICE_LEVEL
,      NEWBUY_SERVICE_LEVEL
,      EXCESS_EDQ_FACTOR
,      REPAIR_EDQ_FACTOR
,      NEWBUY_EDQ_FACTOR
,      RESCHEDULE_RULE_ID
,      RESCHEDULE_RULE_NAME
,      WRP_RULE_ID
,      WRP_RULE_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      STOCKING_SITE_TYPE
,      STOCKING_SITE_TYPE_MEANING
,      CALENDAR_ID
,      CALENDAR_NAME
,      TIMEZONE_ID
,      TIMEZONE_NAME
,      MANAGED_BY
,      MANAGED_BY_MEANING
,      CONTACT_NAME
,      CONTACT_PHONE
,      AH_CONTACT_NAME
,      AH_CONTACT_PHONE
,      STOCKING_SITE_EXCL
,      AUTORECEIPT_FLAG
,      SPECIAL_INSTRUCTIONS
,      HZ_LOCATION_ID
FROM APPS.CSP_PLANNING_PARAMETERS_V;

Dependencies

[top of page]

APPS

CSP_BUSINESS_RULES_B

CSP_EXCESS_RULES_B

CSP_FORECAST_RULES_B

CSP_PLANNING_PARAMETERS

CSP_SEC_INVENTORIES

FND_GLOBAL - show dependent code

FND_LOOKUPS

HR_GENERAL - show dependent code

HR_SECURITY - show dependent code

HZ_TIMEZONES_VL

JTF_CALENDARS_VL

ORG_ORGANIZATION_DEFINITIONS

APPS.CSP_PLANNING_PARAMETERS_V is not referenced by any database object