APPS.POA_DNB_LTPRT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 9

     SELECT distinct TPLO_TPartner_Loc_PK TPartner_Loc_PK,
            TPRT_Name Name,
            TPLO_Address_Line1 Address_Line1,
            TPLO_Address_Line2 Address_Line2,
            TPLO_Address_Line3 Address_Line3,
            TPLO_Address_Line4 Address_Line4,
            TPLO_County County,
            TPLO_City City,
            TPLO_State State,
            TPLO_Province Province,
            TPLO_Country Country,
            TPLO_Postal_Code Postal_Code
      FROM EDW_TRD_PARTNER_M
      where ((TPLO_Business_Type = 'VENDOR SITE') and
             (TPLO_Level_Name = 'LOCATION'));