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: IGI.IGI_AR_POSTING_CONTROL

Object Details

Object Name:	IGI_AR_POSTING_CONTROL
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_AR_POSTING_CONTROL
Subobject Name:
Status:	VALID

IGI_AR_POSTING_CONTROL contains process control information for the Cash Basis Transfer programs in the Combined Basis Accounting requirement. This includes request identifier fields to identify posting programs, import processes, and report requests.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ARC_POSTING_CONTROL_ID	NUMBER	(15)	Yes	Identifies submission of the ARC posting program
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ARC_IGIRCBER_REQUEST_ID	NUMBER	(15)		Concurrent request identifier of the Accrual to Cash Basis Reconciliation Report
ARC_GLLEZL_REQUEST_ID	NUMBER	(15)		Concurrent request identifier of the General Ledger Journal Import program, GLLEZL, if run for the Cash Basis transfer
ARC_SUMMARY_FLAG	VARCHAR2	(1)		Y or N from the concurrent request
ARC_RUN_GL_IMPORT_FLAG	VARCHAR2	(1)		Y or N flag to indicate whether the run General Ledger Journal Import flag was set by the form IGIRCGLP
ARC_CCID_GAIN	NUMBER	(15)		System parameter to identify to which account exchange rate gains and losses are posted
ARC_CCID_LOSS	NUMBER	(15)		Code combination identifier of realized losses
GL_END_DATE	DATE		Yes	High General Ledger date of items to be posted to the General Ledger
GL_START_DATE	DATE		Yes	Low General Ledger date of items to be posted to the General Ledger
GL_POSTED_DATE	DATE		Yes	General Ledger date given to the posted items

Query Text

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


SELECT ARC_POSTING_CONTROL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ARC_IGIRCBER_REQUEST_ID
,      ARC_GLLEZL_REQUEST_ID
,      ARC_SUMMARY_FLAG
,      ARC_RUN_GL_IMPORT_FLAG
,      ARC_CCID_GAIN
,      ARC_CCID_LOSS
,      GL_END_DATE
,      GL_START_DATE
,      GL_POSTED_DATE
FROM IGI.IGI_AR_POSTING_CONTROL;

Dependencies

[top of page]

IGI.IGI_AR_POSTING_CONTROL does not reference any database object

IGI.IGI_AR_POSTING_CONTROL is referenced by following:

APPS: IGI_AR_POSTING_CONTROL