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

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
FROM APPS.AHL_SCHEDULE_MATERIALS_V;

Dependencies

[top of page]

APPS.AHL_SCHEDULE_MATERIALS_V references the following:

SchemaAPPS
PL/SQL PackageAHL_COMPLETIONS_PVT - show dependent code
PL/SQL PackageAHL_PP_MATERIALS_PVT - show dependent code
PL/SQL PackageAHL_PRD_SERN_CHANGE_PVT - show dependent code
PL/SQL PackageAHL_PRD_UTIL_PKG - show dependent code
SynonymAHL_SCHEDULE_MATERIALS
PL/SQL PackageAHL_UTILITY_PVT - show dependent code
PL/SQL PackageAHL_UTIL_UC_PKG - show dependent code
ViewAHL_WORKORDERS_V
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymMTL_RESERVATIONS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymWIP_REQUIREMENT_OPERATIONS

APPS.AHL_SCHEDULE_MATERIALS_V is not referenced by any database object