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

VIEW: APPS.AHL_VISITS_INFO_V

Object Details
Object Name: AHL_VISITS_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_VISITS_INFO_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
Yes Primary Key, Unique indentifier for AHL_VISITS_B and TL tables
VISIT_NUMBER NUMBER (15) Yes Unique identifier of a Visit - Auotgenerated
VISIT_NAME VARCHAR2 (80)
User defined Visit's Name
ORGANIZATION_ID NUMBER

Foreign Key to HR_ORGANIZATION_UNITS AND MTL_PARAMETERS
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name for Org Id from HR_ORGANIZATION_UNITS AND MTL_PARAMETERS
DEPARTMENT_ID NUMBER

Foreign Key to BOM_DEPARTMENTS
DEPARTMENT_NAME VARCHAR2 (240)
Departemnt Description for Dept id in bom_departments
OBJECT_VERSION_NUMBER NUMBER
Yes Stores Locking sequence number
START_DATE_TIME DATE

Storing the Start date and time of a Visit
ITEM_INSTANCE_ID NUMBER

Install Base instance identifier
SERIAL_NUMBER VARCHAR2 (30)
Storing Serial Nubmer for Install Base instance identifier
INVENTORY_ITEM_ID NUMBER

Foreign Key to MTL_SYSTEMS_ITEMS
ITEM_DESCRIPTION VARCHAR2 (40)
Storing Concatenated Segments of the Item
VISIT_TYPE_CODE VARCHAR2 (30)
Storing type of Visit Code
VISIT_TYPE_MEAN VARCHAR2 (80)
Storing meaning of Visit Code
SIMULATION_PLAN_ID NUMBER

Foreign Key to AHL_SIMULATION_PLANS_B and TL tables
SIMULATION_PLAN_NAME VARCHAR2 (80)
Storing simuaiton plan name for simulation plan id
DUE_BY DATE

Storing Due by frrm AHL_UNIT_EFFECTIVITIES_B table
PRIMARY_PLAN_FLAG VARCHAR2 (1)
Storing boolean flag primary plan
MRP_SCH_DESIGNATOR VARCHAR2 (10)
Identifier for schedule designator
PLANNED_END_DATE DATE

identifier for planned end date
UNIT_NAME VARCHAR2 (4000)
Identifier for unit name
SPACE_CATEGORY_CODE VARCHAR2 (30)
Identifier for space category code
SPACE_CATEGORY_MEAN VARCHAR2 (80)
Identifier for space category meaning
STATUS_CODE VARCHAR2 (30)
Identifier for status code
STATUS_MEAN VARCHAR2 (80)
Identifier for status mean
START_TIME_HOURS VARCHAR2 (2)
Identifier for start date time in hours
PLANNED_END_TIME_HOURS VARCHAR2 (2)
Identifier for planned end time hours
END_DATE_TIME DATE

Identifier for visit end date
MC_HEADER_ID NUMBER

MC HeaderID
Query Text

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


SELECT VISIT_ID
,      VISIT_NUMBER
,      VISIT_NAME
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      DEPARTMENT_ID
,      DEPARTMENT_NAME
,      OBJECT_VERSION_NUMBER
,      START_DATE_TIME
,      ITEM_INSTANCE_ID
,      SERIAL_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      VISIT_TYPE_CODE
,      VISIT_TYPE_MEAN
,      SIMULATION_PLAN_ID
,      SIMULATION_PLAN_NAME
,      DUE_BY
,      PRIMARY_PLAN_FLAG
,      MRP_SCH_DESIGNATOR
,      PLANNED_END_DATE
,      UNIT_NAME
,      SPACE_CATEGORY_CODE
,      SPACE_CATEGORY_MEAN
,      STATUS_CODE
,      STATUS_MEAN
,      START_TIME_HOURS
,      PLANNED_END_TIME_HOURS
,      END_DATE_TIME
,      MC_HEADER_ID
FROM APPS.AHL_VISITS_INFO_V;

Dependencies

[top of page]

APPS.AHL_VISITS_INFO_V references the following:

SchemaAPPS
SynonymAHL_MC_HEADERS_B
ViewAHL_SIMULATION_PLANS_VL
SynonymAHL_UNIT_CONFIG_HEADERS
ViewAHL_UNIT_EFFECTIVITIES_APP_V
PL/SQL PackageAHL_UTILITY_PVT - show dependent code
ViewAHL_VISITS_VL
SynonymAHL_VISIT_TASKS_B
ViewAHL_VISIT_TASKS_VL
SynonymBOM_DEPARTMENTS
SynonymCSI_ITEM_INSTANCES
ViewFND_LOOKUP_VALUES_VL
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_SYSTEM_ITEMS_KFV
APPS.AHL_VISITS_INFO_V is referenced by following:

SchemaAPPS
ViewAHL_SRH_MR_HISTORY_V