[Home] [Help]
View: ENG_IMPACTED_BILLS_ERV
View Text
SELECT MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
, ERI.ALTERNATE_BOM_DESIGNATOR
, MIR.REVISION
, MIC.CATEGORY_SET_NAME
, MIC.SEGMENT1||'.'||MIC.SEGMENT2
, MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
FROM MTL_SYSTEM_ITEMS_VL MSI
, MTL_ITEM_REVISIONS MIR
, ENG_REVISED_ITEMS_V ERI
, MTL_ITEM_CATEGORIES_V MIC
WHERE MSI.ORGANIZATION_ID = MIR.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MIR.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = ERI.ORGANIZATION_ID
AND ERI.REVISED_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
Columns
Name |
ASSEMBLY |
DESCRIPTION |
ALTERNATE_BOM_DESIGNATOR |
BILL_REVISION |
CATEGORY_SET_NAME |
CATEGORY |
ASSEMBLY_ITEM_ID |
ORGANIZATION_ID |