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]

VIEW: APPS.CE_FORECAST_LINES_V

Object Details

Object Name:	CE_FORECAST_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CE.CE_FORECAST_LINES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
FORECAST_ID	NUMBER	(15)	Yes
FORECAST_ID_DUMMY	NUMBER	(15)	Yes
FORECAST_HEADER_ID	NUMBER	(15)	Yes
LINE_NUMBER	NUMBER	(15)	Yes
TRX_TYPE	VARCHAR2	(30)	Yes
TRX_TYPE_DSP	VARCHAR2	(80)	Yes
FORECAST_METHOD	VARCHAR2	(1)
DESCRIPTION	VARCHAR2	(255)
COLUMN0	NUMBER
COLUMN1	NUMBER
COLUMN2	NUMBER
COLUMN3	NUMBER
COLUMN4	NUMBER
COLUMN5	NUMBER
COLUMN6	NUMBER
COLUMN7	NUMBER
COLUMN8	NUMBER
COLUMN9	NUMBER
COLUMN10	NUMBER
COLUMN11	NUMBER
COLUMN12	NUMBER
COLUMN13	NUMBER
COLUMN14	NUMBER
COLUMN15	NUMBER
COLUMN16	NUMBER
COLUMN17	NUMBER
COLUMN18	NUMBER
COLUMN19	NUMBER
COLUMN20	NUMBER
COLUMN21	NUMBER
COLUMN22	NUMBER
COLUMN23	NUMBER
COLUMN24	NUMBER
COLUMN25	NUMBER
COLUMN26	NUMBER
COLUMN27	NUMBER
COLUMN28	NUMBER
COLUMN29	NUMBER
COLUMN30	NUMBER
COLUMN31	NUMBER
COLUMN32	NUMBER
COLUMN33	NUMBER
COLUMN34	NUMBER
COLUMN35	NUMBER
COLUMN36	NUMBER
COLUMN37	NUMBER
COLUMN38	NUMBER
COLUMN39	NUMBER
COLUMN40	NUMBER
COLUMN41	NUMBER
COLUMN42	NUMBER
COLUMN43	NUMBER
COLUMN44	NUMBER
COLUMN45	NUMBER
COLUMN46	NUMBER
COLUMN47	NUMBER
COLUMN48	NUMBER
COLUMN49	NUMBER
COLUMN50	NUMBER
COLUMN51	NUMBER
COLUMN52	NUMBER
COLUMN53	NUMBER
COLUMN54	NUMBER
COLUMN55	NUMBER
COLUMN56	NUMBER
COLUMN57	NUMBER
COLUMN58	NUMBER
COLUMN59	NUMBER
COLUMN60	NUMBER
COLUMN61	NUMBER
COLUMN62	NUMBER
COLUMN63	NUMBER
COLUMN64	NUMBER
COLUMN65	NUMBER
COLUMN66	NUMBER
COLUMN67	NUMBER
COLUMN68	NUMBER
COLUMN69	NUMBER
COLUMN70	NUMBER
COLUMN71	NUMBER
COLUMN72	NUMBER
COLUMN73	NUMBER
COLUMN74	NUMBER
COLUMN75	NUMBER
COLUMN76	NUMBER
COLUMN77	NUMBER
COLUMN78	NUMBER
COLUMN79	NUMBER
COLUMN80	NUMBER
COLUMN0_DSP	VARCHAR2	(40)
COLUMN1_DSP	NUMBER
COLUMN2_DSP	NUMBER
COLUMN3_DSP	NUMBER
COLUMN4_DSP	NUMBER
COLUMN5_DSP	NUMBER
COLUMN6_DSP	NUMBER
COLUMN7_DSP	NUMBER
COLUMN8_DSP	NUMBER
COLUMN9_DSP	NUMBER
COLUMN10_DSP	NUMBER
COLUMN11_DSP	NUMBER
COLUMN12_DSP	NUMBER
COLUMN13_DSP	NUMBER
COLUMN14_DSP	NUMBER
COLUMN15_DSP	NUMBER
COLUMN16_DSP	NUMBER
COLUMN17_DSP	NUMBER
COLUMN18_DSP	NUMBER
COLUMN19_DSP	NUMBER
COLUMN20_DSP	NUMBER
COLUMN21_DSP	NUMBER
COLUMN22_DSP	NUMBER
COLUMN23_DSP	NUMBER
COLUMN24_DSP	NUMBER
COLUMN25_DSP	NUMBER
COLUMN26_DSP	NUMBER
COLUMN27_DSP	NUMBER
COLUMN28_DSP	NUMBER
COLUMN29_DSP	NUMBER
COLUMN30_DSP	NUMBER
COLUMN31_DSP	NUMBER
COLUMN32_DSP	NUMBER
COLUMN33_DSP	NUMBER
COLUMN34_DSP	NUMBER
COLUMN35_DSP	NUMBER
COLUMN36_DSP	NUMBER
COLUMN37_DSP	NUMBER
COLUMN38_DSP	NUMBER
COLUMN39_DSP	NUMBER
COLUMN40_DSP	NUMBER
COLUMN41_DSP	NUMBER
COLUMN42_DSP	NUMBER
COLUMN43_DSP	NUMBER
COLUMN44_DSP	NUMBER
COLUMN45_DSP	NUMBER
COLUMN46_DSP	NUMBER
COLUMN47_DSP	NUMBER
COLUMN48_DSP	NUMBER
COLUMN49_DSP	NUMBER
COLUMN50_DSP	NUMBER
COLUMN51_DSP	NUMBER
COLUMN52_DSP	NUMBER
COLUMN53_DSP	NUMBER
COLUMN54_DSP	NUMBER
COLUMN55_DSP	NUMBER
COLUMN56_DSP	NUMBER
COLUMN57_DSP	NUMBER
COLUMN58_DSP	NUMBER
COLUMN59_DSP	NUMBER
COLUMN60_DSP	NUMBER
COLUMN61_DSP	NUMBER
COLUMN62_DSP	NUMBER
COLUMN63_DSP	NUMBER
COLUMN64_DSP	NUMBER
COLUMN65_DSP	NUMBER
COLUMN66_DSP	NUMBER
COLUMN67_DSP	NUMBER
COLUMN68_DSP	NUMBER
COLUMN69_DSP	NUMBER
COLUMN70_DSP	NUMBER
COLUMN71_DSP	NUMBER
COLUMN72_DSP	NUMBER
COLUMN73_DSP	NUMBER
COLUMN74_DSP	NUMBER
COLUMN75_DSP	NUMBER
COLUMN76_DSP	NUMBER
COLUMN77_DSP	NUMBER
COLUMN78_DSP	NUMBER
COLUMN79_DSP	NUMBER
COLUMN80_DSP	NUMBER
COLUMN0_CELLID	NUMBER
COLUMN1_CELLID	NUMBER
COLUMN2_CELLID	NUMBER
COLUMN3_CELLID	NUMBER
COLUMN4_CELLID	NUMBER
COLUMN5_CELLID	NUMBER
COLUMN6_CELLID	NUMBER
COLUMN7_CELLID	NUMBER
COLUMN8_CELLID	NUMBER
COLUMN9_CELLID	NUMBER
COLUMN10_CELLID	NUMBER
COLUMN11_CELLID	NUMBER
COLUMN12_CELLID	NUMBER
COLUMN13_CELLID	NUMBER
COLUMN14_CELLID	NUMBER
COLUMN15_CELLID	NUMBER
COLUMN16_CELLID	NUMBER
COLUMN17_CELLID	NUMBER
COLUMN18_CELLID	NUMBER
COLUMN19_CELLID	NUMBER
COLUMN20_CELLID	NUMBER
COLUMN21_CELLID	NUMBER
COLUMN22_CELLID	NUMBER
COLUMN23_CELLID	NUMBER
COLUMN24_CELLID	NUMBER
COLUMN25_CELLID	NUMBER
COLUMN26_CELLID	NUMBER
COLUMN27_CELLID	NUMBER
COLUMN28_CELLID	NUMBER
COLUMN29_CELLID	NUMBER
COLUMN30_CELLID	NUMBER
COLUMN31_CELLID	NUMBER
COLUMN32_CELLID	NUMBER
COLUMN33_CELLID	NUMBER
COLUMN34_CELLID	NUMBER
COLUMN35_CELLID	NUMBER
COLUMN36_CELLID	NUMBER
COLUMN37_CELLID	NUMBER
COLUMN38_CELLID	NUMBER
COLUMN39_CELLID	NUMBER
COLUMN40_CELLID	NUMBER
COLUMN41_CELLID	NUMBER
COLUMN42_CELLID	NUMBER
COLUMN43_CELLID	NUMBER
COLUMN44_CELLID	NUMBER
COLUMN45_CELLID	NUMBER
COLUMN46_CELLID	NUMBER
COLUMN47_CELLID	NUMBER
COLUMN48_CELLID	NUMBER
COLUMN49_CELLID	NUMBER
COLUMN50_CELLID	NUMBER
COLUMN51_CELLID	NUMBER
COLUMN52_CELLID	NUMBER
COLUMN53_CELLID	NUMBER
COLUMN54_CELLID	NUMBER
COLUMN55_CELLID	NUMBER
COLUMN56_CELLID	NUMBER
COLUMN57_CELLID	NUMBER
COLUMN58_CELLID	NUMBER
COLUMN59_CELLID	NUMBER
COLUMN60_CELLID	NUMBER
COLUMN61_CELLID	NUMBER
COLUMN62_CELLID	NUMBER
COLUMN63_CELLID	NUMBER
COLUMN64_CELLID	NUMBER
COLUMN65_CELLID	NUMBER
COLUMN66_CELLID	NUMBER
COLUMN67_CELLID	NUMBER
COLUMN68_CELLID	NUMBER
COLUMN69_CELLID	NUMBER
COLUMN70_CELLID	NUMBER
COLUMN71_CELLID	NUMBER
COLUMN72_CELLID	NUMBER
COLUMN73_CELLID	NUMBER
COLUMN74_CELLID	NUMBER
COLUMN75_CELLID	NUMBER
COLUMN76_CELLID	NUMBER
COLUMN77_CELLID	NUMBER
COLUMN78_CELLID	NUMBER
COLUMN79_CELLID	NUMBER
COLUMN80_CELLID	NUMBER

