[Home] [Help] [Dependency Information]
Object Name: | IPA_APIS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | IPA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_ID | NUMBER | (10) | Yes | |
BATCH_NAME | VARCHAR2 | (60) | ||
PROJECT_ID | NUMBER | (10) | ||
PROJECT_NUMBER | VARCHAR2 | (60) | ||
PROJECT_NAME | VARCHAR2 | (80) | ||
PROJECT_ASSET_ID | NUMBER | (10) | ||
ASSET_NUMBER | VARCHAR2 | (15) | ||
ASSET_NAME | VARCHAR2 | (80) | ||
ASSET_STATUS | VARCHAR2 | (60) | ||
GROUPING_METHOD1 | VARCHAR2 | (60) | ||
GROUPING_METHOD2 | VARCHAR2 | (60) | ||
GROUPING_METHOD3 | VARCHAR2 | (60) | ||
DATE_PLACED_IN_SERVICE | DATE | Yes | ||
RECORD_STATUS | VARCHAR2 | (10) | ||
ASSET_UNITS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_ID
, BATCH_NAME
, PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, PROJECT_ASSET_ID
, ASSET_NUMBER
, ASSET_NAME
, ASSET_STATUS
, GROUPING_METHOD1
, GROUPING_METHOD2
, GROUPING_METHOD3
, DATE_PLACED_IN_SERVICE
, RECORD_STATUS
, ASSET_UNITS
FROM IPA.IPA_APIS_INTERFACE#;
|
|
|