View: MRP_END_ASSEMBLIES_V

Product:	MRP - Master Scheduling/MRP
Description:	End assemblies view
Implementation/DBA Data:	APPS.MRP_END_ASSEMBLIES_V

View Text

SELECT END.INVENTORY_ITEM_ID
, MTL.ITEM_NUMBER
, MTL2.ITEM_NUMBER
, END.ORGANIZATION_ID
, END.COMPILE_DESIGNATOR
, END.END_ASSEMBLY_ID
, END.USING_ASSEMBLY_ID
, END.END_USAGE
, END.SET_BACK_TIME
, END.USAGE
FROM MRP_END_ASSEMBLIES END
, MTL_ITEM_FLEXFIELDS MTL
, MTL_ITEM_FLEXFIELDS MTL2
WHERE END.END_ASSEMBLY_ID = MTL.INVENTORY_ITEM_ID
AND END.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND END.USING_ASSEMBLY_ID = MTL2.INVENTORY_ITEM_ID
AND END.ORGANIZATION_ID = MTL2.ORGANIZATION_ID

Columns