VIEW: APPS.IGSFV_ORG_ALTERNATE_IDS

Source

View Text - Preformatted

SELECT OAI.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER, OAI.ORG_STRUCTURE_TYPE, OAI.ORG_ALTERNATE_ID_TYPE ORG_ALTERNATE_ID_TYPE, OAI.ORG_ALTERNATE_ID ORG_ALTERNATE_IDENTIFIER, '_LA:OAT.SYSTEM_ID_TYPE:IGS_LOOKUP_VALUES:OR_SYSTEM_ID_TYPE:MEANING' , OAT.PREF_INST_IND, OAT.PREF_UNIT_IND, OAI.START_DATE EFFECTIVE_START_DATE, OAI.END_DATE EFFECTIVE_END_DATE, HP.PARTY_NAME ORG_STRUCTURE_NAME, OAT.ID_TYPE_DESCRIPTION ORG_ALTERNATE_ID_TYPE_DESC, '_LA:OAI.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING' , OAI.CREATED_BY, OAI.CREATION_DATE, OAI.LAST_UPDATED_BY, OAI.LAST_UPDATE_DATE FROM IGS_OR_ORG_ALT_IDS OAI, IGS_OR_ORG_ALT_IDTYP OAT, HZ_PARTIES HP, IGS_PE_HZ_PARTIES IHP WHERE OAI.ORG_ALTERNATE_ID_TYPE = OAT.ORG_ALTERNATE_ID_TYPE AND OAI.ORG_STRUCTURE_ID = IHP.OSS_ORG_UNIT_CD AND IHP.PARTY_ID = HP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT OAI.ORG_STRUCTURE_ID ORG_STRUCTURE_IDENTIFIER
, OAI.ORG_STRUCTURE_TYPE
, OAI.ORG_ALTERNATE_ID_TYPE ORG_ALTERNATE_ID_TYPE
, OAI.ORG_ALTERNATE_ID ORG_ALTERNATE_IDENTIFIER
, '_LA:OAT.SYSTEM_ID_TYPE:IGS_LOOKUP_VALUES:OR_SYSTEM_ID_TYPE:MEANING'
, OAT.PREF_INST_IND
, OAT.PREF_UNIT_IND
, OAI.START_DATE EFFECTIVE_START_DATE
, OAI.END_DATE EFFECTIVE_END_DATE
, HP.PARTY_NAME ORG_STRUCTURE_NAME
, OAT.ID_TYPE_DESCRIPTION ORG_ALTERNATE_ID_TYPE_DESC
, '_LA:OAI.ORG_STRUCTURE_TYPE:IGS_LOOKUP_VALUES:ORG_STRUCTURE_TYPE:MEANING'
, OAI.CREATED_BY
, OAI.CREATION_DATE
, OAI.LAST_UPDATED_BY
, OAI.LAST_UPDATE_DATE
FROM IGS_OR_ORG_ALT_IDS OAI
, IGS_OR_ORG_ALT_IDTYP OAT
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
WHERE OAI.ORG_ALTERNATE_ID_TYPE = OAT.ORG_ALTERNATE_ID_TYPE
AND OAI.ORG_STRUCTURE_ID = IHP.OSS_ORG_UNIT_CD
AND IHP.PARTY_ID = HP.PARTY_ID WITH READ ONLY