Search from 700 + Posts

Nov 22, 2012

Query to drive Parent Work Order in Oracle eAM

Below is Simple Query to drive Parent Work Order for a Follow-up Work Order in Oracle eAM

 SELECT wr.parent_object_id
   FROM eam_wo_relationships wr,eam_work_orders_v wo
 WHERE wo.wip_entity_id = wr.child_object_id
      AND wo.organization_id = p_org_id
      AND wr.parent_relationship_type = 4 --Followup WO
      AND wo.wip_entity_id = p_wip_entity_id;

No comments:

Post a Comment