Powered By Blogger
Showing posts with label ERD. Show all posts
Showing posts with label ERD. Show all posts

Monday, September 6, 2010

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.