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 Comments
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:

SchemaAMS
TableAMS_ADI_MEDIA_PLANNER
AMS.AMS_ADI_MEDIA_PLANNER# is referenced by following:

SchemaAPPS
SynonymAMS_ADI_MEDIA_PLANNER