DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_OM_WSH_LINES_ALL

Object Details
Object Name: JAI_OM_WSH_LINES_ALL
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_OM_WSH_LINES_ALL
Subobject Name:
Status: VALID


Capture localization information picking line wise.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_OM_WSH_LINES_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXCISE_INVOICE_NO
JAI_OM_WSH_LINES_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_LINE_ID
JAI_OM_WSH_LINES_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERY_ID
ColumnDELIVERY_DETAIL_ID
JAI_OM_WSH_LINES_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_HEADER_ID
JAI_OM_WSH_LINES_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVAT_INVOICE_NO
Columns
Name Datatype Length Mandatory Comments
PICKING_LINE_ID NUMBER

No longer used
EXCISE_INVOICE_NO VARCHAR2 (200)
Excise invoice number .Relates a record in this table to that of the JAI_CMN_RG_EXC_INV_NOS
EXCISE_INVOICE_DATE DATE

Date when an excise was attached to this record.
PICKING_HEADER_ID NUMBER

Picking Header Identifier.
ORDER_LINE_ID NUMBER
Yes Order line identifier.
SELLING_PRICE NUMBER
Yes Selling Price.
QUANTITY NUMBER
Yes Shipment quantity.
TAX_CATEGORY_ID NUMBER (15)
Tax Category Identifier.
TAX_AMOUNT NUMBER

Tax amount associated with a shipment line.
REGISTER VARCHAR2 (15)
Register that would be hit.
LOCATION_ID NUMBER
Yes Location Identifier.
EXCISE_AMOUNT NUMBER

Excise Amount.
BASIC_EXCISE_DUTY_AMOUNT NUMBER

Basic Excise duty amount.
ADD_EXCISE_DUTY_AMOUNT NUMBER

Additional Excise duty amount.
OTH_EXCISE_DUTY_AMOUNT NUMBER

Other Excise duty amount.
ORGANIZATION_ID NUMBER

Organization Identifier.
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item Identifier.
UNIT_CODE VARCHAR2 (3)
Unit code.
ASSESSABLE_VALUE NUMBER

Assessable value.
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
PREPRINTED_EXCISE_INV_NO VARCHAR2 (50)
Pre printed Excise Invoice Number.
EXC_EXEMPT_CERT_FLAG VARCHAR2 (1)
Flag to indicate Excise Exemption.
CT3_FORM_FLAG VARCHAR2 (1)
Flag to indicate form tracking for CT3 cases.
EXC_EXEMPT_REF_DATE DATE

Excise Exemption certificate reference date
EXCISE_EXEMPT_REFNO VARCHAR2 (30)
Excise Exemption certificate reference number.
EXCISE_EXEMPT_TYPE VARCHAR2 (30)
Identifies Excise Exempted type like CT2, CT3 etc.
EXCISE_EXEMPT_DATE DATE

Excise Exemption certificate date.
AR3_FORM_NO VARCHAR2 (30)
AR3 form number.
AR3_FORM_DATE DATE

AR3 form date.
DELIVERY_DETAIL_ID NUMBER

Delivery Detail Identifier.
ORDER_HEADER_ID NUMBER

Order header Identifier.
SPLIT_FROM_DELIVERY_DETAIL_ID NUMBER

Parent line identifier from which it is split.
ORG_ID NUMBER

Organization Identifier.
CUSTOMER_ID NUMBER

Customer Identifier.
SHIP_TO_ORG_ID NUMBER

Identifies to which organization should a consignment be shipped.
ORDER_TYPE_ID NUMBER

Order Type Identifier.
SUBINVENTORY VARCHAR2 (10)
Sub inventory Name.
DELIVERY_ID NUMBER

Delivery Identifier.
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 reference number
VAT_ASSESSABLE_VALUE NUMBER

Assessable value to be used for calulating VAT taxes.
VAT_INVOICE_NO VARCHAR2 (240)
VAT invoice number.
VAT_INVOICE_DATE DATE

VAT invoice Date
OBJECT_VERSION_NUMBER NUMBER

Object version number
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
SHIPPABLE_FLAG VARCHAR2 (1)
Flag to indicate whether line is shippable/non-shippable. 'N' for non-shippable line and 'Y' for shippable line.
GST_INVOICE_NO VARCHAR2 (150)
GST Invoice Number
GST_INVOICE_DATE DATE

GST Invoice Date
GST_ASSESSABLE_VALUE NUMBER

GST Assessable Value
Query Text

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


SELECT PICKING_LINE_ID
,      EXCISE_INVOICE_NO
,      EXCISE_INVOICE_DATE
,      PICKING_HEADER_ID
,      ORDER_LINE_ID
,      SELLING_PRICE
,      QUANTITY
,      TAX_CATEGORY_ID
,      TAX_AMOUNT
,      REGISTER
,      LOCATION_ID
,      EXCISE_AMOUNT
,      BASIC_EXCISE_DUTY_AMOUNT
,      ADD_EXCISE_DUTY_AMOUNT
,      OTH_EXCISE_DUTY_AMOUNT
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      UNIT_CODE
,      ASSESSABLE_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PREPRINTED_EXCISE_INV_NO
,      EXC_EXEMPT_CERT_FLAG
,      CT3_FORM_FLAG
,      EXC_EXEMPT_REF_DATE
,      EXCISE_EXEMPT_REFNO
,      EXCISE_EXEMPT_TYPE
,      EXCISE_EXEMPT_DATE
,      AR3_FORM_NO
,      AR3_FORM_DATE
,      DELIVERY_DETAIL_ID
,      ORDER_HEADER_ID
,      SPLIT_FROM_DELIVERY_DETAIL_ID
,      ORG_ID
,      CUSTOMER_ID
,      SHIP_TO_ORG_ID
,      ORDER_TYPE_ID
,      SUBINVENTORY
,      DELIVERY_ID
,      VAT_EXEMPTION_FLAG
,      VAT_EXEMPTION_TYPE
,      VAT_EXEMPTION_DATE
,      VAT_EXEMPTION_REFNO
,      VAT_ASSESSABLE_VALUE
,      VAT_INVOICE_NO
,      VAT_INVOICE_DATE
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      SHIPPABLE_FLAG
,      GST_INVOICE_NO
,      GST_INVOICE_DATE
,      GST_ASSESSABLE_VALUE
FROM JA.JAI_OM_WSH_LINES_ALL;

Dependencies

[top of page]

JA.JAI_OM_WSH_LINES_ALL does not reference any database object

JA.JAI_OM_WSH_LINES_ALL is referenced by following:

SchemaJA
ViewJAI_OM_WSH_LINES_ALL#