VIEW: APPS.CSP_SUBINVENTORIES_V

Source

View Text - Preformatted

SELECT cpp2.NODE_NAME PARENT_NODE, cpp1.PARENT_NODE_ID, cpp1.NODE_NAME, cpp1.PLANNING_PARAMETERS_ID, cpp1.LEVEL_ID, mp.ORGANIZATION_ID, mp.ORGANIZATION_CODE, msi.secondary_inventory_name, FLK.meaning CONDITION_TYPE FROM CSP_PLANNING_PARAMETERS CPP1, CSP_PLANNING_PARAMETERS CPP2, MTL_PARAMETERS MP, MTL_SECONDARY_INVENTORIES MSI,CSP_SEC_INVENTORIES CSE, FND_LOOKUPS FLK WHERE MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID and cpp1.organization_id(+) = msi.organization_id and cpp1.secondary_inventory(+) = msi.secondary_inventory_name and cpp2.planning_parameters_id(+) = cpp1.parent_node_id and cse.organization_id(+) = msi.organization_id and cse.secondary_inventory_name(+) = msi.secondary_inventory_name and flk.lookup_type(+) = 'CSP_CONDITION_TYPE' and flk.lookup_code(+) = cse.condition_type

View Text - HTML Formatted

SELECT CPP2.NODE_NAME PARENT_NODE
, CPP1.PARENT_NODE_ID
, CPP1.NODE_NAME
, CPP1.PLANNING_PARAMETERS_ID
, CPP1.LEVEL_ID
, MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MSI.SECONDARY_INVENTORY_NAME
, FLK.MEANING CONDITION_TYPE
FROM CSP_PLANNING_PARAMETERS CPP1
, CSP_PLANNING_PARAMETERS CPP2
, MTL_PARAMETERS MP
, MTL_SECONDARY_INVENTORIES MSI
, CSP_SEC_INVENTORIES CSE
, FND_LOOKUPS FLK
WHERE MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CPP1.ORGANIZATION_ID(+) = MSI.ORGANIZATION_ID
AND CPP1.SECONDARY_INVENTORY(+) = MSI.SECONDARY_INVENTORY_NAME
AND CPP2.PLANNING_PARAMETERS_ID(+) = CPP1.PARENT_NODE_ID
AND CSE.ORGANIZATION_ID(+) = MSI.ORGANIZATION_ID
AND CSE.SECONDARY_INVENTORY_NAME(+) = MSI.SECONDARY_INVENTORY_NAME
AND FLK.LOOKUP_TYPE(+) = 'CSP_CONDITION_TYPE'
AND FLK.LOOKUP_CODE(+) = CSE.CONDITION_TYPE