[Home] [Help] [Dependency Information]
Object Name: | AHL_WIP_RESOURCE_TXNS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_WIP_RESOURCE_TXNS_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 |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Identifier for resource transaction id | ||
WORKORDER_ID | NUMBER | Identifier for workorder id | ||
JOB_NUMBER | VARCHAR2 | (80) | Identifier for job number | |
WIP_ENTITY_ID | NUMBER | Identifier for wip entity id | ||
OPERATION_SEQ_NUM | NUMBER | Identifier for operation sequence number | ||
RESOURCE_SEQ_NUM | NUMBER | Identifier for resource sequence number | ||
EMPLOYEE_ID | NUMBER | Identifier for employee id | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | identifier for employee number | |
FULL_NAME | VARCHAR2 | (240) | Identifier for employee full name | |
RESOURCE_CODE | VARCHAR2 | (10) | Identifier for resource code | |
DESCRIPTION | VARCHAR2 | (240) | identifier for description | |
RESOURCE_ID | NUMBER | Identifier for resource id | ||
DEPARTMENT_ID | NUMBER | Identifier for department id | ||
DEPT_DESCRIPTION | VARCHAR2 | (240) | Identifier for department description | |
QUANTITY | NUMBER | Identifier for quantity | ||
USAGE_RATE_OR_AMOUNT | NUMBER | Identifier for usage rate or amount | ||
PRIMARY_UOM | VARCHAR2 | (3) | Identifier for primary unit of measure | |
UOM_MEANING | VARCHAR2 | (25) | Identifier for UOM Meaning | |
ACTIVITY_ID | NUMBER | Identifier for activity id | ||
ACTIVITY | VARCHAR2 | (10) | Identifier for activity name | |
REASON_ID | NUMBER | Identifier for reason id | ||
REASON_NAME | VARCHAR2 | (30) | Identifier for reason name | |
REFERENCE | VARCHAR2 | (240) | Identifier for reference | |
TRANSACTION_DATE | DATE | Identifier for transaction date | ||
VISIT_TASK_ID | NUMBER | Identifier for visit task id | ||
JOB_STATUS_CODE | VARCHAR2 | (30) | Identifier for job status code | |
JOB_STATUS_MEANING | VARCHAR2 | (80) | Identifier for job status meaning | |
TRANSACTION_STATUS | VARCHAR2 | (80) | Transaction Status |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, WORKORDER_ID
, JOB_NUMBER
, WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM
, EMPLOYEE_ID
, EMPLOYEE_NUMBER
, FULL_NAME
, RESOURCE_CODE
, DESCRIPTION
, RESOURCE_ID
, DEPARTMENT_ID
, DEPT_DESCRIPTION
, QUANTITY
, USAGE_RATE_OR_AMOUNT
, PRIMARY_UOM
, UOM_MEANING
, ACTIVITY_ID
, ACTIVITY
, REASON_ID
, REASON_NAME
, REFERENCE
, TRANSACTION_DATE
, VISIT_TASK_ID
, JOB_STATUS_CODE
, JOB_STATUS_MEANING
, TRANSACTION_STATUS
FROM APPS.AHL_WIP_RESOURCE_TXNS_V;
|
|
|