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

VIEW: APPS.IGSFV_MILITARY_SERVICES

Object Details
Object Name: IGSFV_MILITARY_SERVICES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSFV_MILITARY_SERVICES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This entity contains information about the person's military services.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_NUMBER VARCHAR2 (30) Yes Unique identification number of a person
_LA:MILITARY_TYPE CHAR (66)
Military service type meaning
START_DATE DATE
Yes Start date of military service
END_DATE DATE

End date of military service
_LA:SEPARATION_TYPE CHAR (68)
Separation type
_LA:ASSISTANCE_TYPE CHAR (68)
Assistance type.
_LA:ASSISTANCE_STATUS CHAR (72)
Assistance status.
_DF CHAR (35)
Descriptive flex field
MILIT_SERVICE_ID NUMBER (15) Yes Unique identifier of the military service details
PERSON_ID NUMBER (15) Yes Person identification number
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
Query Text

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


SELECT PERSON_NUMBER
,      _LA:MILITARY_TYPE
,      START_DATE
,      END_DATE
,      _LA:SEPARATION_TYPE
,      _LA:ASSISTANCE_TYPE
,      _LA:ASSISTANCE_STATUS
,      _DF
,      MILIT_SERVICE_ID
,      PERSON_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSFV_MILITARY_SERVICES;

Dependencies

[top of page]

APPS.IGSFV_MILITARY_SERVICES references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_PE_MIL_SERVICES_ALL

APPS.IGSFV_MILITARY_SERVICES is not referenced by any database object