SQL query

ISO Receipt Register -GST Query

SELECT shipment_num, shipped_date, stnno, receipt_num, rcvd_date, send_orgid,        send_orgname, recv_orgid, recv_org_name, gst_no, segment1, description,        lot_num, pri_rec_uom, uomcode, LINK, rcv_qty, iso_price, iso_price_uom,        NVL (tax_amount, 0) tax_amount,        ((rcv_qty *…

Read More

SQL to Find Employee – Supervisor Hierarchy details

Background The Purchase order or Requisitions are not valid unless it is approved. In any of the procurement process, most of the issues occur in the approval of the purchasing…

Read More