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_SCHEDULE_MATERIALS_V

Object Details

Object Name:	AHL_SCHEDULE_MATERIALS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_SCHEDULE_MATERIALS_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
WORKORDER_ID	NUMBER		Yes	Identifier for Workorder id
VISIT_TASK_ID	NUMBER			Identifier for visit task ID, Foreign key to AHL_VISIT_TASKS_B table.
WO_NAME	VARCHAR2	(80)	Yes	Identifier for job description
SCHEDULE_MATERIAL_ID	NUMBER		Yes	Identifier for scheduled material id.
INVENTORY_ITEM_ID	NUMBER			Identifier for inventory id. Foreign key to MTL_SYSTEM_ITEMS_B
CONCATENATED_SEGMENTS	VARCHAR2	(40)		Identifier for concatenated segments
UOM_CODE	VARCHAR2	(3)		Identifier for primary uom code
UOM	VARCHAR2	(25)		Identifier for Unit of measure
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
ITEM_GROUP_ID	NUMBER			Identifier for alternate parts
RT_OPER_MATERIAL_ID	NUMBER			Identifier for Route oper material id
VISIT_ID	NUMBER			Identifier for visit id. Foreign key to AHL_VISITS_B
REQUESTED_DATE	DATE			Identifier for requested date
REQUESTED_QUANTITY	NUMBER		Yes	Identifier for requested quantity
SCHEDULE_DATE	DATE			Identifier for schedule date
SCHEDULE_QUANTITY	NUMBER			Identifier for schedule quantity
WORKORDER_OPERATION_ID	NUMBER			Identifier for workorder operation
OPERATION_SEQUENCE	NUMBER			Identifier for operation sequence
PRIORITY	NUMBER			Identifier for priority
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Identifier for organization name
DEPARTMENT_NAME	VARCHAR2	(240)		Identifier for department name
SERVICE_REQUEST	VARCHAR2	(64)		Identifier for service request
VISIT_NUMBER	NUMBER	(15)	Yes	Identifier for visit number
ISSUED_QUANTITY	NUMBER			Identifier for issued quantity
JOB_STATUS_CODE	VARCHAR2	(30)	Yes	Identifier for job status code
JOB_STATUS_MEANING	VARCHAR2	(80)		Identifier for job status meaning
SALES_ORDER_LINE_ID	NUMBER		Yes	Identifier for sales order line id
UNIT_LOCKED_FLAG	VARCHAR2	(4000)		Indicates if the Unit is quarantined.
RESERVED_QUANTITY	NUMBER			Total number of Serial Numbers reserved.
IN_SERVICE	VARCHAR2	(1)		Flag to indicate whether the item is repair item or not.
NET_QUANTITY	NUMBER			Net Quantity (Issued Qty - Return Qty)
MC_HEADER_ID	NUMBER			MC Header ID
MC_NAME	VARCHAR2	(80)		MC Name
POSITION_KEY	NUMBER			Position Key
POSITION	VARCHAR2	(80)		Position
ITEM_GROUP_NAME	VARCHAR2	(80)		Item Group Name
AOG_FLAG	VARCHAR2	(1)		AOG Flag

Query Text

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


SELECT WORKORDER_ID
,      VISIT_TASK_ID
,      WO_NAME
,      SCHEDULE_MATERIAL_ID
,      INVENTORY_ITEM_ID
,      CONCATENATED_SEGMENTS
,      UOM_CODE
,      UOM
,      OBJECT_VERSION_NUMBER
,      ITEM_GROUP_ID
,      RT_OPER_MATERIAL_ID
,      VISIT_ID
,      REQUESTED_DATE
,      REQUESTED_QUANTITY
,      SCHEDULE_DATE
,      SCHEDULE_QUANTITY
,      WORKORDER_OPERATION_ID
,      OPERATION_SEQUENCE
,      PRIORITY
,      ORGANIZATION_NAME
,      DEPARTMENT_NAME
,      SERVICE_REQUEST
,      VISIT_NUMBER
,      ISSUED_QUANTITY
,      JOB_STATUS_CODE
,      JOB_STATUS_MEANING
,      SALES_ORDER_LINE_ID
,      UNIT_LOCKED_FLAG
,      RESERVED_QUANTITY
,      IN_SERVICE
,      NET_QUANTITY
,      MC_HEADER_ID
,      MC_NAME
,      POSITION_KEY
,      POSITION
,      ITEM_GROUP_NAME
,      AOG_FLAG
FROM APPS.AHL_SCHEDULE_MATERIALS_V;

Dependencies

[top of page]

APPS.AHL_SCHEDULE_MATERIALS_V references the following:

APPS: AHL_COMPLETIONS_PVT - show dependent code; AHL_ITEM_GROUPS_B; AHL_MC_HEADERS_B; AHL_MC_RELATIONSHIPS; AHL_PP_MATERIALS_PVT - show dependent code; AHL_PRD_PRINT_PVT - show dependent code; AHL_PRD_SERN_CHANGE_PVT - show dependent code; AHL_PRD_UTIL_PKG - show dependent code; AHL_SCHEDULE_MATERIALS; AHL_UTILITY_PVT - show dependent code; AHL_UTIL_UC_PKG - show dependent code; AHL_WARRANTY_ENTL_PVT - show dependent code; AHL_WORKORDERS_V; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MO_GLOBAL - show dependent code; MTL_RESERVATIONS; MTL_SYSTEM_ITEMS_KFV; WIP_REQUIREMENT_OPERATIONS

APPS.AHL_SCHEDULE_MATERIALS_V is referenced by following:

APPS: AHL_PP_MATERIALS_PVT - show dependent code