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]

TABLE: IGS.IGS_FI_CR_ACTIVITIES

Object Details

Object Name:	IGS_FI_CR_ACTIVITIES
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_FI_CR_ACTIVITIES
Subobject Name:
Status:	VALID

Contains steps for the life cycle of credit transactions. This captures one record in this table when a new credit transaction is created in IGS_FI_CREDITS_ALL table with STATUS 'CLEARED'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_CR_ACTIVITIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CREDIT_ACTIVITY_ID
IGS_FI_CR_ACTIVITIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CREDIT_ACTIVITY_ID	NUMBER	(15)	Yes	Sequence generated Primary Key for this table
CREDIT_ID	NUMBER	(15)	Yes	Header ID for this Child table
STATUS	VARCHAR2	(15)	Yes	Status - CLEARED or REVERSED - System level Lookup Code
TRANSACTION_DATE	DATE		Yes	Transaction date of the activity
AMOUNT	NUMBER		Yes	Amount of the activity
DR_ACCOUNT_CD	VARCHAR2	(40)		Debit Account String
CR_ACCOUNT_CD	VARCHAR2	(40)		Credit Account String
DR_GL_CCID	NUMBER	(15)		Debit GL Accounting Flexfield CCID
CR_GL_CCID	NUMBER	(15)		Credit GL Account Flexfield CCID
BILL_ID	NUMBER			Bill Id if this transaction is placed in any Bill
BILL_NUMBER	VARCHAR2	(50)		Bill Number String
BILL_DATE	DATE			Bill Date
POSTING_ID	NUMBER	(15)		Posting ID - If this transaction is posted in posting interface table
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
REQUEST_ID	NUMBER	(15)		Standard Concurrent Process Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Process Column
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Process Column
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Process Column
GL_DATE	DATE			The General Ledger Date of the Credit Activity Record.
GL_POSTED_DATE	DATE			The Date on which the credit activity record is posted to the interface.
POSTING_CONTROL_ID	NUMBER	(15)		The Posting Batch Identifier.

Query Text

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


SELECT CREDIT_ACTIVITY_ID
,      CREDIT_ID
,      STATUS
,      TRANSACTION_DATE
,      AMOUNT
,      DR_ACCOUNT_CD
,      CR_ACCOUNT_CD
,      DR_GL_CCID
,      CR_GL_CCID
,      BILL_ID
,      BILL_NUMBER
,      BILL_DATE
,      POSTING_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      GL_DATE
,      GL_POSTED_DATE
,      POSTING_CONTROL_ID
FROM IGS.IGS_FI_CR_ACTIVITIES;

Dependencies

[top of page]

IGS.IGS_FI_CR_ACTIVITIES does not reference any database object

IGS.IGS_FI_CR_ACTIVITIES is referenced by following:

APPS: IGS_FI_CR_ACTIVITIES