Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Wednesday, November 23, 2011

RCV_SHIPMENT_HEADERS

Purchasing
Table Or View: Table

Important columns: 
SHIPMENT_HEADER_ID - NUMBER  -  Receipt header unique identifier
RECEIPT_SOURCE_CODE - VARCHAR2 - Source type of the shipment - VENDOR, INTERNAL ORDER or
CUSTOMER
VENDOR_ID - NUMBER  - Source supplier unique identifier
VENDOR_SITE_ID
ORGANIZATION_ID - NUMBER - Source organization unique identifier
SHIPMENT_NUM -  Shipment number assigned by the shipment's source
RECEIPT_NUM  - Receipt number
 
Description: 
 RCV_SHIPMENT_HEADERS stores common information about the source of your receipts or expected receipts. You group your receipts by the source type and the source of the receipt. Oracle Purchasing does not allow you to group receipts from different sources under one receipt header.
There are two receipt source types, Supplier and Internal Order, that you need to use when receiving against different source document types. You use a receipt source type of 'Supplier' when receiving items that you ordered from an external supplier using
a purchase order. When you receive items that are part of an inter-organization transfer, or when receiving items that you request from your inventory using an internal requisition, the receipt type would be 'Internal Order'. The 'Internal Order' receipt source type populates  the ORGANIZATION_ID column.
Oracle Purchasing creates a receipt header when you are entering your receipts or when you perform inter-organization transfers using Oracle Inventory. When Oracle Inventory creates a receipt header for an intransit shipment, the receipt number is not populated until you receive the shipment.

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect