VIEW: APPS.MSC_UNDO_DETAILS_V

Source

View Text - Preformatted

SELECT d.undo_id, d.column_changed, d.column_changed_text, DECODE(column_type,'DATE', FND_DATE.DATE_TO_CHARDT(FND_DATE.CANONICAL_TO_DATE(d.old_value)), DECODE(d.column_changed, 'SOURCE_ORGANIZATION_ID', msc_get_name.org_code(d.old_value, s.sr_instance_id), 'SOURCE_SUPPLIER_ID', msc_get_name.supplier(d.old_value), 'SOURCE_SUPPLIER_SITE_ID', msc_get_name.supplier_site(d.old_value), 'PROJECT_ID', msc_get_name.project(d.old_value, NULL, s.plan_id, s.sr_instance_id), 'TASK_ID', msc_get_name.task(d.old_value, NULL, NULL, s.plan_id, s.sr_instance_id), 'LINE_ID', msc_get_name.department_code(1, d.old_value, NULL, s.plan_id, s.sr_instance_id), 'RESCHEDULE_FLAG', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'FIRM_PLANNED_TYPE', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'OPTIMIZE_FLAG', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'DAILY_RESOURCE_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'WEEKLY_RESOURCE_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'PERIOD_RESOURCE_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'DAILY_MATERIAL_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'WEEKLY_MATERIAL_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'PERIOD_MATERIAL_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'CURR_PLAN_CAPACITY_FLAG', msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), 'RESOURCE_ID', msc_get_name.resource_code(d.old_value, -1, s.transaction_id, s.plan_id, s.sr_instance_id), 'FIRM_FLAG',decode(s.table_changed, 7, msc_get_name.lookup_meaning('SYS_YES_NO', d.old_value), msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', d.old_value)), d.old_value)), d.old_value, DECODE(column_type,'DATE', FND_DATE.DATE_TO_CHARDT(FND_DATE.CANONICAL_TO_DATE(d.new_value)), DECODE(d.column_changed, 'SOURCE_ORGANIZATION_ID', msc_get_name.org_code(d.new_value, s.sr_instance_id), 'SOURCE_SUPPLIER_ID', msc_get_name.supplier(d.new_value), 'SOURCE_SUPPLIER_SITE_ID', msc_get_name.supplier_site(d.new_value), 'PROJECT_ID', msc_get_name.project(d.new_value, NULL, s.plan_id, s.sr_instance_id), 'TASK_ID', msc_get_name.task(d.new_value, NULL, NULL, s.plan_id, s.sr_instance_id), 'LINE_ID', msc_get_name.department_code(1, d.new_value, NULL, s.plan_id, s.sr_instance_id), 'RESCHEDULE_FLAG', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'FIRM_PLANNED_TYPE', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'OPTIMIZE_FLAG', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'DAILY_RESOURCE_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'WEEKLY_RESOURCE_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'PERIOD_RESOURCE_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'DAILY_MATERIAL_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'WEEKLY_MATERIAL_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'PERIOD_MATERIAL_CONSTRAINTS', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'CURR_PLAN_CAPACITY_FLAG', msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), 'RESOURCE_ID', msc_get_name.resource_code(d.new_value, -1, s.transaction_id, s.plan_id, s.sr_instance_id), 'FIRM_FLAG',decode(s.table_changed, 7, msc_get_name.lookup_meaning('SYS_YES_NO', d.new_value), msc_get_name.lookup_meaning('RESOURCE_FIRM_TYPE', d.new_value)), d.new_value)), d.new_value, d.created_by, d.creation_date, d.last_updated_by, d.last_update_date, d.last_update_login, d.column_type FROM msc_undo_details d, msc_undo_summary s WHERE s.undo_id = d.undo_id

View Text - HTML Formatted

