VIEW: APPS.CSP_PLANNING_PARAMETERS_V

Source

View Text - Preformatted

SELECT cpp.rowid row_id, cpp.planning_parameters_id planning_parameters_id, cpp.organization_type, cpp.organization_id organization_id , cpp.forecast_rule_id forecast_rule_id, cfrb.forecast_rule_name forecast_rule_name, cpp.secondary_inventory secondary_inventory, cpp.service_level service_level, cpp.edq_factor edq_factor, cpp.planner_code planner_code, cpp.condition_type condition_type, fl.meaning condition_type_meaning, cpp.asl_flag, cpp.safety_stock_flag, cpp.excess_rule_id, cer.excess_rule_name, cpp.created_by, cpp.creation_date, cpp.last_updated_by, cpp.last_update_date, cpp.last_update_login, cpp. CATEGORY_SET_ID , cpp. CATEGORY_ID , cpp. RECOMMEND_METHOD , FLR. MEANING RECOMMEND_METHOD_MEANING, cpp. EDQ_MULTIPLE , cpp. MINIMUM_VALUE , cpp. USABLE_ASSIGNMENT_SET_ID, cpp. DEFECTIVE_ASSIGNMENT_SET_ID, cpp.REPAIR_ASSIGNMENT_SET_ID, cpp. PRODUCT_NORM , cpp.notification_rule_id, cbrb2.business_rule_name, cpp.recommendation_rule_id, cbrb1.business_rule_name, cpp. DEFAULT_FORECAST_RULE_ID , cpp. DEFAULT_SERVICE_LEVEL , cpp. DEFAULT_EDQ_FACTOR , cpp. DEFAULT_PLANNER_CODE , cpp. DEFAULT_CONDITION_TYPE , cpp. DEFAULT_ASL_FLAG , cpp. DEFAULT_SAFETY_STOCK_FLAG , cpp. DEFAULT_EXCESS_RULE_ID , cpp. DEFAULT_CATEGORY_SET_ID , cpp. DEFAULT_CATEGORY_ID , cpp. DEFAULT_RECOMMEND_METHOD , cpp.default_rec_rule_id, cpp. OVERRIDE_FORECAST_RULE_ID , cpp. OVERRIDE_SERVICE_LEVEL , cpp. OVERRIDE_EDQ_FACTOR , cpp. OVERRIDE_PLANNER_CODE , cpp. OVERRIDE_CONDITION_TYPE , cpp. OVERRIDE_ASL_FLAG , cpp. OVERRIDE_SAFETY_STOCK_FLAG , cpp. OVERRIDE_EXCESS_RULE_ID , cpp. OVERRIDE_CATEGORY_SET_ID , cpp. OVERRIDE_CATEGORY_ID , cpp. OVERRIDE_RECOMMEND_METHOD , cpp.override_rec_rule_id, cpp. NODE_TYPE , cpp. NODE_NAME , cpp. PARENT_NODE_ID , cpp. LEVEL_ID , cpp. PRODUCT_NORM_NODE_ID , cpp. DEFAULT_PRODUCT_NORM_NODE_ID , cpp. USAGE_WEIGHT1 , cpp. USAGE_WEIGHT2 , cpp. USAGE_WEIGHT3 , cpp. USAGE_WEIGHT4 , cpp. DEFAULT_USAGE_WEIGHT1 , cpp. DEFAULT_USAGE_WEIGHT2 , cpp. DEFAULT_USAGE_WEIGHT3 , cpp. DEFAULT_USAGE_WEIGHT4 , cpp. OVERRIDE_USAGE_WEIGHT1 , cpp. OVERRIDE_USAGE_WEIGHT2 , cpp. OVERRIDE_USAGE_WEIGHT3 , cpp. OVERRIDE_USAGE_WEIGHT4 , cpp.excess_service_level, cpp.repair_service_level, cpp.newbuy_service_level, cpp.excess_edq_factor, cpp.repair_edq_factor, cpp.newbuy_edq_factor, cpp.reschedule_rule_id, cbrb3.business_rule_name, cpp.wrp_rule_id, cbrb4.business_rule_name, cpp.attribute_category, cpp.attribute1, cpp.attribute2, cpp.attribute3, cpp.attribute4, cpp.attribute5, cpp.attribute6, cpp.attribute7, cpp.attribute8, cpp.attribute9, cpp.attribute10, cpp.attribute11, cpp.attribute12, cpp.attribute13, cpp.attribute14, cpp.attribute15 from csp_planning_parameters cpp, csp_forecast_rules_b cfrb, csp_excess_rules_b cer, csp_business_rules_b cbrb1, csp_business_rules_b cbrb2, csp_business_rules_b cbrb3, csp_business_rules_b cbrb4, fnd_lookups fl, fnd_lookups flr, csp_sec_inventories csi where cfrb.forecast_rule_id(+) = cpp.forecast_rule_id and cer.excess_rule_id(+) = cpp.excess_rule_id and cbrb1.business_rule_id(+) = cpp.recommendation_rule_id and cbrb1.business_rule_type(+) = 'RECOMMENDATIONS' and cbrb2.business_rule_id(+) = cpp.notification_rule_id and cbrb2.business_rule_type(+) = 'NOTIFICATIONS' and cbrb3.business_rule_id(+) = cpp.RESCHEDULE_RULE_ID and cbrb3.business_rule_type(+) = 'RESCHEDULE' and cbrb4.business_rule_id(+) = cpp.wrp_rule_id and cbrb4.business_rule_type(+) = 'WRP' and csi.secondary_inventory_name(+) = cpp.secondary_inventory and csi.organization_id(+) = cpp.organization_id and fl.lookup_type(+) = 'CSP_CONDITION_TYPE' and fl.lookup_code(+) = cpp.condition_type and fl.enabled_flag(+) = 'Y' and flr.lookup_type(+) = 'CSP_RECOMMENDATION_METHOD' and flr.lookup_code(+) = cpp.recommend_method and flr.enabled_flag(+) = 'Y'

