Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT LISTAGG(PAC.DESCRIPTION || ' = '|| ORL.ITEM_PACKAGE_COUNT , ',')
- WITHIN GROUP (ORDER BY PAC.DESCRIPTION || ' = '|| ORL.ITEM_PACKAGE_COUNT)
- FROM (SELECT DISTINCT PAC.DESCRIPTION
- FROM ORDER_RELEASE_LINE ORL , PACKAGED_ITEM PAC , SHIPMENT SH , ORDER_MOVEMENT OM
- WHERE ORL.PACKAGED_ITEM_GID = PAC.PACKAGED_ITEM_GID
- AND OM.ORDER_RELEASE_GID = ORL.ORDER_RELEASE_GID
- AND OM.SHIPMENT_GID = SH.SHIPMENT_GID
- AND SH.SHIPMENT_GID = 'ULA/SAO.5000072118') PAC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement