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_PRINTING_PKG dependencies on PON_LARGE_NEG_PF_VALUES

Line 4059: pon_large_neg_pf_values.supplier_seq_number,

4055:
4056:
4057: OPEN large_neg_bur_pf_cursor FOR
4058: select
4059: pon_large_neg_pf_values.supplier_seq_number,
4060: priceelementtypesvl.name||'('||lookuptable.meaning||')' pf_name,
4061: pon_large_neg_pf_values.value
4062: from
4063: pon_auction_headers_all pah,

Line 4061: pon_large_neg_pf_values.value

4057: OPEN large_neg_bur_pf_cursor FOR
4058: select
4059: pon_large_neg_pf_values.supplier_seq_number,
4060: priceelementtypesvl.name||'('||lookuptable.meaning||')' pf_name,
4061: pon_large_neg_pf_values.value
4062: from
4063: pon_auction_headers_all pah,
4064: pon_large_neg_pf_values pon_large_neg_pf_values,
4065: pon_price_element_types_vl priceelementtypesvl,

Line 4064: pon_large_neg_pf_values pon_large_neg_pf_values,

4060: priceelementtypesvl.name||'('||lookuptable.meaning||')' pf_name,
4061: pon_large_neg_pf_values.value
4062: from
4063: pon_auction_headers_all pah,
4064: pon_large_neg_pf_values pon_large_neg_pf_values,
4065: pon_price_element_types_vl priceelementtypesvl,
4066: fnd_lookups lookuptable
4067: WHERE pah.auction_header_id = p_auction_header_id
4068: AND pon_large_neg_pf_values.auction_header_id = pah.auction_header_id

Line 4068: AND pon_large_neg_pf_values.auction_header_id = pah.auction_header_id

4064: pon_large_neg_pf_values pon_large_neg_pf_values,
4065: pon_price_element_types_vl priceelementtypesvl,
4066: fnd_lookups lookuptable
4067: WHERE pah.auction_header_id = p_auction_header_id
4068: AND pon_large_neg_pf_values.auction_header_id = pah.auction_header_id
4069: and pah.large_neg_enabled_flag = 'Y'
4070: AND l_is_buyer_negpdf = 'Y'
4071: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
4072: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis

Line 4071: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id

4067: WHERE pah.auction_header_id = p_auction_header_id
4068: AND pon_large_neg_pf_values.auction_header_id = pah.auction_header_id
4069: and pah.large_neg_enabled_flag = 'Y'
4070: AND l_is_buyer_negpdf = 'Y'
4071: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
4072: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis
4073: AND lookuptable.lookup_type = 'PON_PRICING_BASIS'
4074: AND pon_large_neg_pf_values.value is not null
4075: order by pon_large_neg_pf_values.supplier_seq_number,pf_name;

Line 4072: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis

4068: AND pon_large_neg_pf_values.auction_header_id = pah.auction_header_id
4069: and pah.large_neg_enabled_flag = 'Y'
4070: AND l_is_buyer_negpdf = 'Y'
4071: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
4072: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis
4073: AND lookuptable.lookup_type = 'PON_PRICING_BASIS'
4074: AND pon_large_neg_pf_values.value is not null
4075: order by pon_large_neg_pf_values.supplier_seq_number,pf_name;
4076:

Line 4074: AND pon_large_neg_pf_values.value is not null

4070: AND l_is_buyer_negpdf = 'Y'
4071: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
4072: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis
4073: AND lookuptable.lookup_type = 'PON_PRICING_BASIS'
4074: AND pon_large_neg_pf_values.value is not null
4075: order by pon_large_neg_pf_values.supplier_seq_number,pf_name;
4076:
4077: BEGIN
4078: queryCtx := DBMS_XMLGEN.newContext(large_neg_bur_pf_cursor);

Line 4075: order by pon_large_neg_pf_values.supplier_seq_number,pf_name;

4071: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
4072: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis
4073: AND lookuptable.lookup_type = 'PON_PRICING_BASIS'
4074: AND pon_large_neg_pf_values.value is not null
4075: order by pon_large_neg_pf_values.supplier_seq_number,pf_name;
4076:
4077: BEGIN
4078: queryCtx := DBMS_XMLGEN.newContext(large_neg_bur_pf_cursor);
4079: DBMS_XMLGEN.SetRowSetTag(queryCtx, 'LARGE_NEG_BUYER_PF_VALUES');