APPS.XNP_CVU_PKG dependencies on WF_LOOKUPS

Line 2728: FROM wf_lookups wl

2724: FROM fnd_lookups fl
2725: WHERE lookup_type = p_fnd_lookup_type
2726: AND NOT EXISTS
2727: (SELECT 1
2728: FROM wf_lookups wl
2729: WHERE substr(wl.lookup_code,1,29) = substr(fl.lookup_code,1, 29)
2730: AND nvl(substr(wl.meaning,1,75),'#') = nvl(substr(fl.meaning, 1,75),'#')
2731: AND nvl(substr(wl.description,1,239),'#') = nvl(substr(fl.description, 1, 239),'#')
2732: AND wl.lookup_type = p_wf_lookup_type);

Line 2798: FROM wf_lookups wl

2794: INTO v_cnt
2795: FROM xdp_fes_vl fe
2796: WHERE NOT EXISTS
2797: (SELECT 1
2798: FROM wf_lookups wl
2799: WHERE substr(wl.lookup_code,1,29) = substr(fe.fulfillment_element_name,1, 29)
2800: AND nvl(substr(wl.meaning,1,75),'#') = nvl(substr(fe.display_name, 1,75),'#')
2801: AND nvl(substr(wl.description,1,239),'#') = nvl(substr(fe.description, 1, 239),'#')
2802: AND wl.lookup_type = 'FE_NAME');

Line 2816: FROM wf_lookups wl

2812: INTO v_cnt
2813: FROM xdp_fulfill_actions_vl fa
2814: WHERE NOT EXISTS
2815: (SELECT 1
2816: FROM wf_lookups wl
2817: WHERE substr(wl.lookup_code,1,29) = substr(fa.fulfillment_action,1, 29)
2818: AND nvl(substr(wl.meaning,1,75),'#') = nvl(substr(fa.display_name, 1,75),'#')
2819: AND nvl(substr(wl.description,1,239),'#') = nvl(substr(fa.description, 1, 239),'#')
2820: AND wl.lookup_type = 'FA_NAME');

Line 2834: FROM wf_lookups wl

2830: INTO v_cnt
2831: FROM xnp_msg_types_vl mt
2832: WHERE NOT EXISTS
2833: (SELECT 1
2834: FROM wf_lookups wl
2835: WHERE substr(wl.lookup_code,1,29) = substr(mt.msg_code,1, 29)
2836: AND nvl(substr(wl.meaning,1,75),'#') = nvl(substr(mt.display_name, 1,75),'#')
2837: AND nvl(substr(wl.description,1,239),'#') = nvl(substr(mt.description, 1, 239),'#')
2838: AND wl.lookup_type = 'MESSAGE_TYPE');

Line 2853: FROM wf_lookups wl

2849: FROM xnp_msg_types_vl mt
2850: WHERE msg_type = 'TIMER'
2851: AND NOT EXISTS
2852: (SELECT 1
2853: FROM wf_lookups wl
2854: WHERE substr(wl.lookup_code,1,29) = substr(mt.msg_code,1, 29)
2855: AND nvl(substr(wl.meaning,1,75),'#') = nvl(substr(mt.display_name, 1,75),'#')
2856: AND nvl(substr(wl.description,1,239),'#') = nvl(substr(mt.description, 1, 239),'#')
2857: AND wl.lookup_type = 'TIMER_NAMES');

Line 2873: FROM wf_lookups wl

2869: FROM fnd_new_messages nm
2870: WHERE message_name like 'X%_NOTFN_%'
2871: AND NOT EXISTS
2872: (SELECT 1
2873: FROM wf_lookups wl
2874: WHERE substr(wl.lookup_code,1,29) = substr(nm.message_name,1, 29)
2875: AND nvl(substr(wl.meaning,1,75),'#') = nvl(substr(nm.description, 1,75),'#')
2876: AND nvl(substr(wl.description,1,239),'#') = nvl(substr(nm.description, 1, 239),'#')
2877: AND wl.lookup_type = 'CUSTOMIZED_NOTN_MESSAGES');

Line 2891: FROM wf_lookups wl

2887: INTO v_cnt
2888: FROM xnp_sv_status_types_vl sst
2889: WHERE NOT EXISTS
2890: (SELECT 1
2891: FROM wf_lookups wl
2892: WHERE substr(wl.lookup_code,1,29) = substr(sst.status_type_code,1, 29)
2893: AND nvl(substr(wl.meaning,1,75),'#') = nvl(substr(sst.display_name, 1,75),'#')
2894: AND nvl(substr(wl.description,1,239),'#') = nvl(substr(sst.description, 1, 239),'#')
2895: AND wl.lookup_type = 'STATUS');

Line 2909: FROM wf_lookups wl

2905: INTO v_cnt
2906: FROM xdp_workitems_vl wi
2907: WHERE NOT EXISTS
2908: (SELECT 1
2909: FROM wf_lookups wl
2910: WHERE substr(wl.lookup_code,1,29) = substr(wi.workitem_name,1, 29)
2911: AND nvl(substr(wl.meaning,1,75),'#') = nvl(substr(wi.display_name, 1,75),'#')
2912: AND nvl(substr(wl.description,1,239),'#') = nvl(substr(wi.description, 1, 239),'#')
2913: AND wl.lookup_type = 'WORKITEM');