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: IGI.IGI_BUD_SHEET_LINES

Object Details

Object Name:	IGI_BUD_SHEET_LINES
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_BUD_SHEET_LINES
Subobject Name:
Status:	VALID

IGI_BUD_SHEET_LINES stores budget journal lines from a budget spreadsheet transfer file. The table contains the following information: currency code, annual amount, profile code, start period, next year budget amount,accounting flexfield and period amount.

Scope: public
Product: IGI
Lifecycle: active
Display Name: Budget Spreadsheet Line File
Category: BUSINESS_ENTITY GL_JOURNAL

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_BUD_SHEET_LINES_F1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SPREADSHEET_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RECORD_TYPE	VARCHAR2	(2)	Yes	Record type. Sheet lines.
SPREADSHEET_HEADER_ID	NUMBER	(15)	Yes	Spreadsheet header identifier
CURRENCY_CODE	VARCHAR2	(10)	Yes	Currency code
PROFILE_CODE	VARCHAR2	(30)	Yes	Profile code
START_PERIOD	VARCHAR2	(15)	Yes	Start period
ANNUAL_AMOUNT	NUMBER			Annual amount
NEXT_YEAR_BUDGET	NUMBER			Next year budget
REFERENCE1	VARCHAR2	(15)		Reference Number 1
REFERENCE2	VARCHAR2	(15)		Reference Number 2
REFERENCE3	VARCHAR2	(15)		Reference Number 3
REFERENCE4	VARCHAR2	(15)		Reference Number 4
REFERENCE5	VARCHAR2	(15)		Reference Number 5
REFERENCE6	VARCHAR2	(15)		Reference Number 6
REFERENCE7	VARCHAR2	(15)		Reference Number 7
REFERENCE8	VARCHAR2	(15)		Reference Number 8
REFERENCE9	VARCHAR2	(15)		Reference Number 9
REFERENCE10	VARCHAR2	(15)		Reference Number 10
REFERENCE11	VARCHAR2	(15)		Reference Number 11
REFERENCE12	VARCHAR2	(15)		Reference Number 12
REFERENCE13	VARCHAR2	(15)		Reference Number 13
REFERENCE14	VARCHAR2	(15)		Reference Number 14
REFERENCE15	VARCHAR2	(15)		Reference Number 15
REFERENCE16	VARCHAR2	(15)		Reference Number 16
REFERENCE17	VARCHAR2	(15)		Reference Number 17
REFERENCE18	VARCHAR2	(15)		Reference Number 18
REFERENCE19	VARCHAR2	(15)		Reference Number 19
REFERENCE20	VARCHAR2	(15)		Reference Number 20
REFERENCE21	VARCHAR2	(15)		Reference Number 21
REFERENCE22	VARCHAR2	(15)		Reference Number 22
REFERENCE23	VARCHAR2	(15)		Reference Number 23
REFERENCE24	VARCHAR2	(15)		Reference Number 24
REFERENCE25	VARCHAR2	(15)		Reference Number 25
REFERENCE26	VARCHAR2	(15)		Reference Number 26
REFERENCE27	VARCHAR2	(15)		Reference Number 27
REFERENCE28	VARCHAR2	(15)		Reference Number 28
REFERENCE29	VARCHAR2	(15)		Reference Number 29
REFERENCE30	VARCHAR2	(15)		Reference Number 30
REFERENCE31	VARCHAR2	(15)		Reference Number 31
REFERENCE32	VARCHAR2	(15)		Reference Number 32
REFERENCE33	VARCHAR2	(15)		Reference Number 33
REFERENCE34	VARCHAR2	(15)		Reference Number 34
REFERENCE35	VARCHAR2	(15)		Reference Number 35
REFERENCE36	VARCHAR2	(15)		Reference Number 36
REFERENCE37	VARCHAR2	(15)		Reference Number 37
REFERENCE38	VARCHAR2	(15)		Reference Number 38
REFERENCE39	VARCHAR2	(15)		Reference Number 39
REFERENCE40	VARCHAR2	(15)		Reference Number 40
REFERENCE41	VARCHAR2	(15)		Reference Number 41
REFERENCE42	VARCHAR2	(15)		Reference Number 42
REFERENCE43	VARCHAR2	(15)		Reference Number 43
REFERENCE44	VARCHAR2	(15)		Reference Number 44
REFERENCE45	VARCHAR2	(15)		Reference Number 45
REFERENCE46	VARCHAR2	(15)		Reference Number 46
REFERENCE47	VARCHAR2	(15)		Reference Number 47
REFERENCE48	VARCHAR2	(15)		Reference Number 48
REFERENCE49	VARCHAR2	(15)		Reference Number 49
REFERENCE50	VARCHAR2	(15)		Reference Number 50
REFERENCE51	VARCHAR2	(15)		Reference Number 51
REFERENCE52	VARCHAR2	(15)		Reference Number 52
REFERENCE53	VARCHAR2	(15)		Reference Number 53
REFERENCE54	VARCHAR2	(15)		Reference Number 54
REFERENCE55	VARCHAR2	(15)		Reference Number 55
REFERENCE56	VARCHAR2	(15)		Reference Number 56
REFERENCE57	VARCHAR2	(15)		Reference Number 57
REFERENCE58	VARCHAR2	(15)		Reference Number 58
REFERENCE59	VARCHAR2	(15)		Reference Number 59
REFERENCE60	VARCHAR2	(15)		Reference Number 60
REFERENCE61	VARCHAR2	(15)		Reference Number 61
REFERENCE62	VARCHAR2	(15)		Reference Number 62
REFERENCE63	VARCHAR2	(15)		Reference Number 63
REFERENCE64	VARCHAR2	(15)		Reference Number 64
REFERENCE65	VARCHAR2	(15)		Reference Number 65
REFERENCE66	VARCHAR2	(15)		Reference Number 66
REFERENCE67	VARCHAR2	(15)		Reference Number 67
REFERENCE68	VARCHAR2	(15)		Reference Number 68
REFERENCE69	VARCHAR2	(15)		Reference Number 69
REFERENCE70	VARCHAR2	(15)		Reference Number 70
REFERENCE71	VARCHAR2	(15)		Reference Number 71
REFERENCE72	VARCHAR2	(15)		Reference Number 72
REFERENCE73	VARCHAR2	(15)		Reference Number 73
REFERENCE74	VARCHAR2	(15)		Reference Number 74
REFERENCE75	VARCHAR2	(15)		Reference Number 75
REFERENCE76	VARCHAR2	(15)		Reference Number 76
REFERENCE77	VARCHAR2	(15)		Reference Number 77
REFERENCE78	VARCHAR2	(15)		Reference Number 78
REFERENCE79	VARCHAR2	(15)		Reference Number 79
REFERENCE80	VARCHAR2	(15)		Reference Number 80
REFERENCE81	VARCHAR2	(15)		Reference Number 81
REFERENCE82	VARCHAR2	(15)		Reference Number 82
REFERENCE83	VARCHAR2	(15)		Reference Number 83
REFERENCE84	VARCHAR2	(15)		Reference Number 84
REFERENCE85	VARCHAR2	(15)		Reference Number 85
REFERENCE86	VARCHAR2	(15)		Reference Number 86
REFERENCE87	VARCHAR2	(15)		Reference Number 87
REFERENCE88	VARCHAR2	(15)		Reference Number 88
REFERENCE89	VARCHAR2	(15)		Reference Number 89
REFERENCE90	VARCHAR2	(15)		Reference Number 90

