DBA Data[Home] [Help]

APPS.OKC_XPRT_RULE_PVT dependencies on FND_LOOKUPS

Line 223: fnd_lookups vartype

219: b.flex_value_set_id value_set_id, variable_type,
220: vartype.meaning var_type_meaning
221: FROM okc_bus_variables_v a,
222: fnd_flex_value_sets b,
223: fnd_lookups vartype
224: WHERE contract_expert_yn = 'Y'
225: AND variable_datatype <> 'D'
226: AND a.xprt_value_set_name = b.flex_value_set_name(+)
227: AND vartype.lookup_type = 'OKC_ART_VAR_TYPE'

Line 237: fnd_lookups vartype

233: b.flex_value_set_id value_set_id, variable_type,
234: vartype.meaning var_type_meaning
235: FROM okc_bus_variables_v a,
236: fnd_flex_value_sets b,
237: fnd_lookups vartype
238: WHERE a.variable_type = 'U'
239: AND a.value_set_id = b.flex_value_set_id
240: AND ( ( b.validation_type IN ('I', 'X', 'F')
241: AND b.format_type = 'C'

Line 1944: FROM okc_terms_templates_all temp, fnd_lookups status

1940: IS
1941: CURSOR cur_val_template
1942: IS
1943: SELECT 'Y'
1944: FROM okc_terms_templates_all temp, fnd_lookups status
1945: WHERE intent = g_rule_intent
1946: AND status.lookup_code = temp.status_code
1947: AND status.lookup_type = 'OKC_TERMS_TMPL_STATUS'
1948: AND contract_expert_enabled = 'Y'