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.

[Home] [Help]

View: AMS_IBA_OP_CUSTOMER_V

Product:	AMS - Marketing
Description:	It provides a list of all eligible customers in Oracle Applications and their personal information
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT TO_CHAR(PARTY.PARTY_ID)
, PARTY.PARTY_NAME
, PARTY.CREATION_DATE
, PERSONAL.GENDER
, TRUNC(MONTHS_BETWEEN(SYSDATE
, PERSONAL.DATE_OF_BIRTH)/12)
, PERSONAL.MARITAL_STATUS
, PERSONAL.PERSONAL_INCOME
, PERSONAL.HEAD_OF_HOUSEHOLD_FLAG
, PERSONAL.HOUSEHOLD_INCOME
, PERSONAL.HOUSEHOLD_SIZE
, PERSONAL.RENT_OWN_IND
, PARTY.ATTRIBUTE1
, PARTY.ATTRIBUTE2
, PARTY.ATTRIBUTE3
, PARTY.ATTRIBUTE4
, PARTY.ATTRIBUTE5
, PARTY.ATTRIBUTE6
, PARTY.ATTRIBUTE7
, PARTY.ATTRIBUTE8
, PARTY.ATTRIBUTE9
, PARTY.ATTRIBUTE10
, PARTY.ATTRIBUTE11
, PARTY.ATTRIBUTE12
, PARTY.ATTRIBUTE13
, PARTY.ATTRIBUTE14
, PARTY.ATTRIBUTE15
, PARTY.ATTRIBUTE16
, PARTY.ATTRIBUTE17
, PARTY.ATTRIBUTE18
, PARTY.ATTRIBUTE19
, PARTY.ATTRIBUTE20
, 'DUMMY ATTRIBUTE 21'
, 'DUMMY ATTRIBUTE 22'
, 'DUMMY ATTRIBUTE 23'
, 'DUMMY ATTRIBUTE 24'
, 'DUMMY ATTRIBUTE 25'
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
FROM HZ_PARTIES PARTY
, HZ_PERSON_PROFILES PERSONAL
WHERE PARTY.PARTY_ID=PERSONAL.PARTY_ID
AND PARTY.PARTY_TYPE = 'PERSON'
AND PERSONAL.EFFECTIVE_END_DATE IS NULL UNION ALL SELECT TO_CHAR(PARTY.PARTY_ID)
, PARTY.PARTY_NAME
, PARTY.CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, PARTY.ATTRIBUTE1
, PARTY.ATTRIBUTE2
, PARTY.ATTRIBUTE3
, PARTY.ATTRIBUTE4
, PARTY.ATTRIBUTE5
, PARTY.ATTRIBUTE6
, PARTY.ATTRIBUTE7
, PARTY.ATTRIBUTE8
, PARTY.ATTRIBUTE9
, PARTY.ATTRIBUTE10
, PARTY.ATTRIBUTE11
, PARTY.ATTRIBUTE12
, PARTY.ATTRIBUTE13
, PARTY.ATTRIBUTE14
, PARTY.ATTRIBUTE15
, PARTY.ATTRIBUTE16
, PARTY.ATTRIBUTE17
, PARTY.ATTRIBUTE18
, PARTY.ATTRIBUTE19
, PARTY.ATTRIBUTE20
, 'DUMMY ATTRIBUTE 21'
, 'DUMMY ATTRIBUTE 22'
, 'DUMMY ATTRIBUTE 23'
, 'DUMMY ATTRIBUTE 24'
, 'DUMMY ATTRIBUTE 25'
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
, -99
FROM HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
WHERE PARTY.PARTY_TYPE = 'PARTY_RELATIONSHIP'
AND PARTY.PARTY_ID = REL.PARTY_ID
AND REL.SUBJECT_TYPE = 'PERSON'
AND REL.RELATIONSHIP_CODE = 'EMPLOYEE_OF'
AND REL.DIRECTIONAL_FLAG = 'F'
AND REL.STATUS = 'A'

Columns

Name
ID
NAME
CREATION_DATE
GENDER
AGE
MARITAL_STATUS
PERSONAL_INCOME
IS_HEAD_OF_HOUSEHOLD
HOUSEHOLD_INCOME
HOUSEHOLD_SIZE
RENT_OWN_INDICATOR
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
ATTRIBUTE31
ATTRIBUTE32
ATTRIBUTE33
ATTRIBUTE34
ATTRIBUTE35
ATTRIBUTE36
ATTRIBUTE37
ATTRIBUTE38
ATTRIBUTE39
ATTRIBUTE40
ATTRIBUTE41
ATTRIBUTE42
ATTRIBUTE43
ATTRIBUTE44
ATTRIBUTE45
ATTRIBUTE46
ATTRIBUTE47
ATTRIBUTE48
ATTRIBUTE49
ATTRIBUTE50