VIEW: JA.JAI_RCV_LINES#

Source

View Text - Preformatted

select SHIPMENT_LINE_ID SHIPMENT_LINE_ID, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, RECEIPT_NUM RECEIPT_NUM, QTY_RECEIVED QTY_RECEIVED, CLAIM_MODVAT_FLAG CLAIM_MODVAT_FLAG, BOE_NUMBER BOE_NUMBER, EXCISE_INVOICE_NO EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE, TAX_MODIFIED_FLAG TAX_MODIFIED_FLAG, LINE_LOCATION_ID LINE_LOCATION_ID, TAX_AMOUNT TAX_AMOUNT, 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, BOE_APPLIED_FLAG BOE_APPLIED_FLAG, PROCESS_RECEIVING PROCESS_RECEIVING, PROCESS_DELIVERY PROCESS_DELIVERY, PROCESS_THIRD_PARTY_INV PROCESS_THIRD_PARTY_INV, PROCESS_MODVAT PROCESS_MODVAT, PROCESS_RG PROCESS_RG, TRANSACTION_ID TRANSACTION_ID, ORGANIZATION_ID ORGANIZATION_ID, PROCESS_POPULATE_CENVAT PROCESS_POPULATE_CENVAT, PROCESS_RTR PROCESS_RTR, PROCESS_RTV PROCESS_RTV, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ONLINE_CLAIM_FLAG ONLINE_CLAIM_FLAG, RMA_TYPE RMA_TYPE, MFG_TRADING MFG_TRADING, 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, GST_INVOICE_NO GST_INVOICE_NO, GST_INVOICE_DATE GST_INVOICE_DATE from "JA"."JAI_RCV_LINES"

View Text - HTML Formatted

SELECT SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, RECEIPT_NUM RECEIPT_NUM
, QTY_RECEIVED QTY_RECEIVED
, CLAIM_MODVAT_FLAG CLAIM_MODVAT_FLAG
, BOE_NUMBER BOE_NUMBER
, EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, TAX_MODIFIED_FLAG TAX_MODIFIED_FLAG
, LINE_LOCATION_ID LINE_LOCATION_ID
, TAX_AMOUNT TAX_AMOUNT
, 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
, BOE_APPLIED_FLAG BOE_APPLIED_FLAG
, PROCESS_RECEIVING PROCESS_RECEIVING
, PROCESS_DELIVERY PROCESS_DELIVERY
, PROCESS_THIRD_PARTY_INV PROCESS_THIRD_PARTY_INV
, PROCESS_MODVAT PROCESS_MODVAT
, PROCESS_RG PROCESS_RG
, TRANSACTION_ID TRANSACTION_ID
, ORGANIZATION_ID ORGANIZATION_ID
, PROCESS_POPULATE_CENVAT PROCESS_POPULATE_CENVAT
, PROCESS_RTR PROCESS_RTR
, PROCESS_RTV PROCESS_RTV
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ONLINE_CLAIM_FLAG ONLINE_CLAIM_FLAG
, RMA_TYPE RMA_TYPE
, MFG_TRADING MFG_TRADING
, 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
, GST_INVOICE_NO GST_INVOICE_NO
, GST_INVOICE_DATE GST_INVOICE_DATE
FROM "JA"."JAI_RCV_LINES"