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]

TABLE: JL.JL_CO_GL_MG_RANGES

Object Details

Object Name:	JL_CO_GL_MG_RANGES
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_CO_GL_MG_RANGES
Subobject Name:
Status:	VALID

JL_CO_GL_MG_RANGES stores the account ranges that you enter in the Accounts window in the Define Literals form. There is a one-to-many relationship between report grouping and account ranges. Each row in this table includes associated report grouping configuration ID, and low and high segment values of Accounting Flexfield.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_CO_GL_MG_RANGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RANGE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CONFIG_ID	NUMBER	(15)	Yes	Configuration identifier
RANGE_ID	NUMBER	(15)	Yes	Range identifier
RANGE_LINE_NUM	NUMBER	(4)		Range line number
SEGMENT1_LOW	VARCHAR2	(25)		Segment 1 low range
SEGMENT1_HIGH	VARCHAR2	(25)		Segment 1 High Range
SEGMENT2_LOW	VARCHAR2	(25)		Segment 2 low range
SEGMENT2_HIGH	VARCHAR2	(25)		Segment 2 high range
SEGMENT3_LOW	VARCHAR2	(25)		Segment 3 low range
SEGMENT3_HIGH	VARCHAR2	(25)		Segment 3 high range
SEGMENT4_LOW	VARCHAR2	(25)		Segment 4 low range
SEGMENT4_HIGH	VARCHAR2	(25)		Segment 4 high range
SEGMENT5_LOW	VARCHAR2	(25)		Segment 5 low range
SEGMENT5_HIGH	VARCHAR2	(25)		Segment 5 high range
SEGMENT6_LOW	VARCHAR2	(25)		Segment 6 low range
SEGMENT6_HIGH	VARCHAR2	(25)		Segment 6 high range
SEGMENT7_LOW	VARCHAR2	(25)		Segment 7 low range
SEGMENT7_HIGH	VARCHAR2	(25)		Segment 7 high range
SEGMENT8_LOW	VARCHAR2	(25)		Segment 8 low range
SEGMENT8_HIGH	VARCHAR2	(25)		Segment 8 high range
SEGMENT9_LOW	VARCHAR2	(25)		Segment 9 low range
SEGMENT9_HIGH	VARCHAR2	(25)		Segment 9 high range
SEGMENT10_LOW	VARCHAR2	(25)		Segment 10 low range
SEGMENT10_HIGH	VARCHAR2	(25)		Segment 10 high range
SEGMENT11_LOW	VARCHAR2	(25)		Segment 11 low range
SEGMENT11_HIGH	VARCHAR2	(25)		Segment 11 high range
SEGMENT12_LOW	VARCHAR2	(25)		Segment 12 low range
SEGMENT12_HIGH	VARCHAR2	(25)		Segment 12 high range
SEGMENT13_LOW	VARCHAR2	(25)		Segment 13 low range
SEGMENT13_HIGH	VARCHAR2	(25)		Segment 13 high range
SEGMENT14_LOW	VARCHAR2	(25)		Segment 14 low range
SEGMENT14_HIGH	VARCHAR2	(25)		Segment 14 high range
SEGMENT15_LOW	VARCHAR2	(25)		Segment 15 low range
SEGMENT15_HIGH	VARCHAR2	(25)		Segment 15 high range
SEGMENT16_LOW	VARCHAR2	(25)		Segment 16 low range
SEGMENT16_HIGH	VARCHAR2	(25)		Segment 16 high range
SEGMENT17_LOW	VARCHAR2	(25)		Segment 17 low range
SEGMENT17_HIGH	VARCHAR2	(25)		Segment 17 high range
SEGMENT18_LOW	VARCHAR2	(25)		Segment 18 low range
SEGMENT18_HIGH	VARCHAR2	(25)		Segment 18 high range
SEGMENT19_LOW	VARCHAR2	(25)		Segment 19 low range
SEGMENT19_HIGH	VARCHAR2	(25)		Segment 19 high range
SEGMENT20_LOW	VARCHAR2	(25)		Segment 20 low range
SEGMENT20_HIGH	VARCHAR2	(25)		Segment 20 high range
SEGMENT21_LOW	VARCHAR2	(25)		Segment 21 low range
SEGMENT21_HIGH	VARCHAR2	(25)		Segment 21 high range
SEGMENT22_LOW	VARCHAR2	(25)		Segment 22 low range
SEGMENT22_HIGH	VARCHAR2	(25)		Segment 22 high range
SEGMENT23_LOW	VARCHAR2	(25)		Segment 23 low range
SEGMENT23_HIGH	VARCHAR2	(25)		Segment 23 high range
SEGMENT24_LOW	VARCHAR2	(25)		Segment 24 low range
SEGMENT24_HIGH	VARCHAR2	(25)		Segment 24 high range
SEGMENT25_LOW	VARCHAR2	(25)		Segment 25 low range
SEGMENT25_HIGH	VARCHAR2	(25)		Segment 25 high range
SEGMENT26_LOW	VARCHAR2	(25)		Segment 26 low range
SEGMENT26_HIGH	VARCHAR2	(25)		Segment 26 high range
SEGMENT27_LOW	VARCHAR2	(25)		Segment 27 low range
SEGMENT27_HIGH	VARCHAR2	(25)		Segment 27 high range
SEGMENT28_LOW	VARCHAR2	(25)		Segment 28 low range
SEGMENT28_HIGH	VARCHAR2	(25)		Segment 28 high range
SEGMENT29_LOW	VARCHAR2	(25)		Segment 29 low range
SEGMENT29_HIGH	VARCHAR2	(25)		Segment 29 high range
SEGMENT30_LOW	VARCHAR2	(25)		Segment 30 low range
SEGMENT30_HIGH	VARCHAR2	(25)		Segment 30 high range
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield Structure Defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield Segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield Segment column

