Customer Invoices SQL
Query to get Customer Invoice data =========================== SELECT distinct rct.CREATION_DATE, Rct.Trx_number "Invoice Number", Rctl.Line_number "Invoice Line Number", Rct.Trx_date "Invoice Date", rctl.SALES_ORDER "Sales Order Number", --rctl.INTERFACE_LINE_ATTRIBUTE3 so_line_id,rctl.inventory_item_id,rctl.warehouse_id, rctl.SALES_ORDER_DATE "Sales Order Date", rct.SHIP_DATE_ACTUAL "Ship Date", Ool.Request_date "Customer Required Date", Ool.Promise_date "Promise Date", rct.PURCHASE_ORDER "Customer Purchase Order Number", rctl.QUANTITY_INVOICED "Quantity Sold", rctl.UOM_CODE "Quantity Unit of Measure", rctl.UNIT_SELLING_PRICE "Unit Price", DECODE ( Ool.Unit_list_price, 0, 0, ROUND ( ...