Friday, 19 April 2013

GL TABLES

Oracle Apps GL Base Table and Interface Table
                           
GL_JE_HEADERS                      GL_INTERFACE
GL_JE_LINES                             GL_INTERFACE_HISTORY
GL_JE_CATEGORIES                GL_DAILY_RATES_INTERFACE  
GL_JE_SOURCES                      GL_BUDGET_INTERFACE
GL_SETS_OF_BOOKS              GL_IEA_INTERFACE
GL_DAILY_RATES
GL_CODE_COMBINATIONS
GL_BALANCES
GL_PERIODS
GL_PERIOD_SETS
GL_CURRENCIES
GL_HISTORICAL_RATES
GL_LOOKUPS   


---------------------------------------------------------------------------------

  
Oracle Apps  :  Link between GL to Subledger Account

GL_JE_BATCHES (je_batch_id)                                   => GL_JE_HEADERS (je_batch_id)

GL_JE_HEADERS (je_header_id)                                  => GL_JE_LINES (je_header_id)

GL_JE_LINES (je_header_id,  je_line_num)                      => GL_IMPORT_REFERENCES (je_header_id, je_line_num)

GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id)        => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id)

XLA_AE_LINES (application_id, ae_header_id)                   => XLA_AE_HEADERS (application_id, ae_header_id) 

XLA_AE_HEADERS (application_id, event_id)                     => XLA_EVENTS (application_id, event_id)  

XLA_EVENTS (application_id, entity_id)                        => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id) 

PO 11i AND R12 TABLES

