No results when querying on mrp_end_assemblies

The only way I can get any results is if I go through the apps and view End assemblies via the MRP Workbench for an item.  Then when I run the query for the item org I get only the results displayed in the apps screen.

Is there any initiallization that needs to be done to get results?

SELECT end_assembly_number, end_usage, using_assembly_number,INVENTORY_ITEM_ID

USAGE, end_assembly_id, using_assembly_id

FROM apps.mrp_end_assemblies_v

WHERE organization_id = 1296

AND compile_designator = 'PEM-MRP-CR'

AND inventory_item_id = 2163564

ORDER BY end_assembly_number, using_assembly_number