VIEW: APPS.CSP_PLN_SUBINV_NAV

Source

View Text - Preformatted

SELECT mp.organization_code ||'.' ||cpp.secondary_inventory LABEL, 'SUBINVENTORY' NODE_TYPE, cpp.planning_parameters_id NODE_KEY , DECODE(csii.condition_type,'G','ECGRNFLG','B','ECRDFLG',NULL) ICON_NAME , 'Y' LEAF_FLAG, 'ORGANIZATION' PARENT_NODE_TYPE , cpp.parent_node_id PARENT_NODE_KEY FROM csp_planning_parameters cpp, csp_sec_inventories csii , mtl_parameters mp WHERE cpp.node_type = 'SUBINVENTORY' AND cpp.organization_id = csii.organization_id (+) AND cpp.secondary_inventory = csii.secondary_inventory_name (+) AND mp.organization_id = cpp.organization_id ORDER BY 4,1

View Text - HTML Formatted

SELECT MP.ORGANIZATION_CODE ||'.' ||CPP.SECONDARY_INVENTORY LABEL
, 'SUBINVENTORY' NODE_TYPE
, CPP.PLANNING_PARAMETERS_ID NODE_KEY
, DECODE(CSII.CONDITION_TYPE
, 'G'
, 'ECGRNFLG'
, 'B'
, 'ECRDFLG'
, NULL) ICON_NAME
, 'Y' LEAF_FLAG
, 'ORGANIZATION' PARENT_NODE_TYPE
, CPP.PARENT_NODE_ID PARENT_NODE_KEY
FROM CSP_PLANNING_PARAMETERS CPP
, CSP_SEC_INVENTORIES CSII
, MTL_PARAMETERS MP
WHERE CPP.NODE_TYPE = 'SUBINVENTORY'
AND CPP.ORGANIZATION_ID = CSII.ORGANIZATION_ID (+)
AND CPP.SECONDARY_INVENTORY = CSII.SECONDARY_INVENTORY_NAME (+)
AND MP.ORGANIZATION_ID = CPP.ORGANIZATION_ID ORDER BY 4
, 1