VIEW: APPS.HZ_PARTY_USAGES_VL

Source

View Text - Preformatted

SELECT b.rowid row_id, b.party_usage_code, t.party_usage_name, t.description, b.party_usage_type, b.restrict_manual_assign_flag, b.restrict_manual_update_flag, b.publish_to_wfds_flag, b.status_flag, b.object_version_number, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login 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')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.PARTY_USAGE_CODE
, T.PARTY_USAGE_NAME
, T.DESCRIPTION
, B.PARTY_USAGE_TYPE
, B.RESTRICT_MANUAL_ASSIGN_FLAG
, B.RESTRICT_MANUAL_UPDATE_FLAG
, B.PUBLISH_TO_WFDS_FLAG
, B.STATUS_FLAG
, B.OBJECT_VERSION_NUMBER
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
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')