SELECT ENTITYX AS "Ent" ,ACCOUNTX AS "Acct",UD3X AS "Prod",AMOUNTX AS "Amt", L.PARTNAME "Loc", P.PERIODDESC AS "Dat"FROM TDATASEG T, TPOVPARTITION L, TPOVPERIOD P WHERE T.PARTITIONKEY = L.PARTITIONKEY AND T.PERIODKEY = P.PERIODKEY AND L.PARTNAME = ~LOCATION~ AND P.PERIODDESC = ~PERIOD~