VIEW: APPS.MSC_SOL_GRP_RES_V

Source

View Text - Preformatted

SELECT MSR.ROWID ROW_ID, MSR.PLAN_ID, MSR.SOLVER_GROUP_ID, MSR.RESOURCE_ID, MSR.DEPARTMENT_ID, MSR.RESOURCE_SEQUENCE, MSR.ORGANIZATION_ID, MSR.SR_INSTANCE_ID, MDR.RESOURCE_CODE RESOURCE_NAME, MDR.RESOURCE_DESCRIPTION DESCRIPTION, MSR.CREATED_BY, MSR.CREATION_DATE, MSR.LAST_UPDATE_DATE, MSR.LAST_UPDATED_BY, MSR.LAST_UPDATE_LOGIN FROM MSC_SOL_GRP_RES MSR, MSC_DEPARTMENT_RESOURCES MDR WHERE MDR.PLAN_ID = -1 AND MDR.LINE_FLAG = 2 AND MDR.ORGANIZATION_ID = MSR.ORGANIZATION_ID AND MDR.SR_INSTANCE_ID = MSR.SR_INSTANCE_ID AND MDR.DEPARTMENT_ID = MSR.DEPARTMENT_ID AND MDR.RESOURCE_ID = MSR.RESOURCE_ID

View Text - HTML Formatted

SELECT MSR.ROWID ROW_ID
, MSR.PLAN_ID
, MSR.SOLVER_GROUP_ID
, MSR.RESOURCE_ID
, MSR.DEPARTMENT_ID
, MSR.RESOURCE_SEQUENCE
, MSR.ORGANIZATION_ID
, MSR.SR_INSTANCE_ID
, MDR.RESOURCE_CODE RESOURCE_NAME
, MDR.RESOURCE_DESCRIPTION DESCRIPTION
, MSR.CREATED_BY
, MSR.CREATION_DATE
, MSR.LAST_UPDATE_DATE
, MSR.LAST_UPDATED_BY
, MSR.LAST_UPDATE_LOGIN
FROM MSC_SOL_GRP_RES MSR
, MSC_DEPARTMENT_RESOURCES MDR
WHERE MDR.PLAN_ID = -1
AND MDR.LINE_FLAG = 2
AND MDR.ORGANIZATION_ID = MSR.ORGANIZATION_ID
AND MDR.SR_INSTANCE_ID = MSR.SR_INSTANCE_ID
AND MDR.DEPARTMENT_ID = MSR.DEPARTMENT_ID
AND MDR.RESOURCE_ID = MSR.RESOURCE_ID