[Home] [Help] [Dependency Information]
Object Name: | GL_LEDGER_RELATIONSHIPS# |
---|---|
Object Type: | VIEW |
Owner: | GL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELATIONSHIP_ID | NUMBER | (15) | Yes | |
SOURCE_LEDGER_ID | NUMBER | (15) | Yes | |
TARGET_LEDGER_ID | NUMBER | (15) | Yes | |
SLA_LEDGER_ID | NUMBER | (15) | Yes | |
PRIMARY_LEDGER_ID | NUMBER | (15) | Yes | |
TARGET_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
TARGET_LEDGER_NAME | VARCHAR2 | (30) | Yes | |
TARGET_LEDGER_SHORT_NAME | VARCHAR2 | (20) | Yes | |
TARGET_LEDGER_CATEGORY_CODE | VARCHAR2 | (30) | Yes | |
RELATIONSHIP_TYPE_CODE | VARCHAR2 | (30) | Yes | |
RELATIONSHIP_ENABLED_FLAG | VARCHAR2 | (1) | Yes | |
INHERIT_CREATION_USER_FLAG | VARCHAR2 | (1) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
GL_JE_CONVERSION_SET_ID | NUMBER | (15) | ||
SL_COA_MAPPING_ID | NUMBER | (15) | ||
AUTOMATIC_POST_FLAG | VARCHAR2 | (1) | ||
ALC_DEFAULT_CONV_RATE_TYPE | VARCHAR2 | (30) | ||
ALC_NO_RATE_ACTION_CODE | VARCHAR2 | (30) | ||
ALC_MAX_DAYS_ROLL_RATE | NUMBER | |||
ALC_INHERIT_CONVERSION_TYPE | VARCHAR2 | (1) | ||
ALC_INIT_CONV_OPTION_CODE | VARCHAR2 | (30) | ||
ALC_INIT_PERIOD | VARCHAR2 | (15) | ||
ALC_INIT_DATE | DATE | |||
ALC_INITIALIZING_RATE_DATE | DATE | |||
ALC_INITIALIZING_RATE_TYPE | VARCHAR2 | (30) | ||
ALC_PERIOD_AVERAGE_RATE_TYPE | VARCHAR2 | (30) | ||
ALC_PERIOD_END_RATE_TYPE | VARCHAR2 | (30) | ||
APPLICATION_ID | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | ||
DISABLE_CONVERSION_DATE | DATE | |||
STATUS_CODE | VARCHAR2 | (30) | ||
HIST_CONV_STATUS_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT RELATIONSHIP_ID
, SOURCE_LEDGER_ID
, TARGET_LEDGER_ID
, SLA_LEDGER_ID
, PRIMARY_LEDGER_ID
, TARGET_CURRENCY_CODE
, TARGET_LEDGER_NAME
, TARGET_LEDGER_SHORT_NAME
, TARGET_LEDGER_CATEGORY_CODE
, RELATIONSHIP_TYPE_CODE
, RELATIONSHIP_ENABLED_FLAG
, INHERIT_CREATION_USER_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, GL_JE_CONVERSION_SET_ID
, SL_COA_MAPPING_ID
, AUTOMATIC_POST_FLAG
, ALC_DEFAULT_CONV_RATE_TYPE
, ALC_NO_RATE_ACTION_CODE
, ALC_MAX_DAYS_ROLL_RATE
, ALC_INHERIT_CONVERSION_TYPE
, ALC_INIT_CONV_OPTION_CODE
, ALC_INIT_PERIOD
, ALC_INIT_DATE
, ALC_INITIALIZING_RATE_DATE
, ALC_INITIALIZING_RATE_TYPE
, ALC_PERIOD_AVERAGE_RATE_TYPE
, ALC_PERIOD_END_RATE_TYPE
, APPLICATION_ID
, ORG_ID
, DISABLE_CONVERSION_DATE
, STATUS_CODE
, HIST_CONV_STATUS_CODE
FROM GL.GL_LEDGER_RELATIONSHIPS#;
|
|
|