DBA Data[Home] [Help]

APPS.PON_PRINTING_PKG dependencies on PON_BID_SHIPMENTS

Line 2245: pon_bid_shipments pbsm

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
2246: WHERE pbsm.bid_number = pbhs.bid_number
2247: and pbsm.auction_header_id = pas.auction_header_id(+)
2248: and pbsm.line_number = pas.line_number(+)
2249: and pbsm.auction_shipment_number = pas.shipment_number(+)

Line 2314: pon_bid_shipments pbsm

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(+)
2318: and pbsm.auction_shipment_number = pas.shipment_number(+)