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_JOB_OPER_MATERIALS_V

Object Details

Object Name:	AHL_JOB_OPER_MATERIALS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_JOB_OPER_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
SCHEDULED_MATERIAL_ID	NUMBER		Yes	Identifier for scheduled material id
VISIT_TASK_ID	NUMBER			Identifier for visit task id
WORKORDER_ID	NUMBER		Yes	Identifier for workorder id
INVENTORY_ITEM_ID	NUMBER			Identifier for inventory item. Foreign key to MTL_SYSTEM_ITEMS_B
CONCATENATED_SEGMENTS	VARCHAR2	(40)		Identifier for concatenated segments
REQUESTED_QUANTITY	NUMBER		Yes	Identifier for requested quantity
ITEM_GROUP_ID	NUMBER			Identifier for alternate parts
RT_OPER_MATERIAL_ID	NUMBER			Identifier for Route oper material id
UOM	VARCHAR2	(25)		Identifier for Unit of measure
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
VISIT_ID	NUMBER		Yes	Identifier for visit id
VISIT_NUMBER	NUMBER	(15)	Yes	Identifier for visit number
REQUESTED_DATE	DATE			Identifier for requested date
SCHEDULE_DATE	DATE			Identifier for schedule date
SCHEDULE_QUANTITY	NUMBER			Identifier for schedule quantity
OPERATION_SEQUENCE	NUMBER		Yes	Identifier for operation sequence
DESCRIPTION	VARCHAR2	(240)		Identifier for description
MRP_PLANNING_CODE	NUMBER			Identifier for mrp planning code
OPERATION_CODE	CHAR	(1)		Identifier for operation code
WORKORDER_OPERATION_ID	NUMBER			Identifier for operation id
ISSUED_QTY	NUMBER			Identifier for issued quantity
SALES_ORDER_LINE_ID	NUMBER		Yes	Identifier for sales order line id
WIP_ENTITY_ID	NUMBER
WORKORDER_NAME	VARCHAR2	(80)	Yes	Workorder Name
DEPARTMENT_ID	NUMBER
ORGANIZATION_ID	NUMBER
RESERVED_QUANTITY	NUMBER			Total number of Serial Numbers reserved.
STATUS	VARCHAR2	(30)		Material status.
NET_QUANTITY	NUMBER			Net Quantity ( Issued Qty - Return Qty)

Query Text

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


SELECT SCHEDULED_MATERIAL_ID
,      VISIT_TASK_ID
,      WORKORDER_ID
,      INVENTORY_ITEM_ID
,      CONCATENATED_SEGMENTS
,      REQUESTED_QUANTITY
,      ITEM_GROUP_ID
,      RT_OPER_MATERIAL_ID
,      UOM
,      OBJECT_VERSION_NUMBER
,      VISIT_ID
,      VISIT_NUMBER
,      REQUESTED_DATE
,      SCHEDULE_DATE
,      SCHEDULE_QUANTITY
,      OPERATION_SEQUENCE
,      DESCRIPTION
,      MRP_PLANNING_CODE
,      OPERATION_CODE
,      WORKORDER_OPERATION_ID
,      ISSUED_QTY
,      SALES_ORDER_LINE_ID
,      WIP_ENTITY_ID
,      WORKORDER_NAME
,      DEPARTMENT_ID
,      ORGANIZATION_ID
,      RESERVED_QUANTITY
,      STATUS
,      NET_QUANTITY
FROM APPS.AHL_JOB_OPER_MATERIALS_V;

Dependencies

[top of page]

APPS.AHL_JOB_OPER_MATERIALS_V references the following:

APPS: AHL_PP_MATERIALS_PVT - show dependent code; AHL_SCHEDULE_MATERIALS; AHL_VISITS_VL; AHL_WORKORDERS; AHL_WORKORDER_OPERATIONS_V; MTL_RESERVATIONS; MTL_SYSTEM_ITEMS_VL; WIP_REQUIREMENT_OPERATIONS

APPS.AHL_JOB_OPER_MATERIALS_V is referenced by following:

APPS: AHL_COMPLETIONS_PVT - show dependent code; AHL_PP_MATERIALS_PVT - show dependent code; AHL_PRD_WORKORDER_PVT - show dependent code