Oracle Apps :      Purchasing (PO)
SR.#R11R12
Table NameTable Name
1CHV_AUTHORIZATIONSCHV_AUTHORIZATIONSSAME
2CHV_BUCKET_PATTERNSCHV_BUCKET_PATTERNSSAME
3CHV_CUM_ADJUSTMENTSCHV_CUM_ADJUSTMENTSSAME
4CHV_CUM_PERIOD_ITEMSCHV_CUM_PERIOD_ITEMSSAME
5CHV_CUM_PERIODSCHV_CUM_PERIODSSAME
6CHV_HISTORY_CUM_PERIODSCHV_HISTORY_CUM_PERIODSSAME
7CHV_HISTORY_SCHEDULESCHV_HISTORY_SCHEDULESSAME
8CHV_HORIZONTAL_SCHEDULESCHV_HORIZONTAL_SCHEDULESSAME
9CHV_ITEM_ORDERSCHV_ITEM_ORDERSSAME
10CHV_ORG_OPTIONSCHV_ORG_OPTIONSSAME
11CHV_PURGE_CUM_LISTCHV_PURGE_CUM_LISTSAME
12CHV_PURGE_SCHEDULE_LISTCHV_PURGE_SCHEDULE_LISTSAME
13CHV_SCHEDULE_HEADERSCHV_SCHEDULE_HEADERSSAME
14CHV_SCHEDULE_ITEMSCHV_SCHEDULE_ITEMSSAME
15CHV_SCHEDULE_ORGANIZATIONSCHV_SCHEDULE_ORGANIZATIONSSAME
16EDW_PO_VENDOR_HIERARCHIESEDW_PO_VENDOR_HIERARCHIESSAME
17FND_FUNCTION_PARAMETER_MAPFND_FUNCTION_PARAMETER_MAPSAME
18FND_NOTIFICATIONSFND_NOTIFICATIONSSAME
19MLOG$_PO_COMMODITY_CATEGORMLOG$_PO_COMMODITY_CATEGORSAME
20MLOG$_PO_VENDOR_SITES_ALLDELETED
21MLOG$_PO_VENDORSDELETED
22PO_ACCEPTANCESPO_ACCEPTANCESSAME
23PO_ACCRUAL_ACCOUNTS_TEMP_ALLPO_ACCRUAL_ACCOUNTS_TEMP_ALLSAME
24PO_ACCRUAL_RECONCILE_TEMP_ALLDELETED
25PO_ACCRUAL_WRITE_OFFS_ALLPO_ACCRUAL_WRITE_OFFS_ALLSAME
26PO_ACCRUAL_WRITE_OFFS_ALL_EFCPO_ACCRUAL_WRITE_OFFS_ALL_EFCSAME
27PO_ACTION_HISTORYPO_ACTION_HISTORYSAME
28PO_ADDRESS_DETAILS_GTPO_ADDRESS_DETAILS_GTSAME
29PO_AGENTSPO_AGENTSSAME
30PO_APPROVAL_LIST_HEADERSPO_APPROVAL_LIST_HEADERSSAME
31PO_APPROVAL_LIST_LINESPO_APPROVAL_LIST_LINESSAME
32PO_APPROVED_SUPPLIER_LISTPO_APPROVED_SUPPLIER_LISTSAME
33PO_ASL_ATTRIBUTESPO_ASL_ATTRIBUTESSAME
34PO_ASL_DOCUMENTSPO_ASL_DOCUMENTSSAME
35PO_ASL_STATUS_RULESPO_ASL_STATUS_RULESSAME
36PO_ASL_STATUSESPO_ASL_STATUSESSAME
37PO_ATT_TMP_RECORDSPO_ATT_TMP_RECORDSSAME
38PO_AUTOSOURCE_DOCUMENTS_ALLPO_AUTOSOURCE_DOCUMENTS_ALLSAME
39PO_AUTOSOURCE_RULESPO_AUTOSOURCE_RULESSAME
40PO_AUTOSOURCE_VENDORSPO_AUTOSOURCE_VENDORSSAME
41PO_CHANGE_REQUESTSPO_CHANGE_REQUESTSSAME
42PO_COMMODITIES_BPO_COMMODITIES_BSAME
43PO_COMMODITIES_TLPO_COMMODITIES_TLSAME
44PO_COMMODITY_CATEGORIESPO_COMMODITY_CATEGORIESSAME
45PO_COMMODITY_GRANTSPO_COMMODITY_GRANTSSAME
46PO_COMMUNICATION_GTPO_COMMUNICATION_GTSAME
47PO_CONTROL_FUNCTIONSPO_CONTROL_FUNCTIONSSAME
48PO_CONTROL_GROUPS_ALLPO_CONTROL_GROUPS_ALLSAME
49PO_CONTROL_RULESPO_CONTROL_RULESSAME
50PO_CONTROL_RULES_EFCPO_CONTROL_RULES_EFCSAME
51PO_DISTRIBUTIONS_ALLPO_DISTRIBUTIONS_ALLSAME
52PO_DISTRIBUTIONS_ALL_EBSPO_DISTRIBUTIONS_ALL_EBSSAME
53PO_DISTRIBUTIONS_ARCHIVE_ALLPO_DISTRIBUTIONS_ARCHIVE_ALLSAME
54PO_DISTRIBUTIONS_GTPO_DISTRIBUTIONS_GTSAME
55PO_DISTRIBUTIONS_INTERFACEPO_DISTRIBUTIONS_INTERFACESAME
56PO_DOCUMENT_TYPES_ALL_BPO_DOCUMENT_TYPES_ALL_BSAME
57PO_DOCUMENT_TYPES_ALL_TLPO_DOCUMENT_TYPES_ALL_TLSAME
58PO_EMPLOYEE_HIERARCHIES_ALLPO_EMPLOYEE_HIERARCHIES_ALLSAME
59PO_ENCUMBRANCE_GTPO_ENCUMBRANCE_GTSAME
60PO_GA_ORG_ASSIGNMENTSPO_GA_ORG_ASSIGNMENTSSAME
61PO_GA_ORG_ASSIGNMENTS_ARCHIVEPO_GA_ORG_ASSIGNMENTS_ARCHIVESAME
62PO_HAZARD_CLASSES_BPO_HAZARD_CLASSES_BSAME
63PO_HAZARD_CLASSES_TLPO_HAZARD_CLASSES_TLSAME
64PO_HEADERS_ALLPO_HEADERS_ALLSAME
65PO_HEADERS_ALL_EBSPO_HEADERS_ALL_EBSSAME
66PO_HEADERS_ARCHIVE_ALLPO_HEADERS_ARCHIVE_ALLSAME
67PO_HEADERS_GTPO_HEADERS_GTSAME
68PO_HEADERS_INTERFACEPO_HEADERS_INTERFACESAME
69PO_HISTORY_POS_ALLPO_HISTORY_POS_ALLSAME
70PO_HISTORY_RECEIPTSPO_HISTORY_RECEIPTSSAME
71PO_HISTORY_REQUISITIONS_ALLPO_HISTORY_REQUISITIONS_ALLSAME
72PO_HISTORY_VENDORSPO_HISTORY_VENDORSSAME
73PO_INTERFACE_ERRORSPO_INTERFACE_ERRORSSAME
74PO_JOB_ASSOCIATIONS_BPO_JOB_ASSOCIATIONS_BSAME
75PO_JOB_ASSOCIATIONS_TLPO_JOB_ASSOCIATIONS_TLSAME
76PO_LINE_LOCATIONS_ALLPO_LINE_LOCATIONS_ALLSAME
77PO_LINE_LOCATIONS_ALL_EBSPO_LINE_LOCATIONS_ALL_EBSSAME
78PO_LINE_LOCATIONS_ARCHIVE_ALLPO_LINE_LOCATIONS_ARCHIVE_ALLSAME
79PO_LINE_LOCATIONS_GTPO_LINE_LOCATIONS_GTSAME
80PO_LINE_TYPES_BPO_LINE_TYPES_BSAME
81PO_LINE_TYPES_TLPO_LINE_TYPES_TLSAME
82PO_LINES_ALLPO_LINES_ALLSAME
83PO_LINES_ALL_EBSPO_LINES_ALL_EBSSAME
84PO_LINES_ARCHIVE_ALLPO_LINES_ARCHIVE_ALLSAME
85PO_LINES_GTPO_LINES_GTSAME
86PO_LINES_INTERFACEPO_LINES_INTERFACESAME
87PO_LOCATION_ASSOCIATIONS_ALLPO_LOCATION_ASSOCIATIONS_ALLSAME
88PO_MASSCANCEL_INCLUDES_ALLPO_MASSCANCEL_INCLUDES_ALLSAME
89PO_MASSCANCEL_INTERIMPO_MASSCANCEL_INTERIMSAME
90PO_MC_DISTRIBUTIONSPO_MC_DISTRIBUTIONSSAME
91PO_MC_HEADERSPO_MC_HEADERSSAME
92PO_NOTE_ATTRIBUTESPO_NOTE_ATTRIBUTESSAME
93PO_NOTE_REFERENCESPO_NOTE_REFERENCESSAME
94PO_NOTESPO_NOTESSAME
95PO_NOTIFICATION_CONTROLSPO_NOTIFICATION_CONTROLSSAME
96PO_NOTIFICATIONS_ALLPO_NOTIFICATIONS_ALLSAME
97PO_ONLINE_REPORT_TEXTPO_ONLINE_REPORT_TEXTSAME
98PO_ONLINE_REPORT_TEXT_GTPO_ONLINE_REPORT_TEXT_GTSAME
99PO_POSITION_CONTROLS_ALLPO_POSITION_CONTROLS_ALLSAME
100PO_PRICE_DIFF_INTERFACEPO_PRICE_DIFF_INTERFACESAME
101PO_PRICE_DIFFERENTIALSPO_PRICE_DIFFERENTIALSSAME
102PO_PRICE_DIFFERENTIALS_ARCHIVEPO_PRICE_DIFFERENTIALS_ARCHIVESAME
103PO_PURGE_PO_LISTPO_PURGE_PO_LISTSAME
104PO_PURGE_REQ_LISTPO_PURGE_REQ_LISTSAME
105PO_PURGE_VENDOR_LISTPO_PURGE_VENDOR_LISTSAME
106PO_QUALITY_CODESPO_QUALITY_CODESSAME
107PO_QUOTATION_APPROVALS_ALLPO_QUOTATION_APPROVALS_ALLSAME
108PO_RELATED_TEMPLATESPO_RELATED_TEMPLATESSAME
109PO_RELEASES_ALLPO_RELEASES_ALLSAME
110PO_RELEASES_ALL_EBSPO_RELEASES_ALL_EBSSAME
111PO_RELEASES_ARCHIVE_ALLPO_RELEASES_ARCHIVE_ALLSAME
112PO_RELEASES_GTPO_RELEASES_GTSAME
113PO_REQ_DIST_INTERFACE_ALLPO_REQ_DIST_INTERFACE_ALLSAME
114PO_REQ_DISTRIBUTIONS_ALLPO_REQ_DISTRIBUTIONS_ALLSAME
115PO_REQ_DISTRIBUTIONS_ALL_EFCPO_REQ_DISTRIBUTIONS_ALL_EFCSAME
116PO_REQ_DISTRIBUTIONS_GTPO_REQ_DISTRIBUTIONS_GTSAME
117PO_REQ_HEADERS_GTPO_REQ_HEADERS_GTSAME
118PO_REQ_LINES_GTPO_REQ_LINES_GTSAME
119PO_REQ_SPLIT_LINES_GTPO_REQ_SPLIT_LINES_GTSAME
120PO_REQEXPRESS_HEADERS_ALLPO_REQEXPRESS_HEADERS_ALLSAME
121PO_REQEXPRESS_LINES_ALLPO_REQEXPRESS_LINES_ALLSAME
122PO_REQUISITION_HEADERS_ALLPO_REQUISITION_HEADERS_ALLSAME
123PO_REQUISITION_LINES_ALLPO_REQUISITION_LINES_ALLSAME
124PO_REQUISITION_LINES_ALL_EFCPO_REQUISITION_LINES_ALL_EFCSAME
125PO_REQUISITION_SUPPLIERSPO_REQUISITION_SUPPLIERSSAME
126PO_REQUISITIONS_INT_ALL_EFCPO_REQUISITIONS_INT_ALL_EFCSAME
127PO_REQUISITIONS_INTERFACE_ALLPO_REQUISITIONS_INTERFACE_ALLSAME
128PO_RESCHEDULE_INTERFACEPO_RESCHEDULE_INTERFACESAME
129PO_RETRIEVED_TIMECARDSPO_RETRIEVED_TIMECARDSSAME
130PO_RETROPRICE_GTPO_RETROPRICE_GTSAME
131PO_RFQ_VENDORSPO_RFQ_VENDORSSAME
132PO_RULE_EXPENSE_ACCOUNTSPO_RULE_EXPENSE_ACCOUNTSSAME
133PO_SESSION_GTPO_SESSION_GTSAME
134PO_SUPPLIER_ITEM_CAPACITYPO_SUPPLIER_ITEM_CAPACITYSAME
135PO_SUPPLIER_ITEM_TOLERANCEPO_SUPPLIER_ITEM_TOLERANCESAME
136PO_SYSTEM_PARAMETERS_ALLPO_SYSTEM_PARAMETERS_ALLSAME
137PO_UN_NUMBERS_BPO_UN_NUMBERS_BSAME
138PO_UN_NUMBERS_TLPO_UN_NUMBERS_TLSAME
139PO_UNIQUE_IDENTIFIER_CONT_ALLPO_UNIQUE_IDENTIFIER_CONT_ALLSAME
140PO_USAGE_ATTRIBUTESPO_USAGE_ATTRIBUTESSAME
141PO_USAGESPO_USAGESSAME
142PO_VENDOR_CONTACTSDELETED
143PO_VENDOR_LIST_ENTRIESPO_VENDOR_LIST_ENTRIESSAME
144PO_VENDOR_LIST_HEADERSPO_VENDOR_LIST_HEADERSSAME
145PO_VENDOR_SITES_ALLDELETED
146PO_VENDOR_SITES_ALL_EBSPO_VENDOR_SITES_ALL_EBSSAME
147PO_VENDORSDELETED
148PO_VENDORS_EBSPO_VENDORS_EBSSAME
149PO_WF_CANDIDATE_REQ_LINES_TEMPPO_WF_CANDIDATE_REQ_LINES_TEMPSAME
150PO_WF_DEBUGPO_WF_DEBUGSAME
151POA_BIS_SAVINGSPOA_BIS_SAVINGSSAME
152POA_BIS_SAVINGS_EFCPOA_BIS_SAVINGS_EFCSAME
153POA_BIS_SAVINGS_RPTPOA_BIS_SAVINGS_RPTSAME
154POA_BIS_SAVINGS_RPT_EFCPOA_BIS_SAVINGS_RPT_EFCSAME
155POA_BIS_SUPPLIER_PERFORMAN_EFCPOA_BIS_SUPPLIER_PERFORMAN_EFCSAME
156POA_BIS_SUPPLIER_PERFORMANCEPOA_BIS_SUPPLIER_PERFORMANCESAME
157POA_CM_DISTRIBUTIONSPOA_CM_DISTRIBUTIONSSAME
158POA_CM_EVAL_SCORESPOA_CM_EVAL_SCORESSAME
159POA_CM_EVALUATIONPOA_CM_EVALUATIONSAME
160RCV_ACCOUNTING_EVENT_TYPESRCV_ACCOUNTING_EVENT_TYPESSAME
161RCV_ACCOUNTING_EVENTSRCV_ACCOUNTING_EVENTSSAME
162RCV_FTE_TRANSACTION_LINESRCV_FTE_TRANSACTION_LINESSAME
163RCV_GAPLESS_INVOICE_NUMBERSRCV_GAPLESS_INVOICE_NUMBERSSAME
164RCV_HEADERS_INTERFACERCV_HEADERS_INTERFACESAME
165RCV_LOT_TRANSACTIONSRCV_LOT_TRANSACTIONSSAME
166RCV_LOTS_INTERFACERCV_LOTS_INTERFACESAME
167RCV_LOTS_SUPPLYRCV_LOTS_SUPPLYSAME
168RCV_MC_REC_SUB_LEDGERRCV_MC_REC_SUB_LEDGERSAME
169RCV_MC_SHIPMENT_HEADERSRCV_MC_SHIPMENT_HEADERSSAME
170RCV_MC_SUB_LEDGER_DETAILSRCV_MC_SUB_LEDGER_DETAILSSAME
171RCV_MC_TRANSACTIONSRCV_MC_TRANSACTIONSSAME
172RCV_PARAMETERSRCV_PARAMETERSSAME
173RCV_RECEIVING_SUB_LEDGERRCV_RECEIVING_SUB_LEDGERSAME
174RCV_ROUTING_HEADERS_OLDRCV_ROUTING_HEADERS_OLDSAME
175RCV_ROUTING_STEPSRCV_ROUTING_STEPSSAME
176RCV_SERIAL_TRANSACTIONSRCV_SERIAL_TRANSACTIONSSAME
177RCV_SERIALS_INTERFACERCV_SERIALS_INTERFACESAME
178RCV_SERIALS_SUPPLYRCV_SERIALS_SUPPLYSAME
179RCV_SHIPMENT_HEADERSRCV_SHIPMENT_HEADERSSAME
180RCV_SHIPMENT_LINESRCV_SHIPMENT_LINESSAME
181RCV_SHIPMENT_LINES_EFCRCV_SHIPMENT_LINES_EFCSAME
182RCV_SUB_LEDGER_DETAILSRCV_SUB_LEDGER_DETAILSSAME
183RCV_SUPPLYRCV_SUPPLYSAME
184RCV_TRANSACTIONSRCV_TRANSACTIONSSAME
185RCV_TRANSACTIONS_INTERFACERCV_TRANSACTIONS_INTERFACESAME
186RCV_UPGRADE_STEPSRCV_UPGRADE_STEPSSAME
187PO_ATTR_VALUES_ARCHIVENEW
188PO_ATTR_VALUES_INTERFACENEW
189PO_ATTR_VALUES_TLP_ARCHIVENEW
190PO_ATTR_VALUES_TLP_INTERFACENEW
191PO_ATTRIBUTE_VALUESNEW
192PO_ATTRIBUTE_VALUES_DRAFTNEW
193PO_ATTRIBUTE_VALUES_TLPNEW
194PO_ATTRIBUTE_VALUES_TLP_DRAFTNEW
195PO_BC_DISTRIBUTIONSNEW
196PO_CHANGE_ORDER_TOLERANCES_ALLNEW
197PO_DISTRIBUTIONS_DRAFT_ALLNEW
198PO_DOC_STYLE_HEADERSNEW
199PO_DOC_STYLE_LINES_BNEW
200PO_DOC_STYLE_LINES_TLNEW
201PO_DOC_STYLE_VALUESNEW
202PO_DOCUMENT_TOTALS_GTNEW
203PO_DRAFTSNEW
204PO_GA_ORG_ASSIGN_DRAFTNEW
205PO_HEADERS_DRAFT_ALLNEW
206PO_LINE_LOCATIONS_DRAFT_ALLNEW
207PO_LINE_LOCATIONS_INTERFACENEW
208PO_LINES_DRAFT_ALLNEW
209PO_NOTIFICATION_CTRL_DRAFTNEW
210PO_PRICE_DIFF_DRAFTNEW
211PO_RCV_CHARGE_ALLOCATIONSNEW
212PO_RCV_CHARGESNEW
213PO_VALIDATION_RESULTS_GTNEW
214PO_VENDOR_CONTACTS_OBSNEW
215PO_VENDOR_SITES_OBSNEW
216PO_VENDORS_OBSNEW
217PO_WF_USER_TMPNEW
218RCV_CHARGES_INTERFACENEW
219RCV_STAGING_TABLENEW




