How to call a BIP report from DFF? Is it possible ?
Summary:
I want to create a DFF of table type with below query (SELECT 'Internal Use Only' name
FROM
dual
UNION
SELECT
substrb(party.party_name, 1, 150) name
FROM
hz_cust_accounts cust_acct,
hz_parties party
WHERE
cust_acct.party_id = party.party_id
AND party.status = 'A'
AND cust_acct.status = 'A'
UNION
SELECT
substr(vendor_name, 1, 150) name
FROM
poz_suppliers
WHERE
enabled_flag = 'Y'
) tab
However the length of above query is more and not allowing in the FROM clause. How to accommodate the above query in DFF FROM clause ? Is there any other way to get above set of data in table type value set.
Tagged:
0