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: AMS.AMS_ADI_MEDIA_PLANNER#

Object Details

Object Name:	AMS_ADI_MEDIA_PLANNER#
Object Type:	VIEW
Owner:	AMS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
UPLOAD_BATCH_ID	NUMBER
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)
OPERATION_TYPE	VARCHAR2	(30)
OPERATION_STATUS	VARCHAR2	(30)
ERROR_MESSAGE	VARCHAR2	(4000)
OBJECT_TYPE	VARCHAR2	(30)
OBJECT_ID	NUMBER
OBJECT_NAME	VARCHAR2	(240)
PARENT_TYPE	VARCHAR2	(30)
PARENT_ID	NUMBER
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)
METRIC_ID_101	NUMBER
ACT_METRIC_ID_101	NUMBER
OBJECT_VERSION_NUMBER_101	NUMBER	(9)
TRANS_CURRENCY_CODE_101	VARCHAR2	(30)
METRIC_FORECAST_101	NUMBER
METRIC_ACTUAL_101	NUMBER
METRIC_ID_102	NUMBER
ACT_METRIC_ID_102	NUMBER
OBJECT_VERSION_NUMBER_102	NUMBER	(9)
TRANS_CURRENCY_CODE_102	VARCHAR2	(30)
METRIC_FORECAST_102	NUMBER
METRIC_ACTUAL_102	NUMBER
METRIC_ID_103	NUMBER
ACT_METRIC_ID_103	NUMBER
OBJECT_VERSION_NUMBER_103	NUMBER	(9)
TRANS_CURRENCY_CODE_103	VARCHAR2	(30)
METRIC_FORECAST_103	NUMBER
METRIC_ACTUAL_103	NUMBER
METRIC_ID_104	NUMBER
ACT_METRIC_ID_104	NUMBER
OBJECT_VERSION_NUMBER_104	NUMBER	(9)
TRANS_CURRENCY_CODE_104	VARCHAR2	(30)
METRIC_FORECAST_104	NUMBER
METRIC_ACTUAL_104	NUMBER
METRIC_ID_105	NUMBER
ACT_METRIC_ID_105	NUMBER
OBJECT_VERSION_NUMBER_105	NUMBER	(9)
TRANS_CURRENCY_CODE_105	VARCHAR2	(30)
METRIC_FORECAST_105	NUMBER
METRIC_ACTUAL_105	NUMBER
METRIC_ID_106	NUMBER
ACT_METRIC_ID_106	NUMBER
OBJECT_VERSION_NUMBER_106	NUMBER	(9)
TRANS_CURRENCY_CODE_106	VARCHAR2	(30)
METRIC_FORECAST_106	NUMBER
METRIC_ACTUAL_106	NUMBER
METRIC_ID_107	NUMBER
ACT_METRIC_ID_107	NUMBER
OBJECT_VERSION_NUMBER_107	NUMBER	(9)
TRANS_CURRENCY_CODE_107	VARCHAR2	(30)
METRIC_FORECAST_107	NUMBER
METRIC_ACTUAL_107	NUMBER
METRIC_ID_108	NUMBER
ACT_METRIC_ID_108	NUMBER
OBJECT_VERSION_NUMBER_108	NUMBER	(9)
TRANS_CURRENCY_CODE_108	VARCHAR2	(30)
METRIC_FORECAST_108	NUMBER
METRIC_ACTUAL_108	NUMBER
METRIC_ID_109	NUMBER
ACT_METRIC_ID_109	NUMBER
OBJECT_VERSION_NUMBER_109	NUMBER	(9)
TRANS_CURRENCY_CODE_109	VARCHAR2	(30)
METRIC_FORECAST_109	NUMBER
METRIC_ACTUAL_109	NUMBER
METRIC_ID_110	NUMBER
ACT_METRIC_ID_110	NUMBER
OBJECT_VERSION_NUMBER_110	NUMBER	(9)
TRANS_CURRENCY_CODE_110	VARCHAR2	(30)
METRIC_FORECAST_110	NUMBER
METRIC_ACTUAL_110	NUMBER
METRIC_ID_201	NUMBER
ACT_METRIC_ID_201	NUMBER
OBJECT_VERSION_NUMBER_201	NUMBER	(9)
TRANS_CURRENCY_CODE_201	VARCHAR2	(30)
METRIC_FORECAST_UNIT_201	NUMBER
METRIC_ACTUAL_201	NUMBER
METRIC_ID_202	NUMBER
ACT_METRIC_ID_202	NUMBER
OBJECT_VERSION_NUMBER_202	NUMBER	(9)
TRANS_CURRENCY_CODE_202	VARCHAR2	(30)
METRIC_FORECAST_UNIT_202	NUMBER
METRIC_ACTUAL_202	NUMBER
METRIC_ID_203	NUMBER
ACT_METRIC_ID_203	NUMBER
OBJECT_VERSION_NUMBER_203	NUMBER	(9)
TRANS_CURRENCY_CODE_203	VARCHAR2	(30)
METRIC_FORECAST_UNIT_203	NUMBER
METRIC_ACTUAL_203	NUMBER
METRIC_ID_204	NUMBER
ACT_METRIC_ID_204	NUMBER
OBJECT_VERSION_NUMBER_204	NUMBER	(9)
TRANS_CURRENCY_CODE_204	VARCHAR2	(30)
METRIC_FORECAST_UNIT_204	NUMBER
METRIC_ACTUAL_204	NUMBER
METRIC_ID_205	NUMBER
ACT_METRIC_ID_205	NUMBER
OBJECT_VERSION_NUMBER_205	NUMBER	(9)
TRANS_CURRENCY_CODE_205	VARCHAR2	(30)
METRIC_FORECAST_UNIT_205	NUMBER
METRIC_ACTUAL_205	NUMBER
METRIC_ID_301	NUMBER
ACT_METRIC_ID_301	NUMBER
OBJECT_VERSION_NUMBER_301	NUMBER	(9)
TRANS_CURRENCY_CODE_301	VARCHAR2	(30)
METRIC_FORECAST_301	NUMBER
METRIC_ID_302	NUMBER
ACT_METRIC_ID_302	NUMBER
OBJECT_VERSION_NUMBER_302	NUMBER	(9)
TRANS_CURRENCY_CODE_302	VARCHAR2	(30)
METRIC_FORECAST_302	NUMBER
METRIC_ID_303	NUMBER
ACT_METRIC_ID_303	NUMBER
OBJECT_VERSION_NUMBER_303	NUMBER	(9)
TRANS_CURRENCY_CODE_303	VARCHAR2	(30)
METRIC_FORECAST_303	NUMBER
METRIC_ID_304	NUMBER
ACT_METRIC_ID_304	NUMBER
OBJECT_VERSION_NUMBER_304	NUMBER	(9)
TRANS_CURRENCY_CODE_304	VARCHAR2	(30)
METRIC_FORECAST_304	NUMBER
METRIC_ID_305	NUMBER
ACT_METRIC_ID_305	NUMBER
OBJECT_VERSION_NUMBER_305	NUMBER	(9)
TRANS_CURRENCY_CODE_305	VARCHAR2	(30)
METRIC_FORECAST_305	NUMBER
METRIC_ID_306	NUMBER
ACT_METRIC_ID_306	NUMBER
OBJECT_VERSION_NUMBER_306	NUMBER	(9)
TRANS_CURRENCY_CODE_306	VARCHAR2	(30)
METRIC_FORECAST_306	NUMBER
METRIC_ID_307	NUMBER
ACT_METRIC_ID_307	NUMBER
OBJECT_VERSION_NUMBER_307	NUMBER	(9)
TRANS_CURRENCY_CODE_307	VARCHAR2	(30)
METRIC_FORECAST_307	NUMBER
METRIC_ID_308	NUMBER
ACT_METRIC_ID_308	NUMBER
OBJECT_VERSION_NUMBER_308	NUMBER	(9)
TRANS_CURRENCY_CODE_308	VARCHAR2	(30)
METRIC_FORECAST_308	NUMBER
METRIC_ID_309	NUMBER
ACT_METRIC_ID_309	NUMBER
OBJECT_VERSION_NUMBER_309	NUMBER	(9)
TRANS_CURRENCY_CODE_309	VARCHAR2	(30)
METRIC_FORECAST_309	NUMBER
METRIC_ID_310	NUMBER
ACT_METRIC_ID_310	NUMBER
OBJECT_VERSION_NUMBER_310	NUMBER	(9)
TRANS_CURRENCY_CODE_310	VARCHAR2	(30)
METRIC_FORECAST_310	NUMBER
METRIC_ID_401	NUMBER
ACT_METRIC_ID_401	NUMBER
OBJECT_VERSION_NUMBER_401	NUMBER	(9)
TRANS_CURRENCY_CODE_401	VARCHAR2	(30)
METRIC_FORECAST_UNIT_401	NUMBER
METRIC_ID_402	NUMBER
ACT_METRIC_ID_402	NUMBER
OBJECT_VERSION_NUMBER_402	NUMBER	(9)
TRANS_CURRENCY_CODE_402	VARCHAR2	(30)
METRIC_FORECAST_UNIT_402	NUMBER
METRIC_ID_403	NUMBER
ACT_METRIC_ID_403	NUMBER
OBJECT_VERSION_NUMBER_403	NUMBER	(9)
TRANS_CURRENCY_CODE_403	VARCHAR2	(30)
METRIC_FORECAST_UNIT_403	NUMBER
METRIC_ID_404	NUMBER
ACT_METRIC_ID_404	NUMBER
OBJECT_VERSION_NUMBER_404	NUMBER	(9)
TRANS_CURRENCY_CODE_404	VARCHAR2	(30)
METRIC_FORECAST_UNIT_404	NUMBER
METRIC_ID_405	NUMBER
ACT_METRIC_ID_405	NUMBER
OBJECT_VERSION_NUMBER_405	NUMBER	(9)
TRANS_CURRENCY_CODE_405	VARCHAR2	(30)
METRIC_FORECAST_UNIT_405	NUMBER
METRIC_ID_501	NUMBER
METRIC_ID_502	NUMBER
METRIC_ID_503	NUMBER
METRIC_ID_504	NUMBER
METRIC_ID_505	NUMBER
METRIC_ID_506	NUMBER
METRIC_ID_507	NUMBER
METRIC_ID_508	NUMBER
METRIC_ID_509	NUMBER
METRIC_ID_510	NUMBER
UI_INSTANCE_ID	NUMBER