SELECT D.UNDO_ID
, D.COLUMN_CHANGED
, D.COLUMN_CHANGED_TEXT
, DECODE(COLUMN_TYPE
, 'DATE'
, FND_DATE.DATE_TO_CHARDT(FND_DATE.CANONICAL_TO_DATE(D.OLD_VALUE))
, DECODE(D.COLUMN_CHANGED
, 'SOURCE_ORGANIZATION_ID'
, MSC_GET_NAME.ORG_CODE(D.OLD_VALUE
, S.SR_INSTANCE_ID)
, 'SOURCE_SUPPLIER_ID'
, MSC_GET_NAME.SUPPLIER(D.OLD_VALUE)
, 'SOURCE_SUPPLIER_SITE_ID'
, MSC_GET_NAME.SUPPLIER_SITE(D.OLD_VALUE)
, 'PROJECT_ID'
, MSC_GET_NAME.PROJECT(D.OLD_VALUE
, NULL
, S.PLAN_ID
, S.SR_INSTANCE_ID)
, 'TASK_ID'
, MSC_GET_NAME.TASK(D.OLD_VALUE
, NULL
, NULL
, S.PLAN_ID
, S.SR_INSTANCE_ID)
, 'LINE_ID'
, MSC_GET_NAME.DEPARTMENT_CODE(1
, D.OLD_VALUE
, NULL
, S.PLAN_ID
, S.SR_INSTANCE_ID)
, 'RESCHEDULE_FLAG'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'FIRM_PLANNED_TYPE'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'OPTIMIZE_FLAG'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'DAILY_RESOURCE_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'WEEKLY_RESOURCE_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'PERIOD_RESOURCE_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'DAILY_MATERIAL_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'WEEKLY_MATERIAL_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'PERIOD_MATERIAL_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'CURR_PLAN_CAPACITY_FLAG'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, 'RESOURCE_ID'
, MSC_GET_NAME.RESOURCE_CODE(D.OLD_VALUE
, -1
, S.TRANSACTION_ID
, S.PLAN_ID
, S.SR_INSTANCE_ID)
, 'FIRM_FLAG'
, DECODE(S.TABLE_CHANGED
, 7
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.OLD_VALUE)
, MSC_GET_NAME.LOOKUP_MEANING('RESOURCE_FIRM_TYPE'
, D.OLD_VALUE))
, D.OLD_VALUE))
, D.OLD_VALUE
, DECODE(COLUMN_TYPE
, 'DATE'
, FND_DATE.DATE_TO_CHARDT(FND_DATE.CANONICAL_TO_DATE(D.NEW_VALUE))
, DECODE(D.COLUMN_CHANGED
, 'SOURCE_ORGANIZATION_ID'
, MSC_GET_NAME.ORG_CODE(D.NEW_VALUE
, S.SR_INSTANCE_ID)
, 'SOURCE_SUPPLIER_ID'
, MSC_GET_NAME.SUPPLIER(D.NEW_VALUE)
, 'SOURCE_SUPPLIER_SITE_ID'
, MSC_GET_NAME.SUPPLIER_SITE(D.NEW_VALUE)
, 'PROJECT_ID'
, MSC_GET_NAME.PROJECT(D.NEW_VALUE
, NULL
, S.PLAN_ID
, S.SR_INSTANCE_ID)
, 'TASK_ID'
, MSC_GET_NAME.TASK(D.NEW_VALUE
, NULL
, NULL
, S.PLAN_ID
, S.SR_INSTANCE_ID)
, 'LINE_ID'
, MSC_GET_NAME.DEPARTMENT_CODE(1
, D.NEW_VALUE
, NULL
, S.PLAN_ID
, S.SR_INSTANCE_ID)
, 'RESCHEDULE_FLAG'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'FIRM_PLANNED_TYPE'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'OPTIMIZE_FLAG'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'DAILY_RESOURCE_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'WEEKLY_RESOURCE_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'PERIOD_RESOURCE_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'DAILY_MATERIAL_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'WEEKLY_MATERIAL_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'PERIOD_MATERIAL_CONSTRAINTS'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'CURR_PLAN_CAPACITY_FLAG'
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, 'RESOURCE_ID'
, MSC_GET_NAME.RESOURCE_CODE(D.NEW_VALUE
, -1
, S.TRANSACTION_ID
, S.PLAN_ID
, S.SR_INSTANCE_ID)
, 'FIRM_FLAG'
, DECODE(S.TABLE_CHANGED
, 7
, MSC_GET_NAME.LOOKUP_MEANING('SYS_YES_NO'
, D.NEW_VALUE)
, MSC_GET_NAME.LOOKUP_MEANING('RESOURCE_FIRM_TYPE'
, D.NEW_VALUE))
, D.NEW_VALUE))
, D.NEW_VALUE
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATE_LOGIN
, D.COLUMN_TYPE
FROM MSC_UNDO_DETAILS D
, MSC_UNDO_SUMMARY S
WHERE S.UNDO_ID = D.UNDO_ID