eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: FV.FV_OPERATING_UNITS_ALL#

Source

View Text - Preformatted


select ORGANIZATION_ID ORGANIZATION_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ALC_CODE ALC_CODE, RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID, PAYABLES_IA_PAYGROUP PAYABLES_IA_PAYGROUP, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, ORG_ID ORG_ID, DIT_FLAG DIT_FLAG, DIT_CASH_TRAN_CODE DIT_CASH_TRAN_CODE, ENABLED ENABLED, DEFAULT_ALC DEFAULT_ALC, FED_EMPLOYER_ID_NUMBER FED_EMPLOYER_ID_NUMBER, PREPAYMENT_TOLERANCE_FLAG PREPAYMENT_TOLERANCE_FLAG, PREPAYMENT_TOLERANCE PREPAYMENT_TOLERANCE, ADVANCE_LIMIT ADVANCE_LIMIT, PAYABLES_TOLERANCE_FLAG PAYABLES_TOLERANCE_FLAG, PAYABLES_TOLERANCE PAYABLES_TOLERANCE, DUNS_NUMBER DUNS_NUMBER, DIT_CONFIRM_CASH_ACCOUNT DIT_CONFIRM_CASH_ACCOUNT, CONFIRM_CASH_ACCOUNT CONFIRM_CASH_ACCOUNT, REIM_TRANSACTION_SOURCE REIM_TRANSACTION_SOURCE, REC_DUE_TRANSACTION_TYPE REC_DUE_TRANSACTION_TYPE, REC_DUE_PREFIX REC_DUE_PREFIX, LIQ_ADV_TRANSACTION_TYPE LIQ_ADV_TRANSACTION_TYPE, LIQ_ADV_PREFIX LIQ_ADV_PREFIX, REIM_TRANSACTION_SOURCE_ID REIM_TRANSACTION_SOURCE_ID, REC_DUE_TRANSACTION_TYPE_ID REC_DUE_TRANSACTION_TYPE_ID, LIQ_ADV_TRANSACTION_TYPE_ID LIQ_ADV_TRANSACTION_TYPE_ID, USER_ID USER_ID, PASSWORD PASSWORD from "FV"."FV_OPERATING_UNITS_ALL"

View Text - HTML Formatted

SELECT ORGANIZATION_ID ORGANIZATION_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ALC_CODE ALC_CODE
, RECEIVABLES_TRX_ID RECEIVABLES_TRX_ID
, PAYABLES_IA_PAYGROUP PAYABLES_IA_PAYGROUP
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, ORG_ID ORG_ID
, DIT_FLAG DIT_FLAG
, DIT_CASH_TRAN_CODE DIT_CASH_TRAN_CODE
, ENABLED ENABLED
, DEFAULT_ALC DEFAULT_ALC
, FED_EMPLOYER_ID_NUMBER FED_EMPLOYER_ID_NUMBER
, PREPAYMENT_TOLERANCE_FLAG PREPAYMENT_TOLERANCE_FLAG
, PREPAYMENT_TOLERANCE PREPAYMENT_TOLERANCE
, ADVANCE_LIMIT ADVANCE_LIMIT
, PAYABLES_TOLERANCE_FLAG PAYABLES_TOLERANCE_FLAG
, PAYABLES_TOLERANCE PAYABLES_TOLERANCE
, DUNS_NUMBER DUNS_NUMBER
, DIT_CONFIRM_CASH_ACCOUNT DIT_CONFIRM_CASH_ACCOUNT
, CONFIRM_CASH_ACCOUNT CONFIRM_CASH_ACCOUNT
, REIM_TRANSACTION_SOURCE REIM_TRANSACTION_SOURCE
, REC_DUE_TRANSACTION_TYPE REC_DUE_TRANSACTION_TYPE
, REC_DUE_PREFIX REC_DUE_PREFIX
, LIQ_ADV_TRANSACTION_TYPE LIQ_ADV_TRANSACTION_TYPE
, LIQ_ADV_PREFIX LIQ_ADV_PREFIX
, REIM_TRANSACTION_SOURCE_ID REIM_TRANSACTION_SOURCE_ID
, REC_DUE_TRANSACTION_TYPE_ID REC_DUE_TRANSACTION_TYPE_ID
, LIQ_ADV_TRANSACTION_TYPE_ID LIQ_ADV_TRANSACTION_TYPE_ID
, USER_ID USER_ID
, PASSWORD PASSWORD
FROM "FV"."FV_OPERATING_UNITS_ALL"