Script

SELECT rownum AS pyIntegerValue , 

nvl(PC0.OFFICIALNAME, PC0.NAME) AS pyTextValue, 

PC0.TIN AS TIN , 

PC0.PINEQ AS PinEQ , 

cnt.VALUE AS Value , 

st.PYLABEL AS pyLabel , 

prt.NAME AS Name , 

PC0.PZINSKEY AS pzInsKey 

FROM DATA.ABRFS_PARTY PC0 

INNER JOIN DATA.ABRFS_PARTYROLEREL cl_prt 

ON ( ( cl_prt.PARTYTOID = PC0.PYID AND cl_prt.ROLECODE = 'PARTYROLE_PARTNERCLIENT' AND PC0.ISDISABLED = 'false' ) AND PC0.PXOBJCLASS = 'ABR-FW-Data-Party-Org' AND cl_prt.PXOBJCLASS = 'ABR-FW-Data-PartyRoleRel' ) 

LEFT OUTER JOIN DATA.cpmrpt_partners_all prt 

ON ( ( prt.PARTYID = cl_prt.PARTYFROMID AND prt.ISDISABLED = 'false' ) AND PC0.PXOBJCLASS = 'ABR-FW-Data-Party-Org' AND cl_prt.PXOBJCLASS = 'ABR-FW-Data-PartyRoleRel' ) 

LEFT OUTER JOIN DATA.ABRFS_PARTYSTATUS st ON ( ( st.CODE = PC0.STATUSCODE ) AND PC0.PXOBJCLASS = 'ABR-FW-Data-Party-Org' AND st.PXOBJCLASS = 'ABR-FW-Data-Dict-PartyStatus' ) 

LEFT OUTER JOIN DATA.cpmrpt_party_first_contactinfo fci ON ( ( fci.PARTYID = PC0.PYID ) AND PC0.PXOBJCLASS = 'ABR-FW-Data-Party-Org' ) 

LEFT OUTER JOIN DATA.ABRFS_PARTYROLECONTACTINFO cnt ON ( ( cnt.PYID = fci.CONTACTINFOID ) AND cnt.PXOBJCLASS = 'ABR-FW-Data-PartyRoleContactInfo' )

 WHERE PC0.pxObjClass = 'ABR-FW-Data-Party-Org';