[Home] [Help]
View: XNC_PCS_BTYPEITM_NAV
Product: | XNC - Sales for Communications (Obsolete) |
Description: | View used to define the attribute fields for an AK object for construction of the Product Catalog Setup tree. Returns all items assigned to a bom type |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SUBSTRB(MSI.PADDED_CONCATENATED_SEGMENTS
, 1
, 78) LABEL
, 'PROD_BOMTYPE_ITEMS' NODE_TYPE
, TO_CHAR(MSI.ORGANIZATION_ID)||'
, '||MSI.BOM_ITEM_TYPE||'
, '||TO_CHAR(MSI.INVENTORY_ITEM_ID) NODE_KEY
, 'AFCLPS' ICON_NAME
, 'Y' LEAF_FLAG
, 'PROD_GROUP_BOMTYPE' PARENT_NODE_TYPE
, MSI.BOM_ITEM_TYPE PARENT_NODE_KEY
FROM MTL_SYSTEM_ITEMS_KFV MSI
Columns
Name |
LABEL |
NODE_TYPE |
NODE_KEY |
ICON_NAME |
LEAF_FLAG |
PARENT_NODE_TYPE |
PARENT_NODE_KEY |