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: TableJA.JAI_OM_OE_SO_LINES
Subobject Name:
Status: VALID


Stores localization information for the sales orders.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_OM_OE_SO_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
JAI_OM_OE_SO_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
ColumnHEADER_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
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
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:

SchemaAPPS
SynonymJAI_OM_OE_SO_LINES