Sales Order SQL
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...