You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!