[Home] [Help] [Dependency Information]
Object Name: | IGI_CBR_GL_SEC_LEDGER_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.IGI_CBR_GL_SEC_LEDGER_V is not referenced by any database object
|
|
|