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


VIEW: APPS.AHL_WIP_RESOURCE_TXNS_V

Object Details
Object Name: AHL_WIP_RESOURCE_TXNS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_WIP_RESOURCE_TXNS_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
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
Query Text

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;

Dependencies

[top of page]

APPS.AHL_WIP_RESOURCE_TXNS_V references the following:

SchemaAPPS
SynonymAHL_WORKORDERS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
SynonymCST_ACTIVITIES
ViewFND_LOOKUP_VALUES_VL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_UNITS_OF_MEASURE
ViewPER_PEOPLE_F
SynonymWIP_COST_TXN_INTERFACE
SynonymWIP_ENTITIES
SynonymWIP_TRANSACTIONS
APPS.AHL_WIP_RESOURCE_TXNS_V is referenced by following:

SchemaAPPS
Package BodyAHL_PRD_WO_PUB - show dependent code
Package BodyAHL_VWP_PRICE_PVT - show dependent code