Thursday, November 7, 2013

Pending Shop Floor Move Query



Select 'Pending Shop Floor Move' ||'~'||
       Ood.Organization_code ||'~'||
       to_char(Wip.Creation_date,'DD-MON-RRRR HH24:MI:SS') ||'~'||
       Wip.Transaction_id ||'~'||
       Msi.Segment1 ||'~'||
       Wip.Transaction_quantity ||'~'||
       Wip.Wip_entity_name ||'~'||
       Wip.Created_by_name ||'~'||
       Wip.Transaction_type ||'~'||
       Wip.Group_id ||'~'||
       Wip.Request_id ||'~'||
       Wip.Process_status ||'~'||
       Wip.Organization_id   l_out
  From Wip_move_txn_interface Wip,
       Org_organization_definitions Ood,
       Mtl_system_items_b Msi
   Where Wip.Organization_id = Ood.Organization_id(+)
   And Msi.Inventory_item_id(+) = Wip.Primary_item_id
   And Msi.Organization_id(+) = Wip.Organization_id
   and ood.organization_id = nvl(p_org_id,ood.organization_id)
   and (:p_minutes is null or wip.creation_date < SYSDATE - (:p_minutes/(24*60)) )
   order by ood.organization_code, Wip.creation_date;

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.