DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AHL_VISIT_TASK_MATRL_V

Object Details
Object Name: AHL_VISIT_TASK_MATRL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_VISIT_TASK_MATRL_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
VISIT_ID NUMBER

Primary key, Unique identifier for visit id
VISIT_TASK_ID NUMBER

Unique identifier for visit task id
VISIT_TASK_NAME VARCHAR2 (80) Yes Unique identifier for user deined visit task name
TASK_STATUS_CODE VARCHAR2 (30)
REQUESTED_QUANTITY NUMBER
Yes Identifier for requested quantity, defined in AHL_RT_OPER_MATERIALS
REQUESTED_DATE DATE
Yes Identifier for requested date, derieved based on visit task start date
SCHEDULED_DATE DATE

Identifier for scheduled date
SCHEDULED_QUANTITY NUMBER

Identifier for scheduled quantity
INVENTORY_ITEM_ID NUMBER

Identifier for inventory item id, Foreign key to MTL_SYSTEM_ITEMS_B
ITEM_NUMBER VARCHAR2 (40)
Identifier for Concatenated segments value from MTL_SYSTEM_ITEMS_KFV
ITEM_DESCRIPTION VARCHAR2 (240)
Identifier for item description value from MTL_SYSTEM_ITEMS_TL
UOM VARCHAR2 (25)
Identifier for UOM Code
RT_OPER_MATERIAL_ID NUMBER

Identifier for Route Operation material id, Foreign key to AHL_RT_OPER_MATERIALS
ITEM_GROUP_ID NUMBER

Identifier for Item group id, Foreign key to AHL_ITEM_ASSOCIATIONS_B
OPERATION_CODE VARCHAR2 (80)
Identifier for Operation code
OPERATION_SEQUENCE NUMBER

Identifier for Operation sequence, Derieved from AHL_ROUTE_OPERATIONS
SCHEDULE_MATERIAL_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER
Yes Identifier for object version number
POSITION_PATH_ID NUMBER

Identifier for mc path position id
POSITION_PATH VARCHAR2 (4000)
Identifier for mc path position
RELATIONSHIP_ID NUMBER

Identifier for mc relationship id
NAME VARCHAR2 (80)
Identifier for MC Subconfiguration
REWORK_PERCENT NUMBER

Identifier for item rework percent
REPLACE_PERCENT NUMBER

Identifier for item replace percent
ITEM_COMP_DETAIL_ID NUMBER

Identifier for item composition
SALES_ORDER_LINE_ID VARCHAR2 (163)
Identifier for sales order line id
MAT_STATUS VARCHAR2 (30)
Status of the Material
Query Text

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


SELECT VISIT_ID
,      VISIT_TASK_ID
,      VISIT_TASK_NAME
,      TASK_STATUS_CODE
,      REQUESTED_QUANTITY
,      REQUESTED_DATE
,      SCHEDULED_DATE
,      SCHEDULED_QUANTITY
,      INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      UOM
,      RT_OPER_MATERIAL_ID
,      ITEM_GROUP_ID
,      OPERATION_CODE
,      OPERATION_SEQUENCE
,      SCHEDULE_MATERIAL_ID
,      OBJECT_VERSION_NUMBER
,      POSITION_PATH_ID
,      POSITION_PATH
,      RELATIONSHIP_ID
,      NAME
,      REWORK_PERCENT
,      REPLACE_PERCENT
,      ITEM_COMP_DETAIL_ID
,      SALES_ORDER_LINE_ID
,      MAT_STATUS
FROM APPS.AHL_VISIT_TASK_MATRL_V;

Dependencies

[top of page]

APPS.AHL_VISIT_TASK_MATRL_V references the following:

SchemaAPPS
ViewAHL_MC_HEADERS_VL
PL/SQL PackageAHL_MC_PATH_POSITION_PVT - show dependent code
SynonymAHL_MC_RELATIONSHIPS
SynonymAHL_RT_OPER_MATERIALS
SynonymAHL_SCHEDULE_MATERIALS
ViewAHL_VISIT_TASKS_V
ViewAHL_VISIT_TASKS_VL
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_SYSTEM_ITEMS_TL
APPS.AHL_VISIT_TASK_MATRL_V is referenced by following:

SchemaAPPS
Package BodyAHL_LTP_MATRL_AVAL_PVT - show dependent code
Package BodyAHL_LTP_REQST_MATRL_PVT - show dependent code
Package BodyAHL_VWP_VISITS_PVT - show dependent code