Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. SELECT LISTAGG(PAC.DESCRIPTION || ' = '|| ORL.ITEM_PACKAGE_COUNT , ',')
  2. WITHIN GROUP (ORDER BY PAC.DESCRIPTION || ' = '|| ORL.ITEM_PACKAGE_COUNT)
  3. FROM (SELECT DISTINCT PAC.DESCRIPTION
  4. FROM ORDER_RELEASE_LINE ORL , PACKAGED_ITEM PAC , SHIPMENT SH , ORDER_MOVEMENT OM
  5. WHERE ORL.PACKAGED_ITEM_GID = PAC.PACKAGED_ITEM_GID
  6. AND OM.ORDER_RELEASE_GID = ORL.ORDER_RELEASE_GID
  7. AND OM.SHIPMENT_GID = SH.SHIPMENT_GID
  8. AND SH.SHIPMENT_GID = 'ULA/SAO.5000072118') PAC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement