DBA Data[Home] [Help]

VIEW: APPS.IGS_PR_OU_AWD_V

Source

View Text - Preformatted

SELECT POA.ROWID , POA.PROGRESSION_RULE_CAT, POA.PRA_SEQUENCE_NUMBER, POA.PRO_SEQUENCE_NUMBER, POA.AWARD_CD, AWD.AWARD_TITLE, POA.CREATED_BY, POA.CREATION_DATE, POA.LAST_UPDATED_BY, POA.LAST_UPDATE_DATE, POA.LAST_UPDATE_LOGIN FROM IGS_PR_OU_AWD POA, IGS_PS_AWD AWD WHERE AWD.AWARD_CD = POA.AWARD_CD
View Text - HTML Formatted

SELECT POA.ROWID
, POA.PROGRESSION_RULE_CAT
, POA.PRA_SEQUENCE_NUMBER
, POA.PRO_SEQUENCE_NUMBER
, POA.AWARD_CD
, AWD.AWARD_TITLE
, POA.CREATED_BY
, POA.CREATION_DATE
, POA.LAST_UPDATED_BY
, POA.LAST_UPDATE_DATE
, POA.LAST_UPDATE_LOGIN
FROM IGS_PR_OU_AWD POA
, IGS_PS_AWD AWD
WHERE AWD.AWARD_CD = POA.AWARD_CD