[Home] [Help] [Dependency Information]
Object Name: | JL_CL_GL_ACCT_HIER_TMP# |
---|---|
Object Type: | VIEW |
Owner: | JL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_VALUE | VARCHAR2 | (60) | Yes | |
CHILD_VALUE | VARCHAR2 | (60) | ||
ACCOUNT_TYPE | VARCHAR2 | (1) | Yes | |
SUMMARY_FLAG | VARCHAR2 | (1) | Yes | |
HIERARCHY_LEVEL | NUMBER | (15) | ||
FLEX_VALUE_SET_ID | NUMBER | (15) | Yes | |
ADDITIONS_DR | NUMBER | |||
ADDITIONS_CR | NUMBER | |||
BALANCE_DR | NUMBER | |||
BALANCE_CR | NUMBER | |||
INVENTORY_ASSET | NUMBER | |||
INVENTORY_LIABILITY | NUMBER | |||
PNL_LOSS | NUMBER | |||
PNL_GAIN | NUMBER | |||
REPORTABLE_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_VALUE
, CHILD_VALUE
, ACCOUNT_TYPE
, SUMMARY_FLAG
, HIERARCHY_LEVEL
, FLEX_VALUE_SET_ID
, ADDITIONS_DR
, ADDITIONS_CR
, BALANCE_DR
, BALANCE_CR
, INVENTORY_ASSET
, INVENTORY_LIABILITY
, PNL_LOSS
, PNL_GAIN
, REPORTABLE_FLAG
FROM JL.JL_CL_GL_ACCT_HIER_TMP#;
|
|
|