any code quaries put a mail

apps.rocks33@gmail.com

aol important tables in oracle apps

-- FLEX FIELDS (DFF)

Select * from   FND_DESCR_FLEX_CONTEXTS

Select * from   FND_DESCR_FLEX_COL_USAGE_TL

-- FLEX FIELDS (KFF)

Select * from   FND_ID_FLEX_STRUCTURES

Select * from   FND_ID_FLEX_SEGMENTS

--VALUE SETS

Select * from   FND_FLEX_VALUES

--REGISTRATION  & EXECUTABLES

Select * from   FND_EXECUTABLES

--CONCURRENT PROGRAM

Select * from   FND_CONCURRENT_PROGRAMS

--RESPONSIBILITY

Select * from   FND_RESPONSIBILITY_TL

--USERS

Select * from   FND_USER

--REQUESTS

Select * from   FND_CONCURRENT_REQUESTS

--REQUEST SETS

Select * from   FND_REQUEST_SETS

--MULTI ORG TABLES

--BUSINESS GROUPS

Select * from   PER_BUSINESS_GROUPS

--SET OF BOOKS

Select * from   GL_SETS_OF_BOOKS

--LEGAL ENTITIES

Select * from   HR_LEGAL_ENTITIES

--INVENTORY

Select * from   ORG_ORGANIZATION_DEFINITIONS

--OPERATING UNIT

Select * from   HR_OPERATING_UNITS

general ledger(gl)important tables in oracle apps

GENERAL LEDGER TABLES

--CURRENCY

Select * from   FND_CURRENCIES

---PERIOD TYPES

Select * from   GL_PERIOD_TYPES

--CALENDER

Select * from   GL_PERIOD_SETS

Select * from   GL_PERIODS

--CHART OF ACCOUNTS

Select * from   FND_ID_FLEX_STRUCTURES

Select * from   FND_ID_FLEX_SEGMENTS

--LEDGERS

Select * from   GL_LEDGERS

--JOURNAL SOURCES

Select * from   GL_JE_SOURCES

--JOURNAL CATEGIRIES

Select * from   GL_JE_CATEGORIES

--JOURNALS

Select * from   GL_JE_HEADERS

Select * from   GL_JE_LINES

work in process(wip)important tables in oracle apps

WORK IN PROCESS TABLES

--ACCOUNT CLASSES

Select * from   WIP_ACCOUNTING_CLASSES

--WIP PARAMETERS

Select * from   WIP_PARAMETERS

--JOBS

Select * from   WIP_ENTITIES

Select * from   WIP_DISCRETE_JOBS

--MOVE TRANSACTIONS

Select * from   WIP_MOVE_TRANSACTIONS

--JOB OPERATIONS

Select * from   WIP_OPERATIONS

--JOB DEPARTMENT DETAILS

Select * from   WIP_REQUIREMENT_OPERATIONS

--JOB RESOURCES

Select * from   WIP_OPERATION_RESOURCES

bill of materials(bom)important tables in oracle apps

BILL OF MATERIALS TABLES

--ITEM COST

Select * from   CST_ITEM_COST_DETAILS

--RESOURCES

Select * from   BOM_RESOURCES

--RESOURCE COST

Select * from   CST_RESOURCE_COSTS

--DEPARTMENTS

Select * from   BOM_DEPARTMENTS

--DEPARTMENT RESOURCES

Select * from   BOM_DEPARTMENT_RESOURCES

--ROUTINGS

Select * from   BOM_OPERATIONAL_ROUTINGS

Select * from   BOM_OPERATION_SEQUENCES

Select * from   BOM_OPERATION_RESOURCES

--BILLS

Select * from   BOM_BILL_OF_MATERIALS

Select * from   BOM_INVENTORY_COMPONENTS

account receivable(ar)important tables in oracle apps

--ACCOUNT RECIEVABLES TABLES

--TRANSACTIONS(INVOICES)

Select * from   RA_CUSTOMER_TRX_ALL

Select * from   RA_CUSTOMER_TRX_LINES_ALL

Select * from   RA_CUST_TRX_LINE_GL_DIST_ALL

