• Blog
    • Oracle EBS ERP
      • DBA
      • Developer
      • Application
    • Db2 Database
    • MySQL
  • About Me
  • Skills
  • Education
  • Employment
  • Contact

returned items

  • Home
  • returned items
Returned items up against the purchase order

Find out items returned up against the purchase order to supplier.  SELECT APS.VENDOR_NAME "SUPPLIER", ph.segment1 "PO NUM", MSI.DESCRIPTION, TO_NUMBER (QUANTITY_RECEIVED) " NET RECIEVED", (QUANTITY_SHIPPED - QUANTITY_RECEIVED) "RETURNED", rct.transaction_type, TRUNC (RCT.TRANSACTION_DATE)...

/ Posted by Kapil
Categories
  • Application
  • Db2 Database
  • DBA
  • Developer
  • MySQL
  • Oracle EBS ERP
o
  • Extract & restore single mysql table from backup of databaseSaturday - September 04, 2021
© 2019 KS is proudly powered by Kapil Savaliya.