[Home] [Help] [Dependency Information]
Object Name: | EAM_CFR_RESOURCES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EAM.EAM_CFR_RESOURCES_V |
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 |
---|---|---|---|---|
WIP_ENTITY_ID | NUMBER | Yes | Work Order Identifier | |
OPERATION_SEQ_NUM | NUMBER | Yes | Operation sequence number within a routing | |
RESOURCE_SEQ_NUM | NUMBER | Yes | Resource sequence number | |
RESOURCE_CODE | VARCHAR2 | (10) | Yes | Resource code |
DESCRIPTION | VARCHAR2 | (240) | Resource Description | |
PURCHASE_ITEM_ID | NUMBER | Purchase item identifier | ||
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
REPETITIVE_SCHEDULE_ID | NUMBER | WIP repetitive schedule Identifier | ||
RESOURCE_ID | NUMBER | Yes | Resource Identifier | |
UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
BASIS_TYPE | NUMBER | Yes | Basis for scheduling and charging resource | |
BASIS_TYPE_DISP | VARCHAR2 | (80) | Basis Type-Meaning from Lookup | |
USAGE_RATE_OR_AMOUNT | NUMBER | Rate per assembly or amount per job/schedule | ||
ACTIVITY_ID | NUMBER | Activity Identifier | ||
SCHEDULED_FLAG | NUMBER | Yes | Method of scheduling the resource | |
SCHEDULED_FLAG_DISP | VARCHAR2 | (80) | Yes | Scheduled Flag-Meaning from Lookup |
ASSIGNED_UNITS | NUMBER | Number of resources assigned to do work | ||
AUTOCHARGE_TYPE | NUMBER | Yes | Method of charging the resource | |
AUTOCHARGE_TYPE_DISP | VARCHAR2 | (80) | Yes | Autocharge Type-Meaning from Lookup |
STANDARD_RATE_FLAG | NUMBER | Yes | Indicates whether the resource is charged at the standard rate | |
STANDARD_RATE_FLAG_DISP | VARCHAR2 | (80) | Yes | Standard Rate Flag-Meaning from Lookup |
APPLIED_RESOURCE_UNITS | NUMBER | Amount of resource units charged | ||
APPLIED_RESOURCE_VALUE | NUMBER | Yes | Value of resource units charged | |
START_DATE | DATE | Yes | Scheduled start date of the resource | |
COMPLETION_DATE | DATE | Yes | Scheduled completion date of the resource | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Standard DFF Column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard DFF Column | |
DEPARTMENT_ID | NUMBER | Department of this resource, if different from that of parent operation | ||
PHANTOM_FLAG | NUMBER | Indicates whether or not this is a phantom routing resource (1 for yes, 2 for no) | ||
DEPARTMENT_CODE | VARCHAR2 | (10) | Department Code | |
PHANTOM_OP_SEQ_NUM | NUMBER | Operation sequence number, if part of a phantom routing | ||
PHANTOM_ITEM_ID | NUMBER | Item, if part of a phantom routing | ||
RESOURCE_TYPE | NUMBER | Resource type | ||
RESOURCE_TYPE_DISP | VARCHAR2 | (80) | Resource Type- Meaning from Lookup | |
SCHEDULE_SEQ_NUM | NUMBER | Schedule sequence number | ||
SUBSTITUTE_GROUP_NUM | NUMBER | Substitution group number | ||
REPLACEMENT_GROUP_NUM | NUMBER | Replacement group number | ||
PRINCIPLE_FLAG | NUMBER | Principle flag, for aps | ||
SETUP_ID | NUMBER | Setup Identifier | ||
PARENT_RESOURCE_SEQ | NUMBER | Parent Resource Sequence | ||
BATCH_ID | NUMBER | Batch Id used in grouping operation resources across jobs | ||
FIRM_FLAG | NUMBER | NOT FIRM - 0, FIRM_START - 1,FIRM_END - 2, FIRM_RESOURCE -3 ,FIRM_START_END- 4, FIRM_START_RESOURCE - 5, FIRM_END_RESOURCE - 6, FIRM_ALL-7 | ||
GROUP_SEQUENCE_ID | NUMBER | Identifies the firmed fixed sequence for resource req | ||
GROUP_SEQUENCE_NUMBER | NUMBER | Sequence in firmed sequence for resource requirement | ||
MAXIMUM_ASSIGNED_UNITS | NUMBER | Maximum allowed assigned_units, inserted during job creation |
Cut, paste (and edit) the following text to query this object:
SELECT WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM
, RESOURCE_CODE
, DESCRIPTION
, PURCHASE_ITEM_ID
, ORGANIZATION_ID
, REPETITIVE_SCHEDULE_ID
, RESOURCE_ID
, UOM_CODE
, BASIS_TYPE
, BASIS_TYPE_DISP
, USAGE_RATE_OR_AMOUNT
, ACTIVITY_ID
, SCHEDULED_FLAG
, SCHEDULED_FLAG_DISP
, ASSIGNED_UNITS
, AUTOCHARGE_TYPE
, AUTOCHARGE_TYPE_DISP
, STANDARD_RATE_FLAG
, STANDARD_RATE_FLAG_DISP
, APPLIED_RESOURCE_UNITS
, APPLIED_RESOURCE_VALUE
, START_DATE
, COMPLETION_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DEPARTMENT_ID
, PHANTOM_FLAG
, DEPARTMENT_CODE
, PHANTOM_OP_SEQ_NUM
, PHANTOM_ITEM_ID
, RESOURCE_TYPE
, RESOURCE_TYPE_DISP
, SCHEDULE_SEQ_NUM
, SUBSTITUTE_GROUP_NUM
, REPLACEMENT_GROUP_NUM
, PRINCIPLE_FLAG
, SETUP_ID
, PARENT_RESOURCE_SEQ
, BATCH_ID
, FIRM_FLAG
, GROUP_SEQUENCE_ID
, GROUP_SEQUENCE_NUMBER
, MAXIMUM_ASSIGNED_UNITS
FROM APPS.EAM_CFR_RESOURCES_V;
APPS.EAM_CFR_RESOURCES_V is not referenced by any database object
|
|
|