VIEW: APPS.IGS_PS_FAC_WL_V

Source

View Text - Preformatted

SELECT PFW.ROWID ROW_ID , PFW.FAC_WL_ID, PFW.PERSON_ID, PE.PERSON_NUMBER, NULL, PE.FULL_NAME, LKUP1.MEANING SEX_MEANING, PE.BIRTH_DATE, PFW.CALENDAR_CAT, LKUP.MEANING CALENDAR_CAT_MEANING, PFW.CAL_TYPE, PFW.CI_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, NULL, PFW.ATTRIBUTE_CATEGORY, PFW.ATTRIBUTE1, PFW.ATTRIBUTE2, PFW.ATTRIBUTE3, PFW.ATTRIBUTE4, PFW.ATTRIBUTE5, PFW.ATTRIBUTE6, PFW.ATTRIBUTE7, PFW.ATTRIBUTE8, PFW.ATTRIBUTE9, PFW.ATTRIBUTE10, PFW.ATTRIBUTE11, PFW.ATTRIBUTE12, PFW.ATTRIBUTE13, PFW.ATTRIBUTE14, PFW.ATTRIBUTE15, PFW.ATTRIBUTE16, PFW.ATTRIBUTE17, PFW.ATTRIBUTE18, PFW.ATTRIBUTE19, PFW.ATTRIBUTE20, PFW.CREATED_BY, PFW.CREATION_DATE, PFW.LAST_UPDATED_BY, PFW.LAST_UPDATE_DATE, PFW.LAST_UPDATE_LOGIN FROM IGS_PS_FAC_WL PFW, IGS_PE_PERSON_BASE_V PE, IGS_CA_INST CI, IGS_LOOKUP_VALUES LKUP, FND_LOOKUP_VALUES LKUP1 WHERE PE.PERSON_ID = PFW.PERSON_ID AND PE.GENDER= LKUP1.LOOKUP_CODE(+) AND LKUP1.LOOKUP_TYPE (+) ='HZ_GENDER' AND LKUP1.VIEW_APPLICATION_ID (+) = 222 AND LKUP1.SECURITY_GROUP_ID (+) = 0 AND LKUP1.LANGUAGE (+) = USERENV('LANG') AND PFW.CAL_TYPE = CI.CAL_TYPE AND PFW.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND LKUP.LOOKUP_CODE = PFW.CALENDAR_CAT AND LKUP.LOOKUP_TYPE = 'CAL_CAT'

View Text - HTML Formatted

SELECT PFW.ROWID ROW_ID
, PFW.FAC_WL_ID
, PFW.PERSON_ID
, PE.PERSON_NUMBER
, NULL
, PE.FULL_NAME
, LKUP1.MEANING SEX_MEANING
, PE.BIRTH_DATE
, PFW.CALENDAR_CAT
, LKUP.MEANING CALENDAR_CAT_MEANING
, PFW.CAL_TYPE
, PFW.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, NULL
, PFW.ATTRIBUTE_CATEGORY
, PFW.ATTRIBUTE1
, PFW.ATTRIBUTE2
, PFW.ATTRIBUTE3
, PFW.ATTRIBUTE4
, PFW.ATTRIBUTE5
, PFW.ATTRIBUTE6
, PFW.ATTRIBUTE7
, PFW.ATTRIBUTE8
, PFW.ATTRIBUTE9
, PFW.ATTRIBUTE10
, PFW.ATTRIBUTE11
, PFW.ATTRIBUTE12
, PFW.ATTRIBUTE13
, PFW.ATTRIBUTE14
, PFW.ATTRIBUTE15
, PFW.ATTRIBUTE16
, PFW.ATTRIBUTE17
, PFW.ATTRIBUTE18
, PFW.ATTRIBUTE19
, PFW.ATTRIBUTE20
, PFW.CREATED_BY
, PFW.CREATION_DATE
, PFW.LAST_UPDATED_BY
, PFW.LAST_UPDATE_DATE
, PFW.LAST_UPDATE_LOGIN
FROM IGS_PS_FAC_WL PFW
, IGS_PE_PERSON_BASE_V PE
, IGS_CA_INST CI
, IGS_LOOKUP_VALUES LKUP
, FND_LOOKUP_VALUES LKUP1
WHERE PE.PERSON_ID = PFW.PERSON_ID
AND PE.GENDER= LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE (+) ='HZ_GENDER'
AND LKUP1.VIEW_APPLICATION_ID (+) = 222
AND LKUP1.SECURITY_GROUP_ID (+) = 0
AND LKUP1.LANGUAGE (+) = USERENV('LANG')
AND PFW.CAL_TYPE = CI.CAL_TYPE
AND PFW.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND LKUP.LOOKUP_CODE = PFW.CALENDAR_CAT
AND LKUP.LOOKUP_TYPE = 'CAL_CAT'