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_WSH_LINES_ALL

Object Details

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

Capture localization information picking line wise.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_OM_WSH_LINES_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCISE_INVOICE_NO
JAI_OM_WSH_LINES_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_LINE_ID
JAI_OM_WSH_LINES_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELIVERY_ID DELIVERY_DETAIL_ID
JAI_OM_WSH_LINES_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_HEADER_ID
JAI_OM_WSH_LINES_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VAT_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:

JA: JAI_OM_WSH_LINES_ALL#