[Home] [Help] [Dependency Information]
Object Name: | IGS_PS_UNIT_FACILITY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_PS_UNIT_FACILITY_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View created to contain the media information that includes the media identification, media code and unit version information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier | |
UNIT_MEDIA_ID | NUMBER | (10) | Yes | Unique identifier for the facility (media) in a unit location |
UNIT_CODE | VARCHAR2 | (10) | Yes | Code of the unit that is offered |
UNIT_VERSION_NUMBER | NUMBER | (3) | Yes | Version number of the unit that is offered |
MEDIA_CODE | VARCHAR2 | (10) | Yes | The code of the media equipment that is needed |
MEDIA_DESCRIPTION | VARCHAR2 | (60) | Yes | Describes the equipment information |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, UNIT_MEDIA_ID
, UNIT_CODE
, UNIT_VERSION_NUMBER
, MEDIA_CODE
, MEDIA_DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_UNIT_FACILITY_V;
|
|
|