View: MSC_UNDO_DETAILS_V

Product:	MSC - Advanced Supply Chain Planning
Description:	this view shows all the changes made to the plan output
Implementation/DBA Data:	APPS.MSC_UNDO_DETAILS_V

View Text

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'
, 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'
, 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

Columns