SNo.
District Name
PS Name
GP Name
LSP Name
Kiosk Name
Kiosk Code
Old Emitra Kiosk Code
Kiosk SSO ID
Kiosk Active Y/N
Kiosk Address
Query ===== SELECT distinct C.DISTRICT_NAME_ENG KIOSK_DISTRICT, GRAM_PAN_SAMITI_NAME_ENG ps_name,GRAMPANCHAYAT_NAME_ENG gp_name, (SELECT VENDOR_NAME_ENG FROM emitra.VENDOR_PROFILE_DETAIL_TB WHERE ENTITY_MASTR_ID=Cd.PARENT) LSP, VENDOR_NAME_ENG Kiosk_Name,VENDOR_CODE Kiosk_Code,OLD_VENDOR_CODE Old_Emitra_Kiosk_Id,A.SSO_ID Kiosk_Admin_SSOID, A.EMAIL_OFF,TRIM(D.PHONE_1) phone_no, A.IS_ACTIVE,A.SBI_TID,D.ADDR_ENG FROM EMITRA.VENDOR_PROFILE_DETAIL_TB A INNER JOIN EMITRA.VENDOR_DISTRICT_MAP_TB B ON A.VENDOR_PROFILE_DETAIL_ID=B.VENDOR_PROFILE_DETAIL_ID INNER JOIN EMITRA.DISTRICT_MASTR_TB C ON B.DISTRICT_MASTR_ID=C.DISTRICT_MASTR_ID INNER JOIN EMITRA.ENTITY_MASTR_TB Cd ON A.ENTITY_MASTR_ID=Cd.ENTITY_MASTR_ID AND CD.IS_ACTIVE='Y' AND CD.DEL_FLAG = 'N' INNER JOIN EMITRA.VENDOR_ADDRESS_DETAIL_TB D ON A.VENDOR_PROFILE_DETAIL_ID=D.VENDOR_PROFILE_DETAIL_ID and d.ADDR_TYPE = 'PROPOSED' LEFT JOIN EMITRA.GRAM_PAN_SAMITI_MASTR_TB ps ON ps.dist_id = B.DISTRICT_MASTR_ID AND ps.GRAM_PAN_SAMITI_MASTR_ID = D.GRAM_PAN_SAMITI_MASTR_ID AND PS.IS_ACTIVE ='Y' AND PS.DEL_FLAG ='N' LEFT JOIN EMITRA.GRAM_PANCHAYAT_MASTR_TB gp ON gp.GRAM_PANCHAYAT_MASTR_ID = d.GRAM_PANCHAYAT_MASTR_ID AND GP.IS_ACTIVE ='Y' AND GP.DEL_FLAG ='N' AND ps.GRAM_PAN_SAMITI_MASTR_ID =gp.GRAM_PAN_SAMITI_MASTR_ID WHERE A.ENTITY_MASTR_ID<>443 AND c.DISTRICT_MASTR_ID>0 AND (A.IS_PAYPOINT = 'BOTH' or 'BOTH' = 'BOTH') and c.DISTRICT_MASTR_ID<34 AND A.IS_ACTIVE='Y' AND A.DEL_FLAG='N' AND B.IS_ACTIVE='Y' AND B.DEL_FLAG='N' AND A.ENTITY_TYPE_ID=5 AND (B.DISTRICT_MASTR_ID = or -1 = ) AND (NVL(D.IS_RURAL,'N') = 'BOTH' OR 'BOTH' = 'BOTH') ORDER BY 1,2,3 Exception showing data :ORA-00936: missing expression
e-Mitra Info
Click to Refresh for
Current Status
