View used to define the attribute fields for an AK object for construction of the Product Catalog Setup tree.Returns all valid bom types in an organization.
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT SUBSTRB(MFL.MEANING , 1 , 78) LABEL , NT.NODE_TYPE , MFL.LOOKUP_CODE NODE_KEY , NT.ICON_NAME , 'N' LEAF_FLAG , 'ROOT' PARENT_NODE_TYPE , NT.ROOT_KEY PARENT_NODE_KEY FROM XNC_NAV_NODE_TYPES_V NT , MFG_LOOKUPS MFL WHERE MFL.LOOKUP_TYPE = 'BOM_ITEM_TYPE' AND NT.NODE_TYPE = 'PROD_GROUP_BOMTYPE' AND NT.ROOT_KEY = 'XNC_PRODUCTS_BT'