VIEW: JA.JAI_OM_WSH_LINES_ALL#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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