Oracle Apps Tables Name (Most Ueses)

General Ledger (GL)

GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
GL_CODE_COMBINATIONS
GL_BALANCES
GL_JE_CATEGORIES_TL
GL_JE_SOURCES_TL

GL_LEDGERS
GL_SETS_OF_BOOKS

 Accounts Payables (AP):


AP_INVOICES_ALL
AP_EXPENSE_REPORT_HEADERS_ALL
AP_INVOICE_RELATIONSHIPS
AP_INVOICE_DISTRIBUTIONS_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_HOLDS_ALL
AP_AE_LINES_ALL
AP_AE_HEADERS_ALL
AP_CHECKS_ALL

 Accounts Receivables (AR):

RA_CUSTOMER_TRX_ALL
RA_CUST_TRX_TYPES_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
AR_PAYMENT_SCHEDULES_ALL
AR_CASH_RECEIPTS_ALL
AR_RECEIVABLES_TRX_ALL
AR_RECEIPT_METHOD_ACCOUNTS_ALL
AR_RECEIVABLE_APPLICATIONS_ALL

Oracle Inventory (INV)

MTL_SYSTEM_ITEMS_B
MTL_SYSTEM_ITEMS_TL
MTL_ITEM_CATEGORIES
MTL_ITEM_SUB_INVENTORIES
MTL_CATEGORIES_B
MTL_CATEGORY_SETS_B
MTL_CATEGORY_SETS_TL
MTL_DEMAND
MTL_ONHAND_QUANTITIES
MTL_MATERIAL_TRANSACTIONS_TEMP
MTL_SYSTEM_ITEMS_FVL
MTL_LOT_NUMBERS
MTL_UNITS_OF_MEASURE_TL
MTL_TXN_SOURCE_TYPES
MTL_MATERIAL_TRANSACTIONS
MTL_TRANSACTION_TYPES
MTL_SECONDARY_INVENTORIES -------Sub Inventory Table
MTL_ITEM_LOCATIONS  -------Locator Table

Purchasing (PO)
PO_HEADERS_ALL
PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_HEADERS_ALL
PO_REQUISITION_LINES
PO_REQ_DISTRIBUTIONS_ALL
PO_VENDORS
PO_VENDOR_SITES_ALL

Order Management (OM)
Entered
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_PRICE_ADJUSTMENTS
OE_ORDER_PRICE_ATTRIBS
OE_ORDER_HOLDS_ALL
Booked
OE_ORDER_HEADERS_ALL
WSH_DELIVERY_DETAILS

Pick Released 
WSH_DELIVERY_DETAILS
WSH_PICKING_BATCHES
MTL_RESERVATIONS

Full Transaction
MTL_MATERIAL_TRANSACTIONS
MTL_TXN_REQUEST_HEADERS
MTL_TXN_REQUEST_LINES
WSH_DELIVERY_DETAILS
WSH_NEW_DELIVERIES
WSH_DELIVERY_ASSIGNMENTS

Pick Confirmed
WSH_DELIVERY_DETAILS
Ship Confirmed
WSH_DELIVERY_DETAILS
MTL_MATERIAL_TRANSACTIONS
WSH_NEW_DELIVERIES
OE_ORDER_LINES_ALL
WSH_DELIVERY_LEGS
OE_ORDER_HEADERS_ALL

Auto invoice
WSH_DELIVERY_DETAILS
RA_INTERFACE_LINES_ALL
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL

Price Details
QP_LIST_HEADERS_B
QP_PRICING_ATTRIBUTES
QP_LIST_LINES

Payment Terms
RA_TERMS
Auto Matic Numbering System
AR_SYSTEM_PARAMETES_ALL

Fixed Assets 
FA_ADDITIONS_B
FA_ADDITIONS_TL
FA_ADJUSTMENTS
FA_ADJUSTMENTS_T

Customer Information
HZ_PARTIES
HZ_PARTY_SITES
HZ_LOCATIONS
HZ_CUST_ACCOUNTS
HZ_CUST_ACCOUNT_SITES_ALL
HZ_CUST_SITE_USES_ALL
HZ_CUSTOMER_PROFILES
HZ_CUST_PROFILE_CLASSES
RA_CUSTOMERS

TAX
JAI_TAX_LINES
JAI_CMN_TAXES_ALL
JAI_PO_TAXES
JAI_CMN_INVENTORY_ORGS
JAI_RGM_REGISTRATIONS
JAI_OM_OE_SO_TAXES

Projects

PA_PROJECTS_ALL



How to print PO file attachments on the PO report (R12)

function CF_ATTACHFormula return Char is
V_ATTACH Varchar2(32000);
V_LONG_TXT LONG(32000);
begin
  SELECT DLT.LONG_TEXT INTO V_LONG_TXT
  /*AD.SEQ_NUM                  ,
  DCT.USER_NAME               ,
  DAT.USER_NAME               ,
  AD.ATTACHED_DOCUMENT_ID     ,
  DET.USER_ENTITY_NAME        ,
  DAT.NAME                    ,
  D.DOCUMENT_ID               ,
  AD.ENTITY_NAME              ,
  AD.PK1_VALUE                ,
  D.MEDIA_ID                  ,
  D.URL                       ,
  DT.TITLE                    ,
  DLT.LONG_TEXT */
FROM FND_DOCUMENT_DATATYPES DAT,
  FND_DOCUMENT_ENTITIES_TL DET    ,
  FND_DOCUMENTS_TL DT             ,
  FND_DOCUMENTS D                 ,
  FND_DOCUMENT_CATEGORIES_TL DCT  ,
  FND_ATTACHED_DOCUMENTS AD       ,
  FND_DOCUMENTS_LONG_TEXT DLT    ,
  PO_HEADERS_ALL    PHA
WHERE D.DOCUMENT_ID       = AD.DOCUMENT_ID
AND DT.DOCUMENT_ID        = D.DOCUMENT_ID
AND DCT.CATEGORY_ID       = D.CATEGORY_ID
AND D.DATATYPE_ID         = DAT.DATATYPE_ID
AND AD.ENTITY_NAME        = DET.DATA_OBJECT_CODE
AND DLT.MEDIA_ID          = D.MEDIA_ID
AND DAT.NAME              = 'LONG_TEXT'
AND ENTITY_NAME = 'PO_HEADERS'
AND AD.PK1_VALUE  = PHA.PO_HEADER_ID
AND PHA.SEGMENT1 = :PO_ORDER;

DECLARE
   f_line       VARCHAR2 (32000);
   f            UTL_FILE.file_type;
   f_dir        VARCHAR2 (250);
   fname        VARCHAR2 (50);
   Comma1       VARCHAR (10);
   Comma2       VARCHAR (10);
   Comma3       VARCHAR (10);
   Comma4       VARCHAR (10);
   Comma5       VARCHAR (10);
 
BEGIN
   f_dir := '/usr/tmp';
   fname := 'TEST.txt';
   f := UTL_FILE.fopen (f_dir, fname, 'r');

 
   LOOP
      BEGIN
        
          UTL_FILE.get_line (f, f_line);
        EXCEPTION
         WHEN NO_DATA_FOUND
         THEN
            EXIT;
      END;

    
   V_ATTACH := V_ATTACH || CHR(10) ||f_line;
   
   SRW.MESSAGE(10001, V_LONG_TXT);

   ---   DBMS_OUTPUT.put_line(  f_line );

     
   END LOOP;

   UTL_FILE.fclose (f);
   COMMIT;
  
   Return V_ATTACH;
  
END;
end;