VIEW: APPS.MSC_EXCEP_THRESHOLDS_V

Source

View Text - Preformatted

SELECT e1.rowid ROW_ID, m1.meaning EXCEPTION_GROUP, m2.meaning EXCEPTION_TYPE, f1.meaning MEASURE, e1.CRITERIA MEASURE_CODE, e1.field_type field_type, e1.LOV_TYPE LOV_TYPE, e1.number_type, e1.threshold_value THRESHOLD, ( case when e1.CRITERIA like '%ITEM_SEGMENT%' then msc_get_name.item_name(to_number(e1.threshold_value)) WHEN CRITERIA like '%ORGANIZATION%' then msc_get_name.org_code(e1.threshold_value) ELSE e1.threshold_value end) THRESHOLD_DISPLAY, e1.threshold_value_uom UOM, e1.CREATED_BY , e1.CREATION_DATE , e1.LAST_UPDATE_DATE, e1.LAST_UPDATED_BY, e1.LAST_UPDATE_LOGIN from mfg_lookups m1, mfg_lookups m2, fnd_lookups f1, MSC_EXCEP_THRESHOLDS e1, MSC_PLAN_EXCP_TYPES e2 WHERE m1.lookup_code = e1.EXCEPTION_GROUP and m1.lookup_type = 'MSC_EXCEPTION_GROUP' and m2.lookup_code = e1.EXCEPTION_TYPE and m2.lookup_type = 'MRP_EXCEPTION_CODE_TYPE' and e2.EXCP_TYPE = m2.lookup_code AND e2.in_srp_plan = 1 AND f1.lookup_code = e1.CRITERIA and f1.lookup_type = 'MSC_PQ_EXCP'

View Text - HTML Formatted

SELECT E1.ROWID ROW_ID
, M1.MEANING EXCEPTION_GROUP
, M2.MEANING EXCEPTION_TYPE
, F1.MEANING MEASURE
, E1.CRITERIA MEASURE_CODE
, E1.FIELD_TYPE FIELD_TYPE
, E1.LOV_TYPE LOV_TYPE
, E1.NUMBER_TYPE
, E1.THRESHOLD_VALUE THRESHOLD
, ( CASE WHEN E1.CRITERIA LIKE '%ITEM_SEGMENT%' THEN MSC_GET_NAME.ITEM_NAME(TO_NUMBER(E1.THRESHOLD_VALUE)) WHEN CRITERIA LIKE '%ORGANIZATION%' THEN MSC_GET_NAME.ORG_CODE(E1.THRESHOLD_VALUE) ELSE E1.THRESHOLD_VALUE END) THRESHOLD_DISPLAY
, E1.THRESHOLD_VALUE_UOM UOM
, E1.CREATED_BY
, E1.CREATION_DATE
, E1.LAST_UPDATE_DATE
, E1.LAST_UPDATED_BY
, E1.LAST_UPDATE_LOGIN
FROM MFG_LOOKUPS M1
, MFG_LOOKUPS M2
, FND_LOOKUPS F1
, MSC_EXCEP_THRESHOLDS E1
, MSC_PLAN_EXCP_TYPES E2
WHERE M1.LOOKUP_CODE = E1.EXCEPTION_GROUP
AND M1.LOOKUP_TYPE = 'MSC_EXCEPTION_GROUP'
AND M2.LOOKUP_CODE = E1.EXCEPTION_TYPE
AND M2.LOOKUP_TYPE = 'MRP_EXCEPTION_CODE_TYPE'
AND E2.EXCP_TYPE = M2.LOOKUP_CODE
AND E2.IN_SRP_PLAN = 1
AND F1.LOOKUP_CODE = E1.CRITERIA
AND F1.LOOKUP_TYPE = 'MSC_PQ_EXCP'