APPS.PON_DATATEMPLATE_PKG dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 11: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_headers_all H,

7: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
8: ATTR_GROUP_ID,
9: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
10: MULTI_ROW
11: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_headers_all H,
12: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
13: WHERE H.auction_header_id = p_auction_header_id
14: AND H.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
15: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID

Line 158: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_item_prices_all L,

154: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
155: ATTR_GROUP_ID,
156: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
157: MULTI_ROW
158: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_item_prices_all L,
159: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
160: WHERE L.auction_header_id = p_auction_header_id
161: AND L.LINE_NUMBER = p_line_id
162: AND L.UDA_TEMPLATE_ID = POT.TEMPLATE_ID

Line 320: FROM ego_fnd_dsc_flx_ctx_ext ag,

316: begin
317: SELECT ag.attr_group_id,
318: efdfce.application_column_name
319: into l_attr_grp_id, l_col_name
320: FROM ego_fnd_dsc_flx_ctx_ext ag,
321: ego_fnd_df_col_usgs_ext efdfce,
322: fnd_descr_flex_column_usages fcu
323: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
324: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code

Line 376: FROM ego_fnd_dsc_flx_ctx_ext ag,

372: begin
373: SELECT ag.attr_group_id,
374: efdfce.application_column_name
375: into l_attr_grp_id, l_col_name
376: FROM ego_fnd_dsc_flx_ctx_ext ag,
377: ego_fnd_df_col_usgs_ext efdfce,
378: fnd_descr_flex_column_usages fcu
379: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
380: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code

Line 456: FROM ego_fnd_dsc_flx_ctx_ext ag,

452: SELECT ag.attr_group_id,
453: efdfce.application_column_name
454: into l_attr_grp_id, l_col_name
455:
456: FROM ego_fnd_dsc_flx_ctx_ext ag,
457: ego_fnd_df_col_usgs_ext efdfce,
458: fnd_descr_flex_column_usages fcu
459:
460: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name