Query Text

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


SELECT ROW_ID
,      FORECAST_ID
,      FORECAST_ID_DUMMY
,      FORECAST_HEADER_ID
,      LINE_NUMBER
,      TRX_TYPE
,      TRX_TYPE_DSP
,      FORECAST_METHOD
,      DESCRIPTION
,      COLUMN0
,      COLUMN1
,      COLUMN2
,      COLUMN3
,      COLUMN4
,      COLUMN5
,      COLUMN6
,      COLUMN7
,      COLUMN8
,      COLUMN9
,      COLUMN10
,      COLUMN11
,      COLUMN12
,      COLUMN13
,      COLUMN14
,      COLUMN15
,      COLUMN16
,      COLUMN17
,      COLUMN18
,      COLUMN19
,      COLUMN20
,      COLUMN21
,      COLUMN22
,      COLUMN23
,      COLUMN24
,      COLUMN25
,      COLUMN26
,      COLUMN27
,      COLUMN28
,      COLUMN29
,      COLUMN30
,      COLUMN31
,      COLUMN32
,      COLUMN33
,      COLUMN34
,      COLUMN35
,      COLUMN36
,      COLUMN37
,      COLUMN38
,      COLUMN39
,      COLUMN40
,      COLUMN41
,      COLUMN42
,      COLUMN43
,      COLUMN44
,      COLUMN45
,      COLUMN46
,      COLUMN47
,      COLUMN48
,      COLUMN49
,      COLUMN50
,      COLUMN51
,      COLUMN52
,      COLUMN53
,      COLUMN54
,      COLUMN55
,      COLUMN56
,      COLUMN57
,      COLUMN58
,      COLUMN59
,      COLUMN60
,      COLUMN61
,      COLUMN62
,      COLUMN63
,      COLUMN64
,      COLUMN65
,      COLUMN66
,      COLUMN67
,      COLUMN68
,      COLUMN69
,      COLUMN70
,      COLUMN71
,      COLUMN72
,      COLUMN73
,      COLUMN74
,      COLUMN75
,      COLUMN76
,      COLUMN77
,      COLUMN78
,      COLUMN79
,      COLUMN80
,      COLUMN0_DSP
,      COLUMN1_DSP
,      COLUMN2_DSP
,      COLUMN3_DSP
,      COLUMN4_DSP
,      COLUMN5_DSP
,      COLUMN6_DSP
,      COLUMN7_DSP
,      COLUMN8_DSP
,      COLUMN9_DSP
,      COLUMN10_DSP
,      COLUMN11_DSP
,      COLUMN12_DSP
,      COLUMN13_DSP
,      COLUMN14_DSP
,      COLUMN15_DSP
,      COLUMN16_DSP
,      COLUMN17_DSP
,      COLUMN18_DSP
,      COLUMN19_DSP
,      COLUMN20_DSP
,      COLUMN21_DSP
,      COLUMN22_DSP
,      COLUMN23_DSP
,      COLUMN24_DSP
,      COLUMN25_DSP
,      COLUMN26_DSP
,      COLUMN27_DSP
,      COLUMN28_DSP
,      COLUMN29_DSP
,      COLUMN30_DSP
,      COLUMN31_DSP
,      COLUMN32_DSP
,      COLUMN33_DSP
,      COLUMN34_DSP
,      COLUMN35_DSP
,      COLUMN36_DSP
,      COLUMN37_DSP
,      COLUMN38_DSP
,      COLUMN39_DSP
,      COLUMN40_DSP
,      COLUMN41_DSP
,      COLUMN42_DSP
,      COLUMN43_DSP
,      COLUMN44_DSP
,      COLUMN45_DSP
,      COLUMN46_DSP
,      COLUMN47_DSP
,      COLUMN48_DSP
,      COLUMN49_DSP
,      COLUMN50_DSP
,      COLUMN51_DSP
,      COLUMN52_DSP
,      COLUMN53_DSP
,      COLUMN54_DSP
,      COLUMN55_DSP
,      COLUMN56_DSP
,      COLUMN57_DSP
,      COLUMN58_DSP
,      COLUMN59_DSP
,      COLUMN60_DSP
,      COLUMN61_DSP
,      COLUMN62_DSP
,      COLUMN63_DSP
,      COLUMN64_DSP
,      COLUMN65_DSP
,      COLUMN66_DSP
,      COLUMN67_DSP
,      COLUMN68_DSP
,      COLUMN69_DSP
,      COLUMN70_DSP
,      COLUMN71_DSP
,      COLUMN72_DSP
,      COLUMN73_DSP
,      COLUMN74_DSP
,      COLUMN75_DSP
,      COLUMN76_DSP
,      COLUMN77_DSP
,      COLUMN78_DSP
,      COLUMN79_DSP
,      COLUMN80_DSP
,      COLUMN0_CELLID
,      COLUMN1_CELLID
,      COLUMN2_CELLID
,      COLUMN3_CELLID
,      COLUMN4_CELLID
,      COLUMN5_CELLID
,      COLUMN6_CELLID
,      COLUMN7_CELLID
,      COLUMN8_CELLID
,      COLUMN9_CELLID
,      COLUMN10_CELLID
,      COLUMN11_CELLID
,      COLUMN12_CELLID
,      COLUMN13_CELLID
,      COLUMN14_CELLID
,      COLUMN15_CELLID
,      COLUMN16_CELLID
,      COLUMN17_CELLID
,      COLUMN18_CELLID
,      COLUMN19_CELLID
,      COLUMN20_CELLID
,      COLUMN21_CELLID
,      COLUMN22_CELLID
,      COLUMN23_CELLID
,      COLUMN24_CELLID
,      COLUMN25_CELLID
,      COLUMN26_CELLID
,      COLUMN27_CELLID
,      COLUMN28_CELLID
,      COLUMN29_CELLID
,      COLUMN30_CELLID
,      COLUMN31_CELLID
,      COLUMN32_CELLID
,      COLUMN33_CELLID
,      COLUMN34_CELLID
,      COLUMN35_CELLID
,      COLUMN36_CELLID
,      COLUMN37_CELLID
,      COLUMN38_CELLID
,      COLUMN39_CELLID
,      COLUMN40_CELLID
,      COLUMN41_CELLID
,      COLUMN42_CELLID
,      COLUMN43_CELLID
,      COLUMN44_CELLID
,      COLUMN45_CELLID
,      COLUMN46_CELLID
,      COLUMN47_CELLID
,      COLUMN48_CELLID
,      COLUMN49_CELLID
,      COLUMN50_CELLID
,      COLUMN51_CELLID
,      COLUMN52_CELLID
,      COLUMN53_CELLID
,      COLUMN54_CELLID
,      COLUMN55_CELLID
,      COLUMN56_CELLID
,      COLUMN57_CELLID
,      COLUMN58_CELLID
,      COLUMN59_CELLID
,      COLUMN60_CELLID
,      COLUMN61_CELLID
,      COLUMN62_CELLID
,      COLUMN63_CELLID
,      COLUMN64_CELLID
,      COLUMN65_CELLID
,      COLUMN66_CELLID
,      COLUMN67_CELLID
,      COLUMN68_CELLID
,      COLUMN69_CELLID
,      COLUMN70_CELLID
,      COLUMN71_CELLID
,      COLUMN72_CELLID
,      COLUMN73_CELLID
,      COLUMN74_CELLID
,      COLUMN75_CELLID
,      COLUMN76_CELLID
,      COLUMN77_CELLID
,      COLUMN78_CELLID
,      COLUMN79_CELLID
,      COLUMN80_CELLID
FROM APPS.CE_FORECAST_LINES_V;

Dependencies

[top of page]

APPS.CE_FORECAST_LINES_V references the following:

APPS: CE_FORECASTS_PKG - show dependent code; CE_FORECAST_LINES_AMT_V; CE_FORECAST_LINES_CELLID_V; CE_FORECAST_ROWS; CE_LOOKUPS

APPS.CE_FORECAST_LINES_V is not referenced by any database object