PJC_DISTRIBUTE_PATTERNS_VL

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name

DISTRIBUTE_PATTERN_ID STATUS BUSINESS_FUNCTION_CODE DETERMINANT1 DETERMINANT2 DETERMINANT3 DETERMINANT4 DETERMINANT5 DETERMINANT6 DETERMINANT7 DETERMINANT8 DETERMINANT9 DETERMINANT10 PATTERN_START_DATE PATTERN_END_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PATTERN_NAME PATTERN_DESCRIPTION

Query

SQL_Statement

SELECT b.distribute_pattern_id, b.status, b.business_function_code, b.determinant1, b.determinant2, b.determinant3, b.determinant4, b.determinant5, b.determinant6, b.determinant7, b.determinant8, b.determinant9, b.determinant10, b.pattern_start_date, b.pattern_end_date, b.attribute_category, b.attribute1, b.attribute2, b.attribute3, b.attribute4, b.attribute5, b.attribute6, b.attribute7, b.attribute8, b.attribute9, b.attribute10, b.object_version_number, b.created_by, b.creation_date, b.last_updated_by, b.last_update_date, b.last_update_login, tl.pattern_name, tl.pattern_description FROM PJC_DISTRIBUTE_PATTERNS_B b, PJC_DISTRIBUTE_PATTERNS_TL tl WHERE b.distribute_pattern_id = tl.distribute_pattern_id AND tl.language = userenv('LANG')