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.

VIEW: APPS.CSP_PLANNING_PARAMS_DETAILS_V

Source

View Text - Preformatted


SELECT CspPlanningParametersEO.AH_CONTACT_NAME, CspPlanningParametersEO.AH_CONTACT_PHONE, CspPlanningParametersEO.ASL_FLAG, CspPlanningParametersEO.ATTRIBUTE1, CspPlanningParametersEO.ATTRIBUTE10, CspPlanningParametersEO.ATTRIBUTE11, CspPlanningParametersEO.ATTRIBUTE12, CspPlanningParametersEO.ATTRIBUTE13, CspPlanningParametersEO.ATTRIBUTE14, CspPlanningParametersEO.ATTRIBUTE15, CspPlanningParametersEO.ATTRIBUTE2, CspPlanningParametersEO.ATTRIBUTE3, CspPlanningParametersEO.ATTRIBUTE4, CspPlanningParametersEO.ATTRIBUTE5, CspPlanningParametersEO.ATTRIBUTE6, CspPlanningParametersEO.ATTRIBUTE7, CspPlanningParametersEO.ATTRIBUTE8, CspPlanningParametersEO.ATTRIBUTE9, CspPlanningParametersEO.ATTRIBUTE_CATEGORY, CspPlanningParametersEO.CALCULATION_RULE_ID, CspPlanningParametersEO.CALENDAR_ID, CspPlanningParametersEO.CATEGORY_ID, CspPlanningParametersEO.CATEGORY_SET_ID, CspPlanningParametersEO.CONDITION_TYPE, CspPlanningParametersEO.CONTACT_NAME, CspPlanningParametersEO.CONTACT_PHONE, CspPlanningParametersEO.CREATED_BY, CspPlanningParametersEO.CREATION_DATE, CspPlanningParametersEO.DEFAULT_ASL_FLAG, CspPlanningParametersEO.DEFAULT_CATEGORY_ID, CspPlanningParametersEO.DEFAULT_CATEGORY_SET_ID, CspPlanningParametersEO.DEFAULT_CONDITION_TYPE, CspPlanningParametersEO.DEFAULT_EDQ_FACTOR, CspPlanningParametersEO.DEFAULT_EXCESS_RULE_ID, CspPlanningParametersEO.DEFAULT_FORECAST_RULE_ID, CspPlanningParametersEO.DEFAULT_PLANNER_CODE, CspPlanningParametersEO.DEFAULT_PRODUCT_NORM_NODE_ID, CspPlanningParametersEO.DEFAULT_REC_RULE_ID, CspPlanningParametersEO.DEFAULT_RECOMMEND_METHOD, CspPlanningParametersEO.DEFAULT_SAFETY_STOCK_FLAG, CspPlanningParametersEO.DEFAULT_SERVICE_LEVEL, CspPlanningParametersEO.DEFAULT_USAGE_WEIGHT1, CspPlanningParametersEO.DEFAULT_USAGE_WEIGHT2, CspPlanningParametersEO.DEFAULT_USAGE_WEIGHT3, CspPlanningParametersEO.DEFAULT_USAGE_WEIGHT4, CspPlanningParametersEO.DEFECTIVE_ASSIGNMENT_SET_ID, CspPlanningParametersEO.EDQ_FACTOR, CspPlanningParametersEO.EDQ_MULTIPLE, CspPlanningParametersEO.EXCESS_EDQ_FACTOR, CspPlanningParametersEO.EXCESS_RULE_ID, CspPlanningParametersEO.EXCESS_SERVICE_LEVEL, CspPlanningParametersEO.FORECAST_RULE_ID, CspPlanningParametersEO.HZ_LOCATION_ID, CspPlanningParametersEO.LAST_UPDATE_DATE, CspPlanningParametersEO.LAST_UPDATE_LOGIN, CspPlanningParametersEO.LAST_UPDATED_BY, CspPlanningParametersEO.LEVEL_ID, CspPlanningParametersEO.MANAGED_BY, CspPlanningParametersEO.MINIMUM_VALUE, CspPlanningParametersEO.NEWBUY_EDQ_FACTOR, CspPlanningParametersEO.NEWBUY_SERVICE_LEVEL, CspPlanningParametersEO.NODE_NAME, CspPlanningParametersEO.NODE_TYPE, CspPlanningParametersEO.NOTIFICATION_RULE_ID, CspPlanningParametersEO.ORGANIZATION_ID, CspPlanningParametersEO.ORGANIZATION_TYPE, NVL(CspPlanningParametersEO.OVERRIDE_ASL_FLAG,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_CATEGORY_ID,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_CATEGORY_SET_ID,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_CONDITION_TYPE,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_EDQ_FACTOR,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_EXCESS_RULE_ID,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_FORECAST_RULE_ID,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_PLANNER_CODE,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_REC_RULE_ID,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_RECOMMEND_METHOD,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_SAFETY_STOCK_FLAG,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_SERVICE_LEVEL,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_USAGE_WEIGHT1,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_USAGE_WEIGHT2,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_USAGE_WEIGHT3,'Y'), NVL(CspPlanningParametersEO.OVERRIDE_USAGE_WEIGHT4,'Y'), CspPlanningParametersEO.PARENT_NODE_ID, CspPlanningParametersEO.PLANNER_CODE, CspPlanningParametersEO.PLANNING_PARAMETERS_ID, CspPlanningParametersEO.PRODUCT_NORM, CspPlanningParametersEO.PRODUCT_NORM_NODE_ID, CspPlanningParametersEO.RECOMMEND_METHOD, CspPlanningParametersEO.RECOMMENDATION_RULE_ID, CspPlanningParametersEO.REPAIR_ASSIGNMENT_SET_ID, CspPlanningParametersEO.REPAIR_EDQ_FACTOR, CspPlanningParametersEO.REPAIR_SERVICE_LEVEL, CspPlanningParametersEO.RESCHEDULE_RULE_ID, CspPlanningParametersEO.SAFETY_STOCK_FLAG, CspPlanningParametersEO.SECONDARY_INVENTORY, CspPlanningParametersEO.SECONDARY_INVENTORY SECONDARY_INVENTORY_NAME, CspPlanningParametersEO.SECURITY_GROUP_ID, CspPlanningParametersEO.SERVICE_LEVEL, CspPlanningParametersEO.SPECIAL_INSTRUCTIONS, CspPlanningParametersEO.STOCKING_SITE_EXCL, CspPlanningParametersEO.STOCKING_SITE_TYPE, CspPlanningParametersEO.TIMEZONE_ID, CspPlanningParametersEO.USABLE_ASSIGNMENT_SET_ID, CspPlanningParametersEO.USAGE_WEIGHT1, CspPlanningParametersEO.USAGE_WEIGHT2, CspPlanningParametersEO.USAGE_WEIGHT3, CspPlanningParametersEO.USAGE_WEIGHT4, CspPlanningParametersEO.WRP_RULE_ID, csi.autoreceipt_flag, fl.meaning condition_type_meaning, cer.excess_rule_name, FLR.MEANING RECOMMEND_METHOD_MEANING, cfrb.forecast_rule_name forecast_rule_name, cbrb2.business_rule_name notification_rule_name, cbrb1.business_rule_name recommendation_rule_name, cbrb3.business_rule_name reschedule_rule_name, cbrb4.business_rule_name wrp_rule_name, fls.meaning stocking_site_type_meaning, jcal.calendar_name, hzt.name time_zone_name, flm.meaning managed_by_meaning, SYSDATE Curr_Sys_Date, ood.organization_name organization_name, hz_format_pub.format_address(CspPlanningParametersEO.hz_location_id,null,null,',') geo_coded_address, 'QUERY' VOOperationCode, csf_util_pvt.get_object_name(csi.owner_resource_type,csi.owner_resource_id) owner, NVL(CspPlanningParametersEO.organization_id,-1) orgIdDup, NVL(CspPlanningParametersEO.secondary_inventory,'-') subinvDup, ood.organization_code organization_code,fln.meaning Node_type_name FROM CSP_PLANNING_PARAMETERS CspPlanningParametersEO, 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, fnd_lookups fls, fnd_lookups flm, fnd_lookups fln, csp_sec_inventories csi, jtf_calendars_vl jcal, hz_timezones_vl hzt, org_organization_definitions ood WHERE cfrb.forecast_rule_id(+) = CspPlanningParametersEO.forecast_rule_id AND cer.excess_rule_id(+) = CspPlanningParametersEO.excess_rule_id AND cbrb1.business_rule_id(+) = CspPlanningParametersEO.recommendation_rule_id AND cbrb1.business_rule_type(+) = 'RECOMMENDATIONS' AND cbrb2.business_rule_id(+) = CspPlanningParametersEO.notification_rule_id AND cbrb2.business_rule_type(+) = 'NOTIFICATIONS' AND cbrb3.business_rule_id(+) = CspPlanningParametersEO.RESCHEDULE_RULE_ID AND cbrb3.business_rule_type(+) = 'RESCHEDULE' AND cbrb4.business_rule_id(+) = CspPlanningParametersEO.wrp_rule_id AND cbrb4.business_rule_type(+) = 'WRP' AND csi.secondary_inventory_name(+) = CspPlanningParametersEO.secondary_inventory AND csi.organization_id(+) = CspPlanningParametersEO.organization_id AND fl.lookup_type(+) = 'CSP_CONDITION_TYPE' AND fl.lookup_code(+) = CspPlanningParametersEO.condition_type AND fl.enabled_flag(+) = 'Y' AND flr.lookup_type(+) = 'CSP_RECOMMENDATION_METHOD' AND flr.lookup_code(+) = CspPlanningParametersEO.recommend_method AND flr.enabled_flag(+) = 'Y' AND fls.lookup_type(+) = 'CSP_STOCKING_SITE_TYPE' AND fls.lookup_code(+) = CspPlanningParametersEO.stocking_site_type AND fls.enabled_flag(+) = 'Y' AND flm.lookup_type(+) = 'CSP_MANAGED_BY' AND flm.lookup_code(+) = CspPlanningParametersEO.managed_by AND flm.enabled_flag(+) = 'Y' and FLN.LOOKUP_TYPE(+) = 'CSP_PLANNING_NODE_TYPE' and FLN.LOOKUP_CODE(+) = CSPPLANNINGPARAMETERSEO.NODE_TYPE and FLN.ENABLED_FLAG(+) = 'Y' AND jcal.calendar_id(+) = CspPlanningParametersEO.calendar_id AND hzt.timezone_id(+) = CspPlanningParametersEO.timezone_id AND ood.organization_id(+) = CspPlanningParametersEO.organization_id