Select * from   RA_CUST_TRX_LINE_SALESREPS_ALL

--CASH RECIEPTS

Select * from   AR_CASH_RECEIPTS_ALL

--INVOICE TYPES

Select * from   RA_CUST_TRX_TYPES_ALL

--SOURCE

Select * from   RA_BATCH_SOURCES_ALL

--SALES REPS

Select * from   RA_SALESREPS_ALL

--PAYMENT TERMS

Select * from   RA_TERMS_TL

Select * from   RA_TERMS_LINES

--RECEIPT PAYMENT METHOD

Select * from   AR_RECEIPT_METHODS

order management(om)important tables in oracle apps

--ORDER MANAGEMENT IMPORTANT TABLES

--ENTERNED

Select * from   OE_ORDER_HEADERS_ALL

Select * from   OE_ORDER_LINES_ALL

--BOOKED

Select * from   OE_ORDER_HEADERS_ALL

Select * from   OE_ORDER_LINES_ALL

Select * from   WSH_DELIVERY_DETAILS

--AUTO CREATE DELIVERIES

Select * from   WSH_NEW_DELIVERIES

--PICKED

Select * from   WSH_DELIVERY_DETAILS

Select * from   WSH_DELIVERY_ASSIGNMENTS

Select * from   WSH_PICKING_BATCHES

Select * from   MTL_MATERIAL_TRANSACTIONS

Select * from   MTL_RESERVATIONS

Select * from   MTL_TXN_REQUEST_HEADERS

Select * from   MTL_TXN_REQUEST_LINES

--SHIPPED

Select * from   OE_ORDER_LINES_ALL

Select * from   WSH_DELIVERY_DETAILS

Select * from   MTL_MATERIAL_TRANSACTIONS

--CLOSED    --YOU NEED TO RUN WORKFLOW BACKGROUND PROCESS

--ITEM_TYPE:-OM ORDER_LINE-----TO CLOSE THE LINE

--ITEM_TYPE:--OM ORDER_HEADER------TO CLOSE THE HEADER

Select * from   OE_ORDER_HEADERS_ALL  --FLOW_STATUS_CODE-:CLOSED

Select * from   OE_ORDER_LINES_ALL    --FLOW_STATUS_CODE-:CLOSED

Select * from   WSH_DELIVERY_DETAILS    --STATUS:-C

--AR INTERFACE_TABLES        ----->WORKFLOW BACKGROUND PROCESS
--WILL TRANSAFER THE RECORDS FROM OM TO AR INTERFACE TABLES
--SOURCE=ORDER_ENTRY

Select * from   RA_INTERFACE_LINES_ALL

Select * from   RA_INTERFACE_DISTRIBUTIONS_ALL

--AR BASE TABLES   --AUTO INVOICE IMPORT PROGRAM WILL 
--BE RUN THEN RECORDS SHOULD BE PRESENT IN AR BASE TABLES

Select * from   RA_CUSTOMER_TRX_ALL

Select * from   RA_CUSTOMER_TRX_LINES_ALL

Select * from   RA_CUST_TRX_LINE_GL_DIST_ALL

--CUSTOMERS

Select * from   HZ_PARTIES

Select * from   HZ_CUST_ACCOUNTS

--CUSTOMER SITES

Select * from   HZ_PARTY_SITES

Select * from   HZ_LOCATIONS

--SITE PURPOSES

Select * from   HZ_CUST_ACCT_SITES_ALL

Select * from   HZ_CUST_SITE_USES_ALL

--ORDER TYPES

Select * from   OE_TRANSACTION_TYPES_TL

--SALES REPS

Select * from   RA_SALESREPS_ALL

--CHARGES

Select * from   OE_CHARGE_LINES_V

--PRICE LIST

Select * from   QP_LIST_HEADERS

Select * from   QP_LIST_LINES

Select * from   QP_PRICING_ATTRIBUTES

--BANKS

Select * from   AP_BANK_ACCOUNTS_ALL

--BANK BRANCHES

Select * from   AP_BANK_ACCOUNT_USES_ALL

--BANK ACCT USES

Select * from AP_BANK_BRANCHES