VIEW: APPS.IGS_EN_NSC_BRANCH_V

Source

View Text - Preformatted

SELECT RPAD(alt.org_alternate_id,20)||' '||alt.org_alternate_id_type alternate_id, alt.org_alternate_id ||' '||alt.org_alternate_id_type alternate_id_type FROM igs_or_org_alt_ids_v alt WHERE alt.org_structure_type = 'ORG_UNIT' AND NVL(alt.end_date,SYSDATE) >= SYSDATE UNION SELECT RPAD('00',20)||' '||'00' alternate_id, '00 00' alternate_id_type FROM DUAL

View Text - HTML Formatted

SELECT RPAD(ALT.ORG_ALTERNATE_ID
, 20)||' '||ALT.ORG_ALTERNATE_ID_TYPE ALTERNATE_ID
, ALT.ORG_ALTERNATE_ID ||' '||ALT.ORG_ALTERNATE_ID_TYPE ALTERNATE_ID_TYPE
FROM IGS_OR_ORG_ALT_IDS_V ALT
WHERE ALT.ORG_STRUCTURE_TYPE = 'ORG_UNIT'
AND NVL(ALT.END_DATE
, SYSDATE) >= SYSDATE UNION SELECT RPAD('00'
, 20)||' '||'00' ALTERNATE_ID
, '00 00' ALTERNATE_ID_TYPE
FROM DUAL