VIEW: APPS.CSP_PLN_REGION_ORG_NAV

Source

View Text - Preformatted

SELECT cpl.node_name , decode(cpl.node_type,'SUBINVENTORY','SUBINVENTORY', 'ORGANIZATION_FE','ORGANIZATION','ORGANIZATION_WH','ORGANIZATION','REGION'), to_char(cpl.planning_parameters_id), decode(cpl.node_type,'SUBINVENTORY',decode(cpl.condition_type, 'G','ECGRNFLG','B','ECRDFLG',null), 'ORGANIZATION_FE','msc_orga','ORGANIZATION_WH','inviorga',nt.icon_name) icon_name , decode(cpl.node_type,'SUBINVENTORY','Y', 'ORGANIZATION_FE','N','ORGANIZATION_WH','Y','N') , 'REGION', cpl.parent_node_id from csp_nav_node_types nt, csp_planning_parameters cpl,csp_sec_inventories si where nt.root_key = 'CSP_PLANNING' and nt.node_type = 'REGION' and cpl.node_type in ('SUBINVENTORY','REGION','ORGANIZATION_WH','ORGANIZATION_ FE') and cpl.organization_id = si.organization_id (+) and cpl.secondary_inventory = si.secondary_inventory_name (+) order by 2,4,1

View Text - HTML Formatted

SELECT CPL.NODE_NAME
, DECODE(CPL.NODE_TYPE
, 'SUBINVENTORY'
, 'SUBINVENTORY'
, 'ORGANIZATION_FE'
, 'ORGANIZATION'
, 'ORGANIZATION_WH'
, 'ORGANIZATION'
, 'REGION')
, TO_CHAR(CPL.PLANNING_PARAMETERS_ID)
, DECODE(CPL.NODE_TYPE
, 'SUBINVENTORY'
, DECODE(CPL.CONDITION_TYPE
, 'G'
, 'ECGRNFLG'
, 'B'
, 'ECRDFLG'
, NULL)
, 'ORGANIZATION_FE'
, 'MSC_ORGA'
, 'ORGANIZATION_WH'
, 'INVIORGA'
, NT.ICON_NAME) ICON_NAME
, DECODE(CPL.NODE_TYPE
, 'SUBINVENTORY'
, 'Y'
, 'ORGANIZATION_FE'
, 'N'
, 'ORGANIZATION_WH'
, 'Y'
, 'N')
, 'REGION'
, CPL.PARENT_NODE_ID
FROM CSP_NAV_NODE_TYPES NT
, CSP_PLANNING_PARAMETERS CPL
, CSP_SEC_INVENTORIES SI
WHERE NT.ROOT_KEY = 'CSP_PLANNING'
AND NT.NODE_TYPE = 'REGION'
AND CPL.NODE_TYPE IN ('SUBINVENTORY'
, 'REGION'
, 'ORGANIZATION_WH'
, 'ORGANIZATION_ FE')
AND CPL.ORGANIZATION_ID = SI.ORGANIZATION_ID (+)
AND CPL.SECONDARY_INVENTORY = SI.SECONDARY_INVENTORY_NAME (+) ORDER BY 2
, 4
, 1