Query Text

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


SELECT CONFIG_ID
,      RANGE_ID
,      RANGE_LINE_NUM
,      SEGMENT1_LOW
,      SEGMENT1_HIGH
,      SEGMENT2_LOW
,      SEGMENT2_HIGH
,      SEGMENT3_LOW
,      SEGMENT3_HIGH
,      SEGMENT4_LOW
,      SEGMENT4_HIGH
,      SEGMENT5_LOW
,      SEGMENT5_HIGH
,      SEGMENT6_LOW
,      SEGMENT6_HIGH
,      SEGMENT7_LOW
,      SEGMENT7_HIGH
,      SEGMENT8_LOW
,      SEGMENT8_HIGH
,      SEGMENT9_LOW
,      SEGMENT9_HIGH
,      SEGMENT10_LOW
,      SEGMENT10_HIGH
,      SEGMENT11_LOW
,      SEGMENT11_HIGH
,      SEGMENT12_LOW
,      SEGMENT12_HIGH
,      SEGMENT13_LOW
,      SEGMENT13_HIGH
,      SEGMENT14_LOW
,      SEGMENT14_HIGH
,      SEGMENT15_LOW
,      SEGMENT15_HIGH
,      SEGMENT16_LOW
,      SEGMENT16_HIGH
,      SEGMENT17_LOW
,      SEGMENT17_HIGH
,      SEGMENT18_LOW
,      SEGMENT18_HIGH
,      SEGMENT19_LOW
,      SEGMENT19_HIGH
,      SEGMENT20_LOW
,      SEGMENT20_HIGH
,      SEGMENT21_LOW
,      SEGMENT21_HIGH
,      SEGMENT22_LOW
,      SEGMENT22_HIGH
,      SEGMENT23_LOW
,      SEGMENT23_HIGH
,      SEGMENT24_LOW
,      SEGMENT24_HIGH
,      SEGMENT25_LOW
,      SEGMENT25_HIGH
,      SEGMENT26_LOW
,      SEGMENT26_HIGH
,      SEGMENT27_LOW
,      SEGMENT27_HIGH
,      SEGMENT28_LOW
,      SEGMENT28_HIGH
,      SEGMENT29_LOW
,      SEGMENT29_HIGH
,      SEGMENT30_LOW
,      SEGMENT30_HIGH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM JL.JL_CO_GL_MG_RANGES;

Dependencies

[top of page]

JL.JL_CO_GL_MG_RANGES does not reference any database object

JL.JL_CO_GL_MG_RANGES is referenced by following:

JL: JL_CO_GL_MG_RANGES#