APPS.BIS_VG_DESC_FLEX dependencies on FND_DESCR_FLEX_CONTEXTS

Line 56: FROM fnd_descr_flex_contexts_vl

52: IS
53: CURSOR context_c IS
54: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
55: description, global_flag, enabled_flag
56: FROM fnd_descr_flex_contexts_vl
57: WHERE application_id = flexfield.application_id
58: AND descriptive_flexfield_name = flexfield.flexfield_name
59: ORDER BY creation_date;
60:

Line 62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)

58: AND descriptive_flexfield_name = flexfield.flexfield_name
59: ORDER BY creation_date;
60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,

Line 63: use_nl(fnd_descr_flex_contexts_vl.b)

59: ORDER BY creation_date;
60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag

Line 64: index(fnd_descr_flex_contexts_vl.t

60:
61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
68: FROM fnd_descr_flex_contexts_vl

Line 65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/

61: CURSOR context_c_with_hints IS
62: SELECT /*+ leading(fnd_descr_flex_contexts_vl.t fnd_descr_flex_contexts_vl.b)
63: use_nl(fnd_descr_flex_contexts_vl.b)
64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
68: FROM fnd_descr_flex_contexts_vl
69: WHERE application_id = flexfield.application_id

Line 68: FROM fnd_descr_flex_contexts_vl

64: index(fnd_descr_flex_contexts_vl.t
65: FND_DESCR_FLEX_CONTEXTS_TL_U1)*/
66: descriptive_flex_context_code, descriptive_flex_context_name,
67: description, global_flag, enabled_flag
68: FROM fnd_descr_flex_contexts_vl
69: WHERE application_id = flexfield.application_id
70: AND descriptive_flexfield_name = flexfield.flexfield_name
71: ORDER BY creation_date;
72:

Line 76: FROM fnd_descr_flex_contexts_vl

72:
73: CURSOR context_c_new IS
74: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
75: description, global_flag, enabled_flag
76: FROM fnd_descr_flex_contexts_vl
77: WHERE application_id = flexfield.application_id
78: AND descriptive_flexfield_name = flexfield.flexfield_name
79: ORDER BY creation_date, descriptive_flex_context_code ;
80:

Line 700: FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE

696: ( p_nContexts_flag IN BOOLEAN
697: , p_Flexfield IN FND_DFLEX.DFLEX_R
698: , p_Flexinfo IN FND_DFLEX.DFLEX_DR
699: , p_Context_Code IN
700: FND_DESCR_FLEX_CONTEXTS.DESCRIPTIVE_FLEX_CONTEXT_CODE%TYPE
701: , p_Context_Num IN NUMBER
702: , p_Prefix IN VARCHAR2
703: , p_decode IN BOOLEAN
704: , p_Table_Alias IN VARCHAR2