VIEW: JA.JAI_RGM_REFS_ALL#

Source

View Text - Preformatted

select TRX_REF_ID TRX_REF_ID, TRANSACTION_ID TRANSACTION_ID, REGIME_ID REGIME_ID, PARTY_ID PARTY_ID, PARTY_TYPE PARTY_TYPE, PARTY_SITE_ID PARTY_SITE_ID, ITEM_CLASSIFICATION ITEM_CLASSIFICATION, ORG_ID ORG_ID, ORGANIZATION_ID ORGANIZATION_ID, LOCATION_ID LOCATION_ID, ORG_TAN_NO ORG_TAN_NO, FIN_YEAR FIN_YEAR, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_TYPE SOURCE_DOCUMENT_TYPE, SOURCE_DOCUMENT_DATE SOURCE_DOCUMENT_DATE, SOURCE_TABLE_NAME SOURCE_TABLE_NAME, SOURCE_DOCUMENT_AMT SOURCE_DOCUMENT_AMT, SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID, LINE_AMT LINE_AMT, TOTAL_TAX_AMT TOTAL_TAX_AMT, SOURCE_REF_DOCUMENT_ID SOURCE_REF_DOCUMENT_ID, SOURCE_REF_DOCUMENT_TYPE SOURCE_REF_DOCUMENT_TYPE, APP_FROM_DOCUMENT_ID APP_FROM_DOCUMENT_ID, APP_FROM_DOCUMENT_TYPE APP_FROM_DOCUMENT_TYPE, APP_TO_DOCUMENT_ID APP_TO_DOCUMENT_ID, APP_TO_DOCUMENT_TYPE APP_TO_DOCUMENT_TYPE, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID, THRESHOLD_SLAB_ID THRESHOLD_SLAB_ID, SETTLEMENT_ID SETTLEMENT_ID, CERTIFICATE_ID CERTIFICATE_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_RGM_REFS_ALL"

View Text - HTML Formatted

SELECT TRX_REF_ID TRX_REF_ID
, TRANSACTION_ID TRANSACTION_ID
, REGIME_ID REGIME_ID
, PARTY_ID PARTY_ID
, PARTY_TYPE PARTY_TYPE
, PARTY_SITE_ID PARTY_SITE_ID
, ITEM_CLASSIFICATION ITEM_CLASSIFICATION
, ORG_ID ORG_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LOCATION_ID LOCATION_ID
, ORG_TAN_NO ORG_TAN_NO
, FIN_YEAR FIN_YEAR
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, SOURCE_DOCUMENT_TYPE SOURCE_DOCUMENT_TYPE
, SOURCE_DOCUMENT_DATE SOURCE_DOCUMENT_DATE
, SOURCE_TABLE_NAME SOURCE_TABLE_NAME
, SOURCE_DOCUMENT_AMT SOURCE_DOCUMENT_AMT
, SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID
, LINE_AMT LINE_AMT
, TOTAL_TAX_AMT TOTAL_TAX_AMT
, SOURCE_REF_DOCUMENT_ID SOURCE_REF_DOCUMENT_ID
, SOURCE_REF_DOCUMENT_TYPE SOURCE_REF_DOCUMENT_TYPE
, APP_FROM_DOCUMENT_ID APP_FROM_DOCUMENT_ID
, APP_FROM_DOCUMENT_TYPE APP_FROM_DOCUMENT_TYPE
, APP_TO_DOCUMENT_ID APP_TO_DOCUMENT_ID
, APP_TO_DOCUMENT_TYPE APP_TO_DOCUMENT_TYPE
, PARENT_TRANSACTION_ID PARENT_TRANSACTION_ID
, THRESHOLD_SLAB_ID THRESHOLD_SLAB_ID
, SETTLEMENT_ID SETTLEMENT_ID
, CERTIFICATE_ID CERTIFICATE_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_RGM_REFS_ALL"