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_HEADERS_INTERFACE

Object Details

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

RCV_HEADERS_INTERFACE is an interface table that stores
receiving header information.
Scope: public
Lifecycle: active
Display Name: RCV Headers Interface
Product: PO
Category: BUSINESS_ENTITY PO_GOODS_RECEIPT
Category: BUSINESS_ENTITY PO_EXPENSE_RECEIPT
Category: BUSINESS_ENTITY PO_SERVICES_RECEIPTS
Category: BUSINESS_ENTITY PO_GOODS_RETURN
Category: BUSINESS_ENTITY PO_RECEIPT_CORRECTION

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_HEADERS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	HEADER_INTERFACE_ID
RCV_HEADERS_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	VENDOR_ID
RCV_HEADERS_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESSING_STATUS_CODE GROUP_ID
RCV_HEADERS_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SHIPMENT_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
HEADER_INTERFACE_ID	NUMBER		Yes	Interface EDI header unique identifier
GROUP_ID	NUMBER			Interface group for set processing
EDI_CONTROL_NUM	VARCHAR2	(10)		EDI transaction control number if data is sent via EDI
PROCESSING_STATUS_CODE	VARCHAR2	(25)		Processing status of the interface header row
RECEIPT_SOURCE_CODE	VARCHAR2	(25)		Source type of the shipment
ASN_TYPE	VARCHAR2	(25)		The document type: values are ASN, ASBN, or RECEIVE
TRANSACTION_TYPE	VARCHAR2	(25)		The transaction purpose code: values are NEW, REPLACE, ADD, or CANCEL
AUTO_TRANSACT_CODE	VARCHAR2	(25)		Automatic transaction creation code of the shipment
TEST_FLAG	VARCHAR2	(1)		Flag indicating transaction is in test mode
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).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
NOTICE_CREATION_DATE	DATE			EDI transaction creation date/time at source if importing data via EDI
SHIPMENT_NUM	VARCHAR2	(30)		Shipment number assigned by the shipment's source
RECEIPT_NUM	VARCHAR2	(30)		Receipt number
RECEIPT_HEADER_ID	NUMBER			Receipt system ID
VENDOR_NAME	VARCHAR2	(240)		Supplier name from ASN; used to derive VENDOR_ID
VENDOR_NUM	VARCHAR2	(30)		Supplier Num from ASN; used to derive VENDOR_ID
VENDOR_ID	NUMBER			Source supplier unique ID
VENDOR_SITE_CODE	VARCHAR2	(35)		Supplier site code from ASN; used to derive VENDOR_SITE_ID
VENDOR_SITE_ID	NUMBER			Source supplier site unique identifier
FROM_ORGANIZATION_CODE	VARCHAR2	(3)		Source organization code; used to derive from ORGANIZATION_ID
FROM_ORGANIZATION_ID	NUMBER			Source organization unique identifier (internal transfers only)
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	(3)		Ship-to organization code
SHIP_TO_ORGANIZATION_ID	NUMBER			Ship-to organization unique identifier
LOCATION_CODE	VARCHAR2	(60)		Ship-to/receiving location code
LOCATION_ID	NUMBER			Receiving location unique identifier
BILL_OF_LADING	VARCHAR2	(25)		Bill of lading number
PACKING_SLIP	VARCHAR2	(25)		Packing slip number
SHIPPED_DATE	DATE			Shipped date
FREIGHT_CARRIER_CODE	VARCHAR2	(25)		Carrier responsible for shipment
EXPECTED_RECEIPT_DATE	DATE			Expected arrival date of the shipment
RECEIVER_ID	NUMBER			Employee unique identifier
NUM_OF_CONTAINERS	NUMBER			Number of containers in the shipment
WAYBILL_AIRBILL_NUM	VARCHAR2	(30)		Waybill or airbill number
COMMENTS	VARCHAR2	(240)		Receiver's comments
GROSS_WEIGHT	NUMBER			Shipment gross weight from 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 packing code
CARRIER_METHOD	VARCHAR2	(2)		Carrier transportation method code
CARRIER_EQUIPMENT	VARCHAR2	(10)		Carrier equipment description code
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 the 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	(30)		EDI transaction 857 invoice number associated with the shipment/billing notice (ASN with billing information)
INVOICE_DATE	DATE			EDI transaction 857 invoice date associated with the shipment/billing notice
TOTAL_INVOICE_AMOUNT	NUMBER			EDI transaction 857 invoice amount associated with the shipment/billing notice
TAX_NAME	VARCHAR2	(50)		EDI transaction 857 tax name associated with the shipment/billing notice
TAX_AMOUNT	NUMBER			EDI transaction 857 tax amount associated with the shipment/billing notice name indicated at the header level
FREIGHT_AMOUNT	NUMBER			EDI transaction 857 freight bill amount associated with the shipment/billing notice
CURRENCY_CODE	VARCHAR2	(15)		EDI transaction 857 currency code
CONVERSION_RATE_TYPE	VARCHAR2	(30)		EDI transaction 857 exchange rate type
CONVERSION_RATE	NUMBER			EDI transaction 857 exchange rate
CONVERSION_RATE_DATE	DATE			EDI transaction 857 exchange rate date
PAYMENT_TERMS_NAME	VARCHAR2	(50)		EDI transaction 857 payment terms name
PAYMENT_TERMS_ID	NUMBER			EDI transaction 857 payment terms unique identifier
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
USGGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
EMPLOYEE_NAME	VARCHAR2	(240)		Employee's name
EMPLOYEE_ID	NUMBER			Employee's unique identifier
INVOICE_STATUS_CODE	VARCHAR2	(25)		For ASN with billing information (ASBN) only, indicates when line items were rejected
VALIDATION_FLAG	VARCHAR2	(1)		Marked after open interface validation
PROCESSING_REQUEST_ID	NUMBER			Unique identifier for the request
CUSTOMER_ACCOUNT_NUMBER	NUMBER			Unique identifier for the request
CUSTOMER_ID	NUMBER			Unique identifier for the request
CUSTOMER_SITE_ID	NUMBER			Unique identifier for the request
CUSTOMER_PARTY_NAME	VARCHAR2	(360)		Customer Name
REMIT_TO_SITE_ID	NUMBER			Remit To Site Id
TRANSACTION_DATE	DATE			Transaction date
ORG_ID	NUMBER			Organization identifier
OPERATING_UNIT	VARCHAR2	(240)		Operating Unit Name used to derive ORG_ID
SHIP_FROM_LOCATION_ID	NUMBER			Ship From Location Unique Identifier
PERFORMANCE_PERIOD_FROM	DATE			Work Confirmation's Performance period from
PERFORMANCE_PERIOD_TO	DATE			Work Confirmation's Performance period to
REQUEST_DATE	DATE			Work Confirmation Request date
SHIP_FROM_LOCATION_CODE	VARCHAR2	(30)		Ship from location code

