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_LINES

Object Details

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

Temporary Table Details

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

Columns

Name	Datatype	Length	Mandatory
LPN_GROUP_ID	NUMBER
INVOICED_QUANTITY	NUMBER
PRIMARY_QUANTITY	NUMBER
PRIMARY_UOM	VARCHAR2	(60)
EXPECTED_RECEIPT_DATE	DATE
LICENSE_PLATE_NUMBER	VARCHAR2	(60)
LLS_CODE	VARCHAR2	(3)
HEADER_INTERFACE_ID	NUMBER
INTERFACE_TRANSACTION_ID	NUMBER
GROUP_ID	NUMBER
ASN_REQUEST_ID	NUMBER
HEADER_ID	NUMBER
LINE_ID	NUMBER		Yes
OPERATING_UNIT	VARCHAR2	(2000)
PO_NUMBER	VARCHAR2	(60)
PO_REVISION	NUMBER
PO_RELEASE_NUM	NUMBER
PO_LINE	NUMBER
PO_SHIPMENT	NUMBER
ORG_ID	NUMBER
PO_HEADER_ID	NUMBER
PO_RELEASE_ID	NUMBER
PO_LINE_ID	NUMBER
PO_LINE_LOCATION_ID	NUMBER
VENDOR_ID	NUMBER
VENDOR_SITE_ID	NUMBER
VENDOR_CONTACT_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
VENDOR_NAME	VARCHAR2	(240)
VENDOR_SITE_CODE	VARCHAR2	(15)
RATE_TYPE	VARCHAR2	(30)
RATE	NUMBER
RATE_DATE	DATE
ITEM_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
UNIT_PRICE	NUMBER
CURRENCY_CODE	VARCHAR2	(15)
VENDOR_PRODUCT_NUM	VARCHAR2	(25)
QUANTITY	NUMBER
UOM	VARCHAR2	(60)
BILL_OF_LADING	VARCHAR2	(60)
PACKING_SLIP	VARCHAR2	(60)
NUM_OF_CONTAINERS	NUMBER
WAYBILL_NUM	VARCHAR2	(60)
BARCODE_LABEL	VARCHAR2	(60)
COUNTRY_OF_ORIGIN	VARCHAR2	(60)
CONTAINER_NUMBER	VARCHAR2	(60)
TRUCK_NUMBER	VARCHAR2	(60)
VENDOR_LOT	VARCHAR2	(60)
COMMENTS	VARCHAR2	(2000)
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)
SH_ATTRIBUTE_CATEGORY	VARCHAR2	(60)
SH_ATTRIBUTE1	VARCHAR2	(2000)
SH_ATTRIBUTE2	VARCHAR2	(2000)
SH_ATTRIBUTE3	VARCHAR2	(2000)
SH_ATTRIBUTE4	VARCHAR2	(2000)
SH_ATTRIBUTE5	VARCHAR2	(2000)
SH_ATTRIBUTE6	VARCHAR2	(2000)
SH_ATTRIBUTE7	VARCHAR2	(2000)
SH_ATTRIBUTE8	VARCHAR2	(2000)
SH_ATTRIBUTE9	VARCHAR2	(2000)
SH_ATTRIBUTE10	VARCHAR2	(2000)
SH_ATTRIBUTE11	VARCHAR2	(2000)
SH_ATTRIBUTE12	VARCHAR2	(2000)
SH_ATTRIBUTE13	VARCHAR2	(2000)
SH_ATTRIBUTE14	VARCHAR2	(2000)
SH_ATTRIBUTE15	VARCHAR2	(2000)
SL_ATTRIBUTE_CATEGORY	VARCHAR2	(60)
SL_ATTRIBUTE1	VARCHAR2	(2000)
SL_ATTRIBUTE2	VARCHAR2	(2000)
SL_ATTRIBUTE3	VARCHAR2	(2000)
SL_ATTRIBUTE4	VARCHAR2	(2000)
SL_ATTRIBUTE5	VARCHAR2	(2000)
SL_ATTRIBUTE6	VARCHAR2	(2000)
SL_ATTRIBUTE7	VARCHAR2	(2000)
SL_ATTRIBUTE8	VARCHAR2	(2000)
SL_ATTRIBUTE9	VARCHAR2	(2000)
SL_ATTRIBUTE10	VARCHAR2	(2000)
SL_ATTRIBUTE11	VARCHAR2	(2000)
SL_ATTRIBUTE12	VARCHAR2	(2000)
SL_ATTRIBUTE13	VARCHAR2	(2000)
SL_ATTRIBUTE14	VARCHAR2	(2000)
SL_ATTRIBUTE15	VARCHAR2	(2000)
SHIP_TO_LOCATION_CODE	VARCHAR2	(60)
SHIP_TO_LOCATION_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)

