eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PO.RCV_SHIPMENT_HEADERS

Object Details

Object Name:	RCV_SHIPMENT_HEADERS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.RCV_SHIPMENT_HEADERS
Subobject Name:
Status:	VALID

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.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_SHIPMENT_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHIPMENT_HEADER_ID
RCV_SHIPMENT_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIP_TO_LOCATION_ID
RCV_SHIPMENT_HEADERS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
RCV_SHIPMENT_HEADERS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PACKING_SLIP
RCV_SHIPMENT_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_NUM
RCV_SHIPMENT_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
RCV_SHIPMENT_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_SITE_ID
RCV_SHIPMENT_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SHIPMENT_NUM RECEIPT_SOURCE_CODE
RCV_SHIPMENT_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID RECEIPT_NUM
RCV_SHIPMENT_HEADERS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EMPLOYEE_ID
RCV_SHIPMENT_HEADERS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECEIPT_NUM SHIP_TO_ORG_ID
RCV_SHIPMENT_HEADERS_N9	FUNCTION-BASED NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DECODE(RTRIM("RECEIPT_NUM",'0123456789'),NULL,TO_NUMBER("RECEIPT_NUM"),(-1))

Columns

Name	Datatype	Length	Mandatory	Comments
SHIPMENT_HEADER_ID	NUMBER		Yes	Receipt header unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
RECEIPT_SOURCE_CODE	VARCHAR2	(25)	Yes	Source type of the shipment
VENDOR_ID	NUMBER			Source supplier unique identifier
VENDOR_SITE_ID	NUMBER			Source supplier site unique identifier
ORGANIZATION_ID	NUMBER			Source organization unique identifier
SHIPMENT_NUM	VARCHAR2	(30)		Shipment number assigned by the shipment's source
RECEIPT_NUM	VARCHAR2	(30)		Receipt number
SHIP_TO_LOCATION_ID	NUMBER			Ship-to location unique identifier
BILL_OF_LADING	VARCHAR2	(25)		Bill of lading number
PACKING_SLIP	VARCHAR2	(25)		Packing slip number
SHIPPED_DATE	DATE			Shipping date
FREIGHT_CARRIER_CODE	VARCHAR2	(25)		Carrier responsible for shipping
EXPECTED_RECEIPT_DATE	DATE			Expected arrival date of the shipment
EMPLOYEE_ID	NUMBER	(9)		Employee unique identifier
NUM_OF_CONTAINERS	NUMBER			Number of containers in the shipment
WAYBILL_AIRBILL_NUM	VARCHAR2	(30)		Waybill or airbill number
COMMENTS	VARCHAR2	(4000)		Receiver's or Approver's comments
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
GOVERNMENT_CONTEXT	VARCHAR2	(30)		USSGL descriptive flexfield context column
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
ASN_TYPE	VARCHAR2	(25)		The document type: ASN, ASBN or Receive
EDI_CONTROL_NUM	VARCHAR2	(10)		EDI transaction control number if data is imported via EDI
NOTICE_CREATION_DATE	DATE			EDI transaction create date/time at source if data is imported via EDI
GROSS_WEIGHT	NUMBER			Shipment gross weight from Advance Shipment Notice (ASN)
GROSS_WEIGHT_UOM_CODE	VARCHAR2	(3)		Shipment gross weight unit of measure from ASN
NET_WEIGHT	NUMBER			Shipment net weight from ASN
NET_WEIGHT_UOM_CODE	VARCHAR2	(3)		Shipment net weight unit of measure from ASN
TAR_WEIGHT	NUMBER			Shipment tar (container) weight from ASN
TAR_WEIGHT_UOM_CODE	VARCHAR2	(3)		Shipment tar (container) weight unit of measure from ASN
PACKAGING_CODE	VARCHAR2	(5)		Shipment packaging code
CARRIER_METHOD	VARCHAR2	(2)		Carrier transportation method code
CARRIER_EQUIPMENT	VARCHAR2	(10)		Carrier equipment description method
CARRIER_EQUIPMENT_NUM	VARCHAR2	(10)		Carrier equipment identification number
CARRIER_EQUIPMENT_ALPHA	VARCHAR2	(10)		Carrier equipment identification initials
SPECIAL_HANDLING_CODE	VARCHAR2	(3)		Special handling code
HAZARD_CODE	VARCHAR2	(1)		Hazardous material qualifier code of the shipment
HAZARD_CLASS	VARCHAR2	(4)		Hazardous material class of shipment
HAZARD_DESCRIPTION	VARCHAR2	(80)		Hazardous material description
FREIGHT_TERMS	VARCHAR2	(25)		Freight payment method (user defined, e.g. PREPAID, COLLECT)
FREIGHT_BILL_NUMBER	VARCHAR2	(35)		Freight bill (PRO invoice) number
INVOICE_NUM	VARCHAR2	(50)		EDI transaction 857 invoice number
INVOICE_DATE	DATE			EDI transaction 857 invoice date
INVOICE_AMOUNT	NUMBER			EDI transaction 857 invoice amount
TAX_NAME	VARCHAR2	(50)		EDI transaction 857 tax name indicated at the header level
TAX_AMOUNT	NUMBER			EDI transaction 857 tax amount indicated at the header level
FREIGHT_AMOUNT	NUMBER			EDI transaction 857 freight bill amount
INVOICE_STATUS_CODE	VARCHAR2	(25)		Eligibility status for automated Oracle Payables invoice creation
ASN_STATUS	VARCHAR2	(10)		ASN shipment status
CURRENCY_CODE	VARCHAR2	(15)		Code from purchase order currency code or PO_VENDOR_SITE.INVOICE_CURRENCY_CODE. Used for ASN with billing information (ASBN) only.
CONVERSION_RATE_TYPE	VARCHAR2	(30)		Purchase order rate type. Used for ASBN only.
CONVERSION_RATE	NUMBER			Purchase order rate. Used for ASBN only.
CONVERSION_DATE	DATE			Purchase order rate date. Used for ASBN only.
PAYMENT_TERMS_ID	NUMBER			EDI transaction 857 payment terms
MRC_CONVERSION_RATE_TYPE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID. Used for ASBN only. Taken from purchase order rate type pairs.
MRC_CONVERSION_DATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID. Used for ASBN only. Taken from purchase order rate date pairs.
MRC_CONVERSION_RATE	VARCHAR2	(2000)		Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID. Used for ASBN only. Taken from purchase order rate pairs.
SHIP_TO_ORG_ID	NUMBER			Ship-to organization unique identifier
CUSTOMER_ID	NUMBER			Customer unique identifier
CUSTOMER_SITE_ID	NUMBER			Customer site unique identifier
REMIT_TO_SITE_ID	NUMBER			Remit To Site Id
SHIP_FROM_LOCATION_ID	NUMBER			Ship From Location unique identifier
WF_ITEM_TYPE	VARCHAR2	(8)		item type used in the Work Confirmation Approval
WF_ITEM_KEY	VARCHAR2	(280)		item key used in the Work Confirmation Approval
APPROVAL_STATUS	VARCHAR2	(25)		Approval status of the work confirmation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='APPROVAL_STATUS')
PERFORMANCE_PERIOD_FROM	DATE			Work Confirmation Period from
PERFORMANCE_PERIOD_TO	DATE			Work Confirmation Period To
REQUEST_DATE	DATE			Work Confirmation request date

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SHIPMENT_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RECEIPT_SOURCE_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      ORGANIZATION_ID
,      SHIPMENT_NUM
,      RECEIPT_NUM
,      SHIP_TO_LOCATION_ID
,      BILL_OF_LADING
,      PACKING_SLIP
,      SHIPPED_DATE
,      FREIGHT_CARRIER_CODE
,      EXPECTED_RECEIPT_DATE
,      EMPLOYEE_ID
,      NUM_OF_CONTAINERS
,      WAYBILL_AIRBILL_NUM
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASN_TYPE
,      EDI_CONTROL_NUM
,      NOTICE_CREATION_DATE
,      GROSS_WEIGHT
,      GROSS_WEIGHT_UOM_CODE
,      NET_WEIGHT
,      NET_WEIGHT_UOM_CODE
,      TAR_WEIGHT
,      TAR_WEIGHT_UOM_CODE
,      PACKAGING_CODE
,      CARRIER_METHOD
,      CARRIER_EQUIPMENT
,      CARRIER_EQUIPMENT_NUM
,      CARRIER_EQUIPMENT_ALPHA
,      SPECIAL_HANDLING_CODE
,      HAZARD_CODE
,      HAZARD_CLASS
,      HAZARD_DESCRIPTION
,      FREIGHT_TERMS
,      FREIGHT_BILL_NUMBER
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_AMOUNT
,      TAX_NAME
,      TAX_AMOUNT
,      FREIGHT_AMOUNT
,      INVOICE_STATUS_CODE
,      ASN_STATUS
,      CURRENCY_CODE
,      CONVERSION_RATE_TYPE
,      CONVERSION_RATE
,      CONVERSION_DATE
,      PAYMENT_TERMS_ID
,      MRC_CONVERSION_RATE_TYPE
,      MRC_CONVERSION_DATE
,      MRC_CONVERSION_RATE
,      SHIP_TO_ORG_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      REMIT_TO_SITE_ID
,      SHIP_FROM_LOCATION_ID
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      APPROVAL_STATUS
,      PERFORMANCE_PERIOD_FROM
,      PERFORMANCE_PERIOD_TO
,      REQUEST_DATE
FROM PO.RCV_SHIPMENT_HEADERS;

Dependencies

[top of page]

PO.RCV_SHIPMENT_HEADERS does not reference any database object

PO.RCV_SHIPMENT_HEADERS is referenced by following:

PO: RCV_SHIPMENT_HEADERS#