Query Text

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


SELECT HEADER_INTERFACE_ID
,      GROUP_ID
,      EDI_CONTROL_NUM
,      PROCESSING_STATUS_CODE
,      RECEIPT_SOURCE_CODE
,      ASN_TYPE
,      TRANSACTION_TYPE
,      AUTO_TRANSACT_CODE
,      TEST_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      NOTICE_CREATION_DATE
,      SHIPMENT_NUM
,      RECEIPT_NUM
,      RECEIPT_HEADER_ID
,      VENDOR_NAME
,      VENDOR_NUM
,      VENDOR_ID
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      FROM_ORGANIZATION_CODE
,      FROM_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_ID
,      LOCATION_CODE
,      LOCATION_ID
,      BILL_OF_LADING
,      PACKING_SLIP
,      SHIPPED_DATE
,      FREIGHT_CARRIER_CODE
,      EXPECTED_RECEIPT_DATE
,      RECEIVER_ID
,      NUM_OF_CONTAINERS
,      WAYBILL_AIRBILL_NUM
,      COMMENTS
,      GROSS_WEIGHT
,      GROSS_WEIGHT_UOM_CODE
,      NET_WEIGHT
,      NET_WEIGHT_UOM_CODE
,      TAR_WEIGHT
,      TAR_WEIGHT_UOM_CODE
,      PACKAGING_CODE
,      CARRIER_METHOD
,      CARRIER_EQUIPMENT
,      SPECIAL_HANDLING_CODE
,      HAZARD_CODE
,      HAZARD_CLASS
,      HAZARD_DESCRIPTION
,      FREIGHT_TERMS
,      FREIGHT_BILL_NUMBER
,      INVOICE_NUM
,      INVOICE_DATE
,      TOTAL_INVOICE_AMOUNT
,      TAX_NAME
,      TAX_AMOUNT
,      FREIGHT_AMOUNT
,      CURRENCY_CODE
,      CONVERSION_RATE_TYPE
,      CONVERSION_RATE
,      CONVERSION_RATE_DATE
,      PAYMENT_TERMS_NAME
,      PAYMENT_TERMS_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      USGGL_TRANSACTION_CODE
,      EMPLOYEE_NAME
,      EMPLOYEE_ID
,      INVOICE_STATUS_CODE
,      VALIDATION_FLAG
,      PROCESSING_REQUEST_ID
,      CUSTOMER_ACCOUNT_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      CUSTOMER_PARTY_NAME
,      REMIT_TO_SITE_ID
,      TRANSACTION_DATE
,      ORG_ID
,      OPERATING_UNIT
,      SHIP_FROM_LOCATION_ID
,      PERFORMANCE_PERIOD_FROM
,      PERFORMANCE_PERIOD_TO
,      REQUEST_DATE
,      SHIP_FROM_LOCATION_CODE
FROM PO.RCV_HEADERS_INTERFACE;

Dependencies

[top of page]

PO.RCV_HEADERS_INTERFACE does not reference any database object

PO.RCV_HEADERS_INTERFACE is referenced by following:

PO: RCV_HEADERS_INTERFACE#