Finance

--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...

-- Period status for Inventory
  SELECT DISTINCT opu.name            AS operating_unit,
                  per.organization_id AS inv_org_id,
                  par.organization_code AS inv_org_code,
  ...

SELECT DISTINCT
         fab.asset_id,
         fab.asset_number,
         FAT.DESCRIPTION,
         fab.current_units,
         SUM (fdh.units_assigned)                         units_assigned_count,
...

SELECT b.order_number,
       a.line_number,
       a.ordered_item,
       a.line_type_id,
       a.ordered_quantity,
       a.shipped_quantity,
       a.freight_terms_code,
       b.order_type_id
  F...

SELECT cust.party_name                   customer_name,
       cust_acct.account_number,
       cust_uses.site_use_code,
       cust_loc.address1,
       cust_loc.address2,
       cust_loc.address3,
 ...

SELECT GCC.CONCATENATED_SEGMENTS ACCOUNT,
       GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION (GCC.CHART_OF_ACCOUNTS_ID,
                                                 GCC.CODE_COMBINATION_ID)
         ...

SELECT a.org_id                          "ORG ID",
       e.vendor_name                     "VENDOR NAME",
       UPPER (e.vendor_type_lookup_code) "VENDOR TYPE",
       f.vendor_site_code            ...

SELECT 'Receipt'                                               matching,
         pv.vendor_name,
         pv.segment1                                             vendor#,
         pvs.vendor_site_cod...

--
SELECT                                                /*Supplier Information*/
      aps.segment1               oracle_supplier_number,
       aps.vendor_id,
       aps.vendor_name           suppli...