Home » Applications » Oracle Fusion Apps & E-Business Suite » Interface Tables
Interface Tables [message #277634] Wed, 31 October 2007 00:06 Go to next message
Abeer30
Messages: 110
Registered: March 2007
Senior Member
Hello,

What are Purchasing & Inventory Interface Tables?
Re: Interface Tables [message #278969 is a reply to message #277634] Tue, 06 November 2007 08:28 Go to previous message
dhrubajyoti_nth
Messages: 18
Registered: October 2007
Location: Renukoot
Junior Member

These are the interface tables in
Inventory :

MTL_SYSTEM_ITEM_B
Columns which end with '_ID' is a number for Identification
Columns which end with '_CODE' contains meaningful information
In MSIB Inventory_Item_Id column contains Item_Id and Segment1 contains Item name
MTL_PARAMETERS is the Organization table (Org Name, Org Code, etc)
For UOM, MTL_UNIT_OF_MEASURE
ORG_ID is the Operating unit id whereas ORGANIZATION_ID is the Inventory Organization Id
MTL_ITEM_CATEGORIES_B for Item Categories
MTL_CATEGORY_SETS is for category sets

IMPORTANT TABLES FOR PHYSICAL INVENTORY
MTL_PHYSICAL INVENTORIES
MTL_PHYSICAL_INVENTORY_TAGS
MTL_PHYSICAL_ADJUSTMENTS

IMPORTANT TABLES FOR ITEM RESERVATION
MTL_RESERVATIONS
MTL_RESERVATIONS_INTERFACE

TABLE FOR MATERIAL TRANSACTION
MTL_MATERIAL_TRANSACTIONS

TABLE FOR ITEM CROSS-REFERENCES
MTL_CROSS_REFERENCES

TABLE FOR ITEM COST
CST_ITEM_COST
CST_ITEM_COST_DETAILS
CST_ITEM_COST_INTERFACE

TABLE FOR ITEM INTERFACE
MTL_SYSTEM_ITEMS_INTERFACE
MTL_SYSTEM_ERRORS

For PO I have no idea......
Regards,

DJ Nath
Previous Topic: steps involved in order management
Next Topic: Repricing the Star Item (Configuration Item)
Goto Forum:
  


Current Time: Sat Dec 10 14:37:05 CST 2016

Total time taken to generate the page: 0.08170 seconds