Follow us: Subscribe via RSS Feed Connect on YouTube Connect on YouTube

Pages

Friday, 27 May 2016

Oracle Apps Tables and Use



FOR FORMS


SELECT * FROM FND_FORM WHERE FORM_NAME = 'EMPANDDEPT' --ALL FORMS


SELECT * FROM FND_FORM_FUNCTIONS WHERE FORM_ID=59986  --ALL FUNCTIONS


SELECT TNAME FROM TAB WHERE TNAME LIKE 'FND_PROF%'


SELECT * FROM FND_MENUS_VL WHERE MENU_NAME='FORMS MENU' --ALL MENUS


SELECT * FROM FND_RESPONSIBILITY_VL WHERE MENU_ID=1014197 --ALL RESPONSIBILITIES


 


FOR REPORTS


SELECT * FROM FND_EXECUTABLES WHERE EXECUTABLE_NAME='GL_LOAD' -- FOR EXECUTABLES


SELECT * FROM FND_CONCURRENT_PROGRAMS_VL WHERE EXECUTABLE_ID=13237 --FOR CONCURRENT PROGRAMS


SELECT * FROM FND_REQUEST_GROUPS WHERE APPLICATION_ID=20064 AND REQUEST_GROUP_NAME='All Reports' --FOR REQUEST GROUPS


SELECT * FROM FND_REQUEST_GROUP_UNITS    --> Concurrent programs assigned to Request group


SELECT * FROM FND_RESPONSIBILITY WHERE REQUEST_GROUP_ID=1001313 --FOR RESPONSE


SELECT * FROM FND_USER --FOR USERS


SELECT * FROM FND_CONCURRENT_REQUESTS  --USER_ID=REQUESTED_BY


SELECT * FROM FND_USER_RESP_GROUPS_DIRECT


 


VALUESETS


SELECT * FROM FND_FLEX_VALUE_SETS        --> VALUE SET INFO


SELECT * FROM FND_FLEX_VALUES            --> VALUES ASSIGNED TO THE VALUESET


 


FOR FLEXFIELDS


SELECT * FROM FND_DESCRIPTIVE_FLEXS_VL WHERE TITLE = 'Requisition Headers'--FOR DESCRIPTIVE FLEXFIELDS


SELECT * FROM FND_ID_FLEXS WHERE ID_FLEX_CODE='GL#' --FOR NAME OF THE KEY FLEXFIELDS


SELECT * FROM FND_ID_FLEX_STRUCTURES WHERE ID_FLEX_CODE ='GL#' AND ID_FLEX_STRUCTURE_CODE='OPERATIONS_ACCOUNTING_FLEX'


   --FOR KEY FLEXFIELDS(CONTAINS STRUCTURES)


 


FOR PROFILES


SELECT * FROM FND_PROFILE_OPTIONS_VL WHERE USER_PROFILE_OPTION_NAME ='MO: Operating Unit' --FOR PROFILES  


HOW TO FIND OUT HOWMANY RESP_NAMES FOR PARTICULAR USER


======================================================


SELECT FU.USER_NAME,


       FR.RESPONSIBILITY_NAME


  FROM FND_USER FU,


       FND_RESPONSIBILITY_VL FR,


       FND_USER_RESP_GROUPS_DIRECT FUR


 WHERE FU.USER_ID=FUR.USER_ID


   AND FUR.RESPONSIBILITY_ID=FR.RESPONSIBILITY_ID


   AND FU.USER_NAME='OPERATIONS'


 


HOW TO FIND OUT THE LIST OF CONC_PROGRAMS EXECUTED BY USER FOR DAY


==================================================================


SELECT FE.EXECUTABLE_NAME,


       FE.EXECUTION_FILE_NAME,


       FCP.CONCURRENT_PROGRAM_NAME,


       FCP.USER_CONCURRENT_PROGRAM_NAME,


       FRG.REQUEST_GROUP_NAME,


       FR.RESPONSIBILITY_NAME


 FROM  FND_USER FU,


       FND_CONCURRENT_REQUESTS FCR,


       FND_CONCURRENT_PROGRAMS_VL FCP,


       FND_EXECUTABLES FE,


       FND_RESPONSIBILITY_VL FR,


       FND_REQUEST_GROUPS FRG


