VIEW: APPS.CSP_PLN_REGION_ORG_NAV

Source

View Text - Preformatted

SELECT DECODE(cpl.node_type,'ORGANIZATION_WH',ood.organization_name,'SUBINVENTORY',ood.organization_code ||'.' ||cpl.secondary_inventory,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, org_organization_definitions ood WHERE nt.root_key = 'CSP_PLANNING' AND ood.organization_id (+) = cpl.organization_id 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 DECODE(CPL.NODE_TYPE
, 'ORGANIZATION_WH'
, OOD.ORGANIZATION_NAME
, 'SUBINVENTORY'
, OOD.ORGANIZATION_CODE ||'.' ||CPL.SECONDARY_INVENTORY
, 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
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE NT.ROOT_KEY = 'CSP_PLANNING'
AND OOD.ORGANIZATION_ID (+) = CPL.ORGANIZATION_ID
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