PJR_OBJECT_STATUSES_VL

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name

STATUS_CODE OBJECT_TYPE STATUS_NAME DESCRIPTION ACTIVE_FLAG USED_BY SEEDED_FLAG SYSTEM_FLOW SYSTEM_STATUS_CODE INITIAL_STATUS_FLAG NEXT_ALLOWABLE_STATUS_FLAG ENABLE_WF_FLAG WF_FAILURE_STATUS_CODE WF_SUCCESS_STATUS_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT base.STATUS_CODE, base.OBJECT_TYPE, tl.STATUS_NAME, tl.DESCRIPTION, base.ACTIVE_FLAG, base.USED_BY, base.SEEDED_FLAG, base.SYSTEM_FLOW, base.SYSTEM_STATUS_CODE, base.INITIAL_STATUS_FLAG, base.NEXT_ALLOWABLE_STATUS_FLAG, base.ENABLE_WF_FLAG, base.WF_FAILURE_STATUS_CODE, base.WF_SUCCESS_STATUS_CODE, base.CREATED_BY, base.CREATION_DATE, base.LAST_UPDATED_BY, base.LAST_UPDATE_DATE, base.LAST_UPDATE_LOGIN, base.OBJECT_VERSION_NUMBER, base.ATTRIBUTE_CATEGORY, base.ATTRIBUTE_CHAR1, base.ATTRIBUTE_CHAR2, base.ATTRIBUTE_CHAR3, base.ATTRIBUTE_CHAR4, base.ATTRIBUTE_CHAR5, base.ATTRIBUTE_CHAR6, base.ATTRIBUTE_CHAR7, base.ATTRIBUTE_CHAR8, base.ATTRIBUTE_CHAR9, base.ATTRIBUTE_CHAR10, base.ATTRIBUTE_CHAR11, base.ATTRIBUTE_CHAR12, base.ATTRIBUTE_CHAR13, base.ATTRIBUTE_CHAR14, base.ATTRIBUTE_CHAR15, base.ATTRIBUTE_CHAR16, base.ATTRIBUTE_CHAR17, base.ATTRIBUTE_CHAR18, base.ATTRIBUTE_CHAR19, base.ATTRIBUTE_CHAR20, base.ATTRIBUTE_DATE1, base.ATTRIBUTE_DATE2, base.ATTRIBUTE_DATE3, base.ATTRIBUTE_DATE4, base.ATTRIBUTE_DATE5, base.ATTRIBUTE_DATE6, base.ATTRIBUTE_DATE7, base.ATTRIBUTE_DATE8, base.ATTRIBUTE_DATE9, base.ATTRIBUTE_DATE10, base.ATTRIBUTE_DATE11, base.ATTRIBUTE_DATE12, base.ATTRIBUTE_DATE13, base.ATTRIBUTE_DATE14, base.ATTRIBUTE_DATE15, base.ATTRIBUTE_NUMBER1, base.ATTRIBUTE_NUMBER2, base.ATTRIBUTE_NUMBER3, base.ATTRIBUTE_NUMBER4, base.ATTRIBUTE_NUMBER5, base.ATTRIBUTE_NUMBER6, base.ATTRIBUTE_NUMBER7, base.ATTRIBUTE_NUMBER8, base.ATTRIBUTE_NUMBER9, base.ATTRIBUTE_NUMBER10, base.ATTRIBUTE_NUMBER11, base.ATTRIBUTE_NUMBER12, base.ATTRIBUTE_NUMBER13, base.ATTRIBUTE_NUMBER14, base.ATTRIBUTE_NUMBER15, base.ATTRIBUTE_TIMESTAMP1, base.ATTRIBUTE_TIMESTAMP2, base.ATTRIBUTE_TIMESTAMP3, base.ATTRIBUTE_TIMESTAMP4, base.ATTRIBUTE_TIMESTAMP5 FROM PJR_OBJECT_STATUSES_B base, PJR_OBJECT_STATUSES_TL tl WHERE base.status_code = tl.status_code AND base.object_type = tl.object_type AND tl.language = userenv('LANG')