Two input lookup parameters within a query and subquery
Posted: Mon Jul 19, 2004 4:36 am
Hi All
I wanted to use following query as User defined query in Oracle Source Stage with two input lookup parameters. I would like to know, Can I pass two values from other source stage (CASE_KEY and TR_CD in the following example)
SELECT DISTINCT FDRT_KEY FROM FD_RATES WHERE
BNTP_KEY =
(
SELECT DISTINCT A.BNTP_KEY FROM BEN_TYPES A
WHERE
CASE_KEY = :1 AND
SBNT_KEY = 90
) AND
TR_CD = :2
Any help would be highly appreciated. :D
Thanks in advance
Anand
I wanted to use following query as User defined query in Oracle Source Stage with two input lookup parameters. I would like to know, Can I pass two values from other source stage (CASE_KEY and TR_CD in the following example)
SELECT DISTINCT FDRT_KEY FROM FD_RATES WHERE
BNTP_KEY =
(
SELECT DISTINCT A.BNTP_KEY FROM BEN_TYPES A
WHERE
CASE_KEY = :1 AND
SBNT_KEY = 90
) AND
TR_CD = :2
Any help would be highly appreciated. :D
Thanks in advance
Anand