DBA Data[Home] [Help]

VIEW: APPS.IGR_I_E_ORGUNITS_V

Source

View Text - Preformatted

SELECT EOR.RowId, EOR.Ent_Org_Unit_Id, EOR.Party_Id, OU.Org_Unit_CD, OU.Description, EOR.Closed_Ind, EOR.Created_By, EOR.Creation_Date, EOR.Last_Updated_By, EOR.Last_Update_Date, EOR.Last_Update_Login, EOR.Inquiry_type_id FROM IGS_OR_UNIT_V OU, IGR_I_E_ORGUNITS EOR WHERE OU.Party_Id = EOR.Party_Id
View Text - HTML Formatted

SELECT EOR.ROWID
, EOR.ENT_ORG_UNIT_ID
, EOR.PARTY_ID
, OU.ORG_UNIT_CD
, OU.DESCRIPTION
, EOR.CLOSED_IND
, EOR.CREATED_BY
, EOR.CREATION_DATE
, EOR.LAST_UPDATED_BY
, EOR.LAST_UPDATE_DATE
, EOR.LAST_UPDATE_LOGIN
, EOR.INQUIRY_TYPE_ID
FROM IGS_OR_UNIT_V OU
, IGR_I_E_ORGUNITS EOR
WHERE OU.PARTY_ID = EOR.PARTY_ID