eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_EDA_DATATEMPLATE_PKG dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 270: FROM ego_fnd_dsc_flx_ctx_ext ag,

266: begin
267: SELECT ag.attr_group_id,
268: efdfce.application_column_name
269: into l_attr_grp_id, l_col_name
270: FROM ego_fnd_dsc_flx_ctx_ext ag,
271: ego_fnd_df_col_usgs_ext efdfce,
272: fnd_descr_flex_column_usages fcu
273: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
274: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code

Line 327: FROM ego_fnd_dsc_flx_ctx_ext ag,

323: begin
324: SELECT ag.attr_group_id,
325: efdfce.application_column_name
326: into l_attr_grp_id, l_col_name
327: FROM ego_fnd_dsc_flx_ctx_ext ag,
328: ego_fnd_df_col_usgs_ext efdfce,
329: fnd_descr_flex_column_usages fcu
330: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
331: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code

Line 394: FROM EGO_FND_DSC_FLX_CTX_EXT AG,

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

Line 456: FROM EGO_FND_DSC_FLX_CTX_EXT AG,

452: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
453: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
454: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
455: AG.MULTI_ROW MULTI_ROW
456: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
457: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
458: WHERE POTU.TEMPLATE_ID IN (SELECT DISTINCT UDA_TEMPLATE_ID FROM PO_LINES_MERGE_V WHERE PO_HEADER_ID = DOCUMENTID AND
459: DRAFT_ID=DRAFTID)
460: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID

Line 530: FROM EGO_FND_DSC_FLX_CTX_EXT AG,

526: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
527: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
528: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
529: AG.MULTI_ROW MULTI_ROW
530: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
531: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
532: WHERE POTU.TEMPLATE_ID IN
533: (SELECT DISTINCT UDA_TEMPLATE_ID FROM PO_LINE_LOCATIONS_MERGE_V WHERE PO_HEADER_ID =DOCUMENTID AND DRAFT_ID = DRAFTID)
534: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID

Line 646: FROM ego_fnd_dsc_flx_ctx_ext ag,

642: SELECT ag.attr_group_id,
643: efdfce.application_column_name
644: into l_attr_grp_id, l_col_name
645:
646: FROM ego_fnd_dsc_flx_ctx_ext ag,
647: ego_fnd_df_col_usgs_ext efdfce,
648: fnd_descr_flex_column_usages fcu
649:
650: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name

Line 2499: FROM ego_fnd_dsc_flx_ctx_ext ag,

2495: WITH temp AS (SELECT ag.attr_group_id gid,
2496: decode(upper(fcu.end_user_column_name),upper('addressdtlsxml'),efdfce.application_column_name,null) addressxml,
2497: decode(upper(fcu.end_user_column_name),upper('addresstype'),efdfce.application_column_name,null) addresstype,
2498: decode(upper(fcu.end_user_column_name),upper('contactdtlsxml'),efdfce.application_column_name,null) contacts
2499: FROM ego_fnd_dsc_flx_ctx_ext ag,
2500: ego_fnd_df_col_usgs_ext efdfce,
2501: fnd_descr_flex_column_usages fcu
2502: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
2503: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code