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_DOS_DEST_ACCOUNTS

Object Details

Object Name:	IGI_DOS_DEST_ACCOUNTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGI.IGI_DOS_DEST_ACCOUNTS
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
VISIBLE_ACCOUNT	VARCHAR2	(155)		Visible account
ROW_ID	ROWID	(10)		Row identifier
DOSSIER_ID	NUMBER		Yes	Dossier identifier
SOURCE_ID	NUMBER		Yes	Source identifier
DESTINATION_ID	NUMBER		Yes	Destination identifier
CONCATENATED_SEGMENTS	VARCHAR2	(155)		Concatenated segments
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Code combination identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Chart of Accounts identifier
SEGMENT1	VARCHAR2	(25)		Key flexfield segment
SEG1_UPDATABLE	VARCHAR2	(1)		Segment1 updateable flag
SEGMENT2	VARCHAR2	(25)		Key flexfield segment
SEG2_UPDATABLE	VARCHAR2	(1)		Segment2 updateable flag
SEGMENT3	VARCHAR2	(25)		Key flexfield segment
SEG3_UPDATABLE	VARCHAR2	(1)		Segment3 updateable flag
SEGMENT4	VARCHAR2	(25)		Key flexfield segment
SEG4_UPDATABLE	VARCHAR2	(1)		Segment4 updateable flag
SEGMENT5	VARCHAR2	(25)		Key flexfield segment
SEG5_UPDATABLE	VARCHAR2	(1)		Segment5 updateable flag
SEGMENT6	VARCHAR2	(25)		Key flexfield segment
SEG6_UPDATABLE	VARCHAR2	(1)		Segment6 updateable flag

Query Text

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


SELECT VISIBLE_ACCOUNT
,      ROW_ID
,      DOSSIER_ID
,      SOURCE_ID
,      DESTINATION_ID
,      CONCATENATED_SEGMENTS
,      CODE_COMBINATION_ID
,      CHART_OF_ACCOUNTS_ID
,      SEGMENT1
,      SEG1_UPDATABLE
,      SEGMENT2
,      SEG2_UPDATABLE
,      SEGMENT3
,      SEG3_UPDATABLE
,      SEGMENT4
,      SEG4_UPDATABLE
,      SEGMENT5
,      SEG5_UPDATABLE
,      SEGMENT6
,      SEG6_UPDATABLE
FROM APPS.IGI_DOS_DEST_ACCOUNTS;

Dependencies

[top of page]

APPS.IGI_DOS_DEST_ACCOUNTS references the following:

APPS: GL_CODE_COMBINATIONS_KFV; IGI_DOS_DESTINATIONS; IGI_DOS_DESTINATION_USAGES; IGI_DOS_DOC_TYPES

APPS.IGI_DOS_DEST_ACCOUNTS is not referenced by any database object