DBA Data[Home] [Help]

APPS.OKL_JTOT_EXTRACT dependencies on OKX_ORGANIZATION_DEFS_V

Line 37: FROM okx_organization_defs_v ord

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