eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	AHL.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	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:

APPS: AHL_WORKORDERS; BOM_DEPARTMENTS; BOM_RESOURCES; CST_ACTIVITIES; FND_LOOKUP_VALUES_VL; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MFG_LOOKUPS; MTL_TRANSACTION_REASONS; MTL_UNITS_OF_MEASURE; PER_PEOPLE_F; WIP_COST_TXN_INTERFACE; WIP_ENTITIES; WIP_OPERATION_RESOURCES; WIP_TRANSACTIONS

APPS.AHL_WIP_RESOURCE_TXNS_V is referenced by following:

APPS: AHL_PRD_WO_PUB - show dependent code; AHL_VWP_PRICE_PVT - show dependent code