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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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