[Home] [Help]
View: CSP_SEC_INVENTORIES_NAV
Product: | CSP - Spares Management |
Description: | View for Parts Loop to Subinventory flow |
Implementation/DBA Data: |
APPS.CSP_SEC_INVENTORIES_NAV
|
View Text
SELECT MP.ORGANIZATION_CODE||'.'|| SI.SECONDARY_INVENTORY_NAME
, NT.NODE_TYPE
, SI.SECONDARY_INVENTORY_ID
, DECODE(SI.CONDITION_TYPE
, 'G'
, 'ECGRNFLG'
, 'B'
, 'ECRDFLG'
, 'ECGRNFLG')
, 'Y'
, 'PARTS_LOOPS'
, SI.PARTS_LOOP_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_SEC_INVENTORIES SI
, MTL_PARAMETERS MP
WHERE NT.ROOT_KEY = 'CSP_PARTS_LOOPS'
AND NT.NODE_TYPE = 'SEC_INV'
AND SI.ORGANIZATION_ID = MP.ORGANIZATION_ID ORDER BY 1
Columns
Name |
LABEL |
NODE_TYPE |
NODE_KEY |
ICON_NAME |
LEAF_FLAG |
PARENT_NODE_TYPE |
PARENT_NODE_KEY |