All Posts

SELECT terr.territory_short_name country,
         hr.name                 operating_unit,
         loc.address1,
         acctsites.cust_acct_site_id,
         acctsites.party_site_id,
         accts...

--Credit card bank details
SELECT * FROM AP_CARD_PROGRAMS_ALL


--Employee credit card details
SELECT ac.ROWID        row_id,
       ac.employee_id,
       ac.card_number,
       ac.card_id,
       ac...

SELECT DISTINCT rtl.responsibility_name,
                ff.function_name,
                ffl.user_function_name,
                usr.user_name
  FROM fnd_compiled_menu_functions cmf,
       fnd_form...

--Tax rate and account query

  SELECT rb.tax_regime_code,
         rb.tax,
         rb.rate_type_code,
         rb.percentage_rate,
         rb.last_update_date,
         za.last_update_date,
       ...

--Customer Account Tax Registration Details

SELECT party_name,
       account_number,
       ps.party_site_number,
       (SELECT LISTAGG (al.meaning, ', ') WITHIN GROUP (ORDER BY al.meaning)
       ...

--Sales order and lines details query

  SELECT ooha.order_number,
         ott.name order_type,
         ooha.cust_po_number,
         ooha.fob_point_code     fob,
         ooha.flow_status_code   "O...

--PO Requisition Debug XML

SELECT por.segment1 REQ_NUMBER,
       por.requisition_header_id,
       porl.line_num,
       VT.REQUEST_ID,
       debug.REQUEST_NAME,
       debug.MESSAGE_TYPE,
       d...

--PO Debug XML

SELECT poh.segment1     PO_NUMBER,
       poh.po_header_id po_header_id,
       pol.line_num,
       VT.REQUEST_ID,
       debug.REQUEST_NAME,
       debug.MESSAGE_TYPE,
       debug.x...

--AP Invoice debug xml

SELECT ap.invoice_num,
       ap.invoice_id trx_id,
       VT.REQUEST_ID,
       debug.REQUEST_NAME,
       debug.MESSAGE_TYPE,
       debug.xml
     --,vt.*
  FROM apps.ap_inv...

--AR Invoice debug xml

SELECT AR.TRX_NUMBER,
       rctl.line_number     line#,
       rctl.customer_trx_id trx_id,
       VT.REQUEST_ID,
       debug.REQUEST_NAME,
       debug.MESSAGE_TYPE,
       ...

SELECT ITEM_TYPE,
         ITEM_KEY,
         invoice_num,
         BEGIN_DATE,
         Q.END_DATE,
         ROOT_ACTIVITY
    FROM apps.WF_ITEMS Q, apps.AP_INVOICES_ALL
   WHERE     Q.ITEM_TYPE = 'A...

SELECT fu.user_name            "User Name",
         frt.responsibility_name "Responsibility Name",
         furg.start_date         "Start Date",
         furg.end_date           "End Date",
        ...