extended query for WO traveller

Legacy Contributor

Does anyone know how I could modify this extended query to also get the Primary location ID from the parts table or if it even possible. I know there is the parts location field in the report but this gives all locations. I just want the primary location.

Select work_order.orig_stage_revision_ID, Part.Engineering_mstr, Part.Stage_ID, Part.Revision_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 gets me the info when the Part ID is the work order header part ID. I would also like to get the Primary location from the part table when the part ID is a requirement part ID. (If this is possible??)

Thanks
Joel

Legacy Contributor

Hi,

You can just add "Part.PRIMARY_WHS_ID, Part.PRIMARY_LOC_ID" to the select statement.

Resulting query:

Select work_order.orig_stage_revision_ID, Part.Engineering_mstr, Part.Stage_ID, Part.Revision_Id, PART.PRIMARY_WHS_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


-Alex