Oracle EBS (ERP)

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

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;

Oracle Apps Tables Name (Most Ueses)

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