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_OTC_CHARGES_V

Object Details

Object Name:	IGS_FI_OTC_CHARGES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_FI_OTC_CHARGES_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)		Row id
OTC_CHARGE_ID	NUMBER	(15)	Yes	OTC receipt charge id
CREDIT_ID	NUMBER	(15)	Yes	Credit id
INVOICE_ID	NUMBER	(15)	Yes	Invoice identifier
GL_DATE	DATE			The General Ledger Date.
PERSON_ID	NUMBER	(15)	Yes	Student identifier
SPONSOR_CD	VARCHAR2	(10)		Sponsor code if student is sponsored _ Obsolete
FEE_TYPE	VARCHAR2	(10)	Yes	Fee type
FEE_CAT	VARCHAR2	(10)		Fee category
FEE_CAL_TYPE	VARCHAR2	(10)	Yes	Fee calendar type
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Fee calendar instance sequence number
COURSE_CD	VARCHAR2	(6)		Program code
ATTENDANCE_MODE	VARCHAR2	(2)		Attendance mode
ATTENDANCE_TYPE	VARCHAR2	(2)		Attendance type
INVOICE_AMOUNT_DUE	NUMBER		Yes	Invoice or Transaction amount
INVOICE_CREATION_DATE	DATE		Yes	Invoice date
INVOICE_DESC	VARCHAR2	(240)		Invoice description
TRANSACTION_TYPE	VARCHAR2	(30)	Yes	Transaction type
CURRENCY_CD	VARCHAR2	(15)	Yes	Currency code
ACCOUNT_ID	NUMBER	(15)		Oracle Student System account identifier
TERM_ID	NUMBER	(15)		Oracle Student System payment term identifier
STATUS	VARCHAR2	(30)	Yes	Initial Value should be 'LOAD', Other values are 'TODO', 'TRANSFER', 'SUCCESS', 'ERROR'
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ORG_ID	NUMBER	(15)		Operating Unit Identifier
MERCHANT_ID	VARCHAR2	(80)		Merchant ID
CREDIT_CARD_CODE	VARCHAR2	(80)		Represent type of credit card
CREDIT_CARD_HOLDER_NAME	VARCHAR2	(80)		Credit card holder name
CREDIT_CARD_EXPIRATION_DATE	DATE			Credit card expiration date
CREDIT_CARD_APPROVAL_CODE	VARCHAR2	(80)		Authorization code
CREDIT_CARD_APPROVAL_DATE	DATE			Date of approval
PAYMENT_SERVER_ORDER_NUMBER	VARCHAR2	(80)		Payment server order number
PAYMENT_SERVER_TXN_DATE	DATE			Payment server Txn date
PAYMENT_SERVER_TXN_STATUS	VARCHAR2	(80)		Payment server txn status
PAYMENT_SERVER_ERROR_CODE	VARCHAR2	(40)		Payment server error code
PAYMENT_SERVER_ERROR_MSG	VARCHAR2	(255)		Payment server error message
BEP_ERROR_CODE	VARCHAR2	(40)		Bep error code
BEP_ERROR_MSG	VARCHAR2	(255)		Bep error message
ERROR_LOCATION	NUMBER			Error location
AUTHORIZED_AMOUNT	NUMBER			Authorized Amount
RECEIPT_METHOD_ID	NUMBER	(15)		Receipt method Id
RECEIPT_METHOD_NAME	VARCHAR2	(30)		Receipt method name
CUSTOMER_BANK_ACCOUNT_ID	NUMBER	(15)		Customer bank account id
CUSTOMER_BANK_ACCOUNT_NAME	VARCHAR2	(25)		Customer bank account name
PROCESSED_IN_SSA	VARCHAR2	(15)		Processed in SSA
PAYMENT_METHOD	VARCHAR2	(15)		Payment method
PAYMENT_STATUS	VARCHAR2	(15)		Payment status
SUBACCOUNT_ID	NUMBER	(15)		OBSOLETE. Subaccount id
INVOICE_AMOUNT	NUMBER			Invoice transaction amount
BILL_ID	NUMBER			Bill Id that this transaction included in
BILL_NUMBER	VARCHAR2	(50)		Bill Number
BILL_DATE	DATE			Bill date
WAIVER_FLAG	VARCHAR2	(1)		Waiver Flag - if this Transaction is waived
WAIVER_REASON	VARCHAR2	(0)
WAIVER_REASON_CODE	VARCHAR2	(240)		Code for the waiver reason
EFFECTIVE_DATE	DATE			Effective date of this charge transaction
INVOICE_NUMBER	VARCHAR2	(60)		Invoice Number - next number would be shown in Receivables Control Screen
BILL_PAYMENT_DUE_DATE	DATE			This field would be updated by the Bill Process
SOURCE_TRANSACTION_ID	NUMBER	(15)		Used to store invoice id of original waived charge
REC_ACCOUNT_CD	VARCHAR2	(40)		The Receivables account code.
REC_ACCOUNT_DESC	VARCHAR2	(60)		The Receivables account description.
REV_ACCOUNT_CD	VARCHAR2	(40)		The Revenue Account code.
REV_ACCOUNT_DESC	VARCHAR2	(60)		The Revenue Account description.
REC_GL_CCID	NUMBER	(15)		The Receivables Key Accounting Flexfield.
REV_GL_CCID	NUMBER	(15)		The Revenue Key Accounting Flexfield.
POSTING_ID	NUMBER	(15)		The Posting Identifier.
POSTING_CONTROL_ID	NUMBER	(15)		The Posting Batch Identifier.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Concurrent Program WHO
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Program WHO
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Program WHO
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Program WHO

Query Text

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


SELECT ROW_ID
,      OTC_CHARGE_ID
,      CREDIT_ID
,      INVOICE_ID
,      GL_DATE
,      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
,      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
,      REC_ACCOUNT_CD
,      REC_ACCOUNT_DESC
,      REV_ACCOUNT_CD
,      REV_ACCOUNT_DESC
,      REC_GL_CCID
,      REV_GL_CCID
,      POSTING_ID
,      POSTING_CONTROL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.IGS_FI_OTC_CHARGES_V;

Dependencies

[top of page]

APPS.IGS_FI_OTC_CHARGES_V references the following:

APPS: IGS_FI_ACC; IGS_FI_INVLN_INT; IGS_FI_INV_INT; IGS_FI_OTC_CHARGES

APPS.IGS_FI_OTC_CHARGES_V is not referenced by any database object