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_AUCTION_ITEM_PRICES_ALL

Line 206: pon_auction_item_prices_all paip

202: decode(p_outcome, 'STANDARD', nvl(pbip.quantity, 0), paip.quantity)) *
203: nvl(pbip.bid_currency_price,0)) bid_total
204: INTO v_bid_total
205: FROM pon_bid_item_prices pbip,
206: pon_auction_item_prices_all paip
207: WHERE pbip.auction_header_id = p_auction_header_id AND
208: pbip.bid_number = p_bid_number AND
209: nvl(pbip.has_bid_flag, 'N') = 'Y' AND
210: pbip.auction_header_id = paip.auction_header_id AND

Line 1639: decode(paip.parent_line_number, null,to_char(null),(select paip2.item_description from pon_auction_item_prices_all paip2 where paip2.auction_header_id = paip.auction_header_id and paip2.line_number = paip.parent_line_number)) parent_line_description,

1635: paip.purchase_basis,
1636: pon_auction_pkg.getNeedByDatesToPrint(paip.auction_header_id,paip.line_number,p_date_format) as need_by_dates_to_print,
1637: paip.document_disp_line_number,
1638: paip.group_type,
1639: decode(paip.parent_line_number, null,to_char(null),(select paip2.item_description from pon_auction_item_prices_all paip2 where paip2.auction_header_id = paip.auction_header_id and paip2.line_number = paip.parent_line_number)) parent_line_description,
1640: tl.territory_short_name country_name,
1641: hl.location_code address_name,
1642: hl.address_line_1 address1,
1643: hl.address_line_2 address2,

Line 1693: pon_auction_item_prices_all paip ,

1689: ), NULL) work_approver_name
1690: ,paip.has_quantity_tiers negline_has_quantity_tiers
1691: ,pbip.has_quantity_tiers bidline_has_quantity_tiers
1692: from
1693: pon_auction_item_prices_all paip ,
1694: hr_locations_all hl,
1695: fnd_territories_tl tl,
1696: per_jobs_vl jobs,
1697: icx_cat_categories_v icx,

Line 2101: pon_auction_item_prices_all itm,

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,
2104: pon_pf_supplier_values pf_values,
2105: -- bidpdf: add bid value for cost factor

Line 2241: pon_auction_item_prices_all paip,

2237: decode(p_user_view_type, 'BUYER',pon_printing_pkg.format_price(pbsm.price,l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbsm.bid_currency_price,l_price_mask, l_price_precision)) bid_currency_price,
2238: pbsm.price_type,
2239: pbsm.price_discount
2240: FROM pon_auction_shipments_all pas,
2241: pon_auction_item_prices_all paip,
2242: hr_locations_all loc,
2243: mtl_parameters mp,
2244: -- bidpdf: add response price for price breaks
2245: pon_bid_shipments pbsm

Line 2283: pon_auction_item_prices_all paip,

2279: null bid_currency_price,
2280: null price_type,
2281: null price_discount
2282: FROM pon_auction_shipments_all pas,
2283: pon_auction_item_prices_all paip,
2284: hr_locations_all loc,
2285: mtl_parameters mp
2286: WHERE pas.auction_header_id = pah.auction_header_id
2287: AND l_neg_has_price_breaks = 'Y'

Line 2313: pon_auction_item_prices_all paip,

2309: , null
2310: ) price,
2311: decode(p_user_view_type, 'BUYER',pon_printing_pkg.format_price(pbsm.unit_price,l_price_mask, l_price_precision), pon_printing_pkg.format_price(pbsm.bid_currency_unit_price,l_price_mask, l_price_precision)) bid_currency_unit_price
2312: FROM pon_auction_shipments_all pas,
2313: pon_auction_item_prices_all paip,
2314: pon_bid_shipments pbsm
2315: WHERE pbsm.bid_number = pbhs.bid_number
2316: and pbsm.auction_header_id = pas.auction_header_id(+)
2317: and pbsm.line_number = pas.line_number(+)

Line 2339: pon_auction_item_prices_all paip

2335: l_price_precision
2336: ) price,
2337: null bid_currency_unit_price
2338: FROM pon_auction_shipments_all pas,
2339: pon_auction_item_prices_all paip
2340: WHERE pas.auction_header_id = pah.auction_header_id
2341: AND paip.auction_header_id = pas.auction_header_id
2342: AND paip.line_number = pas.line_number
2343: AND pas.shipment_type = 'QUANTITY BASED'

Line 2640: 'PON_AUCTION_ITEM_PRICES_ALL' as entity_name,

2636: d.file_name file_name,
2637: d.description,
2638: d.title as attachment_title,
2639: d.url,
2640: 'PON_AUCTION_ITEM_PRICES_ALL' as entity_name,
2641: to_char(paip.auction_header_id) pk1_value,
2642: to_char(paip.line_number) pk2_value,
2643: ad.pk3_value,
2644: categories_tl.user_name category_name

Line 2649: pon_auction_item_prices_all paip,

2645: from fnd_documents_vl d,
2646: fnd_attached_documents ad,
2647: fnd_document_categories categories,
2648: fnd_document_categories_tl categories_tl,
2649: pon_auction_item_prices_all paip,
2650: financials_system_params_all fsp
2651: where d.document_id = ad.document_id
2652: and
2653: ad.entity_name = 'MTL_SYSTEM_ITEMS'

Line 2680: ad.entity_name IN ('PON_AUCTION_ITEM_PRICES_ALL',

2676: fnd_document_categories categories,
2677: fnd_document_categories_tl categories_tl
2678: where d.document_id = ad.document_id
2679: and
2680: ad.entity_name IN ('PON_AUCTION_ITEM_PRICES_ALL',
2681: 'PON_AUCTION_HEADERS_ALL')
2682: and ad.pk1_value = to_char(p_auction_header_id)
2683: and (l_is_buyer_negpdf = 'Y' or categories.name='Vendor')
2684: and categories.category_id = d.category_id