DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PVT dependencies on OKX_ORGANIZATION_DEFS_V

Line 58: FROM okx_organization_defs_v ord

54: SELECT ord.id1,
55: ord.id2,
56: ord.name,
57: ord.description
58: FROM okx_organization_defs_v ord
59: WHERE ord.organization_type = 'OPERATING_UNIT'
60: AND ord.information_type = 'Operating Unit Information'
61: AND ord.name = NVL(p_name,ord.name)
62: AND ord.id1 = NVL(p_id1,ord.id1)