Translate

Sunday, April 28, 2013

Oracle Form Personalize Condition 11.5 /R12 EBS



Form Personalize with Condition:

Once you confirmed that you are in the right form, access Help --> Diagnostics --> Custom Code --> Personalize.


 Trigger Event

It is important to identify the trigger event to write any form personalization.
For example you are getting a requirement like below.

In the Quick Invoice window, when the Invoice type is selected as 'Credit Memo' , make the Description field as non-editable.

So we need to identify the exact trigger being executed by form when the Invoice type is selected as 'Credit Memo'.

There is a simple way to capture that trigger.

Help --> Diagnostics --> Custom Code --> Show Custom Events.

The below message will appear
"Setting this option will cause a dialog box to be displayed whenever an event is passed to the custom library."

Click on 'OK' and proceed to identify the trigger being executed when the value is changed.

1. Open the 'Quick Invoice' Form
2. Enable display for Custom events Help --> Diagnostics --> Custom Code --> Show Custom Events.
3. Select the Invoice type as 'Credit Memo' and then tab out.
4. Note down the trigger being executed as soon as you tab'd out.

APXIISIM.INVOICES_FOLDER.INVOICE_NUM: WHEN-NEW-ITEM-INSTANCE

The above format is nothing but <FORMNAME>.<ITEMNAME>: <TRIGGERNAME>

So we have now identified the trigger event and trigger object.

Now let us access the Personalization from Help --> Diagnostics --> Custom Code --> Personalize.

Doing it...
'Seq' - is the sequence the personalization gets executed.
'Description' - User entered description
'Level' - Form or Function.

The Personalization can be done either at Fuction or Form levels.

Form Level : Once you do the form personalization at the Form level, it will be reflected in all the functions,forms where
this form is included.

Function Level : if the form personalization is done at the Function level, it will be reflected only in the function. When
the same function is included in any other responsibility, the personalization will get reflected there as well.

Choosing the Level

Choosing the level of personalization is entirely based on the requirement and user needs. But understand the impact when the
personalization is done at the Form level.

'Enabled' - When checked, the personalization will have impact on the Form.
When Unchecked, the personalization is disabled.


For our example scenario, we have identified the trigger event and item name.

The condition for our example is : When the Invoice Type is 'Credit Memo'

When you see the above sentence there are two instance one is 'Invoice Type' and another is 'Credit Memo'.

'Invoice Type' is nothing but the form Item
'Credit Memo' is the value of that form item

Now we need the Item name for 'Invoice Type' to mention in it the Condition so that the form understands our condition.

Getting the Item Name

For any field in a Form, you can get the name of the item and the folder where it resides.

Place your cursor at the field. In our case place the cursor in the Invoice Type field then
click on Help--> Diagnostics--> Examine which will give you the field name ,block name the filed belongs to and the value.

In our case Block Name : INVOICES_FOLDER Field Name: INVOICE_TYPE

It is important to refer a field with the block name.

< BLOCK>.<FIELD>
CONDITION

Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger Object:INVOICES_FOLDER.INVOICE_NUM
Condition:

There are properties for each field. for example to get the value of a field, the property name is 'VALUE'. To make the field
editable/non-editable the property name is 'ENTERABLE'. Similary there are more number of properties for a field.

To get the property of any item in the form, the 'Insert 'Get' Expression' button can be used and to get the value of any
item in the form, the 'Insert Item Value' button can be used.

In our case, we need to get the value (property) of Invoice type field (Item).

${item.invoices_folder.invoice_type.value} ='Credit Memo'

ACTIONS

Seq: - is the sequence the personalization action gets executed.
Type: -

Property - To change any item properties
Message - To dispaly any message. Message can be displayed as Warning, Error or Hint.
Builtin - To Launch SRS form,URL,Function, set profile option, execute procedure.
Menu - Any thing related to the Menu and Special Button.

In our case, we are trying to make the Description field read only so the type would be Property.

Object Type : Item
Target Object : INVOICES_FOLDER.DESCRIPTION
Property Name : ENTERABLE
Value : FALSE
So our form personalization to make the Description field read only when the Invoice type is selected as 'Credit Memo' would
be as below

CONDITION

Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger Object:INVOICES_FOLDER.INVOICE_NUM
Condition:

${item.invoices_folder.invoice_type.value} ='Credit Memo'
ACTIONS

Seq: 1
Type: Property

Object Type : Item
Target Object : INVOICES_FOLDER.DESCRIPTION
Property Name : ENTERABLE
Value : FALSE

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

Some Simple Condition For your Reference :
***************************************


1)   :header.receipt_date<(select creation_date from po_headers where     po_header_id=:rcv_transaction.po_header_Id)

2)   SYSTEM.RECORD_STATUS IN ('NEW','INSERT') AND
:USER.USER_NAME IS NOT NULL AND
:USER.EMAIL_ADDRESS IS NULL


3) :VNDR.VENDOR_NAME_MIR != translate(:VNDR.VENDOR_NAME_MIR,'/!;"{}[]|=_*&^%$@~#',' ') 

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

Oracle 11i and R12 Inventory Table Difference


Oracle  Apps  :  INVENTORY (INV) MODULE


SR.#

R11

R12


Table Name

Table 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



Changes in R12:




UN Changed = 241


New Tables = 33


Deleted = 6

Total Tables 


11i Tables --> 247
R12 Tables --> 274
------------------------------------------------------------------------------------------------------------------------------------------