PAY_UPGRADE_OBJECTS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

UPGRADE_OBJECT_ID UPGRADE_PROCEDURE QUALIFYING_PROCEDURE PRE_PROCESS_PROCEDURE RELEASE_LEVEL QUALIFYING_METHOD UPGRADE_METHOD PRE_PROCESS_METHOD OBJECT_TYPE OBJECT_ID OBJECT_NAME UPGRADE_OBJECT_DATE UPGRADE_MODE INCOMPATIBILITY_LEVEL UPGRADE_OBJECT_BASE_NAME LAST_UPDATE_LOGIN LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY OBJECT_VERSION_NUMBER ENTERPRISE_ID MODULE_ID LEGISLATIVE_DATA_GROUP_ID LEGISLATION_CODE LEGISLATIVELY_ENABLED SGUID IS_LDG_REQUIRED IS_DISABLED_IN_PRODUCTION IS_RERUNNABLE FINAL_RELEASE_LEVEL UPGRADE_STYLE OBJECT_UPGRADE_NAME OBJECT_UPGRADE_DESCRIPTION

Query

SQL_Statement

SELECT B.UPGRADE_OBJECT_ID, B.UPGRADE_PROCEDURE, B.QUALIFYING_PROCEDURE, B.PRE_PROCESS_PROCEDURE, B.RELEASE_LEVEL, B.QUALIFYING_METHOD, B.UPGRADE_METHOD, B.PRE_PROCESS_METHOD, B.OBJECT_TYPE, B.OBJECT_ID, B.OBJECT_NAME, B.UPGRADE_OBJECT_DATE, B.UPGRADE_MODE, B.INCOMPATIBILITY_LEVEL, B.UPGRADE_OBJECT_BASE_NAME, B.LAST_UPDATE_LOGIN, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.OBJECT_VERSION_NUMBER, B.ENTERPRISE_ID, B.MODULE_ID, B.LEGISLATIVE_DATA_GROUP_ID, B.LEGISLATION_CODE, B.LEGISLATIVELY_ENABLED, B.SGUID, B.IS_LDG_REQUIRED, B.IS_DISABLED_IN_PRODUCTION, B.IS_RERUNNABLE, B.FINAL_RELEASE_LEVEL, B.UPGRADE_STYLE, TL.OBJECT_UPGRADE_NAME, TL.OBJECT_UPGRADE_DESCRIPTION FROM PAY_UPGRADE_OBJECTS B, PAY_UPGRADE_OBJECTS_TL TL WHERE B.UPGRADE_OBJECT_ID = TL.UPGRADE_OBJECT_ID AND USERENV('LANG') = TL.LANGUAGE