View: CSP_PLANNING_SUBINV_HDR_V

Product:	CSP - Spares Management
Description:
Implementation/DBA Data:	APPS.CSP_PLANNING_SUBINV_HDR_V

View Text

SELECT CUH.USAGE_HEADER_ID
, CUH.INVENTORY_ITEM_ID
, CUH.ORGANIZATION_ID
, CUH.SECONDARY_INVENTORY
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MISI.MIN_MINMAX_QUANTITY MIN_QUANTITY
, MISI.MAX_MINMAX_QUANTITY MAX_QUANTITY
FROM CSP_USAGE_HEADERS CUH
, MTL_SYSTEM_ITEMS_B_KFV MSI
, MTL_ITEM_SUB_INVENTORIES MISI
WHERE CUH.HEADER_DATA_TYPE = 1
AND MSI.INVENTORY_ITEM_ID(+) = CUH.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID(+) = CUH.ORGANIZATION_ID
AND MISI.INVENTORY_ITEM_ID(+) = CUH.INVENTORY_ITEM_ID
AND MISI.ORGANIZATION_ID(+) = CUH.ORGANIZATION_ID
AND MISI.SECONDARY_INVENTORY(+) = CUH.SECONDARY_INVENTORY ORDER BY MSI.CONCATENATED_SEGMENTS

Columns