VIEW: APPS.MSC_NET_EXC_TYPE_V

Source

View Text - Preformatted

SELECT med.query_id, sum(decode(med.from_plan, 1, med.match_id, 0)), sum(decode(med.from_plan, 2, med.match_id, 0)), sum(decode(med.from_plan, 1, decode(med.status, 1, med.match_id, 0), 0)), sum(decode(med.from_plan, 1, decode(med.status, 2, med.match_id, 0), 0)), sum(decode(med.from_plan, 1, decode(med.status, 0, med.match_id, 0), 0)), sum(decode(med.from_plan, 2, decode(med.status, 0, med.match_id, 0), 0)), med.exception_type, msc_get_name.lookup_meaning('MRP_EXCEPTION_CODE_TYPE',med.exception_type), med.exception_group, null, null, null, med.last_update_date, med.last_updated_by, med.creation_date, med.created_by, med.last_update_login from msc_nec_exc_dtl_temp med WHERE med.exception_detail_id is null and med.exception_type is not null group by med.query_id, med.exception_group, med.exception_type, med.last_update_date, med.last_updated_by, med.creation_date, med.created_by, med.last_update_login union all SELECT med.report_id, sum(decode(med.from_plan, 1, med.match_id, 0)), sum(decode(med.from_plan, 2, med.match_id, 0)), sum(decode(med.from_plan, 1, decode(med.status, 1, med.match_id, 0), 0)), sum(decode(med.from_plan, 1, decode(med.status, 2, med.match_id, 0), 0)), sum(decode(med.from_plan, 1, decode(med.status, 0, med.match_id, 0), 0)), sum(decode(med.from_plan, 2, decode(med.status, 0, med.match_id, 0), 0)), med.exception_type, msc_get_name.lookup_meaning('MRP_EXCEPTION_CODE_TYPE',med.exception_type), med.exception_group, null, null, null, med.last_update_date, med.last_updated_by, med.creation_date, med.created_by, med.last_update_login from msc_nec_exc_dtl_compare med where med.exception_detail_id is null and med.exception_type is not null group by med.report_id, med.exception_group, med.exception_type, med.last_update_date, med.last_updated_by, med.creation_date, med.created_by, med.last_update_login

View Text - HTML Formatted

SELECT MED.QUERY_ID
, SUM(DECODE(MED.FROM_PLAN
, 1
, MED.MATCH_ID
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 2
, MED.MATCH_ID
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 1
, MED.MATCH_ID
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 2
, MED.MATCH_ID
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 0
, MED.MATCH_ID
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 2
, DECODE(MED.STATUS
, 0
, MED.MATCH_ID
, 0)
, 0))
, MED.EXCEPTION_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_EXCEPTION_CODE_TYPE'
, MED.EXCEPTION_TYPE)
, MED.EXCEPTION_GROUP
, NULL
, NULL
, NULL
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
FROM MSC_NEC_EXC_DTL_TEMP MED
WHERE MED.EXCEPTION_DETAIL_ID IS NULL
AND MED.EXCEPTION_TYPE IS NOT NULL GROUP BY MED.QUERY_ID
, MED.EXCEPTION_GROUP
, MED.EXCEPTION_TYPE
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN UNION ALL SELECT MED.REPORT_ID
, SUM(DECODE(MED.FROM_PLAN
, 1
, MED.MATCH_ID
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 2
, MED.MATCH_ID
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 1
, MED.MATCH_ID
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 2
, MED.MATCH_ID
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 1
, DECODE(MED.STATUS
, 0
, MED.MATCH_ID
, 0)
, 0))
, SUM(DECODE(MED.FROM_PLAN
, 2
, DECODE(MED.STATUS
, 0
, MED.MATCH_ID
, 0)
, 0))
, MED.EXCEPTION_TYPE
, MSC_GET_NAME.LOOKUP_MEANING('MRP_EXCEPTION_CODE_TYPE'
, MED.EXCEPTION_TYPE)
, MED.EXCEPTION_GROUP
, NULL
, NULL
, NULL
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
FROM MSC_NEC_EXC_DTL_COMPARE MED
WHERE MED.EXCEPTION_DETAIL_ID IS NULL
AND MED.EXCEPTION_TYPE IS NOT NULL GROUP BY MED.REPORT_ID
, MED.EXCEPTION_GROUP
, MED.EXCEPTION_TYPE
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN