VIEW: JA.JAI_OM_OE_SO_LINES#

Source

View Text - Preformatted

select LINE_NUMBER LINE_NUMBER, LINE_ID LINE_ID, HEADER_ID HEADER_ID, SHIPMENT_SCHEDULE_LINE_ID SHIPMENT_SCHEDULE_LINE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, UNIT_CODE UNIT_CODE, QUANTITY QUANTITY, TAX_CATEGORY_ID TAX_CATEGORY_ID, SELLING_PRICE SELLING_PRICE, LINE_AMOUNT LINE_AMOUNT, ASSESSABLE_VALUE ASSESSABLE_VALUE, TAX_AMOUNT TAX_AMOUNT, LINE_TOT_AMOUNT LINE_TOT_AMOUNT, SHIPMENT_SCHEDULE_FLAG SHIPMENT_SCHEDULE_FLAG, SHIPMENT_LINE_NUMBER SHIPMENT_LINE_NUMBER, 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, ATO_FLAG ATO_FLAG, EXCISE_EXEMPT_TYPE EXCISE_EXEMPT_TYPE, EXCISE_EXEMPT_REFNO EXCISE_EXEMPT_REFNO, EXCISE_EXEMPT_DATE EXCISE_EXEMPT_DATE, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID, LC_FLAG LC_FLAG, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SERVICE_TYPE_CODE SERVICE_TYPE_CODE, VAT_REVERSAL_PRICE VAT_REVERSAL_PRICE, 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, GST_ASSESSABLE_VALUE GST_ASSESSABLE_VALUE, SHIP_TO_ORG_ID SHIP_TO_ORG_ID from "JA"."JAI_OM_OE_SO_LINES"

View Text - HTML Formatted

SELECT LINE_NUMBER LINE_NUMBER
, LINE_ID LINE_ID
, HEADER_ID HEADER_ID
, SHIPMENT_SCHEDULE_LINE_ID SHIPMENT_SCHEDULE_LINE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, UNIT_CODE UNIT_CODE
, QUANTITY QUANTITY
, TAX_CATEGORY_ID TAX_CATEGORY_ID
, SELLING_PRICE SELLING_PRICE
, LINE_AMOUNT LINE_AMOUNT
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, TAX_AMOUNT TAX_AMOUNT
, LINE_TOT_AMOUNT LINE_TOT_AMOUNT
, SHIPMENT_SCHEDULE_FLAG SHIPMENT_SCHEDULE_FLAG
, SHIPMENT_LINE_NUMBER SHIPMENT_LINE_NUMBER
, 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
, ATO_FLAG ATO_FLAG
, EXCISE_EXEMPT_TYPE EXCISE_EXEMPT_TYPE
, EXCISE_EXEMPT_REFNO EXCISE_EXEMPT_REFNO
, EXCISE_EXEMPT_DATE EXCISE_EXEMPT_DATE
, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID
, LC_FLAG LC_FLAG
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, VAT_REVERSAL_PRICE VAT_REVERSAL_PRICE
, 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
, GST_ASSESSABLE_VALUE GST_ASSESSABLE_VALUE
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
FROM "JA"."JAI_OM_OE_SO_LINES"