ORACLE ERP & APPS TECH

Query to get Sales Order data ======================== select distinct ooh.CREATION_DATE , Ooh.Order_number  "Sales Order Number", VERSION_NUMBER  "Sales Order Revision Number  ", to_char(ORDERED_DATE,'DD-MM-RRRR')  "Entered Date", (select ORDER_CATEGORY_CODE from apps.oe_transaction_types_all where transaction_type_id = ooh.ORDER_TYPE_ID )  "Order Type",ooh.ORDER_TYPE_ID, Ooh.Quote_number  "Quote Number", ooh.TAX_EXEMPT_FLAG  "Order Taxable  ", (select name from apps.ra_terms where Term_id = ooh.PAYMENT_TERM_ID)  "Payment Terms", ooh.TAX_EXEMPT_NUMBER  "Tax Exempt Id Number", (select p.FIRST_NAME  from apps.fnd_user f,       apps.Per_all_people_f p where f.EMPLOYEE_ID = p.PERSON_ID   and f.user_id = ooh.LAST_UPDATED_BY )  "Last Maintenance - First Name", (select p.LAST_NAME  from apps.fnd_user f,       apps.Per_all_people_f p where f.EMPLOYEE_ID = p.PERSON_ID

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 (                ( ( (Ool.Unit_list_price - Ool.Unit_selling_price)                   / Ool.Unit_lis