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.

APPS.PON_DATATEMPLATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 7


SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
ATTR_GROUP_ID,
      AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
MULTI_ROW
FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_headers_all H,
PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
WHERE H.auction_header_id = p_auction_header_id
AND H.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
AND AG.ATTR_GROUP_ID  = POTU.ATTRIBUTE_GROUP_ID
and POTU.attribute_group_id in (select distinct attr_group_id from PON_AUCTION_HEADERS_EXT_B
                                  where AUCTION_HEADER_ID = H.auction_header_id and attr_group_id = POTU.attribute_group_id)

ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line: 24


SELECT   EFDFCE.ATTR_ID                ,
  EFDFCE.APPLICATION_COLUMN_NAME      ,
  FCU.END_USER_COLUMN_NAME,
  fcu.flex_value_set_id,
     EFDFCE.data_type
   FROM
  EGO_FND_DF_COL_USGS_EXT EFDFCE
       , FND_DESCR_FLEX_COLUMN_USAGES FCU
  WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE  = P_ATTR_GROUP
       AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE =
EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
       AND FCU.DESCRIPTIVE_FLEXFIELD_NAME =
EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
       AND FCU.APPLICATION_COLUMN_NAME = EFDFCE.APPLICATION_COLUMN_NAME
       AND FCU.DISPLAY_FLAG <> 'H';

Line: 67


      L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
|| '", XMLAgg(XMLForest(' ;

Line: 70


      L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '",
XMLAgg(XMLForest(';

Line: 75


      L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
|| '", XMLForest(' ;

Line: 78


      L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLForest(';

Line: 144


l_op := ' select XMLConcat(' || l_sql || ') from dual';

Line: 154


SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP, AG.ATTR_GROUP_ID
ATTR_GROUP_ID,
      AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
MULTI_ROW
FROM EGO_FND_DSC_FLX_CTX_EXT AG, pon_auction_item_prices_all L,
PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
WHERE L.auction_header_id = p_auction_header_id
AND L.LINE_NUMBER = p_line_id
AND L.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
AND AG.ATTR_GROUP_ID  = POTU.ATTRIBUTE_GROUP_ID
and potu.attribute_group_id in (select distinct attr_group_id from PON_AUCTION_ITEM_PRICES_EXT_B
                                  where AUCTION_HEADER_ID = L.auction_header_id and LINE_NUMBER=L.LINE_NUMBER and  attr_group_id = potu.attribute_group_id)
ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line: 171


SELECT   EFDFCE.ATTR_ID                ,
  EFDFCE.APPLICATION_COLUMN_NAME      ,
  FCU.END_USER_COLUMN_NAME ,
     fcu.flex_value_set_id,
     EFDFCE.data_type

   FROM
  EGO_FND_DF_COL_USGS_EXT EFDFCE
       , FND_DESCR_FLEX_COLUMN_USAGES FCU
  WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE  = P_ATTR_GROUP
       AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE =
EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
       AND FCU.DESCRIPTIVE_FLEXFIELD_NAME =
EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
       AND FCU.APPLICATION_COLUMN_NAME = EFDFCE.APPLICATION_COLUMN_NAME
       AND FCU.DISPLAY_FLAG <> 'H';

Line: 216


      L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
|| '", XMLAgg(XMLForest(' ;

Line: 219


      L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '",
XMLAgg(XMLForest(';

Line: 224


      L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
|| '", XMLForest(' ;

Line: 227


      L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLForest(';

Line: 298


l_op := ' select XMLConcat(' || l_sql || ') from dual';

Line: 317


			SELECT 	ag.attr_group_id,
							efdfce.application_column_name
			into   l_attr_grp_id, l_col_name
			FROM ego_fnd_dsc_flx_ctx_ext ag,
					 ego_fnd_df_col_usgs_ext efdfce,
					 fnd_descr_flex_column_usages fcu
			WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
			and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
			and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
			and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
			and fcu.application_column_name = efdfce.application_column_name
			and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PON_AUC_HDRS_EXT_ATTRS'
			and upper(ag.descriptive_flex_context_code) = upper('addresses')
			and upper(fcu.end_user_column_name) = upper('addressdtlsxml');

Line: 334


			l_addr_sql := 'select ' || l_col_name || ' as address ' ;

Line: 373


			SELECT 	ag.attr_group_id,
							efdfce.application_column_name
			into   l_attr_grp_id, l_col_name
			FROM ego_fnd_dsc_flx_ctx_ext ag,
					 ego_fnd_df_col_usgs_ext efdfce,
					 fnd_descr_flex_column_usages fcu
			WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
			and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
			and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
			and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
			and fcu.application_column_name = efdfce.application_column_name
			and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PON_AUC_HDRS_EXT_ATTRS'
			and upper(ag.descriptive_flex_context_code) = upper('addresses')
			and upper(fcu.end_user_column_name) = upper('contactdtlsxml');

Line: 390


			l_cnt_sql := 'select ' || l_col_name || ' as contacts ' ;

Line: 452


			SELECT 	ag.attr_group_id,
				efdfce.application_column_name
				into   l_attr_grp_id, l_col_name

				FROM ego_fnd_dsc_flx_ctx_ext ag,
					 ego_fnd_df_col_usgs_ext efdfce,
					 fnd_descr_flex_column_usages fcu

			WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
			and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
			and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
			and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
			and fcu.application_column_name = efdfce.application_column_name
			and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PON_AUC_PRICES_EXT_ATTRS'
			and upper(ag.descriptive_flex_context_code) = upper('SHIP_INFO')
			and upper(fcu.end_user_column_name) = upper('hiddShipAddXml');

Line: 471


			l_addr_sql := 'select ' || l_col_name || ' as ship_address ' ;

Line: 486


		select '' into clob_addr from dual;

Line: 499


select a.database_column, av.attr_group_id into fob_db_col, l_attr_group_id
from ego_attrs_v a, ego_attr_groups_v av
where a.attr_group_type like 'PON_AUC_PRICES_EXT_ATTRS'
      and a.attr_group_name like 'SHIP_INFO'
      and a.attr_name like 'FOB'
      and av.attr_group_type = a.attr_group_type
      and av.attr_group_name = a.attr_group_name;

Line: 507


l_fobsql := 'select count(extension_id) from pon_auction_item_prices_ext_b where auction_header_id =:1 and attr_group_id = :2 and nvl(' || fob_db_col || ', ''N'') <> ''DEST''';