DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_BID_SHIPMENTS

Line 3324: pon_bid_shipments pbsm

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
3325: WHERE pbsm.bid_number = p_bid_number
3326: AND pbsm.line_number = line_num
3327: and pbsm.auction_header_id = pas.auction_header_id(+)
3328: and pbsm.line_number = pas.line_number(+)

Line 3442: pon_bid_shipments pbsm

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(+)
3446: and pbsm.line_number = pas.line_number(+)