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_CBR_GL_SEC_LEDGER_V

Object Details

Object Name:	IGI_CBR_GL_SEC_LEDGER_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

View that is created to fetch secondary ledgers having SUBLEDGER or JOURNAL data conversion levels and Simultaneous Posting option set to Yes.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PRIMARY_LEDGER_ID	NUMBER	(15)	Yes	Primary ledger ID as defined in the accounting configuration
SECONDARY_LEDGER_ID	NUMBER	(15)	Yes	Secondary ledger defining column
SECONDARY_LEDGER_NAME	VARCHAR2	(30)	Yes	Secondary ledger name
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Accounting flexfield structure defining column
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
PERIOD_SET_NAME	VARCHAR2	(15)	Yes	Accounting calendar name
ACCOUNTED_PERIOD_TYPE	VARCHAR2	(15)	Yes	Accounting period type
SL_COA_MAPPING_ID	NUMBER	(15)		Accounting flexfield structure defining column
SLA_ACCOUNTING_METHOD_CODE	VARCHAR2	(30)		Subledger accounting method code
SLA_ACCOUNTING_METHOD_TYPE	VARCHAR2	(1)		Subledger accounting method type
RELATIONSHIP_TYPE_CODE	VARCHAR2	(30)	Yes	Relationship level between source and target ledger
RELATIONSHIP_ENABLED_FLAG	VARCHAR2	(1)	Yes	Relationship enabled flag
ACCESS_SET_ID	NUMBER	(15)		Data access set ID

Query Text

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


SELECT PRIMARY_LEDGER_ID
,      SECONDARY_LEDGER_ID
,      SECONDARY_LEDGER_NAME
,      CHART_OF_ACCOUNTS_ID
,      CURRENCY_CODE
,      PERIOD_SET_NAME
,      ACCOUNTED_PERIOD_TYPE
,      SL_COA_MAPPING_ID
,      SLA_ACCOUNTING_METHOD_CODE
,      SLA_ACCOUNTING_METHOD_TYPE
,      RELATIONSHIP_TYPE_CODE
,      RELATIONSHIP_ENABLED_FLAG
,      ACCESS_SET_ID
FROM APPS.IGI_CBR_GL_SEC_LEDGER_V;

Dependencies

[top of page]

APPS.IGI_CBR_GL_SEC_LEDGER_V references the following:

APPS: GL_ACCESS_SET_LEDGERS_V; GL_LEDGERS; GL_LEDGER_RELATIONSHIPS

APPS.IGI_CBR_GL_SEC_LEDGER_V is not referenced by any database object