[Home] [Help]
[Dependency Information]
Object Name: | HXTFV_VARIANCES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VARIANCE_TYPE | VARCHAR2 | (10) | Yes | Variance type name |
VARIANCE_PERIOD | VARCHAR2 | (4000) | Variance period | |
HIGH_THRESHOLD | NUMBER | (12) | Yes | Variance high threshold |
AVERAGE_THRESHOLD | NUMBER | (12) | Variance average threshold | |
LOW_THRESHOLD | NUMBER | (12) | Yes | Variance low threshold |
START_DATE | DATE | Yes | Date variance becomes effective | |
END_DATE | DATE | Date variance ceases to be effective | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Name of the organization | |
BALANCE_NAME | VARCHAR2 | (80) | The name of the balance for this variance | |
BALANCE_DIMENSION | VARCHAR2 | (80) | The dimension of the balance (in hours) | |
BALANCE_LEVEL | VARCHAR2 | (60) | The level of the balance | |
LOCATION_NAME | VARCHAR2 | (60) | Location name | |
ELEMENT_NAME | VARCHAR2 | (80) | Earning code element name | |
ELEMENT_TYPE_ID | NUMBER | (9) | ||
LOCATION_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
VARIANCE_TYPE_ID | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT VARIANCE_TYPE
, VARIANCE_PERIOD
, HIGH_THRESHOLD
, AVERAGE_THRESHOLD
, LOW_THRESHOLD
, START_DATE
, END_DATE
, ORGANIZATION_NAME
, BALANCE_NAME
, BALANCE_DIMENSION
, BALANCE_LEVEL
, LOCATION_NAME
, ELEMENT_NAME
, ELEMENT_TYPE_ID
, LOCATION_ID
, ORGANIZATION_ID
, VARIANCE_TYPE_ID
FROM APPS.HXTFV_VARIANCES;
|
|
|