WHERE  FU.USER_ID=FCR.REQUESTED_BY


  AND  FCR.CONCURRENT_PROGRAM_ID=FCP.CONCURRENT_PROGRAM_ID


  AND  FCP.EXECUTABLE_ID = FE.EXECUTABLE_ID


  AND  FCR.RESPONSIBILITY_ID=FR.RESPONSIBILITY_ID


  AND  FRG.REQUEST_GROUP_ID=FR.REQUEST_GROUP_ID


  AND  TO_DATE(FCR.REQUEST_DATE)=TO_DATE(SYSDATE)


  AND  FU.USER_NAME='OPERATIONS'


 


PURCHASE ORDER :


1. PO_REQUISITION_HEADERS_ALL --> REQUISITION HEADER INFO


2. PO_REQUISITION_LINES_ALL   --> REQUISITION LINES INFO


3. PO_REQ_DISTRIBUTIONS_ALL   --> REQUISITION DISTRIBUTION  INFO


4. PO_HEADERS_ALL             --> PO HEADER INFO


5. PO_LINES_ALL               --> PO LINES INFO


6. PO_LINE_LOCATIONS_ALL      --> PO LINE SHIPMENT INFO


7. PO_DISTRIBUITIONS_ALL      --> PO ACCOUNTING INFO


8. RCV_SHIPMENT_HEADERS_ALL   --> RECEIVING HEADER INFO


9. RCV_SHIPMENT_LINES_ALL     --> RECEIVING LINES INFO


10.RCV_TRANSACTIONS          --> RECEIVING TRANSACTIONS INFO


11.PO_VENDORS                 --> VENDOR INFO


12.PO_VENDOR_SITES_ALL        --> VENDOR SITE INFO


13.PO_VENDOR_CONTACTS         --> VENDOR CONTACT INFO


14.HR_LOCATIONS               --> SUPPLIER PHYSICAL ADDRESS INFO


15.PO_LOOKUPS                 --> PO LOOKUP INFO


 


ACCOUNTS PAYABLE :


1. AP_INVOICES_ALL               --> INVOICE HEADER INFO


2. AP_INVOICE_DISTRIBUTIONS_ALL  --> INVOICE LINES INFO


3. AP_TERMS                      --> PAYMENT TERMS INFO


4. AP_PAYMENT_SCHEDULES_ALL      --> PAYMENT SCHEDULE INFO


5. AP_INVOICE_PAYMENTS_ALL       --> INVOICE PAYMENT INFO


6. AP_CHECKS_ALL                 --> CHECK INFO


7. AP_ACCOUNTING_EVENTS_ALL      --> INVOICE ACCOUNTING EVENT INFO


8. AP_AE_HEADERS_ALL             --> ACCOUNTING HEADER INFO


9. AP_AE_LINES_ALL               --> ACCOUNTING LINES INFO


10.AP_BANKS                      --> SUPPLIER BANK INFO


11.AP_BANK_BRANCHES              --> SUPPLIER BANK BRANCHES


12.AP_LOOKUPS                    --> INVOCE LOOKUPS


13.AP_SUPPLIERS S                    --> SUPPLIERS INFO


14.AP_SUPPLIER_SITES_ALL           --> SUPPLIERS SITE INFO


15.AP_SUPPLIER_CONTACTS            --> SUPPLIERS CONTACT INFO


16.HR_LOCATIONS                  --> SUPPLIER PHYSICAL ADDRESS INFO


ORDER MANAGEMENT :


1. OE_ORDER_HEADERS_ALL     --> ORDER HEADER INFO


2. OE_ORDER_LINES_ALL       --> ORDER LINES INFO


3. OE_TRANSACTION_TYPE_TL   --> ORDER TYPES INFO


4. QP_LIST_HEADERS_TL       --> PRICE LIST NAME


5. RA_SALESREPS_ALL         --> SALES PERSONS INFO


6. WSH_DELIVERY_DETAILS     --> DELIVERY DETAILS INFO


7. WSH_NEW_DELIVERIES       --> DELIVERY HEADER INFO


8. WSH_DELIVERY_ASSIGNMENTS --> DELIVERY ASSIGNMENTS INFO


9. WSH_TRIPS                --> DELIVERY TRIPS INFO


10.OE_HOLDS_ALL             --> ORDER HOLDS INFO


11.OE_HOLD_SOURCES_ALL      --> ORDER HOLD SOURCE INFO


12.OE_HOLD_DEFINITIONS_ALL  --> ORDER HOLD DEFINITIONS INFO


13.OE_HOLD_RELEASES_ALL     --> ORDER HOLD RELEASE INFO


