VIEW: APPS.CSP_PLANNING_SUBINV_HDR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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