Query Text

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


SELECT RECORD_TYPE
,      SPREADSHEET_HEADER_ID
,      CURRENCY_CODE
,      PROFILE_CODE
,      START_PERIOD
,      ANNUAL_AMOUNT
,      NEXT_YEAR_BUDGET
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      REFERENCE11
,      REFERENCE12
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      REFERENCE16
,      REFERENCE17
,      REFERENCE18
,      REFERENCE19
,      REFERENCE20
,      REFERENCE21
,      REFERENCE22
,      REFERENCE23
,      REFERENCE24
,      REFERENCE25
,      REFERENCE26
,      REFERENCE27
,      REFERENCE28
,      REFERENCE29
,      REFERENCE30
,      REFERENCE31
,      REFERENCE32
,      REFERENCE33
,      REFERENCE34
,      REFERENCE35
,      REFERENCE36
,      REFERENCE37
,      REFERENCE38
,      REFERENCE39
,      REFERENCE40
,      REFERENCE41
,      REFERENCE42
,      REFERENCE43
,      REFERENCE44
,      REFERENCE45
,      REFERENCE46
,      REFERENCE47
,      REFERENCE48
,      REFERENCE49
,      REFERENCE50
,      REFERENCE51
,      REFERENCE52
,      REFERENCE53
,      REFERENCE54
,      REFERENCE55
,      REFERENCE56
,      REFERENCE57
,      REFERENCE58
,      REFERENCE59
,      REFERENCE60
,      REFERENCE61
,      REFERENCE62
,      REFERENCE63
,      REFERENCE64
,      REFERENCE65
,      REFERENCE66
,      REFERENCE67
,      REFERENCE68
,      REFERENCE69
,      REFERENCE70
,      REFERENCE71
,      REFERENCE72
,      REFERENCE73
,      REFERENCE74
,      REFERENCE75
,      REFERENCE76
,      REFERENCE77
,      REFERENCE78
,      REFERENCE79
,      REFERENCE80
,      REFERENCE81
,      REFERENCE82
,      REFERENCE83
,      REFERENCE84
,      REFERENCE85
,      REFERENCE86
,      REFERENCE87
,      REFERENCE88
,      REFERENCE89
,      REFERENCE90
FROM IGI.IGI_BUD_SHEET_LINES;

Dependencies

[top of page]

IGI.IGI_BUD_SHEET_LINES does not reference any database object

IGI.IGI_BUD_SHEET_LINES is referenced by following:

APPS: IGI_BUD_SHEET_LINES