[Home] [Help]
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
Name |
ATTR_GROUP_NAME |
ATTR_GROUP_DISP_NAME |
ATTR_NAME |
ATTR_DISPLAY_NAME |
DATABASE_COLUMN |
EXT_TABLE_NAME |
INTF_TABLE_NAME |
ATTR_GROUP_ID |
ATTR_GROUP_TYPE |