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_EXTRA_INFO_F_DFV

Object Details

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

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
TYPE	VARCHAR2	(30)
BENEFIT_TYPE	VARCHAR2	(150)
PERCENT_SHARE	NUMBER
NOMINATION_END_REASON	VARCHAR2	(150)
DATE_QUALIFIED	DATE
QUALIFIED_REASON	VARCHAR2	(150)
OCCUPATION	VARCHAR2	(150)
INCOME	VARCHAR2	(150)
LIVING_WITH	VARCHAR2	(150)
DATE_DISQUALIFIED	DATE
DISQUALIFIED_REASON	VARCHAR2	(150)
BASIC_PENSION_NUMBER	VARCHAR2	(150)
OTHER_PENSION_NUMBER	VARCHAR2	(150)
OTHER_QUALIFIED_REASON	VARCHAR2	(150)
NP3_DATE_QUALIFIED	DATE
NP3_QUALIFIED_REASON	VARCHAR2	(150)
OTHER_NP3_QUALIFIED_REASON	VARCHAR2	(150)
NATIONALITY	VARCHAR2	(150)
OTHER_DISQUALIFIED_REASON	VARCHAR2	(150)
NP3_DATE_DISQUALIFIED	DATE
NP3_DISQUALIFIED_REASON	VARCHAR2	(150)
OTHER_NP3_DISQUALIFIED_REASON	VARCHAR2	(150)
NP3_DISQUALIFIED_NOTIFICATION	VARCHAR2	(150)
NP3_NOTIFICATION_DATE	DATE
NP3_NOTIFIED_BY	VARCHAR2	(150)
NP3_NOTIFIER_PHONE	VARCHAR2	(150)
NP3_RECEIVED_DATE	DATE
DEP_TYPE	VARCHAR2	(150)
AGED_PARENT_LIVING_WITH	VARCHAR2	(150)
ESTIMATED_ANNUAL_INCOME	VARCHAR2	(150)
DATE_CHANGED	DATE
CHANGE_REASON	VARCHAR2	(150)
DISABLED_STATUS	VARCHAR2	(150)
DISABILITY_DETAILS	VARCHAR2	(150)
CONTACT_RELATIONSHIP_ID	VARCHAR2	(150)
EMPLOYER_NAME	VARCHAR2	(150)
EMPLOYER_ADDRESS	VARCHAR2	(150)
KR_DPNT_INS_PREM_NTS	NUMBER
KR_DPNT_INS_PREM_OTH	NUMBER
KR_DPNT_DIS_INS_NTS	NUMBER
KR_DPNT_DIS_INS_OTH	NUMBER
KR_DPNT_MED_EXP_NTS	NUMBER
KR_DPNT_MED_EXP_OTH	NUMBER
KR_DPNT_EDUC_EXP_NTS	NUMBER
KR_DPNT_EDUC_EXP_OTH	NUMBER
KR_DPNT_CARD_EXP_NTS	NUMBER
KR_DPNT_CARD_EXP_OTH	NUMBER
KR_DPNT_CASH_EXP_NTS	NUMBER
KR_DPNT_DIRECT_PAYMENT_NTS	NUMBER
KR_DPNT_DIRECT_PAYMENT_OTH	NUMBER
KR_DPNT_DON_EXP_NTS	NUMBER
KR_DPNT_DON_EXP_OTH	NUMBER
KR_DPNT_MED_CARDS	NUMBER
KR_DPNT_NEW_BORN_ADOPTED	VARCHAR2	(150)
KR_DPNT_TM_CARD_EXP_NTS	NUMBER
KR_DPNT_TM_CARD_EXP_OTH	NUMBER
KR_DPNT_TM_CASH_EXP_NTS	NUMBER
KR_DPNT_TM_DIRECT_EXP_NTS	NUMBER
KR_DPNT_TM_DIRECT_EXP_OTH	NUMBER
KR_DPNT_TUTION_GIRO_EXP_NTS	NUMBER
KR_DPNT_TUTION_GIRO_EXP_OTH	NUMBER
START_DATE	DATE
END_DATE	DATE
CONCATENATED_SEGMENTS	VARCHAR2	(3654)

Query Text

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


SELECT ROW_ID
,      TYPE
,      BENEFIT_TYPE
,      PERCENT_SHARE
,      NOMINATION_END_REASON
,      DATE_QUALIFIED
,      QUALIFIED_REASON
,      OCCUPATION
,      INCOME
,      LIVING_WITH
,      DATE_DISQUALIFIED
,      DISQUALIFIED_REASON
,      BASIC_PENSION_NUMBER
,      OTHER_PENSION_NUMBER
,      OTHER_QUALIFIED_REASON
,      NP3_DATE_QUALIFIED
,      NP3_QUALIFIED_REASON
,      OTHER_NP3_QUALIFIED_REASON
,      NATIONALITY
,      OTHER_DISQUALIFIED_REASON
,      NP3_DATE_DISQUALIFIED
,      NP3_DISQUALIFIED_REASON
,      OTHER_NP3_DISQUALIFIED_REASON
,      NP3_DISQUALIFIED_NOTIFICATION
,      NP3_NOTIFICATION_DATE
,      NP3_NOTIFIED_BY
,      NP3_NOTIFIER_PHONE
,      NP3_RECEIVED_DATE
,      DEP_TYPE
,      AGED_PARENT_LIVING_WITH
,      ESTIMATED_ANNUAL_INCOME
,      DATE_CHANGED
,      CHANGE_REASON
,      DISABLED_STATUS
,      DISABILITY_DETAILS
,      CONTACT_RELATIONSHIP_ID
,      EMPLOYER_NAME
,      EMPLOYER_ADDRESS
,      KR_DPNT_INS_PREM_NTS
,      KR_DPNT_INS_PREM_OTH
,      KR_DPNT_DIS_INS_NTS
,      KR_DPNT_DIS_INS_OTH
,      KR_DPNT_MED_EXP_NTS
,      KR_DPNT_MED_EXP_OTH
,      KR_DPNT_EDUC_EXP_NTS
,      KR_DPNT_EDUC_EXP_OTH
,      KR_DPNT_CARD_EXP_NTS
,      KR_DPNT_CARD_EXP_OTH
,      KR_DPNT_CASH_EXP_NTS
,      KR_DPNT_DIRECT_PAYMENT_NTS
,      KR_DPNT_DIRECT_PAYMENT_OTH
,      KR_DPNT_DON_EXP_NTS
,      KR_DPNT_DON_EXP_OTH
,      KR_DPNT_MED_CARDS
,      KR_DPNT_NEW_BORN_ADOPTED
,      KR_DPNT_TM_CARD_EXP_NTS
,      KR_DPNT_TM_CARD_EXP_OTH
,      KR_DPNT_TM_CASH_EXP_NTS
,      KR_DPNT_TM_DIRECT_EXP_NTS
,      KR_DPNT_TM_DIRECT_EXP_OTH
,      KR_DPNT_TUTION_GIRO_EXP_NTS
,      KR_DPNT_TUTION_GIRO_EXP_OTH
,      START_DATE
,      END_DATE
,      CONCATENATED_SEGMENTS
FROM APPS.PER_CONTACT_EXTRA_INFO_F_DFV;

Dependencies

[top of page]

APPS.PER_CONTACT_EXTRA_INFO_F_DFV references the following:

APPS: FND_NUMBER - show dependent code; PER_CONTACT_EXTRA_INFO_F

APPS.PER_CONTACT_EXTRA_INFO_F_DFV is not referenced by any database object