[Home] [Help] [Dependency Information]
Object Name: | AHL_PRD_VISITS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VISIT_ID | NUMBER | Yes | Primary Key, Unique indentifier for AHL_VISITS_B and TL tables | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Stores locking sequence number | |
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 | |
START_DATE_TIME | DATE | Stores Visit Start date and time | ||
CLOSE_DATE_TIME | DATE | Stores Visit End date and time | ||
SCHEDULED_START_DATE | DATE | Yes | Stores Workorder scheduled start date and time | |
SCHEDULED_END_DATE | DATE | Yes | Stores Workorder scheduled end date and time | |
ACTUAL_START_DATE | DATE | Stores Workorder actual start date and time | ||
ACTUAL_END_DATE | DATE | Stores Workorder actual end date and time | ||
STATUS_CODE | VARCHAR2 | (30) | Storing visit status code from FND_LOOKUPS | |
STATUS | VARCHAR2 | (80) | status meaning | |
ITEM_INSTANCE_ID | NUMBER | Install Base instance identifier | ||
SERIAL_NUMBER | VARCHAR2 | (30) | Storing Serial Number for Install Base instance identifier | |
INVENTORY_ITEM_ID | NUMBER | Foreign Key to MTL_SYSTEMS_ITEMS | ||
ITEM_ORGANIZATION_ID | NUMBER | Stores organization for Item to MTL_SYSTEMS_ITEMS | ||
ITEM_DESCRIPTION | VARCHAR2 | (40) | Storing Concatenated Segments of the Item | |
VISIT_TYPE_CODE | VARCHAR2 | (30) | Stores Code from FND_LOOKUPS for Visit Type | |
VISIT_TYPE | VARCHAR2 | (80) | Stores Meaning from FND_LOOKUPS for Visit Type | |
UNIT_NAME | VARCHAR2 | (4000) | Unit Name derived from the unit id | |
UNIT_LOCKED_FLAG | VARCHAR2 | (4000) | Indicates if the Unit is quarantined. | |
INV_LOCATOR_ID | NUMBER | Identifier for Visit Locator. | ||
SUBINVENTORY | VARCHAR2 | (10) | Visit Subinventory | |
LOCATOR_SEGMENTS | VARCHAR2 | (4000) | Visit Locator concatenated segments. | |
FILE_LOCATION | VARCHAR2 | (4000) | Job card relative path and file name. | |
JOB_CARD_EXISTS | VARCHAR2 | (4000) | Indicator if generated work card exists. | |
LATEST_JC_STATUS | VARCHAR2 | (4000) | Status of the most recent (in progress) work card request. | |
JOB_CARD_ERROR_MSG | VARCHAR2 | (4000) | Error message when work card generation fails. |
Cut, paste (and edit) the following text to query this object:
SELECT VISIT_ID
, OBJECT_VERSION_NUMBER
, VISIT_NUMBER
, VISIT_NAME
, ORGANIZATION_ID
, ORGANIZATION_NAME
, DEPARTMENT_ID
, DEPARTMENT_NAME
, START_DATE_TIME
, CLOSE_DATE_TIME
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, STATUS_CODE
, STATUS
, ITEM_INSTANCE_ID
, SERIAL_NUMBER
, INVENTORY_ITEM_ID
, ITEM_ORGANIZATION_ID
, ITEM_DESCRIPTION
, VISIT_TYPE_CODE
, VISIT_TYPE
, UNIT_NAME
, UNIT_LOCKED_FLAG
, INV_LOCATOR_ID
, SUBINVENTORY
, LOCATOR_SEGMENTS
, FILE_LOCATION
, JOB_CARD_EXISTS
, LATEST_JC_STATUS
, JOB_CARD_ERROR_MSG
FROM APPS.AHL_PRD_VISITS_V;
|
|
|