[Home] [Help]
View: 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
Name |
USAGE_HEADER_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
SECONDARY_INVENTORY |
ITEM_NUMBER |
ITEM_DESCRIPTION |
MIN_QUANTITY |
MAX_QUANTITY |