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_FORMS_UTIL_PVT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 3759: select line_number BULK COLLECT INTO l_line_number from (select line_number, clm_amount line_amount from pon_auction_item_prices_all

3755: AND ag.ATTR_NAME = p_attr_name;
3756:
3757: select attr_group_id into l_attr_grp_id from ego_attr_groups_v where attr_group_name = 'FED_CUST_DESG' and attr_group_type = 'PON_AUC_PRICES_EXT_ATTRS';
3758:
3759: select line_number BULK COLLECT INTO l_line_number from (select line_number, clm_amount line_amount from pon_auction_item_prices_all
3760: where order_type_lookup_code <> 'QUANTITY'
3761: and auction_header_id = p_auction_header_id
3762: and clm_amount is not null
3763: union

Line 3764: select line_number, current_price * quantity line_amount from pon_auction_item_prices_all

3760: where order_type_lookup_code <> 'QUANTITY'
3761: and auction_header_id = p_auction_header_id
3762: and clm_amount is not null
3763: union
3764: select line_number, current_price * quantity line_amount from pon_auction_item_prices_all
3765: where order_type_lookup_code = 'QUANTITY'
3766: and auction_header_id = p_auction_header_id
3767: and current_price is not null)
3768: order by line_amount desc;

Line 3819: 'from pon_auction_item_prices_ext_b paip_ext, pon_auction_Item_prices_all paip '||

3815: select attr_group_id into l_attr_grp_id from ego_attr_groups_v where attr_group_name = 'FED_CUST_DESG' and attr_group_type = 'PON_AUC_PRICES_EXT_ATTRS';
3816: print_error_log('default_sys_field_max_amount ','l_attr_grp_id ' || l_attr_grp_id);
3817:
3818: l_sql := 'select paip_ext.' || l_column_name ||', Sum(paip.clm_amount) amount ' ||
3819: 'from pon_auction_item_prices_ext_b paip_ext, pon_auction_Item_prices_all paip '||
3820: 'where paip_ext.auction_header_id = ' || p_auction_header_id ||
3821: 'and paip_ext.attr_group_id = ' || l_attr_grp_id ||
3822: 'AND paip.auction_header_id = paip_ext.auction_header_id ' ||
3823: 'AND paip_ext.line_number = paip.line_number ' ||

Line 4034: select line_number into l_line_number from pon_auction_item_prices_all

4030: node xmldom.DOMNode;
4031: childNode xmldom.DOMNode;
4032: l_pop_address varchar2(4000);
4033: BEGIN
4034: select line_number into l_line_number from pon_auction_item_prices_all
4035: where auction_header_id = p_auction_header_id AND Nvl(clm_info_flag,'N') = 'N' AND rownum < 2;
4036:
4037: l_ship_addr_xml := get_uda_value(p_attr_group_name => 'SHIP_INFO',
4038: p_attr_name => 'hiddShipAddXml', -- bug 9856935

Line 4095: select line_number into l_line_number from pon_auction_item_prices_all

4091: RETURN VARCHAR2 IS
4092: l_line_number NUMBER;
4093: BEGIN
4094:
4095: select line_number into l_line_number from pon_auction_item_prices_all
4096: where auction_header_id = p_auction_header_id AND Nvl(clm_info_flag,'N') = 'N' AND rownum < 2;
4097: return get_uda_value(p_attr_group_name => 'SHIP_INFO',
4098: p_attr_name => 'hiddenZipCode',
4099: p_attr_group_type => 'PON_AUC_PRICES_EXT_ATTRS',

Line 4118: select line_number into l_line_number from pon_auction_item_prices_all

4114: FUNCTION get_uda_fed_popcountry(p_auction_header_id IN NUMBER)
4115: RETURN VARCHAR2 IS
4116: l_line_number NUMBER;
4117: BEGIN
4118: select line_number into l_line_number from pon_auction_item_prices_all
4119: where auction_header_id = p_auction_header_id AND Nvl(clm_info_flag,'N') = 'N' AND rownum < 2;
4120: return get_uda_value(p_attr_group_name => 'SHIP_INFO',
4121: p_attr_name => 'hiddenCountry',
4122: p_attr_group_type => 'PON_AUC_PRICES_EXT_ATTRS',