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_MM_WRK_ORDER_RESERVTN_V

Object Details

Object Name:	AHL_MM_WRK_ORDER_RESERVTN_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_MM_WRK_ORDER_RESERVTN_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
WORK_ORDER_ID	NUMBER		Yes
WIP_ENTITY_ID	NUMBER
JOB_NUMBER	VARCHAR2	(80)	Yes
WORK_ORDER_STATUS_CODE	VARCHAR2	(30)	Yes
STATUS_MEANING	VARCHAR2	(80)
INVENTORY_ITEM_ID	NUMBER		Yes
ITEM_INSTANCE_ID	NUMBER		Yes
INSTANCE_NUMBER	VARCHAR2	(30)	Yes
ITEM	VARCHAR2	(40)
ITEM_OWNER	VARCHAR2	(360)	Yes
SERIAL_NUMBER	VARCHAR2	(30)
LOT_NUMBER	VARCHAR2	(80)
NON_ROUTINE_ID	NUMBER	(15)
NON_ROUTINE_NUMBER	VARCHAR2	(64)
UNIT_EFFECTIVITY_ID	NUMBER
ORG_NAME	VARCHAR2	(240)	Yes
ORG_ID	NUMBER
RESERVING_WORK_ORDER_NUM	VARCHAR2	(80)
RESERVATION_ID	NUMBER
WORK_ORDER_START_DATE	DATE
AVAILABLE_DATE	DATE		Yes
REPAIR_BATCH_NAME	VARCHAR2	(4000)

Query Text

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


SELECT WORK_ORDER_ID
,      WIP_ENTITY_ID
,      JOB_NUMBER
,      WORK_ORDER_STATUS_CODE
,      STATUS_MEANING
,      INVENTORY_ITEM_ID
,      ITEM_INSTANCE_ID
,      INSTANCE_NUMBER
,      ITEM
,      ITEM_OWNER
,      SERIAL_NUMBER
,      LOT_NUMBER
,      NON_ROUTINE_ID
,      NON_ROUTINE_NUMBER
,      UNIT_EFFECTIVITY_ID
,      ORG_NAME
,      ORG_ID
,      RESERVING_WORK_ORDER_NUM
,      RESERVATION_ID
,      WORK_ORDER_START_DATE
,      AVAILABLE_DATE
,      REPAIR_BATCH_NAME
FROM APPS.AHL_MM_WRK_ORDER_RESERVTN_V;

Dependencies

[top of page]

APPS.AHL_MM_WRK_ORDER_RESERVTN_V references the following:

APPS: AHL_CMP_UTIL_PKG - show dependent code; AHL_UNIT_EFFECTIVITIES_B; AHL_VISITS_VL; AHL_VISIT_TASKS_VL; AHL_WORKORDERS; CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_B; FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; HZ_PARTIES; MTL_RESERVATIONS; MTL_SYSTEM_ITEMS_KFV; WIP_DISCRETE_JOBS

APPS.AHL_MM_WRK_ORDER_RESERVTN_V is not referenced by any database object