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: POS.POS_EXASN_HEADERS

Object Details

Object Name:	POS_EXASN_HEADERS
Object Type:	TABLE
Owner:	POS
Subobject Name:
Status:	VALID

Temporary Table Details

POS.POS_EXASN_HEADERS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Primary Key: SYS_C00161476

HEADER_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_C00161476	NORMAL	UNIQUE		HEADER_ID

Columns

Name	Datatype	Length	Mandatory
LPN_GROUP_ID	NUMBER
PAYMENT_TERM_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
RATE	NUMBER
RATE_TYPE	VARCHAR2	(30)
RATE_DATE	DATE
ASN_REQUEST_ID	NUMBER
HEADER_INTERFACE_ID	NUMBER
GROUP_ID	NUMBER
VENDOR_ID	NUMBER
VENDOR_SITE_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
HEADER_ID	NUMBER		Yes
SHIPMENT_NUMBER	VARCHAR2	(60)
SHIPMENT_DATE	DATE
EXPECTED_RECEIPT_DATE	DATE
BILL_OF_LADING	VARCHAR2	(60)
PACKING_SLIP	VARCHAR2	(60)
FREIGHT_CARRIER_CODE	VARCHAR2	(60)
NUM_OF_CONTAINERS	NUMBER
WAYBILL_NUM	VARCHAR2	(60)
GROSS_WEIGHT_UOM	VARCHAR2	(60)
GROSS_WEIGHT	NUMBER
NET_WEIGHT_UOM	VARCHAR2	(60)
NET_WEIGHT	NUMBER
TAR_WEIGHT_UOM	VARCHAR2	(60)
TAR_WEIGHT	NUMBER
PACKAGING_CODE	VARCHAR2	(60)
CARRIER_METHOD	VARCHAR2	(60)
SPECIAL_HANDLING_CODE	VARCHAR2	(60)
HAZARD_CODE	VARCHAR2	(60)
HAZARD_CLASS	VARCHAR2	(60)
FREIGHT_TERMS	VARCHAR2	(60)
COMMENTS	VARCHAR2	(2000)
INVOICE_NUMBER	VARCHAR2	(60)
INVOICE_DATE	DATE
INVOICE_AMOUNT	NUMBER
TAX_AMOUNT	NUMBER
FREIGHT_AMOUNT	NUMBER
PAYMENT_TERMS	VARCHAR2	(60)
LINE_NUMBER	NUMBER
ATTRIBUTE_CATEGORY	VARCHAR2	(60)
ATTRIBUTE1	VARCHAR2	(2000)
ATTRIBUTE2	VARCHAR2	(2000)
ATTRIBUTE3	VARCHAR2	(2000)
ATTRIBUTE4	VARCHAR2	(2000)
ATTRIBUTE5	VARCHAR2	(2000)
ATTRIBUTE6	VARCHAR2	(2000)
ATTRIBUTE7	VARCHAR2	(2000)
ATTRIBUTE8	VARCHAR2	(2000)
ATTRIBUTE9	VARCHAR2	(2000)
ATTRIBUTE10	VARCHAR2	(2000)
ATTRIBUTE11	VARCHAR2	(2000)
ATTRIBUTE12	VARCHAR2	(2000)
ATTRIBUTE13	VARCHAR2	(2000)
ATTRIBUTE14	VARCHAR2	(2000)
ATTRIBUTE15	VARCHAR2	(2000)
SHIP_FROM_LOCATION_CODE	VARCHAR2	(30)

Query Text

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


SELECT LPN_GROUP_ID
,      PAYMENT_TERM_ID
,      CURRENCY_CODE
,      RATE
,      RATE_TYPE
,      RATE_DATE
,      ASN_REQUEST_ID
,      HEADER_INTERFACE_ID
,      GROUP_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      SHIP_TO_ORG_ID
,      HEADER_ID
,      SHIPMENT_NUMBER
,      SHIPMENT_DATE
,      EXPECTED_RECEIPT_DATE
,      BILL_OF_LADING
,      PACKING_SLIP
,      FREIGHT_CARRIER_CODE
,      NUM_OF_CONTAINERS
,      WAYBILL_NUM
,      GROSS_WEIGHT_UOM
,      GROSS_WEIGHT
,      NET_WEIGHT_UOM
,      NET_WEIGHT
,      TAR_WEIGHT_UOM
,      TAR_WEIGHT
,      PACKAGING_CODE
,      CARRIER_METHOD
,      SPECIAL_HANDLING_CODE
,      HAZARD_CODE
,      HAZARD_CLASS
,      FREIGHT_TERMS
,      COMMENTS
,      INVOICE_NUMBER
,      INVOICE_DATE
,      INVOICE_AMOUNT
,      TAX_AMOUNT
,      FREIGHT_AMOUNT
,      PAYMENT_TERMS
,      LINE_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SHIP_FROM_LOCATION_CODE
FROM POS.POS_EXASN_HEADERS;

Dependencies

[top of page]

POS.POS_EXASN_HEADERS does not reference any database object

POS.POS_EXASN_HEADERS is referenced by following:

APPS: POS_EXASN_HEADERS