[Home] [Help]
6: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
7: ATTR_GROUP_ID,
8: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
9: MULTI_ROW
10: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_headers_all H,
11: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
12: WHERE H.auction_header_id = p_auction_header_id
13: AND H.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
14: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
162: begin
163: SELECT ag.attr_group_id,
164: efdfce.application_column_name
165: into l_attr_grp_id, l_col_name
166: FROM ego_fnd_dsc_flx_ctx_ext ag,
167: ego_fnd_df_col_usgs_ext efdfce,
168: fnd_descr_flex_column_usages fcu
169: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
170: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
218: begin
219: SELECT ag.attr_group_id,
220: efdfce.application_column_name
221: into l_attr_grp_id, l_col_name
222: FROM ego_fnd_dsc_flx_ctx_ext ag,
223: ego_fnd_df_col_usgs_ext efdfce,
224: fnd_descr_flex_column_usages fcu
225: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
226: and efdfce.descriptive_flex_context_code = ag.descriptive_flex_context_code
263: SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
264: ATTR_GROUP_ID,
265: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
266: MULTI_ROW
267: FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_item_prices_all L,
268: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
269: WHERE L.auction_header_id = p_auction_header_id
270: AND L.LINE_NUMBER = p_line_id
271: AND L.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
430: SELECT ag.attr_group_id,
431: efdfce.application_column_name
432: into l_attr_grp_id, l_col_name
433:
434: FROM ego_fnd_dsc_flx_ctx_ext ag,
435: ego_fnd_df_col_usgs_ext efdfce,
436: fnd_descr_flex_column_usages fcu
437:
438: WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name