DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on EGO_FND_DF_COL_USGS_EXT

Line 2587: EGO_FND_DF_COL_USGS_EXT EG

2583: l_owner,
2584: l_lud
2585: FROM FND_DESCR_FLEX_COL_USAGE_TL TL,
2586: FND_DESCR_FLEX_COLUMN_USAGES CL,
2587: EGO_FND_DF_COL_USGS_EXT EG
2588: WHERE CL.APPLICATION_ID = p_glb_application_id
2589: AND EG.APPLICATION_ID = CL.APPLICATION_ID
2590: AND EG.DESCRIPTIVE_FLEXFIELD_NAME = CL.DESCRIPTIVE_FLEXFIELD_NAME
2591: AND EG.DESCRIPTIVE_FLEX_CONTEXT_CODE = CL.DESCRIPTIVE_FLEX_CONTEXT_CODE

Line 3621: FROM ego_fnd_dsc_flx_ctx_ext efdfce , ego_fnd_df_col_usgs_ext efdcue

3617: and a.multi_row = 'N';
3618:
3619: CURSOR l_uda_attr_col_name(p_attr_grp_id NUMBER, p_entity_code VARCHAR2) IS
3620: SELECT efdcue.APPLICATION_COLUMN_NAME AS APPLICATION_COLUMN_NAME
3621: FROM ego_fnd_dsc_flx_ctx_ext efdfce , ego_fnd_df_col_usgs_ext efdcue
3622: WHERE ATTR_GROUP_ID = p_attr_grp_id
3623: AND efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = efdcue.DESCRIPTIVE_FLEX_CONTEXT_CODE
3624: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME <> 'PO_UDA_DUMMY_EXT_ATTRS'
3625: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME = p_entity_code;

Line 3794: FROM ego_fnd_dsc_flx_ctx_ext efdfce , ego_fnd_df_col_usgs_ext efdcue

3790: AND b.template_id = u.template_id;
3791:
3792: CURSOR l_uda_attr_col_name(p_attr_grp_id NUMBER, p_entity_code VARCHAR2) IS
3793: SELECT efdcue.APPLICATION_COLUMN_NAME AS APPLICATION_COLUMN_NAME
3794: FROM ego_fnd_dsc_flx_ctx_ext efdfce , ego_fnd_df_col_usgs_ext efdcue
3795: WHERE ATTR_GROUP_ID = p_attr_grp_id
3796: AND efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = efdcue.DESCRIPTIVE_FLEX_CONTEXT_CODE
3797: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME = p_entity_code
3798: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME <> 'PO_UDA_DUMMY_EXT_ATTRS';

Line 3921: ego_fnd_df_col_usgs_ext efdcue,

3917: CURSOR l_attr_disp_col_name IS
3918: select fdfcu.APPLICATION_COLUMN_NAME AS APPLICATION_COLUMN_NAME, fdfcu.END_USER_COLUMN_NAME AS END_USER_COLUMN_NAME,
3919: efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE AS AG_internal_name
3920: FROM fnd_descr_flex_column_usages fdfcu,
3921: ego_fnd_df_col_usgs_ext efdcue,
3922: ego_fnd_dsc_flx_ctx_ext efdfce
3923: where efdfce.ATTR_GROUP_ID = P_ATTR_GRP_ID
3924: AND efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = fdfcu.DESCRIPTIVE_FLEX_CONTEXT_CODE
3925: AND fdfcu.DESCRIPTIVE_FLEX_CONTEXT_CODE = efdcue.DESCRIPTIVE_FLEX_CONTEXT_CODE