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 1887: CURSOR line_num_cur IS (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id);

1883: itempdiffsCtx DBMS_XMLGEN.ctxHandle;
1884: quanTiersCtx DBMS_XMLGEN.ctxHandle;
1885: pfCtx DBMS_XMLGEN.ctxHandle;
1886:
1887: CURSOR line_num_cur IS (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_header_id = p_auction_header_id);
1888: line_num NUMBER;
1889:
1890: BEGIN
1891: IF p_bid_number <= 0 THEN

Line 2784: 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,

2780: paip.purchase_basis,
2781: pon_auction_pkg.getNeedByDatesToPrint(paip.auction_header_id,paip.line_number,p_date_format) as need_by_dates_to_print,
2782: paip.document_disp_line_number,
2783: paip.group_type,
2784: 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,
2785: tl.territory_short_name country_name,
2786: hl.location_code address_name,
2787: hl.address_line_1 address1,
2788: hl.address_line_2 address2,

Line 2838: pon_auction_item_prices_all paip ,

2834: ), NULL) work_approver_name
2835: ,paip.has_quantity_tiers negline_has_quantity_tiers
2836: ,pbip.has_quantity_tiers bidline_has_quantity_tiers
2837: from
2838: pon_auction_item_prices_all paip ,
2839: hr_locations_all hl,
2840: fnd_territories_tl tl,
2841: per_jobs_vl jobs,
2842: icx_cat_categories_v icx,

Line 3211: pon_auction_item_prices_all itm,

3207: FROM
3208: pon_auction_headers_all pah,
3209: pon_price_elements pe,
3210: pon_price_element_types_tl pet,
3211: pon_auction_item_prices_all itm,
3212: fnd_lookup_values flv,
3213: fnd_lookup_values flv2,
3214: pon_pf_supplier_values pf_values,
3215: -- bidpdf: add bid value for cost factor

Line 3320: pon_auction_item_prices_all paip,

3316: 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,
3317: pbsm.price_type,
3318: pbsm.price_discount
3319: FROM pon_auction_shipments_all pas,
3320: pon_auction_item_prices_all paip,
3321: hr_locations_all loc,
3322: mtl_parameters mp,
3323: -- bidpdf: add response price for price breaks
3324: pon_bid_shipments pbsm

Line 3361: pon_auction_item_prices_all paip,

3357: null bid_currency_price,
3358: null price_type,
3359: null price_discount
3360: FROM pon_auction_shipments_all pas,
3361: pon_auction_item_prices_all paip,
3362: hr_locations_all loc,
3363: mtl_parameters mp
3364: WHERE pas.auction_header_id = p_auction_header_id
3365: AND pas.line_number = line_num

Line 3441: pon_auction_item_prices_all paip,

3437: , null
3438: ) price,
3439: 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
3440: FROM pon_auction_shipments_all pas,
3441: pon_auction_item_prices_all paip,
3442: pon_bid_shipments pbsm
3443: WHERE pbsm.bid_number = p_bid_number
3444: AND pbsm.line_number = line_num
3445: and pbsm.auction_header_id = pas.auction_header_id(+)

Line 3466: pon_auction_item_prices_all paip

3462: l_price_precision
3463: ) price,
3464: null bid_currency_unit_price
3465: FROM pon_auction_shipments_all pas,
3466: pon_auction_item_prices_all paip
3467: WHERE pas.auction_header_id = p_auction_header_id
3468: AND pas.line_number = line_num
3469: AND paip.auction_header_id = pas.auction_header_id
3470: AND paip.line_number = pas.line_number

Line 4223: 'PON_AUCTION_ITEM_PRICES_ALL' as entity_name,

4219: d.file_name file_name,
4220: d.description,
4221: d.title as attachment_title,
4222: d.url,
4223: 'PON_AUCTION_ITEM_PRICES_ALL' as entity_name,
4224: to_char(paip.auction_header_id) pk1_value,
4225: to_char(paip.line_number) pk2_value,
4226: ad.pk3_value,
4227: categories_tl.user_name category_name

Line 4233: pon_auction_item_prices_all paip,

4229: fnd_documents_vl d,
4230: fnd_attached_documents ad,
4231: fnd_document_categories categories,
4232: fnd_document_categories_tl categories_tl,
4233: pon_auction_item_prices_all paip,
4234: financials_system_params_all fsp
4235: where d.document_id = ad.document_id
4236: and
4237: ad.entity_name = 'MTL_SYSTEM_ITEMS'

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

4261: fnd_document_categories categories,
4262: fnd_document_categories_tl categories_tl
4263: where d.document_id = ad.document_id
4264: and
4265: ad.entity_name IN ('PON_AUCTION_ITEM_PRICES_ALL',
4266: 'PON_AUCTION_HEADERS_ALL')
4267: and ad.pk1_value = to_char(p_auction_header_id)
4268: and (l_is_buyer_negpdf = 'Y' or categories.name='Vendor')
4269: and categories.category_id = d.category_id