View: BOM_ATTRS_V

Product:	BOM - Bills of Material
Description:	Displays the BOM attributes
Implementation/DBA Data:	APPS.BOM_ATTRS_V

View Text

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

Columns