View Text - HTML Formatted

SELECT CSPPLANNINGPARAMETERSEO.AH_CONTACT_NAME
, CSPPLANNINGPARAMETERSEO.AH_CONTACT_PHONE
, CSPPLANNINGPARAMETERSEO.ASL_FLAG
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE1
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE10
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE11
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE12
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE13
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE14
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE15
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE2
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE3
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE4
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE5
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE6
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE7
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE8
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE9
, CSPPLANNINGPARAMETERSEO.ATTRIBUTE_CATEGORY
, CSPPLANNINGPARAMETERSEO.CALCULATION_RULE_ID
, CSPPLANNINGPARAMETERSEO.CALENDAR_ID
, CSPPLANNINGPARAMETERSEO.CATEGORY_ID
, CSPPLANNINGPARAMETERSEO.CATEGORY_SET_ID
, CSPPLANNINGPARAMETERSEO.CONDITION_TYPE
, CSPPLANNINGPARAMETERSEO.CONTACT_NAME
, CSPPLANNINGPARAMETERSEO.CONTACT_PHONE
, CSPPLANNINGPARAMETERSEO.CREATED_BY
, CSPPLANNINGPARAMETERSEO.CREATION_DATE
, CSPPLANNINGPARAMETERSEO.DEFAULT_ASL_FLAG
, CSPPLANNINGPARAMETERSEO.DEFAULT_CATEGORY_ID
, CSPPLANNINGPARAMETERSEO.DEFAULT_CATEGORY_SET_ID
, CSPPLANNINGPARAMETERSEO.DEFAULT_CONDITION_TYPE
, CSPPLANNINGPARAMETERSEO.DEFAULT_EDQ_FACTOR
, CSPPLANNINGPARAMETERSEO.DEFAULT_EXCESS_RULE_ID
, CSPPLANNINGPARAMETERSEO.DEFAULT_FORECAST_RULE_ID
, CSPPLANNINGPARAMETERSEO.DEFAULT_PLANNER_CODE
, CSPPLANNINGPARAMETERSEO.DEFAULT_PRODUCT_NORM_NODE_ID
, CSPPLANNINGPARAMETERSEO.DEFAULT_REC_RULE_ID
, CSPPLANNINGPARAMETERSEO.DEFAULT_RECOMMEND_METHOD
, CSPPLANNINGPARAMETERSEO.DEFAULT_SAFETY_STOCK_FLAG
, CSPPLANNINGPARAMETERSEO.DEFAULT_SERVICE_LEVEL
, CSPPLANNINGPARAMETERSEO.DEFAULT_USAGE_WEIGHT1
, CSPPLANNINGPARAMETERSEO.DEFAULT_USAGE_WEIGHT2
, CSPPLANNINGPARAMETERSEO.DEFAULT_USAGE_WEIGHT3
, CSPPLANNINGPARAMETERSEO.DEFAULT_USAGE_WEIGHT4
, CSPPLANNINGPARAMETERSEO.DEFECTIVE_ASSIGNMENT_SET_ID
, CSPPLANNINGPARAMETERSEO.EDQ_FACTOR
, CSPPLANNINGPARAMETERSEO.EDQ_MULTIPLE
, CSPPLANNINGPARAMETERSEO.EXCESS_EDQ_FACTOR
, CSPPLANNINGPARAMETERSEO.EXCESS_RULE_ID
, CSPPLANNINGPARAMETERSEO.EXCESS_SERVICE_LEVEL
, CSPPLANNINGPARAMETERSEO.FORECAST_RULE_ID
, CSPPLANNINGPARAMETERSEO.HZ_LOCATION_ID
, CSPPLANNINGPARAMETERSEO.LAST_UPDATE_DATE
, CSPPLANNINGPARAMETERSEO.LAST_UPDATE_LOGIN
, CSPPLANNINGPARAMETERSEO.LAST_UPDATED_BY
, CSPPLANNINGPARAMETERSEO.LEVEL_ID
, CSPPLANNINGPARAMETERSEO.MANAGED_BY
, CSPPLANNINGPARAMETERSEO.MINIMUM_VALUE
, CSPPLANNINGPARAMETERSEO.NEWBUY_EDQ_FACTOR
, CSPPLANNINGPARAMETERSEO.NEWBUY_SERVICE_LEVEL
, CSPPLANNINGPARAMETERSEO.NODE_NAME
, CSPPLANNINGPARAMETERSEO.NODE_TYPE
, CSPPLANNINGPARAMETERSEO.NOTIFICATION_RULE_ID
, CSPPLANNINGPARAMETERSEO.ORGANIZATION_ID
, CSPPLANNINGPARAMETERSEO.ORGANIZATION_TYPE
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_ASL_FLAG
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_CATEGORY_ID
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_CATEGORY_SET_ID
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_CONDITION_TYPE
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_EDQ_FACTOR
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_EXCESS_RULE_ID
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_FORECAST_RULE_ID
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_PLANNER_CODE
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_REC_RULE_ID
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_RECOMMEND_METHOD
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_SAFETY_STOCK_FLAG
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_SERVICE_LEVEL
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_USAGE_WEIGHT1
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_USAGE_WEIGHT2
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_USAGE_WEIGHT3
, 'Y')
, NVL(CSPPLANNINGPARAMETERSEO.OVERRIDE_USAGE_WEIGHT4
, 'Y')
, CSPPLANNINGPARAMETERSEO.PARENT_NODE_ID
, CSPPLANNINGPARAMETERSEO.PLANNER_CODE
, CSPPLANNINGPARAMETERSEO.PLANNING_PARAMETERS_ID
, CSPPLANNINGPARAMETERSEO.PRODUCT_NORM
, CSPPLANNINGPARAMETERSEO.PRODUCT_NORM_NODE_ID
, CSPPLANNINGPARAMETERSEO.RECOMMEND_METHOD
, CSPPLANNINGPARAMETERSEO.RECOMMENDATION_RULE_ID
, CSPPLANNINGPARAMETERSEO.REPAIR_ASSIGNMENT_SET_ID
, CSPPLANNINGPARAMETERSEO.REPAIR_EDQ_FACTOR
, CSPPLANNINGPARAMETERSEO.REPAIR_SERVICE_LEVEL
, CSPPLANNINGPARAMETERSEO.RESCHEDULE_RULE_ID
, CSPPLANNINGPARAMETERSEO.SAFETY_STOCK_FLAG
, CSPPLANNINGPARAMETERSEO.SECONDARY_INVENTORY
, CSPPLANNINGPARAMETERSEO.SECONDARY_INVENTORY SECONDARY_INVENTORY_NAME
, CSPPLANNINGPARAMETERSEO.SECURITY_GROUP_ID
, CSPPLANNINGPARAMETERSEO.SERVICE_LEVEL
, CSPPLANNINGPARAMETERSEO.SPECIAL_INSTRUCTIONS
, CSPPLANNINGPARAMETERSEO.STOCKING_SITE_EXCL
, CSPPLANNINGPARAMETERSEO.STOCKING_SITE_TYPE
, CSPPLANNINGPARAMETERSEO.TIMEZONE_ID
, CSPPLANNINGPARAMETERSEO.USABLE_ASSIGNMENT_SET_ID
, CSPPLANNINGPARAMETERSEO.USAGE_WEIGHT1
, CSPPLANNINGPARAMETERSEO.USAGE_WEIGHT2
, CSPPLANNINGPARAMETERSEO.USAGE_WEIGHT3
, CSPPLANNINGPARAMETERSEO.USAGE_WEIGHT4
, CSPPLANNINGPARAMETERSEO.WRP_RULE_ID
, CSI.AUTORECEIPT_FLAG
, FL.MEANING CONDITION_TYPE_MEANING
, CER.EXCESS_RULE_NAME
, FLR.MEANING RECOMMEND_METHOD_MEANING
, CFRB.FORECAST_RULE_NAME FORECAST_RULE_NAME
, CBRB2.BUSINESS_RULE_NAME NOTIFICATION_RULE_NAME
, CBRB1.BUSINESS_RULE_NAME RECOMMENDATION_RULE_NAME
, CBRB3.BUSINESS_RULE_NAME RESCHEDULE_RULE_NAME
, CBRB4.BUSINESS_RULE_NAME WRP_RULE_NAME
, FLS.MEANING STOCKING_SITE_TYPE_MEANING
, JCAL.CALENDAR_NAME
, HZT.NAME TIME_ZONE_NAME
, FLM.MEANING MANAGED_BY_MEANING
, SYSDATE CURR_SYS_DATE
, OOD.ORGANIZATION_NAME ORGANIZATION_NAME
, HZ_FORMAT_PUB.FORMAT_ADDRESS(CSPPLANNINGPARAMETERSEO.HZ_LOCATION_ID
, NULL
, NULL
, '
, ') GEO_CODED_ADDRESS
, 'QUERY' VOOPERATIONCODE
, CSF_UTIL_PVT.GET_OBJECT_NAME(CSI.OWNER_RESOURCE_TYPE
, CSI.OWNER_RESOURCE_ID) OWNER
, NVL(CSPPLANNINGPARAMETERSEO.ORGANIZATION_ID
, -1) ORGIDDUP
, NVL(CSPPLANNINGPARAMETERSEO.SECONDARY_INVENTORY
, '-') SUBINVDUP
, OOD.ORGANIZATION_CODE ORGANIZATION_CODE
, FLN.MEANING NODE_TYPE_NAME
FROM CSP_PLANNING_PARAMETERS CSPPLANNINGPARAMETERSEO
, 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
, FND_LOOKUPS FLS
, FND_LOOKUPS FLM
, FND_LOOKUPS FLN
, CSP_SEC_INVENTORIES CSI
, JTF_CALENDARS_VL JCAL
, HZ_TIMEZONES_VL HZT
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE CFRB.FORECAST_RULE_ID(+) = CSPPLANNINGPARAMETERSEO.FORECAST_RULE_ID
AND CER.EXCESS_RULE_ID(+) = CSPPLANNINGPARAMETERSEO.EXCESS_RULE_ID
AND CBRB1.BUSINESS_RULE_ID(+) = CSPPLANNINGPARAMETERSEO.RECOMMENDATION_RULE_ID
AND CBRB1.BUSINESS_RULE_TYPE(+) = 'RECOMMENDATIONS'
AND CBRB2.BUSINESS_RULE_ID(+) = CSPPLANNINGPARAMETERSEO.NOTIFICATION_RULE_ID
AND CBRB2.BUSINESS_RULE_TYPE(+) = 'NOTIFICATIONS'
AND CBRB3.BUSINESS_RULE_ID(+) = CSPPLANNINGPARAMETERSEO.RESCHEDULE_RULE_ID
AND CBRB3.BUSINESS_RULE_TYPE(+) = 'RESCHEDULE'
AND CBRB4.BUSINESS_RULE_ID(+) = CSPPLANNINGPARAMETERSEO.WRP_RULE_ID
AND CBRB4.BUSINESS_RULE_TYPE(+) = 'WRP'
AND CSI.SECONDARY_INVENTORY_NAME(+) = CSPPLANNINGPARAMETERSEO.SECONDARY_INVENTORY
AND CSI.ORGANIZATION_ID(+) = CSPPLANNINGPARAMETERSEO.ORGANIZATION_ID
AND FL.LOOKUP_TYPE(+) = 'CSP_CONDITION_TYPE'
AND FL.LOOKUP_CODE(+) = CSPPLANNINGPARAMETERSEO.CONDITION_TYPE
AND FL.ENABLED_FLAG(+) = 'Y'
AND FLR.LOOKUP_TYPE(+) = 'CSP_RECOMMENDATION_METHOD'
AND FLR.LOOKUP_CODE(+) = CSPPLANNINGPARAMETERSEO.RECOMMEND_METHOD
AND FLR.ENABLED_FLAG(+) = 'Y'
AND FLS.LOOKUP_TYPE(+) = 'CSP_STOCKING_SITE_TYPE'
AND FLS.LOOKUP_CODE(+) = CSPPLANNINGPARAMETERSEO.STOCKING_SITE_TYPE
AND FLS.ENABLED_FLAG(+) = 'Y'
AND FLM.LOOKUP_TYPE(+) = 'CSP_MANAGED_BY'
AND FLM.LOOKUP_CODE(+) = CSPPLANNINGPARAMETERSEO.MANAGED_BY
AND FLM.ENABLED_FLAG(+) = 'Y'
AND FLN.LOOKUP_TYPE(+) = 'CSP_PLANNING_NODE_TYPE'
AND FLN.LOOKUP_CODE(+) = CSPPLANNINGPARAMETERSEO.NODE_TYPE
AND FLN.ENABLED_FLAG(+) = 'Y'
AND JCAL.CALENDAR_ID(+) = CSPPLANNINGPARAMETERSEO.CALENDAR_ID
AND HZT.TIMEZONE_ID(+) = CSPPLANNINGPARAMETERSEO.TIMEZONE_ID
AND OOD.ORGANIZATION_ID(+) = CSPPLANNINGPARAMETERSEO.ORGANIZATION_ID