[Home] [Help]
View: XNC_PCS_ITEMTYPE_NAV
Product: | XNC - Sales for Communications (Obsolete) |
Description: | This view returns all valid item types for the organization |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SUBSTRB(FNDC.MEANING
, 1
, 78) LABEL
, NT.NODE_TYPE NODE_TYPE
, FNDC.LOOKUP_CODE NODE_KEY
, NT.ICON_NAME
, 'N' LEAF_FLAG
, 'ROOT' PARENT_NODE_TYPE
, 'XNC_PRODUCTS_IT' PARENT_NODE_KEY
FROM FND_COMMON_LOOKUPS FNDC
, XNC_NAV_NODE_TYPES_V NT
WHERE FNDC.LOOKUP_TYPE = 'ITEM_TYPE'
AND NT.NODE_TYPE = 'PROD_GROUP_ITEMTYPE'
AND NT.ROOT_KEY = 'XNC_PRODUCTS_IT'
Columns
Name |
LABEL |
NODE_TYPE |
NODE_KEY |
ICON_NAME |
LEAF_FLAG |
PARENT_NODE_TYPE |
PARENT_NODE_KEY |