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_MATERIAL_REQUIREMENTS_V

Object Details

Object Name:	AHL_MATERIAL_REQUIREMENTS_V
Object Type:	VIEW
Owner:	APPS
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
VISIT_ID	NUMBER
VISIT_TASK_ID	NUMBER
VISIT_TASK_NUMBER	NUMBER	(15)	Yes
TASK_STATUS_CODE	VARCHAR2	(30)
VISIT_NUMBER	NUMBER	(15)	Yes
VISIT_TYPE_CODE	VARCHAR2	(30)
VISIT_TYPE_MEAN	VARCHAR2	(80)
VISIT_STATUS_CODE	VARCHAR2	(30)
VISIT_STATUS_MEAN	VARCHAR2	(80)
REQUESTED_QUANTITY	NUMBER		Yes
REQUESTED_DATE	DATE		Yes
EXCEPTION_DATE	DATE
SCHEDULED_QUANTITY	NUMBER
INVENTORY_ITEM_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(40)
TRACKABLE_FLAG	VARCHAR2	(1)
SERIAL_CONTROL_FLAG	VARCHAR2	(1)
ORGANIZATION_ID	NUMBER
ORGANIZATION_NAME	VARCHAR2	(240)
UOM	VARCHAR2	(25)
SCHEDULE_MATERIAL_ID	NUMBER		Yes
OBJECT_VERSION_NUMBER	NUMBER		Yes
REWORK_PERCENT	NUMBER
REPLACE_PERCENT	NUMBER
WORKORDER_NUMBER	VARCHAR2	(80)
RESERVED_QUANTITY	NUMBER
RT_OPER_MATERIAL_ID	NUMBER
WORKORDER_OPERATION_ID	NUMBER
ITEM_GROUP_ID	NUMBER
POSITION_PATH_ID	NUMBER
RELATIONSHIP_ID	NUMBER
SUBCONFIG_NAME	VARCHAR2	(80)
MR_TITLE	VARCHAR2	(80)
ROUTE_NUMBER	VARCHAR2	(30)
ROUTE_TITLE	VARCHAR2	(240)
OPERATION_SEQ_NUM	NUMBER
COMPLETED_QUANTITY	NUMBER
MC_HEADER_ID	NUMBER			MC Header Id
POSITION_KEY	NUMBER			Position Key of the MC position
VISIT_UNIT_HEADER_ID	NUMBER			Visit's Unit's Id
AOG_FLAG	VARCHAR2	(1)		AOG Flag

Query Text

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


SELECT VISIT_ID
,      VISIT_TASK_ID
,      VISIT_TASK_NUMBER
,      TASK_STATUS_CODE
,      VISIT_NUMBER
,      VISIT_TYPE_CODE
,      VISIT_TYPE_MEAN
,      VISIT_STATUS_CODE
,      VISIT_STATUS_MEAN
,      REQUESTED_QUANTITY
,      REQUESTED_DATE
,      EXCEPTION_DATE
,      SCHEDULED_QUANTITY
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      TRACKABLE_FLAG
,      SERIAL_CONTROL_FLAG
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      UOM
,      SCHEDULE_MATERIAL_ID
,      OBJECT_VERSION_NUMBER
,      REWORK_PERCENT
,      REPLACE_PERCENT
,      WORKORDER_NUMBER
,      RESERVED_QUANTITY
,      RT_OPER_MATERIAL_ID
,      WORKORDER_OPERATION_ID
,      ITEM_GROUP_ID
,      POSITION_PATH_ID
,      RELATIONSHIP_ID
,      SUBCONFIG_NAME
,      MR_TITLE
,      ROUTE_NUMBER
,      ROUTE_TITLE
,      OPERATION_SEQ_NUM
,      COMPLETED_QUANTITY
,      MC_HEADER_ID
,      POSITION_KEY
,      VISIT_UNIT_HEADER_ID
,      AOG_FLAG
FROM APPS.AHL_MATERIAL_REQUIREMENTS_V;