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

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:

SchemaAPPS
PL/SQL PackageAHL_PP_MATERIALS_PVT - show dependent code
SynonymAHL_SCHEDULE_MATERIALS
ViewAHL_VISITS_VL
SynonymAHL_WORKORDERS
ViewAHL_WORKORDER_OPERATIONS_V
SynonymMTL_RESERVATIONS
ViewMTL_SYSTEM_ITEMS_VL
SynonymWIP_REQUIREMENT_OPERATIONS
APPS.AHL_JOB_OPER_MATERIALS_V is referenced by following:

SchemaAPPS
Package BodyAHL_COMPLETIONS_PVT - show dependent code
Package BodyAHL_PP_MATERIALS_PVT - show dependent code
Package BodyAHL_PRD_WORKORDER_PVT - show dependent code