VIEW: APPS.BOM_ATTRS_V

Source

View Text - Preformatted

SELECT ATTR.ATTR_GROUP_NAME, ATTR_GRPS.ATTR_GROUP_DISP_NAME, ATTR.ATTR_NAME, ATTR.ATTR_DISPLAY_NAME, DATABASE_COLUMN, EXT_TABLE_NAME, INTF.INTF_TABLE_NAME, ATTR_GRPS.ATTR_GROUP_ID, ATTR_GRPS.ATTR_GROUP_TYPE FROM EGO_ATTRS_V ATTR, EGO_ATTR_GROUPS_V ATTR_GRPS, EGO_ATTR_GROUP_TYPES_V GRPS, (SELECT 'BOM_COMPONENTMGMT_GROUP' ATTR_GROUP_TYPE, 'BOM_INV_COMPS_EXT_INTERFACE' INTF_TABLE_NAME FROM DUAL UNION ALL SELECT 'BOM_COMPONENT_BASE' ATTR_GROUP_TYPE, 'BOM_INVENTORY_COMPS_INTERFACE' INTF_TABLE_NAME FROM DUAL ) INTF WHERE (ATTR.ATTR_GROUP_TYPE = 'BOM_COMPONENTMGMT_GROUP' OR ATTR.ATTR_GROUP_TYPE = 'BOM_COMPONENT_BASE' ) AND ATTR.ATTR_GROUP_TYPE = GRPS.ATTR_GROUP_TYPE AND ATTR_GRPS.ATTR_GROUP_NAME = ATTR.ATTR_GROUP_NAME AND INTF.ATTR_GROUP_TYPE = GRPS.ATTR_GROUP_TYPE AND ATTR.APPLICATION_ID = 702 ORDER BY ATTR.ATTR_GROUP_TYPE, ATTR.ATTR_GROUP_NAME

View Text - HTML Formatted

SELECT ATTR.ATTR_GROUP_NAME
, ATTR_GRPS.ATTR_GROUP_DISP_NAME
, ATTR.ATTR_NAME
, ATTR.ATTR_DISPLAY_NAME
, DATABASE_COLUMN
, EXT_TABLE_NAME
, INTF.INTF_TABLE_NAME
, ATTR_GRPS.ATTR_GROUP_ID
, ATTR_GRPS.ATTR_GROUP_TYPE
FROM EGO_ATTRS_V ATTR
, EGO_ATTR_GROUPS_V ATTR_GRPS
, EGO_ATTR_GROUP_TYPES_V GRPS
, (SELECT 'BOM_COMPONENTMGMT_GROUP' ATTR_GROUP_TYPE
, 'BOM_INV_COMPS_EXT_INTERFACE' INTF_TABLE_NAME
FROM DUAL UNION ALL SELECT 'BOM_COMPONENT_BASE' ATTR_GROUP_TYPE
, 'BOM_INVENTORY_COMPS_INTERFACE' INTF_TABLE_NAME
FROM DUAL ) INTF
WHERE (ATTR.ATTR_GROUP_TYPE = 'BOM_COMPONENTMGMT_GROUP' OR ATTR.ATTR_GROUP_TYPE = 'BOM_COMPONENT_BASE' )
AND ATTR.ATTR_GROUP_TYPE = GRPS.ATTR_GROUP_TYPE
AND ATTR_GRPS.ATTR_GROUP_NAME = ATTR.ATTR_GROUP_NAME
AND INTF.ATTR_GROUP_TYPE = GRPS.ATTR_GROUP_TYPE
AND ATTR.APPLICATION_ID = 702 ORDER BY ATTR.ATTR_GROUP_TYPE
, ATTR.ATTR_GROUP_NAME