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

VIEW: APPS.IGS_FI_CONTROL

Object Details
Object Name: IGS_FI_CONTROL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_CONTROL
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
REC_INSTALLED VARCHAR2 (1) Yes
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)
ACCOUNTING_METHOD VARCHAR2 (30)
INTERFACE_LINE_CONTEXT VARCHAR2 (30)
No longer used.
INTERFACE_LINE_ATTRIBUTE VARCHAR2 (30)
No longer used.
LOCKBOX_CONTEXT VARCHAR2 (30)
No longer used.
LOCKBOX_NUMBER_ATTRIBUTE VARCHAR2 (150)
No longer used.
NEXT_INVOICE_NUMBER VARCHAR2 (60)
No longer used.
CUST_TRX_TYPE_ID NUMBER (15)
No longer used.
TERM_ID NUMBER (15)
No longer used.
BATCH_SOURCE_ID NUMBER (15)
No longer used.
SET_OF_BOOKS_ID NUMBER (15)
No Longer Used
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_CR_ACCOUNT_CD VARCHAR2 (40)
Account code
REFUND_DT_ALIAS VARCHAR2 (10)
Date alias for the refunds add drop period.
ORG_ID NUMBER (15)
PRG_CHG_DT_ALIAS VARCHAR2 (0)
No longer used
FEE_CALC_MTHD_CODE VARCHAR2 (30)
The 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
REV_ACCOUNT_CD VARCHAR2 (40)
Revenue Account Code String
CASH_ACCOUNT_CD VARCHAR2 (40)
Cash Account Code String
UNAPP_ACCOUNT_CD VARCHAR2 (40)
Unapplied Account Code String
CONV_PROCESS_RUN_IND NUMBER

CURRENCY_CD VARCHAR2 (15)
The functional currency code.
RFND_DESTINATION VARCHAR2 (30)
Column for storing the Refund Destination.
AP_ORG_ID NUMBER

Organization Identifier for 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.
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
,      LAST_ACCOUNT_TRANS
,      LAST_PAY_TERM_TRANS
,      LAST_PAYMENT_TRANS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ACCOUNTING_METHOD
,      INTERFACE_LINE_CONTEXT
,      INTERFACE_LINE_ATTRIBUTE
,      LOCKBOX_CONTEXT
,      LOCKBOX_NUMBER_ATTRIBUTE
,      NEXT_INVOICE_NUMBER
,      CUST_TRX_TYPE_ID
,      TERM_ID
,      BATCH_SOURCE_ID
,      SET_OF_BOOKS_ID
,      REFUND_DR_GL_CCID
,      REFUND_CR_GL_CCID
,      REFUND_DR_ACCOUNT_CD
,      REFUND_CR_ACCOUNT_CD
,      REFUND_DT_ALIAS
,      ORG_ID
,      PRG_CHG_DT_ALIAS
,      FEE_CALC_MTHD_CODE
,      AR_INT_ORG_ID
,      PLANNED_CREDITS_IND
,      REC_GL_CCID
,      CASH_GL_CCID
,      UNAPP_GL_CCID
,      REC_ACCOUNT_CD
,      REV_ACCOUNT_CD
,      CASH_ACCOUNT_CD
,      UNAPP_ACCOUNT_CD
,      CONV_PROCESS_RUN_IND
,      CURRENCY_CD
,      RFND_DESTINATION
,      AP_ORG_ID
,      DFLT_SUPPLIER_SITE_NAME
,      MANAGE_ACCOUNTS
,      ACCT_CONV_FLAG
,      RES_DT_ALIAS
,      POST_WAIVER_GL_FLAG
,      WAIVER_NOTIFY_FINAID_FLAG
FROM APPS.IGS_FI_CONTROL;

Dependencies

[top of page]

APPS.IGS_FI_CONTROL references the following:

SchemaAPPS
SynonymIGS_FI_CONTROL_ALL
APPS.IGS_FI_CONTROL is referenced by following:

SchemaAPPS
Package BodyIGS_FI_AD_HOC_WAV - show dependent code
Package BodyIGS_FI_BILL_EXTRACT - show dependent code
Package BodyIGS_FI_CHARGES_API_PVT - show dependent code
Package BodyIGS_FI_CONTROL_PKG - show dependent code
ViewIGS_FI_CONTROL_V
Package BodyIGS_FI_CREDIT_PVT - show dependent code
Package BodyIGS_FI_DEPOSITS_PRCSS - show dependent code
ViewIGS_FI_FEE_ASS_DEBT_V
Package BodyIGS_FI_F_TYP_CA_INST_PKG - show dependent code
Package BodyIGS_FI_GEN_001 - show dependent code
Package BodyIGS_FI_GEN_004 - show dependent code
Package BodyIGS_FI_GEN_005 - show dependent code
PL/SQL PackageIGS_FI_GEN_005 - show dependent code
PL/SQL PackageIGS_FI_GEN_007 - show dependent code
Package BodyIGS_FI_GEN_007 - show dependent code
Package BodyIGS_FI_GEN_APINT - show dependent code
Package BodyIGS_FI_GEN_GL - show dependent code
Package BodyIGS_FI_GEN_REFUNDS - show dependent code
Package BodyIGS_FI_GL_INTERFACE - show dependent code
Package BodyIGS_FI_LOAD_EXT_CHG - show dependent code
Package BodyIGS_FI_PAYMENT_PLANS - show dependent code
Package BodyIGS_FI_POSTING_PROCESS - show dependent code
Package BodyIGS_FI_PRC_ACCT_PKG - show dependent code
Package BodyIGS_FI_PRC_APINT - show dependent code
Package BodyIGS_FI_PRC_APPL - show dependent code
PL/SQL PackageIGS_FI_PRC_FEE_ASS - show dependent code
Package BodyIGS_FI_PRC_FEE_ROLLV - show dependent code
Package BodyIGS_FI_PRC_FIN_LT_CHG - show dependent code
Package BodyIGS_FI_PRC_IMPCLC_ANC_CHGS - show dependent code
Package BodyIGS_FI_PRC_LOCKBOX - show dependent code
Package BodyIGS_FI_PRC_REFUNDS - show dependent code
Package BodyIGS_FI_PRC_SP_FEES - show dependent code
Package BodyIGS_FI_PRC_WAIVERS - show dependent code
Package BodyIGS_FI_REFUNDS_PKG - show dependent code
Package BodyIGS_FI_VAL_FAS - show dependent code
Package BodyIGS_FI_VAL_FCFL - show dependent code
Package BodyIGS_FI_VAL_FE - show dependent code
Package BodyIGS_FI_VAL_FRTNS - show dependent code
PL/SQL PackageIGS_FI_WAV_UTILS_002 - show dependent code
Package BodyIGS_FI_WAV_UTILS_002 - show dependent code