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_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDELIVERY_DETAIL_ID
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
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
Yes 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
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
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:

SchemaAPPS
SynonymJAI_OM_WSH_LINES_ALL