HZ_PARTY_USAGES_VL
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: VIEW
Columns
Name |
---|
PARTY_USAGE_CODE PARTY_USAGE_TYPE PARTY_USAGE_NAME DESCRIPTION RESTRICT_MANUAL_ASSIGN_FLAG RESTRICT_MANUAL_UPDATE_FLAG STATUS_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER REL_CAUSES_ASSIGNMENT_FLAG UNCOND_ASSIGN_FLAG PARTY_USG_ASSGN_DESC PARTY_USG_UNASSGN_DESC |
Query
SQL_Statement |
---|
SELECT B.PARTY_USAGE_CODE, B.PARTY_USAGE_TYPE, T.PARTY_USAGE_NAME, T.DESCRIPTION, B.RESTRICT_MANUAL_ASSIGN_FLAG, B.RESTRICT_MANUAL_UPDATE_FLAG, B.STATUS_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.REL_CAUSES_ASSIGNMENT_FLAG, B.UNCOND_ASSIGN_FLAG, T.PARTY_USG_ASSGN_DESC, T.PARTY_USG_UNASSGN_DESC FROM HZ_PARTY_USAGES_B B, HZ_PARTY_USAGES_TL T WHERE B.PARTY_USAGE_CODE = T.PARTY_USAGE_CODE AND T.LANGUAGE = USERENV('LANG') |