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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGS_FI_CONTROL_V

Object Details

Object Name:	IGS_FI_CONTROL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_FI_CONTROL_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
REC_INSTALLED	VARCHAR2	(1)	Yes
ACCOUNTING_METHOD	VARCHAR2	(80)
ACCOUNTING_METHOD_CODE	VARCHAR2	(30)
INTERFACE_LINE_CONTEXT	VARCHAR2	(30)		No longer used.
INTERFACE_LINE_ATTRIBUTE	VARCHAR2	(30)		No longer used.
BATCH_SOURCE_ID	NUMBER	(15)		No longer used.
BATCH_SOURCE_NAME	VARCHAR2	(0)		No longer used.
CUST_TRX_TYPE_ID	NUMBER	(15)		No longer used.
CUST_TRX_TYPE_NAME	VARCHAR2	(0)		No longer used.
TERM_ID	NUMBER	(15)		No longer used.
PAYMENT_TERM_NAME	VARCHAR2	(0)		No longer used.
LOCKBOX_CONTEXT	VARCHAR2	(30)		No longer used.
LOCKBOX_NUMBER_ATTRIBUTE	VARCHAR2	(150)		No longer used.
NEXT_CHARGE_NUMBER	VARCHAR2	(60)		No longer used.
LAST_ACCOUNT_TRANS	DATE
LAST_PAY_TERM_TRANS	DATE
LAST_PAYMENT_TRANS	DATE
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
ORG_ID	NUMBER	(15)		The Org ID Column for Multi Org functionality
REFUND_DR_GL_CCID	NUMBER	(38)		General ledger account code combination identifier.
REFUND_CR_GL_CCID	NUMBER	(38)		General ledger account code combination identifier.
REFUND_DR_ACCOUNT_CD	VARCHAR2	(40)		Account code
REFUND_DR_ACCOUNT_DESC	VARCHAR2	(60)		Description of debit account
REFUND_CR_ACCOUNT_CD	VARCHAR2	(40)		Account code
REFUND_CR_ACCOUNT_DESC	VARCHAR2	(60)		Description of credit account
REFUND_DT_ALIAS	VARCHAR2	(10)		Date alias for the refunds add drop period
REFUND_DT_ALIAS_DESC	VARCHAR2	(60)		Description for the date alias for the refunds add drop period
SET_OF_BOOKS_ID	NUMBER	(15)		No Longer Used
SET_OF_BOOKS_NAME	VARCHAR2	(30)		No Longer Used
PRG_CHG_DT_ALIAS	VARCHAR2	(0)		No longer used
PRG_CHG_DT_ALIAS_DESC	VARCHAR2	(0)		No longer used
FEE_CALC_MTHD_CODE	VARCHAR2	(30)		The Fee Calculation Method to be Used
FEE_CALC_MTHD	VARCHAR2	(80)		The description of Fee Calculation Method to be used
AR_INT_ORG_ID	NUMBER	(15)		No longer used.
PLANNED_CREDITS_IND	VARCHAR2	(1)		Suggests if the Student Finance sub system should consider planned credits for the transactions
REC_GL_CCID	NUMBER	(38)		Receivables Account Code Combination identifier
CASH_GL_CCID	NUMBER	(38)		Cash Account Code Combination identifier
UNAPP_GL_CCID	NUMBER	(38)		Unapplied Account Code Combination identifier
REC_ACCOUNT_CD	VARCHAR2	(40)		Receivables Account Code String
REC_ACCOUNT_DESC	VARCHAR2	(60)
REV_ACCOUNT_CD	VARCHAR2	(40)		Revenue Account Code String
REV_ACCOUNT_DESC	VARCHAR2	(0)
CASH_ACCOUNT_CD	VARCHAR2	(40)		Cash Account Code String
CASH_ACCOUNT_DESC	VARCHAR2	(60)
UNAPP_ACCOUNT_CD	VARCHAR2	(40)		Unapplied Account Code String
UNAPP_ACCOUNT_DESC	VARCHAR2	(60)
CONV_PROCESS_RUN_IND	NUMBER
CURRENCY_CD	VARCHAR2	(15)		The functional currency code.
NAME	VARCHAR2	(80)		The currency code description.
RFND_DESTINATION	VARCHAR2	(30)		Column for storing the Refund Destination.
RFND_DESTINATION_DESC	VARCHAR2	(80)		The Meaning for the Refund Destination.
AP_ORG_ID	NUMBER			Organization Identifier for the Payables Operating Unit.
AP_ORG_ID_NAME	VARCHAR2	(240)		Name of the Payables Operating Unit.
DFLT_SUPPLIER_SITE_NAME	VARCHAR2	(15)		No longer used
MANAGE_ACCOUNTS	VARCHAR2	(30)		This column indicates the decision for the management of Accounts. The valid values are Student Finance and Other.
ACCT_CONV_FLAG	VARCHAR2	(1)		Flag for Account conversion process.
RES_DT_ALIAS	VARCHAR2	(0)		No longer used.
RES_DT_ALIAS_DESC	VARCHAR2	(0)		No longer used.
POST_WAIVER_GL_FLAG	VARCHAR2	(1)		Flag to identify if waiver credit transaction needs to be posted to General Ledger for a Cash base Accounting
WAIVER_NOTIFY_FINAID_FLAG	VARCHAR2	(1)		Flag to indicate if waiver transaction for the student should be reported to Financial Aid

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      REC_INSTALLED
,      ACCOUNTING_METHOD
,      ACCOUNTING_METHOD_CODE
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE
,      BATCH_SOURCE_ID
,      BATCH_SOURCE_NAME
,      CUST_TRX_TYPE_ID
,      CUST_TRX_TYPE_NAME
,      TERM_ID
,      PAYMENT_TERM_NAME
,      LOCKBOX_CONTEXT
,      LOCKBOX_NUMBER_ATTRIBUTE
,      NEXT_CHARGE_NUMBER
,      LAST_ACCOUNT_TRANS
,      LAST_PAY_TERM_TRANS
,      LAST_PAYMENT_TRANS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      REFUND_DR_GL_CCID
,      REFUND_CR_GL_CCID
,      REFUND_DR_ACCOUNT_CD
,      REFUND_DR_ACCOUNT_DESC
,      REFUND_CR_ACCOUNT_CD
,      REFUND_CR_ACCOUNT_DESC
,      REFUND_DT_ALIAS
,      REFUND_DT_ALIAS_DESC
,      SET_OF_BOOKS_ID
,      SET_OF_BOOKS_NAME
,      PRG_CHG_DT_ALIAS
,      PRG_CHG_DT_ALIAS_DESC
,      FEE_CALC_MTHD_CODE
,      FEE_CALC_MTHD
,      AR_INT_ORG_ID
,      PLANNED_CREDITS_IND
,      REC_GL_CCID
,      CASH_GL_CCID
,      UNAPP_GL_CCID
,      REC_ACCOUNT_CD
,      REC_ACCOUNT_DESC
,      REV_ACCOUNT_CD
,      REV_ACCOUNT_DESC
,      CASH_ACCOUNT_CD
,      CASH_ACCOUNT_DESC
,      UNAPP_ACCOUNT_CD
,      UNAPP_ACCOUNT_DESC
,      CONV_PROCESS_RUN_IND
,      CURRENCY_CD
,      NAME
,      RFND_DESTINATION
,      RFND_DESTINATION_DESC
,      AP_ORG_ID
,      AP_ORG_ID_NAME
,      DFLT_SUPPLIER_SITE_NAME
,      MANAGE_ACCOUNTS
,      ACCT_CONV_FLAG
,      RES_DT_ALIAS
,      RES_DT_ALIAS_DESC
,      POST_WAIVER_GL_FLAG
,      WAIVER_NOTIFY_FINAID_FLAG
FROM APPS.IGS_FI_CONTROL_V;

Dependencies

[top of page]

APPS.IGS_FI_CONTROL_V references the following:

APPS: FND_CURRENCIES_TL; GL_SETS_OF_BOOKS; HR_OPERATING_UNITS; IGS_CA_DA; IGS_FI_ACC; IGS_FI_CONTROL; IGS_LOOKUP_VALUES

APPS.IGS_FI_CONTROL_V is referenced by following:

APPS: IGS_FI_CRDAPI_UTIL - show dependent code; IGS_FI_GEN_GL - show dependent code; IGS_FI_PRC_APINT - show dependent code