Product: | CSP - Spares Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSP_PLANNING_PARAMETERS_V |
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. PRODUCT_NORM
, 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. 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. 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.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
, 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 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'