[Home] [Help]
[Dependency Information]
| Object Name: | GL_SECONDARY_LEDGER_RSHIPS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | SQLGL.GL_SECONDARY_LEDGER_RSHIPS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PRIMARY_LEDGER_ID | NUMBER | (15) | Yes | |
| LEDGER_ID | NUMBER | (15) | Yes | |
| LEDGER_NAME | VARCHAR2 | (30) | Yes | |
| LEDGER_SHORT_NAME | VARCHAR2 | (20) | Yes | |
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | |
| ACCOUNTED_PERIOD_TYPE | VARCHAR2 | (15) | Yes | |
| SL_COA_MAPPING_ID | NUMBER | (15) | ||
| SLA_ACCOUNTING_METHOD_CODE | VARCHAR2 | (30) | ||
| SLA_ACCOUNTING_METHOD_TYPE | VARCHAR2 | (1) | ||
| RELATIONSHIP_TYPE_CODE | VARCHAR2 | (30) | Yes | |
| RELATIONSHIP_ENABLED_FLAG | VARCHAR2 | (1) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PRIMARY_LEDGER_ID
, LEDGER_ID
, LEDGER_NAME
, LEDGER_SHORT_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
FROM APPS.GL_SECONDARY_LEDGER_RSHIPS_V;
APPS
GL_LEDGERS
GL_LEDGER_RELATIONSHIPS
APPS
AP_SOB_INFO_V
GL_MC_INFO
- show dependent code
IGC_LEDGER_UTILS
- show dependent code
PA_ADJUSTMENTS
- show dependent code
|
|
|
|