oracle apps r12 inventory

What is the primary key in MTL_SYSTEMS_ITEMS_B ?

Composite primary key (INVENTORY_ITEM_ID + ORGANIZATION_D)

What is the column name and table name to get item?

MTL_SYSTEMS_ITEMS_B.SEGMENT1

What are the tables get hit when we create item?

MTL_SYSTEMS_ITEMS_B

MTL_SYSTEMS_ITEMS_TL

MTL_ITEM_CATEGORIES

MTL_ITEM_REVISIONS

What is the item category?

 

Logical grouping of inventory items based on similar properties for reporting purpose.

 

What is a template ?

Template is a collection of attributes.

What is attribute?

Attribute is an property of item .

Ex: stockable transactable, uom,purchase …

What is the base table for inventory organizations ?

MTL_PARAMETERS

MTL stands for -> material

 

Difference b/w MTL_PARAMETERS and ORG_ORGANIZATION_DEFINITIONS ?

MTL_PARAMETERS : it is the base table.

ORG_ORGANIZATION_DEFINITIONS : it is a view and depends on MTL_PARAMETERS, GL_LEDGERS and HR_ORGANIZATION_UNITS

What are the tables get hit when create material transaction ?

MTL_MATERIAL_TRANSACTIONS

MTL_ONHAND_QUANTITIES

what is the navigation to create sub-inventory ?

Setup -> organizations -> sub inventories

what is the table name and column name to get long description?

MTL_SYSTEM_ITEMS_TL.LONG_DESCRIPTION

what is the navigation to assign template to the item ?

 

CLICK ON TOOLS -> COPY FROM

 

what is the base table for stock locators ?

MTL_ITEM_LOCATIONS

what are the KKF’s (key flexifields) in inventory module ?

stock locator

item categories

item catalog

items

which attribute we need to enable to create sub inventory transfer?

TRANSACTABLE

 

which attribute we need to enable to create sales order?

 

Customer order (and) transactable

 

link b/w MTL_PARAMETERS and MTL_SYSTEM_ITEMS_B ?

ORGANIZATION_ID = ORGANIZATION_ID

 

link b/w MTL_SYSTEM_ITEMS_B (and) MTL_ONHAND_QUANTITIES ?

INVENTORY_ITEM_ID = INVENTORY_ITEM_ID

And

ORGANIZATION_ID = ORGANIZATION_ID

linka b/w MTL_SYSTEM_ITEMS_B (and)MTL_reservations

INVENTORY_ITEM_ID = INVENTORY_ITEM_ID

And

ORGANIZATION_ID = ORGANIZATION_ID

link b/w MTL_SYSTEM_ITEMS_B (and) MTL_ITEM_CATEGORIES

 

INVENTORY_ITEM_ID = INVENTORY_ITEM_ID

And

ORGANIZATION_ID = ORGANIZATION_ID

 

can we create items directly in child inventory organization?

NO, We can’t

 

 

Related Posts

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by k2schools