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

VIEW: JA.JAI_OM_WSH_LINES_ALL#

Object Details
Object Name: JAI_OM_WSH_LINES_ALL#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PICKING_LINE_ID NUMBER

EXCISE_INVOICE_NO VARCHAR2 (200)
EXCISE_INVOICE_DATE DATE

PICKING_HEADER_ID NUMBER

ORDER_LINE_ID NUMBER
Yes
SELLING_PRICE NUMBER
Yes
QUANTITY NUMBER
Yes
TAX_CATEGORY_ID NUMBER (15)
TAX_AMOUNT NUMBER

REGISTER VARCHAR2 (15)
LOCATION_ID NUMBER
Yes
EXCISE_AMOUNT NUMBER

BASIC_EXCISE_DUTY_AMOUNT NUMBER

ADD_EXCISE_DUTY_AMOUNT NUMBER

OTH_EXCISE_DUTY_AMOUNT NUMBER

ORGANIZATION_ID NUMBER

INVENTORY_ITEM_ID NUMBER (15)
UNIT_CODE VARCHAR2 (3)
ASSESSABLE_VALUE NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
PREPRINTED_EXCISE_INV_NO VARCHAR2 (50)
EXC_EXEMPT_CERT_FLAG VARCHAR2 (1)
CT3_FORM_FLAG VARCHAR2 (1)
EXC_EXEMPT_REF_DATE DATE

EXCISE_EXEMPT_REFNO VARCHAR2 (30)
EXCISE_EXEMPT_TYPE VARCHAR2 (30)
EXCISE_EXEMPT_DATE DATE

AR3_FORM_NO VARCHAR2 (30)
AR3_FORM_DATE DATE

DELIVERY_DETAIL_ID NUMBER

ORDER_HEADER_ID NUMBER

SPLIT_FROM_DELIVERY_DETAIL_ID NUMBER

ORG_ID NUMBER

CUSTOMER_ID NUMBER

SHIP_TO_ORG_ID NUMBER

ORDER_TYPE_ID NUMBER

SUBINVENTORY VARCHAR2 (10)
DELIVERY_ID NUMBER

VAT_EXEMPTION_FLAG VARCHAR2 (1)
VAT_EXEMPTION_TYPE VARCHAR2 (30)
VAT_EXEMPTION_DATE DATE

VAT_EXEMPTION_REFNO VARCHAR2 (100)
VAT_ASSESSABLE_VALUE NUMBER

VAT_INVOICE_NO VARCHAR2 (240)
VAT_INVOICE_DATE DATE

OBJECT_VERSION_NUMBER NUMBER

ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
SHIPPABLE_FLAG VARCHAR2 (1)
GST_INVOICE_NO VARCHAR2 (150)
GST_INVOICE_DATE DATE

GST_ASSESSABLE_VALUE 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
,      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# references the following:

SchemaJA
TableJAI_OM_WSH_LINES_ALL
JA.JAI_OM_WSH_LINES_ALL# is referenced by following:

SchemaAPPS
SynonymJAI_OM_WSH_LINES_ALL