VIEW: JA.JAI_RCV_TRANSACTIONS#

Source

View Text - Preformatted

select SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_DATE TRANSACTION_DATE, QUANTITY QUANTITY, UOM_CODE UOM_CODE, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID, PARENT_TRANSACTION_TYPE PARENT_TRANSACTION_TYPE, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE, RECEIPT_NUM RECEIPT_NUM, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, EXCISE_INVOICE_NO EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE, TAX_AMOUNT TAX_AMOUNT, ASSESSABLE_VALUE ASSESSABLE_VALUE, CENVAT_AMOUNT CENVAT_AMOUNT, CENVAT_CLAIMED_PTG CENVAT_CLAIMED_PTG, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, ITEM_CLASS ITEM_CLASS, ITEM_CENVATABLE ITEM_CENVATABLE, ITEM_EXCISABLE ITEM_EXCISABLE, ITEM_TRADING_FLAG ITEM_TRADING_FLAG, INV_ITEM_FLAG INV_ITEM_FLAG, INV_ASSET_FLAG INV_ASSET_FLAG, LOC_SUBINV_TYPE LOC_SUBINV_TYPE, ORGANIZATION_TYPE ORGANIZATION_TYPE, EXCISE_IN_TRADING EXCISE_IN_TRADING, COSTING_METHOD COSTING_METHOD, BOE_APPLIED_FLAG BOE_APPLIED_FLAG, THIRD_PARTY_FLAG THIRD_PARTY_FLAG, PROCESS_MESSAGE PROCESS_MESSAGE, CENVAT_RG_MESSAGE CENVAT_RG_MESSAGE, PROCESS_DATE PROCESS_DATE, CODEPATH CODEPATH, 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, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, TAX_TRANSACTION_ID TAX_TRANSACTION_ID, PROCESS_VAT_MESSAGE PROCESS_VAT_MESSAGE, VAT_INVOICE_NO VAT_INVOICE_NO, VAT_INVOICE_DATE VAT_INVOICE_DATE, BASE_ASSET_INVENTORY BASE_ASSET_INVENTORY, PROCESS_STATUS PROCESS_STATUS, CENVAT_RG_STATUS CENVAT_RG_STATUS, PROCESS_VAT_STATUS PROCESS_VAT_STATUS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TAX_APPORTION_FACTOR TAX_APPORTION_FACTOR, QUANTITY_REGISTER_FLAG QUANTITY_REGISTER_FLAG, OPM_COSTING_FLAG OPM_COSTING_FLAG, OPM_COSTING_AMOUNT OPM_COSTING_AMOUNT, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, EXCISE_INV_GEN_STATUS EXCISE_INV_GEN_STATUS, VAT_INV_GEN_STATUS VAT_INV_GEN_STATUS, EXCISE_INV_GEN_NUMBER EXCISE_INV_GEN_NUMBER, VAT_INV_GEN_NUMBER VAT_INV_GEN_NUMBER, CENVAT_COSTED_FLAG CENVAT_COSTED_FLAG, TRX_INFORMATION TRX_INFORMATION, GST_INVOICE_NO GST_INVOICE_NO, GST_INVOICE_DATE GST_INVOICE_DATE from "JA"."JAI_RCV_TRANSACTIONS"

View Text - HTML Formatted

SELECT SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_DATE TRANSACTION_DATE
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID
, PARENT_TRANSACTION_TYPE PARENT_TRANSACTION_TYPE
, DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, RECEIPT_NUM RECEIPT_NUM
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, EXCISE_INVOICE_NO EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE EXCISE_INVOICE_DATE
, TAX_AMOUNT TAX_AMOUNT
, ASSESSABLE_VALUE ASSESSABLE_VALUE
, CENVAT_AMOUNT CENVAT_AMOUNT
, CENVAT_CLAIMED_PTG CENVAT_CLAIMED_PTG
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, ITEM_CLASS ITEM_CLASS
, ITEM_CENVATABLE ITEM_CENVATABLE
, ITEM_EXCISABLE ITEM_EXCISABLE
, ITEM_TRADING_FLAG ITEM_TRADING_FLAG
, INV_ITEM_FLAG INV_ITEM_FLAG
, INV_ASSET_FLAG INV_ASSET_FLAG
, LOC_SUBINV_TYPE LOC_SUBINV_TYPE
, ORGANIZATION_TYPE ORGANIZATION_TYPE
, EXCISE_IN_TRADING EXCISE_IN_TRADING
, COSTING_METHOD COSTING_METHOD
, BOE_APPLIED_FLAG BOE_APPLIED_FLAG
, THIRD_PARTY_FLAG THIRD_PARTY_FLAG
, PROCESS_MESSAGE PROCESS_MESSAGE
, CENVAT_RG_MESSAGE CENVAT_RG_MESSAGE
, PROCESS_DATE PROCESS_DATE
, CODEPATH CODEPATH
, 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
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, TAX_TRANSACTION_ID TAX_TRANSACTION_ID
, PROCESS_VAT_MESSAGE PROCESS_VAT_MESSAGE
, VAT_INVOICE_NO VAT_INVOICE_NO
, VAT_INVOICE_DATE VAT_INVOICE_DATE
, BASE_ASSET_INVENTORY BASE_ASSET_INVENTORY
, PROCESS_STATUS PROCESS_STATUS
, CENVAT_RG_STATUS CENVAT_RG_STATUS
, PROCESS_VAT_STATUS PROCESS_VAT_STATUS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TAX_APPORTION_FACTOR TAX_APPORTION_FACTOR
, QUANTITY_REGISTER_FLAG QUANTITY_REGISTER_FLAG
, OPM_COSTING_FLAG OPM_COSTING_FLAG
, OPM_COSTING_AMOUNT OPM_COSTING_AMOUNT
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, EXCISE_INV_GEN_STATUS EXCISE_INV_GEN_STATUS
, VAT_INV_GEN_STATUS VAT_INV_GEN_STATUS
, EXCISE_INV_GEN_NUMBER EXCISE_INV_GEN_NUMBER
, VAT_INV_GEN_NUMBER VAT_INV_GEN_NUMBER
, CENVAT_COSTED_FLAG CENVAT_COSTED_FLAG
, TRX_INFORMATION TRX_INFORMATION
, GST_INVOICE_NO GST_INVOICE_NO
, GST_INVOICE_DATE GST_INVOICE_DATE
FROM "JA"."JAI_RCV_TRANSACTIONS"