DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKX_ORGANIZATION_DEFS_V

Line 35: FROM okx_organization_defs_v ord

31: SELECT ord.id1,
32: ord.id2,
33: ord.name,
34: ord.description
35: FROM okx_organization_defs_v ord
36: WHERE ord.organization_type = 'OPERATING_UNIT'
37: AND ord.information_type = 'Operating Unit Information'
38: AND ord.name = NVL(p_name,ord.name)
39: AND ord.id1 = NVL(p_id1,ord.id1)