VIEW: JA.JAI_RCV_RGM_CLAIMS#

Source

View Text - Preformatted

select CLAIM_SCHEDULE_ID CLAIM_SCHEDULE_ID, RCV_RGM_LINE_ID RCV_RGM_LINE_ID, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, REGIME_CODE REGIME_CODE, TAX_TRANSACTION_ID TAX_TRANSACTION_ID, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_ID TRANSACTION_ID, PARENT_TRANSACTION_TYPE PARENT_TRANSACTION_TYPE, INSTALLMENT_NO INSTALLMENT_NO, INSTALLMENT_AMOUNT INSTALLMENT_AMOUNT, CLAIMED_AMOUNT CLAIMED_AMOUNT, SCHEDULED_DATE SCHEDULED_DATE, CLAIMED_DATE CLAIMED_DATE, STATUS STATUS, MANUAL_CLAIM_FLAG MANUAL_CLAIM_FLAG, REMARKS REMARKS, TAX_TYPE TAX_TYPE, TAX_ID TAX_ID, TRX_TAX_ID TRX_TAX_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "JA"."JAI_RCV_RGM_CLAIMS"

View Text - HTML Formatted

SELECT CLAIM_SCHEDULE_ID CLAIM_SCHEDULE_ID
, RCV_RGM_LINE_ID RCV_RGM_LINE_ID
, SHIPMENT_HEADER_ID SHIPMENT_HEADER_ID
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, REGIME_CODE REGIME_CODE
, TAX_TRANSACTION_ID TAX_TRANSACTION_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_ID TRANSACTION_ID
, PARENT_TRANSACTION_TYPE PARENT_TRANSACTION_TYPE
, INSTALLMENT_NO INSTALLMENT_NO
, INSTALLMENT_AMOUNT INSTALLMENT_AMOUNT
, CLAIMED_AMOUNT CLAIMED_AMOUNT
, SCHEDULED_DATE SCHEDULED_DATE
, CLAIMED_DATE CLAIMED_DATE
, STATUS STATUS
, MANUAL_CLAIM_FLAG MANUAL_CLAIM_FLAG
, REMARKS REMARKS
, TAX_TYPE TAX_TYPE
, TAX_ID TAX_ID
, TRX_TAX_ID TRX_TAX_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "JA"."JAI_RCV_RGM_CLAIMS"