14.HZ_CUST_ACCOUNTS         --> CUST ACCOUT INFO


15.HZ_PARTIES               --> PARTY INFO


16.HZ_CUST_SITE_USES_ALL    --> CUSTOMER SITE INFO


17.HZ_CUST_ACCT_SITES_ALL   --> CUSTOMER SITE ACCOUNT INFO


18.HZ_PARTY_SITES           --> PARTY SITE INFO


19.HZ_LOCATIONS             --> CUSTOMER PHYSICAL ADDRESS INFO


ACCOUNTS RECEIVABLE :


1. RA_CUSTOMER_TRX_ALL            --> TRANSACTION HEADER INFO


2. RA_CUSTOMER_TRX_LINES_ALL      --> TRANSACTION LINES INFO


3. RA_CUST_TRX_LINE_GL_DIST_ALL   --> TRANSACTION DISTRIBUTION INFO


4. AR_PAYMENT_SCHEDULES_ALL       --> CUSTOMER PAYMENT SCHEDULE INFO


5. RA_CUST_TRX_TYPES_ALL          --> TRANSACTION TYPE INFO


6. AR_CASH_RECEIPTS_ALL           --> RECEIPT HEADER INFO


7. AR_RECEIVABLE_APPLICATIONS_ALL --> RECEIPT APPLIED INFO


8. AR_RECEIPT_METHODS             --> RECEIPT METHOD INFO


9. AR_INTERIM_CASH_RECEIPTS_ALL   --> INTERIM RECEIPTS INFO


10.HZ_CUST_ACCOUNTS               --> CUST ACCOUT INFO


11.HZ_PARTIES                     --> PARTY INFO


12.HZ_CUST_SITE_USES_ALL          --> CUSTOMER SITE INFO


13.HZ_CUST_ACCT_SITES_ALL         --> CUSTOMER SITE ACCOUNT INFO


14.HZ_PARTY_SITES                 --> PARTY SITE INFO


15.HZ_LOCATIONS                   --> CUSTOMER PHYSICAL ADDRESS INFO


INVENTORY MODULUE :


1. MTL_SYSTEM_ITEMS_B        --> ITEM INFO


2. MTL_ONHAND_QUANTITIES     --> ITEM ONHAND QTY INFO


3. MTL_RESERVATIONS          --> ITEM RESERVATIONS INFO


4. MTL_MATERIAL_TRANSACTIONS --> ITEM TRANSACTIONS INFO


5. MTL_TRANSACTION_TYPES     --> ITEM TRANSACTION TYPES INFO


6. MTL_TXN_SOURCE_TYPES      --> ITEM TRANSACTION SOURCE INFO


7. MTL_TXN_REQUEST_HEADERS   --> MOVE ORDER HEADER INFO


8. MTL_TXN_REQUEST_LINES     --> MOVE ORDER LINES INFO


9. MTL_ITEM_LOCATORS         --> ITEM LOCATOR INFO


10.MTL_CATEGORIES            --> INVENTORY CATEGORIES


11.MTL_ITEM_CATEGORIES       --> INVENTORY ITEM CATEGORIES


12.MTL_PARAMETERS            --> INVENTORY PARAMETERS


13.ORG_ORGANIZATION_DEFINITIONS --> ORGANIZATION INFO


14.MTL_SECONDARY_INVENTORIES    --> SUBINVENTORY INFO


 


GENERAL LEDGER (GL)  :


1. GL_JE_HEADERS     -- JOURNAL HEADER INFO


2. GL_JE_LINES       -- JOURNAL LINES INFO


3. GL_JE_BATCHES     -- JOURNAL BATCH INFO


4. GL_BALANCES       -- JOURNAL BALANCES


5. GL_SETS_OF_BOOKS  -- SET OF BOOKS INFO


6. GL_CHART_OF_ACCOUNTS -- CHART OF ACCOUNTS INFO


7. GL_CODE_COMBINATIONS -- CODE COMBINATIONS INFO


8. GL_JE_SOURCES        -- JOURNAL SOURCE INFO


9. GL_JE_CATEGORIES     -- JOURNAL CATEGORY INFO


10.GL_DAILY_RATES       -- DAILY RATES INFO


11.FND_CURRENCIES       -- CURRENCY INFO


12.GL_PERIODS           -- ACCOUNTING PERIODS INFO


13.GL_PERIOD_SETS       -- ACCOUNTING PERIOD SET INFO


 


 


 

Share this article :

0 comments:

Post a Comment