16: begin
17: SELECT ag.attr_group_id,
18: efdfce.application_column_name
19: into l_attr_grp_id, l_col_name
20: FROM ego_fnd_dsc_flx_ctx_ext ag,
21: ego_fnd_df_col_usgs_ext efdfce,
22: fnd_descr_flex_column_usages fcu
23: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
24: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
73: begin
74: SELECT ag.attr_group_id,
75: efdfce.application_column_name
76: into l_attr_grp_id, l_col_name
77: FROM ego_fnd_dsc_flx_ctx_ext ag,
78: ego_fnd_df_col_usgs_ext efdfce,
79: fnd_descr_flex_column_usages fcu
80: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
81: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
194: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
195: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
196: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
197: AG.MULTI_ROW MULTI_ROW
198: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
199: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
200: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
201: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
202: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
291: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
292: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
293: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
294: AG.MULTI_ROW MULTI_ROW
295: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
296: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
297: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
298: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
299: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
390: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
391: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
392: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
393: AG.MULTI_ROW MULTI_ROW
394: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
395: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
396: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
397: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
398: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
506: SELECT ag.attr_group_id,
507: efdfce.application_column_name
508: into l_attr_grp_id, l_col_name
509:
510: FROM ego_fnd_dsc_flx_ctx_ext ag,
511: ego_fnd_df_col_usgs_ext efdfce,
512: fnd_descr_flex_column_usages fcu
513:
514: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name