Thanks Mahmoud, Jonathan and Richard. Creating SQL view within extender was easy. the following is the sql of the same. but my problem is we are having a extender windows and extender notes. I am able to select the table of extender window and join with customer address master but the extender notes table doesnt show up to add it on view. so I am thinking of creating a view directly in sql to include the table extender notes. let me know if any other suggestion from anyone.
create view CUST_TYPE
as select
A1.ADRSCODE,
A1.CREATDDT,
A1.CUSTNMBR,
A1.MODIFDT,
A1.SLPRSNID,
'CUSTOMER TYPE' = CASE A2.CUST_TYPE_1_CUSTOMERTYPE WHEN 1 THEN 'SOLDTO' WHEN 2 THEN 'SHIPTO' END ,
A2.CUST_TYPE_Key1 AS 'Address Code',
A2.CUST_TYPE_2_CUSTOMERCLASS AS 'CUSTOMER CLASS',
A2.CUST_TYPE_3_SICCODE AS 'SIC CODE',
A2.CUST_TYPE_4_SHIPTONAME AS 'SHIPTO NAME',
A2.CUST_TYPE_8_COUNTY AS 'COUNTY' from
RM00102 A1
left join
(select
K1.Key_Strings_1 as CUST_TYPE_Key1,
CUST_TYPE_1_CUSTOMERTYPE,CUST_TYPE_2_CUSTOMERCLASS,CUST_TYPE_3_SICCODE,CUST_TYPE_4_SHIPTONAME,CUST_TYPE_8_COUNTY
from
(select PT_UD_Key, Key_Strings_1, Key_Strings_2, Key_Strings_3, Key_Strings_4, Key_Strings_5 from EXT00100 where PT_Window_ID = 'CUST_TYPE') K1
left join
(select PT_UD_Key, TOTAL as CUST_TYPE_1_CUSTOMERTYPE from EXT00103
where PT_Window_ID = 'CUST_TYPE' and PT_UD_Number = 1) B1
on K1.PT_UD_Key = B1.PT_UD_Key
left join
(select PT_UD_Key, STRGA255 as CUST_TYPE_2_CUSTOMERCLASS from EXT00101
where PT_Window_ID = 'CUST_TYPE' and PT_UD_Number = 2) B2
on K1.PT_UD_Key = B2.PT_UD_Key
left join
(select PT_UD_Key, STRGA255 as CUST_TYPE_3_SICCODE from EXT00101
where PT_Window_ID = 'CUST_TYPE' and PT_UD_Number = 3) B3
on K1.PT_UD_Key = B3.PT_UD_Key
left join
(select PT_UD_Key, STRGA255 as CUST_TYPE_4_SHIPTONAME from EXT00101
where PT_Window_ID = 'CUST_TYPE' and PT_UD_Number = 4) B4
on K1.PT_UD_Key = B4.PT_UD_Key
left join
(select PT_UD_Key, STRGA255 as CUST_TYPE_8_COUNTY from EXT00101
where PT_Window_ID = 'CUST_TYPE' and PT_UD_Number = 8) B8
on K1.PT_UD_Key = B8.PT_UD_Key ) A2
on A2.CUST_TYPE_Key1 = A1.ADRSCODE
left join
(select
from
(select PT_UD_Key, Key_Strings_1, Key_Strings_2, Key_Strings_3, Key_Strings_4, Key_Strings_5 from EXT00100 where PT_Window_ID = 'CUST_TYPE') K1 ) A3
on
