update extended query to get the part.primary_loc_id for all parts

Legacy Contributor

I am trying to update the extended query for the work order traveler and am having problems getting it to work. I have this query in right now.

SELECT WORK_ORDER.ORIG_STAGE_REVISION_ID , PART.ENGINEERING_MSTR , PART.STAGE_ID , PART.REVISION_ID , PART.PRIMARY_LOC_ID FROM WORK_ORDER , PART WHERE WORK_ORDER.BASE_ID = :WO_BASE_ID AND WORK_ORDER.LOT_ID = :WO_LOT_ID AND WORK_ORDER.SPLIT_ID = :WO_SPLIT_ID AND WORK_ORDER.SUB_ID = '0' AND PART.ID = :WO_PART_ID

This is getting the part info for the work order header card just fine. I need to get the Part.Primary_Loc_ID for ALL parts and print the Primary_Loc_ID on the traveler for each part. right now if I put the primary_Loc_ID next to the part the wrong location is printed or a location is printed next to a resource or other goofy things. Does anyone know how to get this to print the primary_location_Id for all parts.

Thanks
Joel