Query Text

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


SELECT UPLOAD_BATCH_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      OPERATION_TYPE
,      OPERATION_STATUS
,      ERROR_MESSAGE
,      OBJECT_TYPE
,      OBJECT_ID
,      OBJECT_NAME
,      PARENT_TYPE
,      PARENT_ID
,      TRANSACTION_CURRENCY_CODE
,      METRIC_ID_101
,      ACT_METRIC_ID_101
,      OBJECT_VERSION_NUMBER_101
,      TRANS_CURRENCY_CODE_101
,      METRIC_FORECAST_101
,      METRIC_ACTUAL_101
,      METRIC_ID_102
,      ACT_METRIC_ID_102
,      OBJECT_VERSION_NUMBER_102
,      TRANS_CURRENCY_CODE_102
,      METRIC_FORECAST_102
,      METRIC_ACTUAL_102
,      METRIC_ID_103
,      ACT_METRIC_ID_103
,      OBJECT_VERSION_NUMBER_103
,      TRANS_CURRENCY_CODE_103
,      METRIC_FORECAST_103
,      METRIC_ACTUAL_103
,      METRIC_ID_104
,      ACT_METRIC_ID_104
,      OBJECT_VERSION_NUMBER_104
,      TRANS_CURRENCY_CODE_104
,      METRIC_FORECAST_104
,      METRIC_ACTUAL_104
,      METRIC_ID_105
,      ACT_METRIC_ID_105
,      OBJECT_VERSION_NUMBER_105
,      TRANS_CURRENCY_CODE_105
,      METRIC_FORECAST_105
,      METRIC_ACTUAL_105
,      METRIC_ID_106
,      ACT_METRIC_ID_106
,      OBJECT_VERSION_NUMBER_106
,      TRANS_CURRENCY_CODE_106
,      METRIC_FORECAST_106
,      METRIC_ACTUAL_106
,      METRIC_ID_107
,      ACT_METRIC_ID_107
,      OBJECT_VERSION_NUMBER_107
,      TRANS_CURRENCY_CODE_107
,      METRIC_FORECAST_107
,      METRIC_ACTUAL_107
,      METRIC_ID_108
,      ACT_METRIC_ID_108
,      OBJECT_VERSION_NUMBER_108
,      TRANS_CURRENCY_CODE_108
,      METRIC_FORECAST_108
,      METRIC_ACTUAL_108
,      METRIC_ID_109
,      ACT_METRIC_ID_109
,      OBJECT_VERSION_NUMBER_109
,      TRANS_CURRENCY_CODE_109
,      METRIC_FORECAST_109
,      METRIC_ACTUAL_109
,      METRIC_ID_110
,      ACT_METRIC_ID_110
,      OBJECT_VERSION_NUMBER_110
,      TRANS_CURRENCY_CODE_110
,      METRIC_FORECAST_110
,      METRIC_ACTUAL_110
,      METRIC_ID_201
,      ACT_METRIC_ID_201
,      OBJECT_VERSION_NUMBER_201
,      TRANS_CURRENCY_CODE_201
,      METRIC_FORECAST_UNIT_201
,      METRIC_ACTUAL_201
,      METRIC_ID_202
,      ACT_METRIC_ID_202
,      OBJECT_VERSION_NUMBER_202
,      TRANS_CURRENCY_CODE_202
,      METRIC_FORECAST_UNIT_202
,      METRIC_ACTUAL_202
,      METRIC_ID_203
,      ACT_METRIC_ID_203
,      OBJECT_VERSION_NUMBER_203
,      TRANS_CURRENCY_CODE_203
,      METRIC_FORECAST_UNIT_203
,      METRIC_ACTUAL_203
,      METRIC_ID_204
,      ACT_METRIC_ID_204
,      OBJECT_VERSION_NUMBER_204
,      TRANS_CURRENCY_CODE_204
,      METRIC_FORECAST_UNIT_204
,      METRIC_ACTUAL_204
,      METRIC_ID_205
,      ACT_METRIC_ID_205
,      OBJECT_VERSION_NUMBER_205
,      TRANS_CURRENCY_CODE_205
,      METRIC_FORECAST_UNIT_205
,      METRIC_ACTUAL_205
,      METRIC_ID_301
,      ACT_METRIC_ID_301
,      OBJECT_VERSION_NUMBER_301
,      TRANS_CURRENCY_CODE_301
,      METRIC_FORECAST_301
,      METRIC_ID_302
,      ACT_METRIC_ID_302
,      OBJECT_VERSION_NUMBER_302
,      TRANS_CURRENCY_CODE_302
,      METRIC_FORECAST_302
,      METRIC_ID_303
,      ACT_METRIC_ID_303
,      OBJECT_VERSION_NUMBER_303
,      TRANS_CURRENCY_CODE_303
,      METRIC_FORECAST_303
,      METRIC_ID_304
,      ACT_METRIC_ID_304
,      OBJECT_VERSION_NUMBER_304
,      TRANS_CURRENCY_CODE_304
,      METRIC_FORECAST_304
,      METRIC_ID_305
,      ACT_METRIC_ID_305
,      OBJECT_VERSION_NUMBER_305
,      TRANS_CURRENCY_CODE_305
,      METRIC_FORECAST_305
,      METRIC_ID_306
,      ACT_METRIC_ID_306
,      OBJECT_VERSION_NUMBER_306
,      TRANS_CURRENCY_CODE_306
,      METRIC_FORECAST_306
,      METRIC_ID_307
,      ACT_METRIC_ID_307
,      OBJECT_VERSION_NUMBER_307
,      TRANS_CURRENCY_CODE_307
,      METRIC_FORECAST_307
,      METRIC_ID_308
,      ACT_METRIC_ID_308
,      OBJECT_VERSION_NUMBER_308
,      TRANS_CURRENCY_CODE_308
,      METRIC_FORECAST_308
,      METRIC_ID_309
,      ACT_METRIC_ID_309
,      OBJECT_VERSION_NUMBER_309
,      TRANS_CURRENCY_CODE_309
,      METRIC_FORECAST_309
,      METRIC_ID_310
,      ACT_METRIC_ID_310
,      OBJECT_VERSION_NUMBER_310
,      TRANS_CURRENCY_CODE_310
,      METRIC_FORECAST_310
,      METRIC_ID_401
,      ACT_METRIC_ID_401
,      OBJECT_VERSION_NUMBER_401
,      TRANS_CURRENCY_CODE_401
,      METRIC_FORECAST_UNIT_401
,      METRIC_ID_402
,      ACT_METRIC_ID_402
,      OBJECT_VERSION_NUMBER_402
,      TRANS_CURRENCY_CODE_402
,      METRIC_FORECAST_UNIT_402
,      METRIC_ID_403
,      ACT_METRIC_ID_403
,      OBJECT_VERSION_NUMBER_403
,      TRANS_CURRENCY_CODE_403
,      METRIC_FORECAST_UNIT_403
,      METRIC_ID_404
,      ACT_METRIC_ID_404
,      OBJECT_VERSION_NUMBER_404
,      TRANS_CURRENCY_CODE_404
,      METRIC_FORECAST_UNIT_404
,      METRIC_ID_405
,      ACT_METRIC_ID_405
,      OBJECT_VERSION_NUMBER_405
,      TRANS_CURRENCY_CODE_405
,      METRIC_FORECAST_UNIT_405
,      METRIC_ID_501
,      METRIC_ID_502
,      METRIC_ID_503
,      METRIC_ID_504
,      METRIC_ID_505
,      METRIC_ID_506
,      METRIC_ID_507
,      METRIC_ID_508
,      METRIC_ID_509
,      METRIC_ID_510
,      UI_INSTANCE_ID
FROM AMS.AMS_ADI_MEDIA_PLANNER#;

Dependencies

[top of page]

AMS.AMS_ADI_MEDIA_PLANNER# references the following:

AMS: AMS_ADI_MEDIA_PLANNER

AMS.AMS_ADI_MEDIA_PLANNER# is referenced by following:

APPS: AMS_ADI_MEDIA_PLANNER