DBA Data[Home] [Help]

APPS.XNP_CVU_PKG dependencies on FND_LOOKUP_VALUES

Line 450: FROM xnp_sv_status_types_b sst, fnd_lookup_values flv

446: 'INQUIRY', decode (count(*), 0, gc_WARNING,gc_OK),
447: decode(count(*), 0, gc_ERROR,gc_OK)) result_type
448: FROM
449: (SELECT flv.lookup_code pi, sst.status_type_code stc
450: FROM xnp_sv_status_types_b sst, fnd_lookup_values flv
451: WHERE flv.lookup_code = sst.phase_indicator (+)
452: AND flv.lookup_type = 'XNP_PHASE_INDICATOR'
453: AND flv.enabled_flag = 'Y'
454: AND sst.active_flag = 'Y')