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

VIEW: APPS.IGS_FI_INV_INT_V

Object Details
Object Name: IGS_FI_INV_INT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_INV_INT_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)
INVOICE_ID NUMBER (15) Yes
PERSON_ID NUMBER (15) Yes
SPONSOR_CD VARCHAR2 (10)
Obsolete
FEE_TYPE VARCHAR2 (10) Yes
FEE_CAT VARCHAR2 (10)
FEE_CAL_TYPE VARCHAR2 (10) Yes
FEE_CI_SEQUENCE_NUMBER NUMBER (6) Yes
COURSE_CD VARCHAR2 (6)
ATTENDANCE_MODE VARCHAR2 (2)
ATTENDANCE_TYPE VARCHAR2 (2)
INVOICE_AMOUNT_DUE NUMBER
Yes
INVOICE_CREATION_DATE DATE
Yes
INVOICE_DESC VARCHAR2 (240)
TRANSACTION_TYPE VARCHAR2 (30) Yes
CURRENCY_CD VARCHAR2 (15) Yes
EXCHANGE_RATE NUMBER

ACCOUNT_ID NUMBER (15)
No longer used
TERM_ID NUMBER (15)
No longer used
STATUS VARCHAR2 (30) Yes
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ORG_ID NUMBER (15)
MERCHANT_ID VARCHAR2 (80)
No longer used
CREDIT_CARD_CODE VARCHAR2 (80)
No longer used
CREDIT_CARD_HOLDER_NAME VARCHAR2 (80)
No longer used
CREDIT_CARD_EXPIRATION_DATE DATE

No longer used
CREDIT_CARD_APPROVAL_CODE VARCHAR2 (80)
No longer used
CREDIT_CARD_APPROVAL_DATE DATE

No longer used
PAYMENT_SERVER_ORDER_NUMBER VARCHAR2 (80)
No longer used
PAYMENT_SERVER_TXN_DATE DATE

No longer used
PAYMENT_SERVER_TXN_STATUS VARCHAR2 (80)
No longer used
PAYMENT_SERVER_ERROR_CODE VARCHAR2 (40)
No longer used
PAYMENT_SERVER_ERROR_MSG VARCHAR2 (255)
No longer used
BEP_ERROR_CODE VARCHAR2 (40)
No longer used
BEP_ERROR_MSG VARCHAR2 (255)
No longer used
ERROR_LOCATION NUMBER

No longer used
AUTHORIZED_AMOUNT NUMBER

No longer used
RECEIPT_METHOD_ID NUMBER (15)
No longer used
RECEIPT_METHOD_NAME VARCHAR2 (30)
No longer used
CUSTOMER_BANK_ACCOUNT_ID NUMBER (15)
No longer used
CUSTOMER_BANK_ACCOUNT_NAME VARCHAR2 (25)
No longer used
PROCESSED_IN_SSA VARCHAR2 (15)
No longer used
PAYMENT_METHOD VARCHAR2 (15)
No longer used
PAYMENT_STATUS VARCHAR2 (15)
No longer used
SUBACCOUNT_ID NUMBER (15)
OBSOLETE.
INVOICE_AMOUNT NUMBER

BILL_ID NUMBER

BILL_NUMBER VARCHAR2 (50)
BILL_DATE DATE

WAIVER_FLAG VARCHAR2 (1)
WAIVER_REASON VARCHAR2 (80)
WAIVER_REASON_CODE VARCHAR2 (240)
EFFECTIVE_DATE DATE

INVOICE_NUMBER VARCHAR2 (60)
Invoice Number
BILL_PAYMENT_DUE_DATE DATE

SOURCE_TRANSACTION_ID NUMBER (15)
Obsolete - As part of Enh bug #2228910
OPTIONAL_FEE_FLAG VARCHAR2 (1)
Decline Optional fee Status
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)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REVERSAL_GL_DATE DATE

The Reversal General Ledger Date.
TAX_YEAR_CODE VARCHAR2 (30)
Indicates the 1098-T Reporting Tax Year, in which the charge is reported to the Internal Revenue Services
WAIVER_NAME VARCHAR2 (30)
Indicates the Waiver Program Name attached to fee calendar instance for which waiver adjustment charge was created.
Query Text

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


SELECT ROW_ID
,      INVOICE_ID
,      PERSON_ID
,      SPONSOR_CD
,      FEE_TYPE
,      FEE_CAT
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      COURSE_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      INVOICE_AMOUNT_DUE
,      INVOICE_CREATION_DATE
,      INVOICE_DESC
,      TRANSACTION_TYPE
,      CURRENCY_CD
,      EXCHANGE_RATE
,      ACCOUNT_ID
,      TERM_ID
,      STATUS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ORG_ID
,      MERCHANT_ID
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      CREDIT_CARD_APPROVAL_DATE
,      PAYMENT_SERVER_ORDER_NUMBER
,      PAYMENT_SERVER_TXN_DATE
,      PAYMENT_SERVER_TXN_STATUS
,      PAYMENT_SERVER_ERROR_CODE
,      PAYMENT_SERVER_ERROR_MSG
,      BEP_ERROR_CODE
,      BEP_ERROR_MSG
,      ERROR_LOCATION
,      AUTHORIZED_AMOUNT
,      RECEIPT_METHOD_ID
,      RECEIPT_METHOD_NAME
,      CUSTOMER_BANK_ACCOUNT_ID
,      CUSTOMER_BANK_ACCOUNT_NAME
,      PROCESSED_IN_SSA
,      PAYMENT_METHOD
,      PAYMENT_STATUS
,      SUBACCOUNT_ID
,      INVOICE_AMOUNT
,      BILL_ID
,      BILL_NUMBER
,      BILL_DATE
,      WAIVER_FLAG
,      WAIVER_REASON
,      WAIVER_REASON_CODE
,      EFFECTIVE_DATE
,      INVOICE_NUMBER
,      BILL_PAYMENT_DUE_DATE
,      SOURCE_TRANSACTION_ID
,      OPTIONAL_FEE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REVERSAL_GL_DATE
,      TAX_YEAR_CODE
,      WAIVER_NAME
FROM APPS.IGS_FI_INV_INT_V;

Dependencies

[top of page]

APPS.IGS_FI_INV_INT_V references the following:

SchemaAPPS
ViewIGS_FI_INV_INT
ViewIGS_LOOKUP_VALUES
APPS.IGS_FI_INV_INT_V is referenced by following:

SchemaAPPS
Package BodyIGS_AS_ORDER_HDR_PKG - show dependent code
Package BodyIGS_FI_PRC_BALANCES - show dependent code