DBA Data[Home] [Help]

APPS.PO_UDA_TEMPLATES_UTIL dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 2365: FROM FND_DESCR_FLEX_COLUMN_USAGES

2361: ,p_dummy_internal_name IN VARCHAR2
2362: )
2363: IS
2364: SELECT END_USER_COLUMN_NAME
2365: FROM FND_DESCR_FLEX_COLUMN_USAGES
2366: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_real_attr_grp_type
2367: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_dummy_internal_name
2368: AND END_USER_COLUMN_NAME NOT IN
2369: (

Line 2371: FROM FND_DESCR_FLEX_COLUMN_USAGES

2367: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_dummy_internal_name
2368: AND END_USER_COLUMN_NAME NOT IN
2369: (
2370: SELECT END_USER_COLUMN_NAME
2371: FROM FND_DESCR_FLEX_COLUMN_USAGES
2372: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_dummy_attr_grp_type
2373: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_dummy_internal_name
2374: );
2375:

Line 2383: FROM FND_DESCR_FLEX_COLUMN_USAGES

2379: ,p_dummy_internal_name IN VARCHAR2
2380: )
2381: IS
2382: SELECT END_USER_COLUMN_NAME
2383: FROM FND_DESCR_FLEX_COLUMN_USAGES
2384: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_dummy_attr_grp_type
2385: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_dummy_internal_name;
2386:
2387: BEGIN

Line 2586: FND_DESCR_FLEX_COLUMN_USAGES CL,

2582: l_customization_level,
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

Line 2782: FROM FND_DESCR_FLEX_COLUMN_USAGES

2778: END IF;
2779:
2780: SELECT 1
2781: INTO l_present
2782: FROM FND_DESCR_FLEX_COLUMN_USAGES
2783: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_real_attr_grp_type
2784: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_real_internal_name
2785: AND END_USER_COLUMN_NAME = p_attribute_name
2786: AND ROWNUM < 2;

Line 3920: FROM fnd_descr_flex_column_usages fdfcu,

3916:
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