Generate tax invoice for supplier. User have to change currency code in below script as per requirement. /* Formatted on 8/22/2021 11:39:45 AM (QP5 v5.136.908.31019) */ SELECT DISTINCT RCTL.LINE_NUMBER AS...

In depth details of supplier with status of supplier & status of items.   SELECT DISTINCT msi.segment1 "ITEM CODE", pla.item_id, msi.description "ITEM DESCRIPTION", msi.inventory_item_status_code "ITEM STATUS", mp.organization_code, msi.item_type, PV.SEGMENT1 VENDOR_NUMBER, PV.VENDOR_NAME,...