View Text - HTML Formatted

SELECT CPP.ROWID ROW_ID
, CPP.PLANNING_PARAMETERS_ID PLANNING_PARAMETERS_ID
, CPP.ORGANIZATION_TYPE
, CPP.ORGANIZATION_ID ORGANIZATION_ID
, CPP.FORECAST_RULE_ID FORECAST_RULE_ID
, CFRB.FORECAST_RULE_NAME FORECAST_RULE_NAME
, CPP.SECONDARY_INVENTORY SECONDARY_INVENTORY
, CPP.SERVICE_LEVEL SERVICE_LEVEL
, CPP.EDQ_FACTOR EDQ_FACTOR
, CPP.PLANNER_CODE PLANNER_CODE
, CPP.CONDITION_TYPE CONDITION_TYPE
, FL.MEANING CONDITION_TYPE_MEANING
, CPP.ASL_FLAG
, CPP.SAFETY_STOCK_FLAG
, CPP.EXCESS_RULE_ID
, CER.EXCESS_RULE_NAME
, CPP.CREATED_BY
, CPP.CREATION_DATE
, CPP.LAST_UPDATED_BY
, CPP.LAST_UPDATE_DATE
, CPP.LAST_UPDATE_LOGIN
, CPP. CATEGORY_SET_ID
, CPP. CATEGORY_ID
, CPP. RECOMMEND_METHOD
, FLR. MEANING RECOMMEND_METHOD_MEANING
, CPP. EDQ_MULTIPLE
, CPP. MINIMUM_VALUE
, CPP. USABLE_ASSIGNMENT_SET_ID
, CPP. DEFECTIVE_ASSIGNMENT_SET_ID
, CPP.REPAIR_ASSIGNMENT_SET_ID
, CPP. PRODUCT_NORM
, CPP.NOTIFICATION_RULE_ID
, CBRB2.BUSINESS_RULE_NAME
, CPP.RECOMMENDATION_RULE_ID
, CBRB1.BUSINESS_RULE_NAME
, CPP. DEFAULT_FORECAST_RULE_ID
, CPP. DEFAULT_SERVICE_LEVEL
, CPP. DEFAULT_EDQ_FACTOR
, CPP. DEFAULT_PLANNER_CODE
, CPP. DEFAULT_CONDITION_TYPE
, CPP. DEFAULT_ASL_FLAG
, CPP. DEFAULT_SAFETY_STOCK_FLAG
, CPP. DEFAULT_EXCESS_RULE_ID
, CPP. DEFAULT_CATEGORY_SET_ID
, CPP. DEFAULT_CATEGORY_ID
, CPP. DEFAULT_RECOMMEND_METHOD
, CPP.DEFAULT_REC_RULE_ID
, CPP. OVERRIDE_FORECAST_RULE_ID
, CPP. OVERRIDE_SERVICE_LEVEL
, CPP. OVERRIDE_EDQ_FACTOR
, CPP. OVERRIDE_PLANNER_CODE
, CPP. OVERRIDE_CONDITION_TYPE
, CPP. OVERRIDE_ASL_FLAG
, CPP. OVERRIDE_SAFETY_STOCK_FLAG
, CPP. OVERRIDE_EXCESS_RULE_ID
, CPP. OVERRIDE_CATEGORY_SET_ID
, CPP. OVERRIDE_CATEGORY_ID
, CPP. OVERRIDE_RECOMMEND_METHOD
, CPP.OVERRIDE_REC_RULE_ID
, CPP. NODE_TYPE
, CPP. NODE_NAME
, CPP. PARENT_NODE_ID
, CPP. LEVEL_ID
, CPP. PRODUCT_NORM_NODE_ID
, CPP. DEFAULT_PRODUCT_NORM_NODE_ID
, CPP. USAGE_WEIGHT1
, CPP. USAGE_WEIGHT2
, CPP. USAGE_WEIGHT3
, CPP. USAGE_WEIGHT4
, CPP. DEFAULT_USAGE_WEIGHT1
, CPP. DEFAULT_USAGE_WEIGHT2
, CPP. DEFAULT_USAGE_WEIGHT3
, CPP. DEFAULT_USAGE_WEIGHT4
, CPP. OVERRIDE_USAGE_WEIGHT1
, CPP. OVERRIDE_USAGE_WEIGHT2
, CPP. OVERRIDE_USAGE_WEIGHT3
, CPP. OVERRIDE_USAGE_WEIGHT4
, CPP.EXCESS_SERVICE_LEVEL
, CPP.REPAIR_SERVICE_LEVEL
, CPP.NEWBUY_SERVICE_LEVEL
, CPP.EXCESS_EDQ_FACTOR
, CPP.REPAIR_EDQ_FACTOR
, CPP.NEWBUY_EDQ_FACTOR
, CPP.RESCHEDULE_RULE_ID
, CBRB3.BUSINESS_RULE_NAME
, CPP.WRP_RULE_ID
, CBRB4.BUSINESS_RULE_NAME
, CPP.ATTRIBUTE_CATEGORY
, CPP.ATTRIBUTE1
, CPP.ATTRIBUTE2
, CPP.ATTRIBUTE3
, CPP.ATTRIBUTE4
, CPP.ATTRIBUTE5
, CPP.ATTRIBUTE6
, CPP.ATTRIBUTE7
, CPP.ATTRIBUTE8
, CPP.ATTRIBUTE9
, CPP.ATTRIBUTE10
, CPP.ATTRIBUTE11
, CPP.ATTRIBUTE12
, CPP.ATTRIBUTE13
, CPP.ATTRIBUTE14
, CPP.ATTRIBUTE15
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_FORECAST_RULES_B CFRB
, CSP_EXCESS_RULES_B CER
, CSP_BUSINESS_RULES_B CBRB1
, CSP_BUSINESS_RULES_B CBRB2
, CSP_BUSINESS_RULES_B CBRB3
, CSP_BUSINESS_RULES_B CBRB4
, FND_LOOKUPS FL
, FND_LOOKUPS FLR
, CSP_SEC_INVENTORIES CSI
WHERE CFRB.FORECAST_RULE_ID(+) = CPP.FORECAST_RULE_ID
AND CER.EXCESS_RULE_ID(+) = CPP.EXCESS_RULE_ID
AND CBRB1.BUSINESS_RULE_ID(+) = CPP.RECOMMENDATION_RULE_ID
AND CBRB1.BUSINESS_RULE_TYPE(+) = 'RECOMMENDATIONS'
AND CBRB2.BUSINESS_RULE_ID(+) = CPP.NOTIFICATION_RULE_ID
AND CBRB2.BUSINESS_RULE_TYPE(+) = 'NOTIFICATIONS'
AND CBRB3.BUSINESS_RULE_ID(+) = CPP.RESCHEDULE_RULE_ID
AND CBRB3.BUSINESS_RULE_TYPE(+) = 'RESCHEDULE'
AND CBRB4.BUSINESS_RULE_ID(+) = CPP.WRP_RULE_ID
AND CBRB4.BUSINESS_RULE_TYPE(+) = 'WRP'
AND CSI.SECONDARY_INVENTORY_NAME(+) = CPP.SECONDARY_INVENTORY
AND CSI.ORGANIZATION_ID(+) = CPP.ORGANIZATION_ID
AND FL.LOOKUP_TYPE(+) = 'CSP_CONDITION_TYPE'
AND FL.LOOKUP_CODE(+) = CPP.CONDITION_TYPE
AND FL.ENABLED_FLAG(+) = 'Y'
AND FLR.LOOKUP_TYPE(+) = 'CSP_RECOMMENDATION_METHOD'
AND FLR.LOOKUP_CODE(+) = CPP.RECOMMEND_METHOD
AND FLR.ENABLED_FLAG(+) = 'Y'