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_OM_OE_SO_LINES

Object Details

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

Stores localization information for the sales orders.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_OM_OE_SO_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
JAI_OM_OE_SO_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HEADER_ID LINE_ID
JAI_OM_OE_SO_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_ID HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_NUMBER	NUMBER			Line number.
LINE_ID	NUMBER		Yes	Line identifier.
HEADER_ID	NUMBER		Yes	Sales Order header identifier. Identifies records in this table to that of records attached to the table oe_order_headers_all in base applications.
SHIPMENT_SCHEDULE_LINE_ID	NUMBER			It is used in the case of ATO Scenario. This column holds the value of the order_line_id of the model item for all the OPTION items and CONFIG Item.
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier.
UNIT_CODE	VARCHAR2	(3)		Unit code.
QUANTITY	NUMBER		Yes	Quantity of the sales order line.
TAX_CATEGORY_ID	NUMBER	(15)		Tax category identifier.
SELLING_PRICE	NUMBER			Selling price of the inventory item.
LINE_AMOUNT	NUMBER			Line amount of the sale order line.
ASSESSABLE_VALUE	NUMBER			Assessable value of the sales order line.
TAX_AMOUNT	NUMBER			Tax amount associated with the sales order line.
LINE_TOT_AMOUNT	NUMBER			Line total amount for the sales order line.
SHIPMENT_SCHEDULE_FLAG	VARCHAR2	(1)		No longer used
SHIPMENT_LINE_NUMBER	NUMBER			Line number of the shipment.
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
ATO_FLAG	VARCHAR2	(1)		ATO flag indicator, for future use.
EXCISE_EXEMPT_TYPE	VARCHAR2	(60)		Identifies Excise Exempted type like CT2, CT3 etc.,.
EXCISE_EXEMPT_REFNO	VARCHAR2	(30)		Excise Exemption certificate reference no.
EXCISE_EXEMPT_DATE	DATE			Excise Exemption certificate date.
SPLIT_FROM_LINE_ID	NUMBER			Line identifier of parent line.
LC_FLAG	VARCHAR2	(1)		Indicates whether the order is LC enabled or not.
VAT_EXEMPTION_FLAG	VARCHAR2	(1)		Flag to indicate if the line is exempted from VAT type of taxes.
VAT_EXEMPTION_TYPE	VARCHAR2	(30)		VAT exemption type.
VAT_EXEMPTION_DATE	DATE			VAT exemption Date.
VAT_EXEMPTION_REFNO	VARCHAR2	(100)		VAT exemption refund.
VAT_ASSESSABLE_VALUE	NUMBER			Assessable value to be used for calulating VAT taxes.
OBJECT_VERSION_NUMBER	NUMBER			Object version number
SERVICE_TYPE_CODE	VARCHAR2	(30)		Indicates the service type for the sales order line
VAT_REVERSAL_PRICE	NUMBER			Price on which VAT reversal tax is calculated
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
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield context field
GST_ASSESSABLE_VALUE	NUMBER			GST Assessable Value
SHIP_TO_ORG_ID	NUMBER			Ship to Organization ID

Query Text

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


SELECT LINE_NUMBER
,      LINE_ID
,      HEADER_ID
,      SHIPMENT_SCHEDULE_LINE_ID
,      INVENTORY_ITEM_ID
,      UNIT_CODE
,      QUANTITY
,      TAX_CATEGORY_ID
,      SELLING_PRICE
,      LINE_AMOUNT
,      ASSESSABLE_VALUE
,      TAX_AMOUNT
,      LINE_TOT_AMOUNT
,      SHIPMENT_SCHEDULE_FLAG
,      SHIPMENT_LINE_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATO_FLAG
,      EXCISE_EXEMPT_TYPE
,      EXCISE_EXEMPT_REFNO
,      EXCISE_EXEMPT_DATE
,      SPLIT_FROM_LINE_ID
,      LC_FLAG
,      VAT_EXEMPTION_FLAG
,      VAT_EXEMPTION_TYPE
,      VAT_EXEMPTION_DATE
,      VAT_EXEMPTION_REFNO
,      VAT_ASSESSABLE_VALUE
,      OBJECT_VERSION_NUMBER
,      SERVICE_TYPE_CODE
,      VAT_REVERSAL_PRICE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      GST_ASSESSABLE_VALUE
,      SHIP_TO_ORG_ID
FROM JA.JAI_OM_OE_SO_LINES;

Dependencies

[top of page]

JA.JAI_OM_OE_SO_LINES does not reference any database object

JA.JAI_OM_OE_SO_LINES is referenced by following:

JA: JAI_OM_OE_SO_LINES#