[Home] [Help]
2095: decode(pe.display_to_suppliers_flag,
2096: 'N', 'N',
2097: PON_TRANSFORM_BIDDING_PKG.has_pf_values_defined(pe.auction_header_id, pe.line_number, pe.sequence_number, p_trading_partner_id, p_vendor_site_id, p_requested_supplier_id)))) can_view_pf_flag
2098: FROM
2099: pon_price_elements pe,
2100: pon_price_element_types_tl pet,
2101: pon_auction_item_prices_all itm,
2102: fnd_lookup_values flv,
2103: fnd_lookup_values flv2,
2163: pf_values.value,
2164: pfs.price_element_type_id,
2165: pfs.pricing_basis
2166: FROM
2167: pon_price_elements pfs,
2168: pon_pf_supplier_values pf_values
2169: WHERE
2170: pf_values.auction_header_id = pah.auction_header_id
2171: AND pah.large_neg_enabled_flag = 'N'
2180: ppe.pricing_basis,
2181: ppett.name,
2182: fl.meaning as pricing_basis_meaning
2183: FROM
2184: pon_price_elements ppe,
2185: pon_price_element_types_tl ppett,
2186: fnd_lookups fl
2187: WHERE
2188: ppe.auction_header_id = pah.auction_header_id