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 2199: pon_large_neg_pf_values.supplier_seq_number,

2195: AND fl.lookup_type = 'PON_PRICING_BASIS'
2196: ORDER BY name, pricing_basis_meaning) as DISTINCT_BUYER_PFS,
2197: cursor (
2198: select
2199: pon_large_neg_pf_values.supplier_seq_number,
2200: priceelementtypesvl.name||'('||lookuptable.meaning||')' pf_name,
2201: pon_large_neg_pf_values.value
2202: from
2203: pon_large_neg_pf_values pon_large_neg_pf_values,

Line 2201: pon_large_neg_pf_values.value

2197: cursor (
2198: select
2199: pon_large_neg_pf_values.supplier_seq_number,
2200: priceelementtypesvl.name||'('||lookuptable.meaning||')' pf_name,
2201: pon_large_neg_pf_values.value
2202: from
2203: pon_large_neg_pf_values pon_large_neg_pf_values,
2204: pon_price_element_types_vl priceelementtypesvl,
2205: fnd_lookups lookuptable

Line 2203: pon_large_neg_pf_values pon_large_neg_pf_values,

2199: pon_large_neg_pf_values.supplier_seq_number,
2200: priceelementtypesvl.name||'('||lookuptable.meaning||')' pf_name,
2201: pon_large_neg_pf_values.value
2202: from
2203: pon_large_neg_pf_values pon_large_neg_pf_values,
2204: pon_price_element_types_vl priceelementtypesvl,
2205: fnd_lookups lookuptable
2206: WHERE pon_large_neg_pf_values.auction_header_id = pah.auction_header_id
2207: and pah.large_neg_enabled_flag = 'Y'

Line 2206: WHERE pon_large_neg_pf_values.auction_header_id = pah.auction_header_id

2202: from
2203: pon_large_neg_pf_values pon_large_neg_pf_values,
2204: pon_price_element_types_vl priceelementtypesvl,
2205: fnd_lookups lookuptable
2206: WHERE pon_large_neg_pf_values.auction_header_id = pah.auction_header_id
2207: and pah.large_neg_enabled_flag = 'Y'
2208: AND l_is_buyer_negpdf = 'Y'
2209: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
2210: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis

Line 2209: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id

2205: fnd_lookups lookuptable
2206: WHERE pon_large_neg_pf_values.auction_header_id = pah.auction_header_id
2207: and pah.large_neg_enabled_flag = 'Y'
2208: AND l_is_buyer_negpdf = 'Y'
2209: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
2210: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis
2211: AND lookuptable.lookup_type = 'PON_PRICING_BASIS'
2212: AND pon_large_neg_pf_values.value is not null
2213: order by pon_large_neg_pf_values.supplier_seq_number,pf_name) as LARGE_NEG_BUYER_PF_VALUES,

Line 2210: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis

2206: WHERE pon_large_neg_pf_values.auction_header_id = pah.auction_header_id
2207: and pah.large_neg_enabled_flag = 'Y'
2208: AND l_is_buyer_negpdf = 'Y'
2209: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
2210: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis
2211: AND lookuptable.lookup_type = 'PON_PRICING_BASIS'
2212: AND pon_large_neg_pf_values.value is not null
2213: order by pon_large_neg_pf_values.supplier_seq_number,pf_name) as LARGE_NEG_BUYER_PF_VALUES,
2214: CURSOR (

Line 2212: AND pon_large_neg_pf_values.value is not null

2208: AND l_is_buyer_negpdf = 'Y'
2209: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
2210: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis
2211: AND lookuptable.lookup_type = 'PON_PRICING_BASIS'
2212: AND pon_large_neg_pf_values.value is not null
2213: order by pon_large_neg_pf_values.supplier_seq_number,pf_name) as LARGE_NEG_BUYER_PF_VALUES,
2214: CURSOR (
2215: (
2216: SELECT pbsm.auction_header_id,

Line 2213: order by pon_large_neg_pf_values.supplier_seq_number,pf_name) as LARGE_NEG_BUYER_PF_VALUES,

2209: AND priceelementtypesvl.price_element_type_id = pon_large_neg_pf_values.price_element_type_id
2210: AND lookuptable.lookup_code = pon_large_neg_pf_values.pricing_basis
2211: AND lookuptable.lookup_type = 'PON_PRICING_BASIS'
2212: AND pon_large_neg_pf_values.value is not null
2213: order by pon_large_neg_pf_values.supplier_seq_number,pf_name) as LARGE_NEG_BUYER_PF_VALUES,
2214: CURSOR (
2215: (
2216: SELECT pbsm.auction_header_id,
2217: pbsm.line_number,