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

VIEW: APPS.IGSBV_INTERNATIONAL_DEPENDENTS

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

View Type

A Business Intelligence System view


This entity contains information about the international dependents.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SUBJECT_PERSON_NUMBER VARCHAR2 (30) Yes Unique identifier for a person.
DEPENDENT_PERSON_NUMBER VARCHAR2 (30) Yes Unique identifier for the dependent.
_LA:RELATIONSHIP_CODE CHAR (65)
Relationship code.
DIRECTIONAL_FLAG VARCHAR2 (1) Yes Indicates if this is a directional relationship, such as parent-to-child or headquarters-to-branch. F for a forward relationship and B for a backward relationship.
RELATIONSHIP_ID NUMBER (15) Yes Unique identifier for the relationship
SUBJECT_ID NUMBER (15) Yes Unique identifier for the person.
OBJECT_ID NUMBER (15) Yes Unique identifier for the dependent.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) 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 SUBJECT_PERSON_NUMBER
,      DEPENDENT_PERSON_NUMBER
,      _LA:RELATIONSHIP_CODE
,      DIRECTIONAL_FLAG
,      RELATIONSHIP_ID
,      SUBJECT_ID
,      OBJECT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_INTERNATIONAL_DEPENDENTS;

Dependencies

[top of page]

APPS.IGSBV_INTERNATIONAL_DEPENDENTS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS

APPS.IGSBV_INTERNATIONAL_DEPENDENTS is not referenced by any database object