VIEW: GMF.GL_SUBR_TST_VAR#

Source

View Text - Preformatted

select SUBLEDGER_VARIANCE_ID SUBLEDGER_VARIANCE_ID, REFERENCE_NO REFERENCE_NO, CO_CODE CO_CODE, FISCAL_YEAR FISCAL_YEAR, PERIOD PERIOD, DOC_TYPE DOC_TYPE, DOC_ID DOC_ID, LINE_ID LINE_ID, ITEM_ID ITEM_ID, RESOURCES RESOURCES, VARIANCE_TYPE VARIANCE_TYPE, TRANS_SOURCE_TYPE TRANS_SOURCE_TYPE, SUB_EVENT_TYPE SUB_EVENT_TYPE, ACCT_TTL_TYPE ACCT_TTL_TYPE, AMOUNT_BASE AMOUNT_BASE, AMOUNT_TRANS AMOUNT_TRANS, DEBIT_CREDIT_SIGN DEBIT_CREDIT_SIGN, QUANTITY QUANTITY, QUANTITY_UOM QUANTITY_UOM, 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, DELETE_MARK DELETE_MARK from "GMF"."GL_SUBR_TST_VAR"

View Text - HTML Formatted

SELECT SUBLEDGER_VARIANCE_ID SUBLEDGER_VARIANCE_ID
, REFERENCE_NO REFERENCE_NO
, CO_CODE CO_CODE
, FISCAL_YEAR FISCAL_YEAR
, PERIOD PERIOD
, DOC_TYPE DOC_TYPE
, DOC_ID DOC_ID
, LINE_ID LINE_ID
, ITEM_ID ITEM_ID
, RESOURCES RESOURCES
, VARIANCE_TYPE VARIANCE_TYPE
, TRANS_SOURCE_TYPE TRANS_SOURCE_TYPE
, SUB_EVENT_TYPE SUB_EVENT_TYPE
, ACCT_TTL_TYPE ACCT_TTL_TYPE
, AMOUNT_BASE AMOUNT_BASE
, AMOUNT_TRANS AMOUNT_TRANS
, DEBIT_CREDIT_SIGN DEBIT_CREDIT_SIGN
, QUANTITY QUANTITY
, QUANTITY_UOM QUANTITY_UOM
, 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
, DELETE_MARK DELETE_MARK
FROM "GMF"."GL_SUBR_TST_VAR"