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?

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 13 20:18:15 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.