DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKX_PARTIES_V

Line 23: FROM okx_parties_v prv

19: SELECT prv.id1,
20: prv.id2,
21: prv.name,
22: prv.description
23: FROM okx_parties_v prv
24: WHERE prv.name = NVL(p_name,prv.name)
25: AND prv.id1 = p_id1
26: AND prv.id2 = NVL(p_id2,prv.id2)
27: ORDER BY prv.name;