VIEW: APPS.IGS_PE_EIT_PERM_RES_V

Source

View Text - Preformatted

SELECT t.rowid row_id, t.pe_eit_id, t.person_id, t.information_type, t.pei_information1 perm_res_cntry, ter.territory_short_name meaning, t.pei_information2 document_num, t.start_date, t.end_date, t.created_by, t.creation_date, t.last_updated_by, t.last_update_date, t.last_update_login FROM IGS_PE_EIT T, fnd_territories_vl ter WHERE T.INFORMATION_TYPE = 'PE_INT_PERM_RES' AND T.PEI_INFORMATION1 = Ter.TERRITORY_CODE

View Text - HTML Formatted

SELECT T.ROWID ROW_ID
, T.PE_EIT_ID
, T.PERSON_ID
, T.INFORMATION_TYPE
, T.PEI_INFORMATION1 PERM_RES_CNTRY
, TER.TERRITORY_SHORT_NAME MEANING
, T.PEI_INFORMATION2 DOCUMENT_NUM
, T.START_DATE
, T.END_DATE
, T.CREATED_BY
, T.CREATION_DATE
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
FROM IGS_PE_EIT T
, FND_TERRITORIES_VL TER
WHERE T.INFORMATION_TYPE = 'PE_INT_PERM_RES'
AND T.PEI_INFORMATION1 = TER.TERRITORY_CODE