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.IGI_INT_DETAILS_V

Object Details

Object Name:	IGI_INT_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGI.IGI_INT_DETAILS_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
JE_SOURCE	VARCHAR2	(25)	Yes	As GL_JE_HEADERS table
BALANCE_TYPE	VARCHAR2	(1)	Yes	As GL_JE_BATCHES table
CURRENCY_CODE	VARCHAR2	(15)	Yes	As GL_JE_HEADERS table
PERIOD_NAME	VARCHAR2	(15)	Yes	As GL_JE_HEADERS table
STATUS	VARCHAR2	(1)	Yes	As GL_JE_BATCHES table
JE_BATCH_ID	NUMBER	(15)	Yes	As GL_JE_BATCHES table
JE_HEADER_ID	NUMBER	(15)	Yes	As GL_JE_HEADERS table
JE_LINE_NUM	NUMBER	(15)	Yes	As GL_JE_LINES table
CODE_COMBINATION_ID	NUMBER	(15)	Yes	As GL_JE_LINES table
AMOUNT	VARCHAR2	(240)
PRIMARY_DESCRIPTION	VARCHAR2	(240)
TRANSACTION_DATE	VARCHAR2	(240)
DESCRIPTOR1	VARCHAR2	(240)		As GL_IMPORT_REFERENCES
DESCRIPTOR2	VARCHAR2	(240)		As GL_IMPORT_REFERENCES
DESCRIPTOR3	VARCHAR2	(240)		As GL_IMPORT_REFERENCES
DESCRIPTOR4	VARCHAR2	(240)		As GL_IMPORT_REFERENCES
DESCRIPTOR5	VARCHAR2	(240)		As GL_IMPORT_REFERENCES
DESCRIPTOR6	VARCHAR2	(240)		As GL_IMPORT_REFERENCES
DESCRIPTOR7	VARCHAR2	(240)		As GL_IMPORT_REFERENCES
SECURE_SOURCE_FLAG	VARCHAR2	(1)	Yes	As IGI_INT_DESCRIPTRS table

Query Text

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


SELECT JE_SOURCE
,      BALANCE_TYPE
,      CURRENCY_CODE
,      PERIOD_NAME
,      STATUS
,      JE_BATCH_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      CODE_COMBINATION_ID
,      AMOUNT
,      PRIMARY_DESCRIPTION
,      TRANSACTION_DATE
,      DESCRIPTOR1
,      DESCRIPTOR2
,      DESCRIPTOR3
,      DESCRIPTOR4
,      DESCRIPTOR5
,      DESCRIPTOR6
,      DESCRIPTOR7
,      SECURE_SOURCE_FLAG
FROM APPS.IGI_INT_DETAILS_V;

Dependencies

[top of page]

APPS.IGI_INT_DETAILS_V references the following:

APPS: GL_IMPORT_REFERENCES; GL_JE_BATCHES; GL_JE_HEADERS; GL_JE_LINES; IGI_INT_DESCRIPTRS

APPS.IGI_INT_DETAILS_V is not referenced by any database object