VIEW: APPS.MSC_NET_EXC_DETAIL_V

Source

View Text - Preformatted

SELECT med.query_id, med.exception_detail_id, med.exception_type, med.exception_group, med.from_plan, med.plan_id, null, med.status, msc_get_name.lookup_meaning('MRP_EXCEPTION_CODE_TYPE',med.exception_type), null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_number(null), to_date(null), to_date(null), null, null, null, null, null, to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), null, to_date(null), to_date(null), to_number(null), to_date(null), null, null, med.last_update_date, med.last_updated_by, med.creation_date, med.created_by, med.last_update_login, med.match_id from msc_nec_exc_dtl_temp med WHERE med.exception_detail_id is not null union all SELECT med.report_id, med.exception_detail_id, med.exception_type, med.exception_group, med.from_plan, med.plan_id, null, med.status, msc_get_name.lookup_meaning('MRP_EXCEPTION_CODE_TYPE',med.exception_type), null, null, null, null, null, null, null, null, null, null, null, null, null, null, to_number(null), to_date(null), to_date(null), null, null, null, null, null, to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), to_number(null), null, to_date(null), to_date(null), to_number(null), to_date(null), null, null, med.last_update_date, med.last_updated_by, med.creation_date, med.created_by, med.last_update_login, med.match_id from msc_nec_exc_dtl_compare med where med.exception_detail_id is not null

View Text - HTML Formatted

SELECT MED.QUERY_ID
, MED.EXCEPTION_DETAIL_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_GROUP
, MED.FROM_PLAN
, MED.PLAN_ID
, NULL
, MED.STATUS
, MSC_GET_NAME.LOOKUP_MEANING('MRP_EXCEPTION_CODE_TYPE'
, MED.EXCEPTION_TYPE)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
, MED.MATCH_ID
FROM MSC_NEC_EXC_DTL_TEMP MED
WHERE MED.EXCEPTION_DETAIL_ID IS NOT NULL UNION ALL SELECT MED.REPORT_ID
, MED.EXCEPTION_DETAIL_ID
, MED.EXCEPTION_TYPE
, MED.EXCEPTION_GROUP
, MED.FROM_PLAN
, MED.PLAN_ID
, NULL
, MED.STATUS
, MSC_GET_NAME.LOOKUP_MEANING('MRP_EXCEPTION_CODE_TYPE'
, MED.EXCEPTION_TYPE)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL)
, NULL
, NULL
, MED.LAST_UPDATE_DATE
, MED.LAST_UPDATED_BY
, MED.CREATION_DATE
, MED.CREATED_BY
, MED.LAST_UPDATE_LOGIN
, MED.MATCH_ID
FROM MSC_NEC_EXC_DTL_COMPARE MED
WHERE MED.EXCEPTION_DETAIL_ID IS NOT NULL