MSC_PLANNERS_WITH_PIMID_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name

PLANNER_CODE ORGANIZATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN DESCRIPTION DISABLE_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ELECTRONIC_MAIL_ADDRESS EMPLOYEE_ID OBJECT_VERSION_NUMBER EMPLOYEE_NUMBER EMPLOYEE_NAME REFRESH_NUMBER CURRENT_EMPLOYEE_FLAG PLANNER_ID

Query

SQL_Statement

SELECT MP.PLANNER_CODE, MIO.SR_ORGANIZATION_ID ORGANIZATION_ID, MP.LAST_UPDATE_DATE, MP.LAST_UPDATED_BY, MP.CREATION_DATE, MP.CREATED_BY, MP.LAST_UPDATE_LOGIN, MP.DESCRIPTION, MP.DISABLE_DATE, MP.ATTRIBUTE_CATEGORY, MP.ATTRIBUTE1, MP.ATTRIBUTE2, MP.ATTRIBUTE3, MP.ATTRIBUTE4, MP.ATTRIBUTE5, MP.ATTRIBUTE6, MP.ATTRIBUTE7, MP.ATTRIBUTE8, MP.ATTRIBUTE9, MP.ATTRIBUTE10, MP.ATTRIBUTE11, MP.ATTRIBUTE12, MP.ATTRIBUTE13, MP.ATTRIBUTE14, MP.ATTRIBUTE15, MP.ELECTRONIC_MAIL_ADDRESS, MP.EMPLOYEE_ID, MP.OBJECT_VERSION_NUMBER, MP.EMPLOYEE_NUMBER, MP.EMPLOYEE_NAME, MP.REFRESH_NUMBER, MP.CURRENT_EMPLOYEE_FLAG, MP.PLANNER_ID FROM MSC_PLANNERS MP, MSC_INSTANCE_ORGS MIO WHERE MP.SR_INSTANCE_ID = MIO.SR_INSTANCE_ID AND MIO.SR_INSTANCE_ID IN (SELECT INSTANCE_ID FROM MSC_APPS_INSTANCES WHERE APPS_VER = 2 AND ENABLE_FLAG = 1)