VIEW: APPS.MRP_END_ASSEMBLIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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