Key ERP Tables

admin
Below is the list of some of the important Oracle Apps Tables. If you are familiar with any other module and know the technical part of it then please feel free to submit the content and I will post it here. You may just send me the module and the table names. Enjoy!
%post_URL%","12"); ?>

 

FND : fnd_descriptive_flexs, fnd_descr_flex_column_usages

FND_DESCRIPTIVE_FLEXS stores setup information about descriptive flexfields. Each row includes the name of the table that contains the descriptive flexfield columns, the name and title of the flexfield, the identifier of the application with which the flexfield is registered, whether the flexfield is currently frozen, whether this is a protected descriptive flexfield, the name of the structure defining column for the flexfield (CONTEXT_COLUMN_NAME), and other information about how the flexfield is defined. You need one row for each descriptive flexfield in each application. Oracle Application Object Library uses this information to generate a compiled definition for a descriptive flexfield. FND_DESCR_FLEX_COLUMN_USAGES stores the correspondences between application table columns and the descriptive flexfield segments. Each row includes an application identifier, the name of a descriptive flexfield, and a column name. The context field value, also known as the structure name, is in DESCRIPTIVE_FLEX_CONTEXT_CODE. Each row also includes the segment name (END_USER_COLUMN_NAME), the display information about the segment such as prompts, display size, type of default value, whether the segment is required or not, whether the segment is part of a high, low segment pair, whether security is enabled for the segment, whether to display the segment or not, and the value set the segment uses. You need one row for each segment for each context value (structure), including global data element segments, for each descriptive flexfield of each application. Oracle Application Object Library uses this information to create a compiled descriptive flexfield definition to store in the FND_COMPILED_DESCRIPTIVE_FLEXS table. -->

 

Oracle Sysadmin: FND_CONCURRENT_PROGRAMS, FND_CONCURRENT_PROCESSES

 

Oracle Concurrent Requests : FND_CONCURRENT_REQUESTS

 

Oracle concurrent programs table: FND_EXECUTABLES

 

FND_FLEX_VALUE_NORM_HIERARCHY

 

Oracle FND_FLEX_VALUE_SETS

Oracle Workflow tables:WF_ACTIVITIES, WF_ITEMS, WF_NOTIFICATIONS

 

Oracle FND key tables , FND_FLEX_VALUE_HIERARCHIES (4)

 

Oracle FND key tables , FND_FLEX_VALUES (3)

 

Oracle FND key tables , FND_ID_FLEX_STRUCTURES (2)

 

Oracle FND key tables , FND_ID_FLEXS, FND_ID_FLEX_SEGMENTS (1)

 

Oracle Inventory (INV) key tables - mtl_demand (4)

 

Oracle Inventory (INV) key tables - mtl_category_sets_b, mtl_categories_b (3)

 

Oracle Purchasing (PO) key Vendor tables (5)

 

Oracle Fixed Assets (FA) Key Tables fa_categories_b, fa_deprn_detail

Oracle Fixed Assets (FA) Key Tables fa_books

 

Oracle Inventory (INV) key tables - mtl_item_categories, mtl_item_sub_inventories (2)

 

Oracle Inventory (INV) key tables - mtl_system_items (1)

 

Oracle Purchasing (PO) key requisition tables (4)

 

Oracle Purchasing (PO) key table - po_distributions_all (3)

 

Oracle Purchasing (PO) key table - po_lines_all (2)

 

Oracle HRMS (human resource management) HR key Tables (2)

 

Oracle HRMS key Tables (2)

 

Oracle Purchasing (PO) key table - po_headers_all (1)

Oracle Projects key views and tables PA (2)

 

Oracle HRMS key Tables (1)

 

Oracle Projects key Tables PA (1)

 

FA Key Tables fa_additions_b , fa_adjustments (2)

 

Bill of Materials Key tables bom_inventory_components(2)

 

Bill of Materials Key Tables (1)

 

CST (Cost) Key tables cst_cost_types, cst_standard_costs (2)

 

CST (Cost) Key Tables cst_item_costs , cst_item_cost_details (1)

 

WIP Key tables wip_lines , wip_operations (1)

WIP Key tables wip_entities , wip_discrete_jobs, wip_transactions (1)

 

FA Key Tables fa_deprn_summary, fa_deprn_periods (1)

 

Can you count the number of products Oracle has? (2)

 

Can you count the number of products Oracle has? (1)

 

GL Key Tables : GL_sets_of_books, gl_import_references,gl_daily_rates (4)

 

GL Key Tables : GL_lines, gl_periods (3)

 

GL Key Tables : GL_headers, gl_batches (2)

 

GL Key Tables : GL_Balances, gl_code_combinations (1)

 

Oracle Accounts Receivables (AR) - key Tables 3

Oracle Accounts Receivables (AR) - key Tables 2

 

Oracle Accounts Receivables (AR) - key Tables 1

 

Oracle Accounts Payables (AP) - Key Tables 2

Oracle Accounts Payables (AP) - Key Tables 1

Oracle Apps Tables and Brief Description

Comments are closed.