eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PER_CONTACT_RELATIONSHIPS_DFV

Object Details

Object Name:	PER_CONTACT_RELATIONSHIPS_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
SOMEBODY	VARCHAR2	(150)
DUMMY_FIELD	VARCHAR2	(150)
ENTITLED_FOR_BENIFITS	VARCHAR2	(150)
ENTILTED_FOR_LOCAL_COST	VARCHAR2	(150)
ALIMONY_AMOUNT	NUMBER
SEQ_NUM	NUMBER
FISCAL_DEPENDENT	VARCHAR2	(150)
SINGLE_PARENT	VARCHAR2	(150)
CERT_DEPENDANT	VARCHAR2	(150)
PAY_COLL	VARCHAR2	(150)
FAMILY_ALLOWANCE_FOR_CHILD	VARCHAR2	(150)
FAMILY_TAX_ALLOWANCE_FOR_CHILD	VARCHAR2	(150)
HOLIDAY_FOR_CHILD_CARE	VARCHAR2	(150)
GUARDIAN_NAME	VARCHAR2	(150)
GUARDIAN_BIRTH_DATE	DATE
GUARDIAN_ADDRESS	VARCHAR2	(150)
GUARDIAN_PHONE	VARCHAR2	(150)
SI_ITAX_FLAG	VARCHAR2	(150)
SEQUENCE	NUMBER
HOUSEHOLD_HEAD_FLAG	VARCHAR2	(150)
PRIMARY_CTR_FLAG	VARCHAR2	(150)
ITAX_DPNT_FLAG	VARCHAR2	(150)
AGE_CHECK_EXCEPTION	VARCHAR2	(150)
ADDL_TAX_EXEM_FLAG	VARCHAR2	(150)
ADDL_TAX_EXEM_FLAG_CHILD	VARCHAR2	(150)
DISABLED_TAX_EXEM_FLAG	VARCHAR2	(150)
EXCL_ADDTL_CHILD_EXEM	VARCHAR2	(150)
HI_DPNT_FLAG	VARCHAR2	(150)
END_REASON	VARCHAR2	(150)
KR_CONTACT_TYPE	VARCHAR2	(150)
SOLE_GUARDIAN	VARCHAR2	(150)
CHRONICALLY_III_OR_DISABLED	VARCHAR2	(150)
RELATIONSHIP_INFO	VARCHAR2	(150)
ADDRESS_INFO	VARCHAR2	(150)
EDUCATIONAL_FLAG	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(1540)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      SOMEBODY
,      DUMMY_FIELD
,      ENTITLED_FOR_BENIFITS
,      ENTILTED_FOR_LOCAL_COST
,      ALIMONY_AMOUNT
,      SEQ_NUM
,      FISCAL_DEPENDENT
,      SINGLE_PARENT
,      CERT_DEPENDANT
,      PAY_COLL
,      FAMILY_ALLOWANCE_FOR_CHILD
,      FAMILY_TAX_ALLOWANCE_FOR_CHILD
,      HOLIDAY_FOR_CHILD_CARE
,      GUARDIAN_NAME
,      GUARDIAN_BIRTH_DATE
,      GUARDIAN_ADDRESS
,      GUARDIAN_PHONE
,      SI_ITAX_FLAG
,      SEQUENCE
,      HOUSEHOLD_HEAD_FLAG
,      PRIMARY_CTR_FLAG
,      ITAX_DPNT_FLAG
,      AGE_CHECK_EXCEPTION
,      ADDL_TAX_EXEM_FLAG
,      ADDL_TAX_EXEM_FLAG_CHILD
,      DISABLED_TAX_EXEM_FLAG
,      EXCL_ADDTL_CHILD_EXEM
,      HI_DPNT_FLAG
,      END_REASON
,      KR_CONTACT_TYPE
,      SOLE_GUARDIAN
,      CHRONICALLY_III_OR_DISABLED
,      RELATIONSHIP_INFO
,      ADDRESS_INFO
,      EDUCATIONAL_FLAG
,      CONCATENATED_SEGMENTS
FROM APPS.PER_CONTACT_RELATIONSHIPS_DFV;

Dependencies

[top of page]

APPS.PER_CONTACT_RELATIONSHIPS_DFV references the following:

APPS: FND_NUMBER - show dependent code; PER_CONTACT_RELATIONSHIPS

APPS.PER_CONTACT_RELATIONSHIPS_DFV is not referenced by any database object