VIEW: APPS.IGS_AD_RECRUIT_PI_V

Source

View Text - Preformatted

SELECT IRP.ROWID ROW_ID, IRP.PROBABILITY_INDEX_ID, IRP.PERSON_ID, IRP.PROBABILITY_TYPE_CODE_ID, IACT.NAME TYPE_NAME, IRP.CALCULATION_DATE, IRP.PROBABILITY_VALUE, IRP.PROBABILITY_SOURCE_CODE_ID, IACS.NAME SOURCE_NAME, IRP.CREATED_BY, IRP.CREATION_DATE, IRP.LAST_UPDATED_BY, IRP.LAST_UPDATE_DATE, IRP.LAST_UPDATE_LOGIN FROM IGS_AD_RECRUIT_PI IRP, IGS_AD_CODE_CLASSES IACT, IGS_AD_CODE_CLASSES IACS WHERE IACT.CLASS (+) = 'PROB_TYPE' AND IACT.CODE_ID (+) = IRP.PROBABILITY_TYPE_CODE_ID AND IACS.CLASS(+) = 'PROB_SOURCE' AND IACS.CODE_ID (+) = IRP.PROBABILITY_SOURCE_CODE_ID

View Text - HTML Formatted

SELECT IRP.ROWID ROW_ID
, IRP.PROBABILITY_INDEX_ID
, IRP.PERSON_ID
, IRP.PROBABILITY_TYPE_CODE_ID
, IACT.NAME TYPE_NAME
, IRP.CALCULATION_DATE
, IRP.PROBABILITY_VALUE
, IRP.PROBABILITY_SOURCE_CODE_ID
, IACS.NAME SOURCE_NAME
, IRP.CREATED_BY
, IRP.CREATION_DATE
, IRP.LAST_UPDATED_BY
, IRP.LAST_UPDATE_DATE
, IRP.LAST_UPDATE_LOGIN
FROM IGS_AD_RECRUIT_PI IRP
, IGS_AD_CODE_CLASSES IACT
, IGS_AD_CODE_CLASSES IACS
WHERE IACT.CLASS (+) = 'PROB_TYPE'
AND IACT.CODE_ID (+) = IRP.PROBABILITY_TYPE_CODE_ID
AND IACS.CLASS(+) = 'PROB_SOURCE'
AND IACS.CODE_ID (+) = IRP.PROBABILITY_SOURCE_CODE_ID