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 1100: FROM fnd_descr_flex_contexts_vl

1096:
1097: CURSOR get_max_sequence IS
1098: select max(to_number(substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,
1099: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')+2)))
1100: FROM fnd_descr_flex_contexts_vl
1101: WHERE descriptive_flexfield_name = 'OTC Information Types'
1102: AND application_id = 809
1103: AND substrB(DESCRIPTIVE_FLEX_CONTEXT_CODE,0,
1104: instr(DESCRIPTIVE_FLEX_CONTEXT_CODE,'-')-2)

Line 1471: from fnd_descr_flex_contexts_vl fdfc

1467: where reference_object = p_alias_context_code;
1468:
1469: cursor c_prompt (p_alias_context_code varchar2) is
1470: select fdfc.descriptive_flex_context_name
1471: from fnd_descr_flex_contexts_vl fdfc
1472: where application_id = 809
1473: and DESCRIPTIVE_FLEXFIELD_NAME = 'OTC Aliases'
1474: and fdfc.descriptive_flex_context_code = p_alias_context_code;
1475: