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: JA.JAI_CMN_LINES

Object Details

Object Name:	JAI_CMN_LINES
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_CMN_LINES
Subobject Name:
Status:	VALID

Stores the ASBN information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_CMN_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	CMN_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CMN_LINE_ID	NUMBER		Yes	Indicates the line Identifier.It derives its value based on a sequence.
SHIPMENT_NUMBER	VARCHAR2	(30)		Indicates the shipment number of the ASBN Shipment.
PO_HEADER_ID	NUMBER			Indicates the Header Identifier of the purchase order based on which the ASBN is created.
PO_LINE_ID	NUMBER			Indicates the Line Identifier of the Purchase order Line.
PO_LINE_LOCATION_ID	NUMBER			Indicates the Purchase order line location identifier.
PO_NUMBER	VARCHAR2	(20)		Indicates the Purchase Order Number that was included in the ASBN Shipment.
LINE_NUM	NUMBER			Indicates the Line number of the purchase order.
SHIPMENT_LINE_NUM	NUMBER			Indicates the Shipment line number of the purchase order line.
HEADER_INTERFACE_ID	NUMBER			Indicates the Header identifier of the record created in the rcv_headers_interface.
SHIPMENT_HEADER_ID	NUMBER			Indicates the Header identifier of the receipt created.
INTERFACE_TRANSACTION_ID	NUMBER			Indicates the transaction identifier of the lines that are inserted in the rcv_transactions_interface table.
SHIPMENT_LINE_ID	NUMBER			Indicates the Line Identifier of the receipt Line.
ITEM_ID	NUMBER			Indicates the identifier of the Inventory Item.
QUANTITY	NUMBER			Indicates the Quantiy for the inventory item in the ASBN shipment line.
EXCISE_INV_NUMBER	VARCHAR2	(30)		Indicates the Excise invoice number provided by the user.
EXCISE_INV_DATE	DATE			Indicated the Excise Invoice Date provide by the user.
CURRENCY_CODE	VARCHAR2	(15)		Indicates the currency of the Purchase Order.
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PO_UNIT_PRICE	NUMBER			Indicates the Unit price of the Inventory Item in the Purchase Order.
UOM_CODE	VARCHAR2	(3)		Indicates the unit of measurement of the Inventory Item for the quantity in the ASBN Shipment.
OBJECT_VERSION_NUMBER	NUMBER			Standard Who Column

Query Text

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


SELECT CMN_LINE_ID
,      SHIPMENT_NUMBER
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_NUMBER
,      LINE_NUM
,      SHIPMENT_LINE_NUM
,      HEADER_INTERFACE_ID
,      SHIPMENT_HEADER_ID
,      INTERFACE_TRANSACTION_ID
,      SHIPMENT_LINE_ID
,      ITEM_ID
,      QUANTITY
,      EXCISE_INV_NUMBER
,      EXCISE_INV_DATE
,      CURRENCY_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PO_UNIT_PRICE
,      UOM_CODE
,      OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_LINES;

Dependencies

[top of page]

JA.JAI_CMN_LINES does not reference any database object

JA.JAI_CMN_LINES is referenced by following:

JA: JAI_CMN_LINES#