Oracle APPS Supply Chain tables ERD - PART-2

RCV_TRANSACTIONS

You can get data of all receiving transactions in this table.

Important columns

TRANSACTION_TYPE like  DELIVER,REJECT,ACCEPT,CORRECT,RETURN TO RECEIVING

TRANSFER, RETURN TO VENDOR, RECEIVE.

Also you can directly connect to shipment and purchase order tables for rcv_transactions

By  SHIPMENT_HEADER_ID and PO_HEADER_ID.

Oracle APPS Supply Chain Tables ERD PART-1

Oracle inventory main reporting tables.
--------------------------------------------------------------------------------

MTL_MATERIAL_TRANSACTIONS

Base table for all transactions (etc RCV,Issuance,Sub Inv Transfer,Inter Org Transfer,Misl Transactions...).

MTL_SYSTEM_ITEMS

Table contains all System items organization wise. It is Base table for items.

This table holds the definitions for inventory items, engineering items, and purchasing items. The flexfield code is MSTK. The primary key for an item is the INVENTORY_ITEM_ID and the ORGANIZATION_ID. The same item could be defined in more than one organization. Each row represents an item in an organization.