[Home] [Help] [Dependency Information]
Object Name: | AMS_ACT_METRIC_FACTS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AMS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_METRIC_FACT_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
ACT_METRIC_USED_BY_ID | NUMBER | Yes | ||
ARC_ACT_METRIC_USED_BY | VARCHAR2 | (30) | Yes | |
VALUE_TYPE | VARCHAR2 | (30) | Yes | |
ACTIVITY_METRIC_ID | NUMBER | Yes | ||
ACTIVITY_GEO_AREA_ID | NUMBER | |||
ACTIVITY_PRODUCT_ID | NUMBER | |||
TRANSACTION_CURRENCY_CODE | VARCHAR2 | (15) | ||
TRANS_FORECASTED_VALUE | NUMBER | (15) | Yes | |
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
FUNC_FORECASTED_VALUE | NUMBER | (15) | Yes | |
ORG_ID | NUMBER | (32) | ||
DE_METRIC_ID | NUMBER | Yes | ||
DE_GEOGRAPHIC_AREA_ID | NUMBER | |||
DE_GEOGRAPHIC_AREA_TYPE | VARCHAR2 | (30) | ||
DE_INVENTORY_ITEM_ID | NUMBER | (38) | ||
DE_INVENTORY_ITEM_ORG_ID | NUMBER | (32) | ||
TIME_ID1 | NUMBER | Yes | ||
TIME_ID2 | NUMBER | |||
TIME_ID3 | NUMBER | |||
TIME_ID4 | NUMBER | |||
TIME_ID5 | NUMBER | |||
TIME_ID6 | NUMBER | |||
TIME_ID7 | NUMBER | |||
TIME_ID8 | NUMBER | |||
TIME_ID9 | NUMBER | |||
TIME_ID10 | NUMBER | |||
TIME_ID11 | NUMBER | |||
TIME_ID12 | NUMBER | |||
TIME_ID13 | NUMBER | |||
TIME_ID14 | NUMBER | |||
TIME_ID15 | NUMBER | |||
TIME_ID16 | NUMBER | |||
TIME_ID17 | NUMBER | |||
TIME_ID18 | NUMBER | |||
TIME_ID19 | NUMBER | |||
TIME_ID20 | NUMBER | |||
TIME_ID21 | NUMBER | |||
TIME_ID22 | NUMBER | |||
TIME_ID23 | NUMBER | |||
TIME_ID24 | NUMBER | |||
TIME_ID25 | NUMBER | |||
TIME_ID26 | NUMBER | |||
TIME_ID27 | NUMBER | |||
TIME_ID28 | NUMBER | |||
TIME_ID29 | NUMBER | |||
TIME_ID30 | NUMBER | |||
TIME_ID31 | NUMBER | |||
TIME_ID32 | NUMBER | |||
TIME_ID33 | NUMBER | |||
TIME_ID34 | NUMBER | |||
TIME_ID35 | NUMBER | |||
TIME_ID36 | NUMBER | |||
TIME_ID37 | NUMBER | |||
TIME_ID38 | NUMBER | |||
TIME_ID39 | NUMBER | |||
TIME_ID40 | NUMBER | |||
TIME_ID41 | NUMBER | |||
TIME_ID42 | NUMBER | |||
TIME_ID43 | NUMBER | |||
TIME_ID44 | NUMBER | |||
TIME_ID45 | NUMBER | |||
TIME_ID46 | NUMBER | |||
TIME_ID47 | NUMBER | |||
TIME_ID48 | NUMBER | |||
TIME_ID49 | NUMBER | |||
TIME_ID50 | NUMBER | |||
TIME_ID51 | NUMBER | |||
TIME_ID52 | NUMBER | |||
TIME_ID53 | NUMBER | |||
HIERARCHY_ID | NUMBER | |||
NODE_ID | NUMBER | |||
LEVEL_DEPTH | NUMBER | (15) | ||
FORMULA_ID | NUMBER | |||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
FACT_VALUE | NUMBER | |||
FACT_PERCENT | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
BASE_QUANTITY | NUMBER | |||
ROOT_FACT_ID | NUMBER | |||
PREVIOUS_FACT_ID | NUMBER | |||
FACT_TYPE | VARCHAR2 | (30) | ||
FACT_REFERENCE | VARCHAR2 | (240) | ||
FORECAST_REMAINING_QUANTITY | NUMBER | |||
FORWARD_BUY_QUANTITY | NUMBER | |||
STATUS_CODE | VARCHAR2 | (30) | ||
HIERARCHY_TYPE | VARCHAR2 | (30) | ||
RECOMMEND_TOTAL_AMOUNT | NUMBER | |||
APPROVAL_DATE | DATE | |||
RECOMMEND_HB_AMOUNT | NUMBER | |||
REQUEST_TOTAL_AMOUNT | NUMBER | |||
REQUEST_HB_AMOUNT | NUMBER | |||
ACTUAL_TOTAL_AMOUNT | NUMBER | |||
ACTUAL_HB_AMOUNT | NUMBER | |||
BASE_TOTAL_PCT | NUMBER | |||
BASE_HB_PCT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_METRIC_FACT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, ACT_METRIC_USED_BY_ID
, ARC_ACT_METRIC_USED_BY
, VALUE_TYPE
, ACTIVITY_METRIC_ID
, ACTIVITY_GEO_AREA_ID
, ACTIVITY_PRODUCT_ID
, TRANSACTION_CURRENCY_CODE
, TRANS_FORECASTED_VALUE
, FUNCTIONAL_CURRENCY_CODE
, FUNC_FORECASTED_VALUE
, ORG_ID
, DE_METRIC_ID
, DE_GEOGRAPHIC_AREA_ID
, DE_GEOGRAPHIC_AREA_TYPE
, DE_INVENTORY_ITEM_ID
, DE_INVENTORY_ITEM_ORG_ID
, TIME_ID1
, TIME_ID2
, TIME_ID3
, TIME_ID4
, TIME_ID5
, TIME_ID6
, TIME_ID7
, TIME_ID8
, TIME_ID9
, TIME_ID10
, TIME_ID11
, TIME_ID12
, TIME_ID13
, TIME_ID14
, TIME_ID15
, TIME_ID16
, TIME_ID17
, TIME_ID18
, TIME_ID19
, TIME_ID20
, TIME_ID21
, TIME_ID22
, TIME_ID23
, TIME_ID24
, TIME_ID25
, TIME_ID26
, TIME_ID27
, TIME_ID28
, TIME_ID29
, TIME_ID30
, TIME_ID31
, TIME_ID32
, TIME_ID33
, TIME_ID34
, TIME_ID35
, TIME_ID36
, TIME_ID37
, TIME_ID38
, TIME_ID39
, TIME_ID40
, TIME_ID41
, TIME_ID42
, TIME_ID43
, TIME_ID44
, TIME_ID45
, TIME_ID46
, TIME_ID47
, TIME_ID48
, TIME_ID49
, TIME_ID50
, TIME_ID51
, TIME_ID52
, TIME_ID53
, HIERARCHY_ID
, NODE_ID
, LEVEL_DEPTH
, FORMULA_ID
, FROM_DATE
, TO_DATE
, FACT_VALUE
, FACT_PERCENT
, SECURITY_GROUP_ID
, BASE_QUANTITY
, ROOT_FACT_ID
, PREVIOUS_FACT_ID
, FACT_TYPE
, FACT_REFERENCE
, FORECAST_REMAINING_QUANTITY
, FORWARD_BUY_QUANTITY
, STATUS_CODE
, HIERARCHY_TYPE
, RECOMMEND_TOTAL_AMOUNT
, APPROVAL_DATE
, RECOMMEND_HB_AMOUNT
, REQUEST_TOTAL_AMOUNT
, REQUEST_HB_AMOUNT
, ACTUAL_TOTAL_AMOUNT
, ACTUAL_HB_AMOUNT
, BASE_TOTAL_PCT
, BASE_HB_PCT
FROM AMS.AMS_ACT_METRIC_FACTS_ALL#;
|
|
|