DBA Data[Home] [Help]

APPS.EGO_AG_BULKLOAD_PVT dependencies on EGO_FND_DF_COL_USGS_EXT

Line 2584: ego_fnd_df_col_usgs_ext efdcue

2580: /*Sets the Attr_id for the update and sync flow*/
2581: UPDATE ego_attr_group_cols_intf eagci
2582: SET eagci.attr_id = (SELECT efdcue.attr_id
2583: FROM fnd_descr_flex_column_usages fdfcu,
2584: ego_fnd_df_col_usgs_ext efdcue
2585: WHERE fdfcu.application_id = efdcue.application_id
2586: AND fdfcu.descriptive_flexfield_name = efdcue.descriptive_flexfield_name
2587: AND fdfcu.descriptive_flex_context_code = efdcue.descriptive_flex_context_code
2588: AND fdfcu.application_column_name = efdcue.application_column_name

Line 2895: ego_fnd_df_col_usgs_ext efdcue

2891: /*Sets the Internal Attribute name when then Attr id is given*/
2892: UPDATE ego_attr_group_cols_intf eagci
2893: SET eagci.internal_name = (SELECT fdfcu.end_user_column_name
2894: FROM fnd_descr_flex_column_usages fdfcu,
2895: ego_fnd_df_col_usgs_ext efdcue
2896: WHERE fdfcu.application_id = efdcue.application_id
2897: AND fdfcu.descriptive_flexfield_name = efdcue.descriptive_flexfield_name
2898: AND fdfcu.descriptive_flex_context_code = efdcue.descriptive_flex_context_code
2899: AND fdfcu.application_column_name = efdcue.application_column_name

Line 4208: ego_fnd_df_col_usgs_ext efdcue

4204: BEGIN
4205: SELECT efdcue.attr_id
4206: INTO P_attr_tbl(i).attr_id
4207: FROM fnd_descr_flex_column_usages fdfcu,
4208: ego_fnd_df_col_usgs_ext efdcue
4209: WHERE fdfcu.application_id = efdcue.application_id
4210: AND fdfcu.descriptive_flexfield_name = efdcue.descriptive_flexfield_name
4211: AND fdfcu.descriptive_flex_context_code = efdcue.descriptive_flex_context_code
4212: AND fdfcu.application_column_name = efdcue.application_column_name

Line 6013: ego_fnd_df_col_usgs_ext efdcue

6009: BEGIN
6010: SELECT fdfcu.end_user_column_name
6011: INTO P_attr_tbl(i).internal_name
6012: FROM fnd_descr_flex_column_usages fdfcu,
6013: ego_fnd_df_col_usgs_ext efdcue
6014: WHERE fdfcu.application_id = efdcue.application_id
6015: AND fdfcu.descriptive_flexfield_name = efdcue.descriptive_flexfield_name
6016: AND fdfcu.descriptive_flex_context_code = efdcue.descriptive_flex_context_code
6017: AND fdfcu.application_column_name = efdcue.application_column_name

Line 6533: FROM EGO_FND_DF_COL_USGS_EXT

6529: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_tbl(i).attr_group_name
6530: AND APPLICATION_COLUMN_NAME = p_attr_tbl(i).application_column_name;
6531:
6532: SELECT INFO_1, UOM_CLASS INTO lv_info_1, lv_uom_class
6533: FROM EGO_FND_DF_COL_USGS_EXT
6534: WHERE APPLICATION_ID = G_EGO_APPLICATION_ID
6535: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_tbl(i).attr_group_type
6536: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_tbl(i).attr_group_name
6537: AND APPLICATION_COLUMN_NAME = p_attr_tbl(i).application_column_name;