SELECT
  ET.*,
  R.REPLICATION_ID AS R$REPLICATION_ID, R.OPERATION AS R$OPERATION, R.CREATE_DATETIME AS R$CREATE_DATETIME
FROM REPLICATIONS$GET_ACTUALLY_INFOS(:1   , 'E$OPERATIONS') R
INNER JOIN "E$OPERATIONS" ET ON (ET."CASH_FK" || '/' || CAST(ET."DATE" AS VARCHAR(10)) || '/' || ET."NUM") = R.TABLE_KEY
WHERE R.OPERATION = 'C'
ORDER BY R.REPLICATION_ID, R.CREATE_DATETIME

PLAN SORT (JOIN (SORT (REPLICATIONS INDEX (REPLICATIONS$IDX_PK)), ET NATURAL))

PLAN SORT (JOIN (SORT (REPLICATIONS INDEX (REPLICATIONS$IDX_PK)), ET INDEX (R$E$OPERATIONS$IDX)))

CREATE INDEX R$E$OPERATIONS$IDX ON E$OPERATIONS COMPUTED BY ( "CASH_FK" || '/' || CAST("DATE" AS VARCHAR(10)) || '/' || "NUM" );

TABLE_KEY D$TABLE_KEY

CREATE DOMAIN D$TABLE_KEY AS
VARCHAR(128) CHARACTER SET OCTETS
COLLATE OCTETS;

PLAN SORT (JOIN (SORT (REPLICATIONS INDEX (REPLICATIONS$IDX_PK)), ET INDEX (R$E$OPERATIONS$IDX)))

PLAN SORT (JOIN (SORT (REPLICATIONS INDEX (REPLICATIONS$IDX_PK)), ET NATURAL))

SELECT
 *
FROM TEST$2 T2
INNER JOIN TEST$1 ET ON (ET."CASH_FK" || '/' || CAST(ET."DATE" AS VARCHAR(10)) || '/' || ET."NUM") = T2.TABLE_KEY
WHERE T2.REPLICATION_ID = 1

SET SQL DIALECT 3;

CREATE DOMAIN D$DATE AS
DATE;

CREATE DOMAIN D$INTEGER AS
INTEGER;

CREATE DOMAIN D$KEY AS
BIGINT;

CREATE DOMAIN D$TABLE_KEY AS
VARCHAR(128) CHARACTER SET OCTETS;

CREATE TABLE TEST$1 (
    CASH_FK  D$KEY NOT NULL /* D$KEY = BIGINT */,
    "DATE"   D$DATE NOT NULL /* D$DATE = DATE */,
    NUM      D$INTEGER NOT NULL /* D$INTEGER = INTEGER */
);


CREATE TABLE TEST$2 (
    REPLICATION_ID  D$KEY NOT NULL /* D$KEY = BIGINT */,
    TABLE_KEY       D$TABLE_KEY NOT NULL /* D$TABLE_KEY = VARCHAR(128) */
);


INSERT INTO TEST$1 (CASH_FK, "DATE", NUM) VALUES (1, '2014-11-18', 100);

COMMIT WORK;

INSERT INTO TEST$2 (REPLICATION_ID, TABLE_KEY) VALUES (1, '1/2014-11-18/100');

COMMIT WORK;

ALTER TABLE TEST$2 ADD CONSTRAINT TEST$2$PK_DESC PRIMARY KEY (REPLICATION_ID)
USING DESCENDING INDEX TEST$2$PK_DESC;

CREATE INDEX R$TEST$1$IDX ON TEST$1 COMPUTED BY ( "CASH_FK" || '/' || CAST("DATE" AS VARCHAR(10)) || '/' || "NUM" );
CREATE INDEX TEST$2$IDX_PK ON TEST$2 (REPLICATION_ID);