DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.AHL_RT_OPER_RESOURCES_V

Object Details
Object Name: AHL_RT_OPER_RESOURCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_RT_OPER_RESOURCES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
RT_OPER_RESOURCE_ID NUMBER
Yes Primary Key, unique identifier for a record in this table
OBJECT_VERSION_NUMBER NUMBER
Yes Stores locking sequence number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
ASSOCIATION_TYPE_CODE VARCHAR2 (30) Yes Attribute which indicates the association type of Material or tool requirement, Whether it is associated with a route or an operation
OBJECT_ID NUMBER
Yes Identifier for an operation or a route
ASO_RESOURCE_ID NUMBER

Stores the ASO resource id
ASO_RESOURCE_NAME VARCHAR2 (30) Yes ASO resource name
ASO_RESOURCE_DESC VARCHAR2 (240) Yes The Description of ASO Resource
RESOURCE_TYPE_ID NUMBER

To indicate whether it is an ASO resource or BOM resource
RESOURCE_TYPE VARCHAR2 (80) Yes Indicates the resource type
COST_BASIS_ID NUMBER

Attribute to define cost basis id for costing reasons in WIP
COST_BASIS VARCHAR2 (80)
Attribute to define cost basis id for costing reasons in WIP
SCHEDULED_TYPE_ID NUMBER

Attribute to define scheduled type id for costing reasons in WIP
SCHEDULED_TYPE VARCHAR2 (80)
Attribute to define scheduled type id for costing reasons in WIP
ACTIVITY_ID NUMBER

Attribute to define activity id for costing reasons in WIP
ACTIVITY VARCHAR2 (10)
Attribute to define activity id for costing reasons in WIP
AUTOCHARGE_TYPE_ID NUMBER

Attribute to define autocharge type id for costing reasons in WIP
AUTOCHARGE_TYPE VARCHAR2 (80)
Attribute to define autocharge type id for costing reasons in WIP
STANDARD_RATE_FLAG NUMBER

Attribute to define standard rate flag for costing reasons in WIP
STANDARD_RATE VARCHAR2 (80)
Attribute to define standard rate flag for costing reasons in WIP
QUANTITY NUMBER
Yes Stores the quantity of resources required
DURATION NUMBER
Yes Stores the duration for which the headcount is required
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column
SCHEDULE_SEQ NUMBER

Resource schedule for a route or operation.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RT_OPER_RESOURCE_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ASSOCIATION_TYPE_CODE
,      OBJECT_ID
,      ASO_RESOURCE_ID
,      ASO_RESOURCE_NAME
,      ASO_RESOURCE_DESC
,      RESOURCE_TYPE_ID
,      RESOURCE_TYPE
,      COST_BASIS_ID
,      COST_BASIS
,      SCHEDULED_TYPE_ID
,      SCHEDULED_TYPE
,      ACTIVITY_ID
,      ACTIVITY
,      AUTOCHARGE_TYPE_ID
,      AUTOCHARGE_TYPE
,      STANDARD_RATE_FLAG
,      STANDARD_RATE
,      QUANTITY
,      DURATION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SCHEDULE_SEQ
FROM APPS.AHL_RT_OPER_RESOURCES_V;

Dependencies

[top of page]

APPS.AHL_RT_OPER_RESOURCES_V references the following:

SchemaAPPS
ViewAHL_RESOURCES_V
SynonymAHL_RT_OPER_RESOURCES
SynonymCST_ACTIVITIES
ViewMFG_LOOKUPS
APPS.AHL_RT_OPER_RESOURCES_V is referenced by following:

SchemaAPPS
Package BodyAHL_RM_RT_OPER_RESOURCE_PVT - show dependent code