TOTAL186213









Changes in R12:


Un Changed = 180


New Tables = 33


Deleted = 6

INVENTORY TABLES 11i AND R12


Oracle  Apps  :  INVENTORY (INV) MODULE
SR.#R11R12
Table NameTable Name
1COST_UPGR_ERROR_TABLECOST_UPGR_ERROR_TABLE
2INV_ERES_EVENTS_TEMPINV_ERES_EVENTS_TEMP
3INV_ITEM_TEMPINV_ITEM_TEMP
4INV_MIN_MAX_TEMPINV_MIN_MAX_TEMP
5INV_MSN_GTEMPINV_MSN_GTEMP
6INV_MVT_EXCEP_REP_TEMPINV_MVT_EXCEP_REP_TEMP
7JE_IT_INV_PACKSLIPSJE_IT_INV_PACKSLIPS
8MLOG$_MTL_DEFAULT_CATEGORYMLOG$_MTL_DEFAULT_CATEGORY
9MTL_ABC_ASSGN_GROUP_CLASSESMTL_ABC_ASSGN_GROUP_CLASSES
10MTL_ABC_ASSIGNMENT_GROUPSMTL_ABC_ASSIGNMENT_GROUPS
11MTL_ABC_ASSIGNMENTSMTL_ABC_ASSIGNMENTS
12MTL_ABC_CLASSESMTL_ABC_CLASSES
13MTL_ABC_COMPILE_HEADERSMTL_ABC_COMPILE_HEADERS
14MTL_ABC_COMPILE_HEADERS_EFCMTL_ABC_COMPILE_HEADERS_EFC
15MTL_ABC_COMPILESMTL_ABC_COMPILES
16MTL_ABC_COMPILES_EFCMTL_ABC_COMPILES_EFC
17MTL_ACTUAL_COST_SUBELEMENTMTL_ACTUAL_COST_SUBELEMENT
18MTL_ACTUAL_COST_SUBELEMENT_EFCMTL_ACTUAL_COST_SUBELEMENT_EFC
19MTL_ALLOCATIONS_GTMPMTL_ALLOCATIONS_GTMP
20MTL_ATP_RULESMTL_ATP_RULES
21MTL_ATTR_APPL_DEPENDENCIESMTL_ATTR_APPL_DEPENDENCIES
22MTL_BIS_INV_BY_PERIODMTL_BIS_INV_BY_PERIOD
23MTL_CATALOG_SEARCH_ITEMSMTL_CATALOG_SEARCH_ITEMS
24MTL_CATEGORIES_BMTL_CATEGORIES_B
25MTL_CATEGORIES_TLMTL_CATEGORIES_TL
26MTL_CATEGORY_ACCOUNTSMTL_CATEGORY_ACCOUNTS
27MTL_CATEGORY_SET_VALID_CATSMTL_CATEGORY_SET_VALID_CATS
28MTL_CATEGORY_SETS_BMTL_CATEGORY_SETS_B
29MTL_CATEGORY_SETS_TLMTL_CATEGORY_SETS_TL
30MTL_CC_ENTRIES_INTERFACEMTL_CC_ENTRIES_INTERFACE
31MTL_CC_INTERFACE_ERRORSMTL_CC_INTERFACE_ERRORS
32MTL_CC_SCHED_COUNT_XREFSMTL_CC_SCHED_COUNT_XREFS
33MTL_CC_SCHEDULE_REQUESTSMTL_CC_SCHEDULE_REQUESTS
34MTL_CC_SERIAL_NUMBERSMTL_CC_SERIAL_NUMBERS
35MTL_CC_SUBINVENTORIESMTL_CC_SUBINVENTORIES
36MTL_CI_INTERFACEMTL_CI_INTERFACE
37MTL_CI_XREFS_INTERFACEMTL_CI_XREFS_INTERFACE
38MTL_COMMODITY_CODESMTL_COMMODITY_CODES
39MTL_CONSIGNED_DIAG_ERRORSMTL_CONSIGNED_DIAG_ERRORS
40MTL_CONSIGNED_DIAG_TEMPMTL_CONSIGNED_DIAG_TEMP
41MTL_CONSIGNED_QTY_TEMP
42MTL_CONSUMPTION_DEFINITIONMTL_CONSUMPTION_DEFINITION
43MTL_CONSUMPTION_TRANSACTIONSMTL_CONSUMPTION_TRANSACTIONS
44MTL_CONSUMPTION_TXN_TEMPMTL_CONSUMPTION_TXN_TEMP
45MTL_COPY_ORG_INTERFACEMTL_COPY_ORG_INTERFACE
46MTL_COPY_ORG_REPORTMTL_COPY_ORG_REPORT
47MTL_COPY_ORG_REPORT_TEMP
48MTL_COPY_ORG_TEMPMTL_COPY_ORG_TEMP
49MTL_COUNTRY_ASSIGNMENTSMTL_COUNTRY_ASSIGNMENTS
50MTL_CROSS_REFERENCE_TYPESMTL_CROSS_REFERENCE_TYPES
51MTL_CROSS_REFERENCES
52MTL_CROSS_REFERENCES_INTERFACEMTL_CROSS_REFERENCES_INTERFACE
53MTL_CST_ACTUAL_COST_DETAIL_EFCMTL_CST_ACTUAL_COST_DETAIL_EFC
54MTL_CST_ACTUAL_COST_DETAILSMTL_CST_ACTUAL_COST_DETAILS
55MTL_CST_LAYER_ACT_COST_DETAILSMTL_CST_LAYER_ACT_COST_DETAILS
56MTL_CST_TXN_COST_DETAILSMTL_CST_TXN_COST_DETAILS
57MTL_CST_TXN_COST_DETAILS_EFCMTL_CST_TXN_COST_DETAILS_EFC
58MTL_CUSTOMER_ITEM_XREFSMTL_CUSTOMER_ITEM_XREFS
59MTL_CUSTOMER_ITEMSMTL_CUSTOMER_ITEMS
60MTL_CYCLE_COUNT_CLASSESMTL_CYCLE_COUNT_CLASSES
61MTL_CYCLE_COUNT_CLASSES_EFCMTL_CYCLE_COUNT_CLASSES_EFC
62MTL_CYCLE_COUNT_ENTRIESMTL_CYCLE_COUNT_ENTRIES
63MTL_CYCLE_COUNT_ENTRIES_EFCMTL_CYCLE_COUNT_ENTRIES_EFC
64MTL_CYCLE_COUNT_HEADERSMTL_CYCLE_COUNT_HEADERS
65MTL_CYCLE_COUNT_HEADERS_EFCMTL_CYCLE_COUNT_HEADERS_EFC
66MTL_CYCLE_COUNT_ITEMSMTL_CYCLE_COUNT_ITEMS
67MTL_DEFAULT_CATEGORY_SETSMTL_DEFAULT_CATEGORY_SETS
68MTL_DEMANDMTL_DEMAND
69MTL_DEMAND_HISTORIESMTL_DEMAND_HISTORIES
70MTL_DEMAND_INTERFACEMTL_DEMAND_INTERFACE
71MTL_DESC_ELEM_VAL_INTERFACEMTL_DESC_ELEM_VAL_INTERFACE
72MTL_DESCR_ELEMENT_VALUESMTL_DESCR_ELEMENT_VALUES
73MTL_DESCRIPTIVE_ELEMENTSMTL_DESCRIPTIVE_ELEMENTS
74MTL_DO_CHECK_TEMPMTL_DO_CHECK_TEMP
75MTL_EAM_ASSET_ACTIVITIESMTL_EAM_ASSET_ACTIVITIES
76MTL_EAM_ASSET_ATTR_GROUPSMTL_EAM_ASSET_ATTR_GROUPS
77MTL_EAM_ASSET_ATTR_VALUESMTL_EAM_ASSET_ATTR_VALUES
78MTL_EAM_ASSET_NUM_INTERFACEMTL_EAM_ASSET_NUM_INTERFACE
79MTL_EAM_ASSET_SEARCH_TEMPMTL_EAM_ASSET_SEARCH_TEMP
80MTL_EAM_ATTR_VAL_INTERFACEMTL_EAM_ATTR_VAL_INTERFACE
81MTL_EAM_LOCATIONSMTL_EAM_LOCATIONS
82MTL_EAM_NETWORK_ASSETSMTL_EAM_NETWORK_ASSETS
83MTL_ECONOMIC_ZONES_BMTL_ECONOMIC_ZONES_B
84MTL_ECONOMIC_ZONES_TLMTL_ECONOMIC_ZONES_TL
85MTL_ERES_TRANSACTIONS_GTMPMTL_ERES_TRANSACTIONS_GTMP
86MTL_EXT_OBJECTSMTL_EXT_OBJECTS
87MTL_FISCAL_CAT_ACCOUNTSMTL_FISCAL_CAT_ACCOUNTS
88MTL_FLEX_CONTEXTMTL_FLEX_CONTEXT
89MTL_FORECAST_RULESMTL_FORECAST_RULES
90MTL_GENERIC_DISPOSITIONSMTL_GENERIC_DISPOSITIONS
91MTL_ICG_ALIASESMTL_ICG_ALIASES
92MTL_ICG_CATEGORIESMTL_ICG_CATEGORIES
93MTL_INTERCOMPANY_PARAMETERSMTL_INTERCOMPANY_PARAMETERS
94MTL_INTERFACE_ERRORSMTL_INTERFACE_ERRORS
95MTL_INTERFACE_PROC_CONTROLSMTL_INTERFACE_PROC_CONTROLS
96MTL_INTERORG_PARAMETERSMTL_INTERORG_PARAMETERS
97MTL_INTERORG_SHIP_METHODSMTL_INTERORG_SHIP_METHODS
98MTL_ITEM_ATTRIBUTESMTL_ITEM_ATTRIBUTES
99MTL_ITEM_ATTRIBUTES_TEMPMTL_ITEM_ATTRIBUTES_TEMP
100MTL_ITEM_CATALOG_GROUPS_BMTL_ITEM_CATALOG_GROUPS_B
101MTL_ITEM_CATALOG_GROUPS_TLMTL_ITEM_CATALOG_GROUPS_TL
102MTL_ITEM_CATEGORIESMTL_ITEM_CATEGORIES
103MTL_ITEM_CATEGORIES_INTERFACEMTL_ITEM_CATEGORIES_INTERFACE
104MTL_ITEM_CHILD_INFO_INTERFACEMTL_ITEM_CHILD_INFO_INTERFACE
105MTL_ITEM_LOC_DEFAULTSMTL_ITEM_LOC_DEFAULTS
106MTL_ITEM_LOCATIONSMTL_ITEM_LOCATIONS
107MTL_ITEM_REVISIONS_BMTL_ITEM_REVISIONS_B
108MTL_ITEM_REVISIONS_INTERFACEMTL_ITEM_REVISIONS_INTERFACE
109MTL_ITEM_REVISIONS_TLMTL_ITEM_REVISIONS_TL
110MTL_ITEM_STATUS
111MTL_ITEM_SUB_DEFAULTSMTL_ITEM_SUB_DEFAULTS
112MTL_ITEM_SUB_INVENTORIESMTL_ITEM_SUB_INVENTORIES
113MTL_ITEM_SUB_INVS_INTERFACEMTL_ITEM_SUB_INVS_INTERFACE
114MTL_ITEM_TEMPL_ATTRIBUTESMTL_ITEM_TEMPL_ATTRIBUTES
115MTL_ITEM_TEMPLATES
116MTL_ITEM_VALUES_TEMPMTL_ITEM_VALUES_TEMP
117MTL_KANBAN_CARD_ACTIVITYMTL_KANBAN_CARD_ACTIVITY
118MTL_KANBAN_CARD_PRINT_TEMPMTL_KANBAN_CARD_PRINT_TEMP
119MTL_KANBAN_CARDSMTL_KANBAN_CARDS
120MTL_KANBAN_PULL_SEQUENCESMTL_KANBAN_PULL_SEQUENCES
121MTL_KANBAN_TEMPLATESMTL_KANBAN_TEMPLATES
122MTL_LE_ECONOMIC_ZONESMTL_LE_ECONOMIC_ZONES
123MTL_LOT_NUMBERSMTL_LOT_NUMBERS
124MTL_MANUFACTURERSMTL_MANUFACTURERS
125MTL_MATERIAL_STATUS_HISTORYMTL_MATERIAL_STATUS_HISTORY
126MTL_MATERIAL_STATUSES_BMTL_MATERIAL_STATUSES_B
127MTL_MATERIAL_STATUSES_TLMTL_MATERIAL_STATUSES_TL
128MTL_MATERIAL_TRANSACTIONSMTL_MATERIAL_TRANSACTIONS
129MTL_MATERIAL_TRANSACTIONS_EFCMTL_MATERIAL_TRANSACTIONS_EFC
130MTL_MATERIAL_TRANSACTIONS_TEMPMTL_MATERIAL_TRANSACTIONS_TEMP
131MTL_MATERIAL_TXN_ALLOCATIONSMTL_MATERIAL_TXN_ALLOCATIONS
132MTL_MFG_PART_NUMBERSMTL_MFG_PART_NUMBERS
133MTL_MGD_INVENTORY_POSITIONSMTL_MGD_INVENTORY_POSITIONS
134MTL_MOBILE_LOGIN_HISTMTL_MOBILE_LOGIN_HIST
135MTL_MOVEMENT_PARAMETERSMTL_MOVEMENT_PARAMETERS
136MTL_MOVEMENT_STATISTICSMTL_MOVEMENT_STATISTICS
137MTL_MOVEMENT_STATISTICS_EFCMTL_MOVEMENT_STATISTICS_EFC
138MTL_MVT_STATS_RULEMTL_MVT_STATS_RULE
139MTL_MVT_STATS_RULE_SETS_BMTL_MVT_STATS_RULE_SETS_B
140MTL_MVT_STATS_RULE_SETS_TLMTL_MVT_STATS_RULE_SETS_TL
141MTL_MVT_STATS_RULESMTL_MVT_STATS_RULES
142MTL_OBJECT_EVENTSMTL_OBJECT_EVENTS
143MTL_OBJECT_GENEALOGYMTL_OBJECT_GENEALOGY
144MTL_OBJECT_GENEALOGY_INTERFACEMTL_OBJECT_GENEALOGY_INTERFACE
145MTL_ONHAND_DISCREPANCIESMTL_ONHAND_DISCREPANCIES
146MTL_ONHAND_LOCK_TEMPMTL_ONHAND_LOCK_TEMP
147MTL_ONHAND_QUANTITIES_BACKUPMTL_ONHAND_QUANTITIES_BACKUP
148MTL_ONHAND_QUANTITIES_D_BKPMTL_ONHAND_QUANTITIES_D_BKP
149MTL_ONHAND_QUANTITIES_DETAILMTL_ONHAND_QUANTITIES_DETAIL
150MTL_ONHAND_QUANTITY_TEMPMTL_ONHAND_QUANTITY_TEMP
151MTL_ORG_REPORT_TEMPMTL_ORG_REPORT_TEMP
152MTL_PAC_ACT_CST_DTL_TEMPMTL_PAC_ACT_CST_DTL_TEMP
153MTL_PAC_ACTUAL_COST_DETAIL_EFCMTL_PAC_ACTUAL_COST_DETAIL_EFC
154MTL_PAC_ACTUAL_COST_DETAILSMTL_PAC_ACTUAL_COST_DETAILS
155MTL_PAC_COST_SUBELEMENTSMTL_PAC_COST_SUBELEMENTS
156MTL_PAC_COST_SUBELEMENTS_EFCMTL_PAC_COST_SUBELEMENTS_EFC
157MTL_PAC_TXN_COST_DETAILSMTL_PAC_TXN_COST_DETAILS
158MTL_PAC_TXN_COST_DETAILS_EFCMTL_PAC_TXN_COST_DETAILS_EFC
159MTL_PARAMETERSMTL_PARAMETERS
160MTL_PENDING_ITEM_STATUSMTL_PENDING_ITEM_STATUS
161MTL_PER_CLOSE_DTLSMTL_PER_CLOSE_DTLS
162MTL_PER_CLOSE_DTLS_EFCMTL_PER_CLOSE_DTLS_EFC
163MTL_PERIOD_CG_SUMMARYMTL_PERIOD_CG_SUMMARY
164MTL_PERIOD_SUMMARYMTL_PERIOD_SUMMARY
165MTL_PERIOD_SUMMARY_EFCMTL_PERIOD_SUMMARY_EFC
166MTL_PHYSICAL_ADJUSTMENTSMTL_PHYSICAL_ADJUSTMENTS
167MTL_PHYSICAL_ADJUSTMENTS_EFCMTL_PHYSICAL_ADJUSTMENTS_EFC
168MTL_PHYSICAL_INVENTORIESMTL_PHYSICAL_INVENTORIES
169MTL_PHYSICAL_INVENTORIES_EFCMTL_PHYSICAL_INVENTORIES_EFC
170MTL_PHYSICAL_INVENTORY_TAGSMTL_PHYSICAL_INVENTORY_TAGS
171MTL_PHYSICAL_SUBINVENTORIESMTL_PHYSICAL_SUBINVENTORIES
172MTL_PICKING_RULESMTL_PICKING_RULES
173MTL_PLANNERSMTL_PLANNERS
174MTL_PURGE_HEADERMTL_PURGE_HEADER
175MTL_QOH_ITEM_TMPMTL_QOH_ITEM_TMP
176MTL_QOH_LOCATOR_TMPMTL_QOH_LOCATOR_TMP
177MTL_QOH_LOT_TMPMTL_QOH_LOT_TMP
178MTL_QOH_REV_TMPMTL_QOH_REV_TMP
179MTL_QOH_SUB_TMPMTL_QOH_SUB_TMP
180MTL_RELATED_ITEMSMTL_RELATED_ITEMS
181MTL_RELATED_ITEMS_CUST_REFMTL_RELATED_ITEMS_CUST_REF
182MTL_RELATED_ITEMS_INTERFACEMTL_RELATED_ITEMS_INTERFACE
183MTL_RELATED_ITEMS_PLN_INFOMTL_RELATED_ITEMS_PLN_INFO
184MTL_REPLENISH_HEADERSMTL_REPLENISH_HEADERS
185MTL_REPLENISH_HEADERS_INTMTL_REPLENISH_HEADERS_INT
186MTL_REPLENISH_LINESMTL_REPLENISH_LINES
187MTL_REPLENISH_LINES_INTMTL_REPLENISH_LINES_INT
188MTL_RESERVATIONSMTL_RESERVATIONS
189MTL_RESERVATIONS_INTERFACEMTL_RESERVATIONS_INTERFACE
190MTL_RMA_SERIAL_TEMPMTL_RMA_SERIAL_TEMP
191MTL_RSV_QUANTITIES_TEMP
192MTL_RTG_ITEM_REVISIONSMTL_RTG_ITEM_REVISIONS
193MTL_RTG_ITEM_REVS_INTERFACEMTL_RTG_ITEM_REVS_INTERFACE
194MTL_SAFETY_STOCKSMTL_SAFETY_STOCKS
195MTL_SALES_ORDERSMTL_SALES_ORDERS
196MTL_SEASONALITY_INDICESMTL_SEASONALITY_INDICES
197MTL_SECONDARY_INVENTORIESMTL_SECONDARY_INVENTORIES
198MTL_SECONDARY_LOCATORSMTL_SECONDARY_LOCATORS
199MTL_SECONDARY_LOCS_INTERFACEMTL_SECONDARY_LOCS_INTERFACE
200MTL_SERIAL_NUMBERSMTL_SERIAL_NUMBERS
201MTL_SERIAL_NUMBERS_INTERFACEMTL_SERIAL_NUMBERS_INTERFACE
202MTL_SERIAL_NUMBERS_TEMPMTL_SERIAL_NUMBERS_TEMP
203MTL_SHORT_CHK_PARAMMTL_SHORT_CHK_PARAM
204MTL_SHORT_CHK_STATEMENTSMTL_SHORT_CHK_STATEMENTS
205MTL_SHORT_CHK_TEMPMTL_SHORT_CHK_TEMP
206MTL_SO_RMA_INTERFACEMTL_SO_RMA_INTERFACE
207MTL_SO_RMA_RECEIPTSMTL_SO_RMA_RECEIPTS
208MTL_STAT_TYPE_USAGESMTL_STAT_TYPE_USAGES
209MTL_STATUS_ATTRIBUTE_VALUESMTL_STATUS_ATTRIBUTE_VALUES
210MTL_STATUS_TRANSACTION_CONTROLMTL_STATUS_TRANSACTION_CONTROL
211MTL_SUMMARY_TEMPMTL_SUMMARY_TEMP
212MTL_SUPPLYMTL_SUPPLY
213MTL_SUPPLY_DEMAND_TEMPMTL_SUPPLY_DEMAND_TEMP
214MTL_SYSTEM_ITEMS_BMTL_SYSTEM_ITEMS_B
215MTL_SYSTEM_ITEMS_B_EFCMTL_SYSTEM_ITEMS_B_EFC
216MTL_SYSTEM_ITEMS_INTERFACEMTL_SYSTEM_ITEMS_INTERFACE
217MTL_SYSTEM_ITEMS_TLMTL_SYSTEM_ITEMS_TL
218MTL_TRANSACTION_ACCOUNTSMTL_TRANSACTION_ACCOUNTS
219MTL_TRANSACTION_ACCOUNTS_EFCMTL_TRANSACTION_ACCOUNTS_EFC
220MTL_TRANSACTION_FLOW_HEADERSMTL_TRANSACTION_FLOW_HEADERS
221MTL_TRANSACTION_FLOW_LINESMTL_TRANSACTION_FLOW_LINES
222MTL_TRANSACTION_LOT_NUMBERSMTL_TRANSACTION_LOT_NUMBERS
223MTL_TRANSACTION_LOTS_INTERFACEMTL_TRANSACTION_LOTS_INTERFACE
224MTL_TRANSACTION_LOTS_TEMPMTL_TRANSACTION_LOTS_TEMP
225MTL_TRANSACTION_REASONSMTL_TRANSACTION_REASONS
226MTL_TRANSACTION_TYPESMTL_TRANSACTION_TYPES
227MTL_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACE
228MTL_TRANSFER_TEMPMTL_TRANSFER_TEMP
229MTL_TXN_COST_DET_INTERFACEMTL_TXN_COST_DET_INTERFACE
230MTL_TXN_REQUEST_HEADERSMTL_TXN_REQUEST_HEADERS
231MTL_TXN_REQUEST_LINESMTL_TXN_REQUEST_LINES
232MTL_TXN_SOURCE_TYPESMTL_TXN_SOURCE_TYPES
233MTL_UNIT_TRANSACTIONSMTL_UNIT_TRANSACTIONS
234MTL_UNITS_OF_MEASURE_TLMTL_UNITS_OF_MEASURE_TL
235MTL_UOM_CLASS_CONVERSIONSMTL_UOM_CLASS_CONVERSIONS
236MTL_UOM_CLASSES_TLMTL_UOM_CLASSES_TL
237MTL_UOM_CONVERSIONSMTL_UOM_CONVERSIONS
238MTL_UPDATE_RECORDS_TEMPMTL_UPDATE_RECORDS_TEMP
239MTL_USER_DEMANDMTL_USER_DEMAND
240MTL_USER_SUPPLYMTL_USER_SUPPLY
241MTL_VMI_QUANTITIES_TEMPMTL_VMI_QUANTITIES_TEMP
242ORG_ACCESSORG_ACCESS
243ORG_ACCT_PERIODSORG_ACCT_PERIODS
244ORG_FREIGHT_TLORG_FREIGHT_TL
245ORG_GL_BATCHESORG_GL_BATCHES
246RSV_TEMPRSV_TEMP
247WMS_CARTONIZATION_TEMPWMS_CARTONIZATION_TEMP
248MTL_ACTIONS_B
249MTL_ACTIONS_TL
250MTL_AVAILABLE_INVENTORY_TEMP
251MTL_CHILD_LOT_NUMBERS
252MTL_COGS_RECOGNITION_TEMP
253MTL_CONSIGNED_QTY_TEMP
254MTL_CROSS_REFERENCES_B
255MTL_CROSS_REFERENCES_TL
256MTL_GEN_TEMP
257MTL_GRADE_STATUS_ERES_GTMP
258MTL_GRADES_B
259MTL_GRADES_TL
260MTL_INV_PACKSLIPS
261MTL_INV_PICKING_RULES
262MTL_ITEM_ATTRIBUTES_SEED_INFO
263MTL_ITEM_BULKLOAD_RECS
264MTL_ITEM_STATUS_TL
265MTL_ITEM_TEMPLATES_B
266MTL_ITEM_TEMPLATES_TL
267MTL_LOT_CONV_AUDIT
268MTL_LOT_CONV_AUDIT_DETAILS
269MTL_LOT_ERES_GTMP
270MTL_LOT_GRADE_HISTORY
271MTL_LOT_UOM_CLASS_CONVERSIONS
272MTL_LPN_ATR_QTY_GT
273MTL_MOQD_BACKUP
274MTL_MWB_GTMP
275MTL_PICK_SLIP_NUMBERS
276MTL_PO_PACKSLIPS
277MTL_RSV_QUANTITIES_TEMP
278MTL_SERIAL_NUMBERS_GT
279MTL_TRANS_REASON_SECURITY
280MTL_UOM_CONVERSIONS_ERES_GTMP




TOTAL247274









Changes in R12:


Un Changed = 241


New Tables = 33


Deleted = 6