Query Text

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


SELECT LPN_GROUP_ID
,      INVOICED_QUANTITY
,      PRIMARY_QUANTITY
,      PRIMARY_UOM
,      EXPECTED_RECEIPT_DATE
,      LICENSE_PLATE_NUMBER
,      LLS_CODE
,      HEADER_INTERFACE_ID
,      INTERFACE_TRANSACTION_ID
,      GROUP_ID
,      ASN_REQUEST_ID
,      HEADER_ID
,      LINE_ID
,      OPERATING_UNIT
,      PO_NUMBER
,      PO_REVISION
,      PO_RELEASE_NUM
,      PO_LINE
,      PO_SHIPMENT
,      ORG_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      SHIP_TO_ORG_ID
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      RATE_TYPE
,      RATE
,      RATE_DATE
,      ITEM_ID
,      ITEM_REVISION
,      UNIT_PRICE
,      CURRENCY_CODE
,      VENDOR_PRODUCT_NUM
,      QUANTITY
,      UOM
,      BILL_OF_LADING
,      PACKING_SLIP
,      NUM_OF_CONTAINERS
,      WAYBILL_NUM
,      BARCODE_LABEL
,      COUNTRY_OF_ORIGIN
,      CONTAINER_NUMBER
,      TRUCK_NUMBER
,      VENDOR_LOT
,      COMMENTS
,      LINE_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SH_ATTRIBUTE_CATEGORY
,      SH_ATTRIBUTE1
,      SH_ATTRIBUTE2
,      SH_ATTRIBUTE3
,      SH_ATTRIBUTE4
,      SH_ATTRIBUTE5
,      SH_ATTRIBUTE6
,      SH_ATTRIBUTE7
,      SH_ATTRIBUTE8
,      SH_ATTRIBUTE9
,      SH_ATTRIBUTE10
,      SH_ATTRIBUTE11
,      SH_ATTRIBUTE12
,      SH_ATTRIBUTE13
,      SH_ATTRIBUTE14
,      SH_ATTRIBUTE15
,      SL_ATTRIBUTE_CATEGORY
,      SL_ATTRIBUTE1
,      SL_ATTRIBUTE2
,      SL_ATTRIBUTE3
,      SL_ATTRIBUTE4
,      SL_ATTRIBUTE5
,      SL_ATTRIBUTE6
,      SL_ATTRIBUTE7
,      SL_ATTRIBUTE8
,      SL_ATTRIBUTE9
,      SL_ATTRIBUTE10
,      SL_ATTRIBUTE11
,      SL_ATTRIBUTE12
,      SL_ATTRIBUTE13
,      SL_ATTRIBUTE14
,      SL_ATTRIBUTE15
,      SHIP_TO_LOCATION_CODE
,      SHIP_TO_LOCATION_ID
,      ITEM_DESCRIPTION
FROM POS.POS_EXASN_LINES;

Dependencies

[top of page]

POS.POS_EXASN_LINES does not reference any database object

POS.POS_EXASN_LINES is referenced by following:

APPS: POS_EXASN_LINES