eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: BOM.BOM_COMPONENT_COLUMNS#

Source

View Text - Preformatted


select APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME, ATTRIBUTE_GROUP ATTRIBUTE_GROUP, ATTRIBUTE_CODE ATTRIBUTE_CODE, OBJECT_TYPE OBJECT_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DISPLAY_NAME DISPLAY_NAME, SORTABLE SORTABLE, TABLE_NAME TABLE_NAME, TABLE_COLUMN_NAME TABLE_COLUMN_NAME, TABLE_ALIAS_NAME TABLE_ALIAS_NAME, BASE_WHERE_CLAUSE BASE_WHERE_CLAUSE, PARENT_ENTITY PARENT_ENTITY, ADDITIONAL_JOIN_TABLES ADDITIONAL_JOIN_TABLES, BOM_INTF_COLUMN_NAME BOM_INTF_COLUMN_NAME, BOM_INTF_TABLE_NAME BOM_INTF_TABLE_NAME, AVAILABLE_IN_RESULT_FORMAT AVAILABLE_IN_RESULT_FORMAT, AVAILABLE_IN_CRITERIA AVAILABLE_IN_CRITERIA, OPERATION_TYPE OPERATION_TYPE, LOV_OR_POPLIST_SQL LOV_OR_POPLIST_SQL, ADDITIONAL_JOIN_CONDITIONS ADDITIONAL_JOIN_CONDITIONS, ATTRIBUTE_GROUP_DISPLAY_NAME ATTRIBUTE_GROUP_DISPLAY_NAME, PREDEFINED PREDEFINED, UPDATE_ALLOWED UPDATE_ALLOWED, VALUESET_NAME VALUESET_NAME, LOOKUP_TYPE LOOKUP_TYPE, DISPLAY_TYPE DISPLAY_TYPE, ATTRIBUTE_SEQUENCE ATTRIBUTE_SEQUENCE, ZD_EDITION_NAME ZD_EDITION_NAME from "BOM"."BOM_COMPONENT_COLUMNS"

View Text - HTML Formatted

SELECT APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, ATTRIBUTE_GROUP ATTRIBUTE_GROUP
, ATTRIBUTE_CODE ATTRIBUTE_CODE
, OBJECT_TYPE OBJECT_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DISPLAY_NAME DISPLAY_NAME
, SORTABLE SORTABLE
, TABLE_NAME TABLE_NAME
, TABLE_COLUMN_NAME TABLE_COLUMN_NAME
, TABLE_ALIAS_NAME TABLE_ALIAS_NAME
, BASE_WHERE_CLAUSE BASE_WHERE_CLAUSE
, PARENT_ENTITY PARENT_ENTITY
, ADDITIONAL_JOIN_TABLES ADDITIONAL_JOIN_TABLES
, BOM_INTF_COLUMN_NAME BOM_INTF_COLUMN_NAME
, BOM_INTF_TABLE_NAME BOM_INTF_TABLE_NAME
, AVAILABLE_IN_RESULT_FORMAT AVAILABLE_IN_RESULT_FORMAT
, AVAILABLE_IN_CRITERIA AVAILABLE_IN_CRITERIA
, OPERATION_TYPE OPERATION_TYPE
, LOV_OR_POPLIST_SQL LOV_OR_POPLIST_SQL
, ADDITIONAL_JOIN_CONDITIONS ADDITIONAL_JOIN_CONDITIONS
, ATTRIBUTE_GROUP_DISPLAY_NAME ATTRIBUTE_GROUP_DISPLAY_NAME
, PREDEFINED PREDEFINED
, UPDATE_ALLOWED UPDATE_ALLOWED
, VALUESET_NAME VALUESET_NAME
, LOOKUP_TYPE LOOKUP_TYPE
, DISPLAY_TYPE DISPLAY_TYPE
, ATTRIBUTE_SEQUENCE ATTRIBUTE_SEQUENCE
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "BOM"."BOM_COMPONENT_COLUMNS"