DBA Data[Home] [Help]

APPS.HXC_CREATE_FLEX_MAPPINGS dependencies on FND_DESCR_FLEX_CONTEXTS_VL

Line 311: from fnd_descr_flex_contexts_vl c,

307: p_flex_name in FND_DESCRIPTIVE_FLEXS.DESCRIPTIVE_FLEXFIELD_NAME%TYPE
308: ,p_appl_short_name in FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE
309: ) is
310: select c.descriptive_flex_context_code, c.descriptive_flex_context_name
311: from fnd_descr_flex_contexts_vl c,
312: fnd_application a
313: where c.descriptive_flexfield_name = p_flex_name
314: and a.application_short_name = p_appl_short_name
315: and a.application_id = c.application_id

Line 1199: FROM fnd_descr_flex_contexts_vl

1195:
1196: CURSOR get_max_sequence IS
1197: select max(to_number(substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,
1198: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')+2)))
1199: FROM fnd_descr_flex_contexts_vl
1200: WHERE descriptive_flexfield_name = 'OTC Information Types'
1201: AND application_id = 809
1202: AND substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,0,
1203: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')-2)

Line 1698: from fnd_descr_flex_contexts_vl fdfc

1694: where reference_object = p_alias_context_code;
1695:
1696: cursor c_prompt (p_alias_context_code varchar2) is
1697: select fdfc.descriptive_flex_context_name
1698: from fnd_descr_flex_contexts_vl fdfc
1699: where application_id = 809
1700: and DESCRIPTIVE_FLEXFIELD_NAME = 'OTC Aliases'
1701: and fdfc.descriptive_flex_context_code = p_alias_context_code;
1702: