SELECT dha.source_order_number, dha.order_number, dfla.status_code, dfla.source_line_number   FROM  fusion.doo_headers_all dha, fusion.doo_fulfill_lines_all dfla, fusion.wsh_delivery_assignments [...]

SELECT esi.inventory_item_id, esi.item_number, esi.organization_id, inv.organization_code, esi.enabled_flag, esi.end_date_active, ohq.transaction_quantity onhand_qty   FROM [...]

SELECT gjjlv.period_name “Period Name”, gjb.name “Batch Name”, gjjlv.header_name “Journal Entry”, gjjlv.je_source “Source”, [...]

SELECT amount_dr, amount_cr, acctd_amount_dr, acct_amount_cr, gcc.segment1 ||’.’ ||gcc.segment2 ||’.’ ||gcc.segment3 ||’.’ ||gcc.segment4 ||’.’ [...]

SELECT DISTINCT fma.book_type_code, fma.posting_status, fma.description, fcb.segmnet1 major_category, fcb.segment2 minor_category, fma.fixed_assets_units, fma.fixed_assets_cost, (select segment3 [...]

SELECT DISTINCT fb.asset_number, fab.book_type_code, (SELECT   CASE WHEN decode(faab.conversion_date, NULL, [...]

SELECT hou.name Entity_name, tax_type_id, tax_type_code, tax_type_name, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_recovery_ccid) [...]

select distinct hou.name,         a.org_id, a.invoice_id, a.invoice_num, a.invoice_date, a.attribute11 ship_to d.segment4 dist_loc, aps.vendor_name, apsa.vendor_site_code from [...]

select org_id, customer_trx_id, sum(tax) tax, sum(rev) rev, sum(rec) rec, sum(tax)+sum(rev) acutal_rec from ( select org_id, customer_trx_id, case when account_class=’TAX’ then [...]

select * from (select fnar.batch_id, fnar.customer_trx_id, rct.bill_to_customer_id cust_acct_id, rct.bill_to_site_use_id cust_site_use_id, fnar.ar_txn_rank, nvl(fnar.netted_amt,0) as netted_amt, [...]