[Home] [Help] [Dependency Information]
Object Name: | OZF_FUND_ALLOCATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OZF.OZF_FUND_ALLOCATIONS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FUND_ID | NUMBER | Yes | ||
SHORT_NAME | VARCHAR2 | (240) | Yes | |
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
CATEGORY_ID | NUMBER | Yes | ||
CATEGORY | VARCHAR2 | (120) | ||
FUND_TYPE | VARCHAR2 | (30) | ||
ACTIVITY_METRIC_ID | NUMBER | Yes | ||
HIERARCHY_ID | NUMBER | |||
FROM_LEVEL | NUMBER | |||
TO_LEVEL | NUMBER | |||
START_NODE | NUMBER | |||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
FUNC_ACTUAL_VALUE | NUMBER | |||
METRIC_UOM_CODE | VARCHAR2 | (3) | ||
ACT_METRIC_USED_BY_ID | NUMBER | Yes | ||
ARC_ACT_METRIC_USED_BY | VARCHAR2 | (30) | Yes | |
METRIC_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT FUND_ID
, SHORT_NAME
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CATEGORY_ID
, CATEGORY
, FUND_TYPE
, ACTIVITY_METRIC_ID
, HIERARCHY_ID
, FROM_LEVEL
, TO_LEVEL
, START_NODE
, FROM_DATE
, TO_DATE
, FUNC_ACTUAL_VALUE
, METRIC_UOM_CODE
, ACT_METRIC_USED_BY_ID
, ARC_ACT_METRIC_USED_BY
, METRIC_ID
FROM APPS.OZF_FUND_ALLOCATIONS_V;
APPS.OZF_FUND_ALLOCATIONS_V is not referenced by any database object
|
|
|