APPS.PON_CONSOLE_PVT dependencies on PON_BID_HEADERS

Line 907: FROM pon_bid_headers bh

903:
904:
905: SELECT MIN(bh.publish_date)
906: INTO l_graph_start_date
907: FROM pon_bid_headers bh
908: WHERE bh.auction_header_id = p_auction_header_id
909: AND bh.bid_status IN ('ACTIVE', 'ARCHIVED');
910:
911: -- If no bids were available for the context, then let the caller know

Line 1094: FROM pon_bid_headers bh

1090: SELECT bh.trading_partner_id,
1091: bh.trading_partner_contact_id,
1092: bh.vendor_site_id,
1093: MAX(bid_number)
1094: FROM pon_bid_headers bh
1095: WHERE bh.auction_header_id = p_auction_header_id
1096: GROUP BY
1097: bh.trading_partner_id,
1098: bh.trading_partner_contact_id,

Line 1134: UPDATE pon_bid_headers bh

1130: -- site_id is -1 if it is not there - hence no nvl
1131: -- last_update_login field is missing in the table. Add the update to
1132: -- that column after the column is introduced
1133:
1134: UPDATE pon_bid_headers bh
1135: SET bh.color_sequence_id = l_color_sequence_id,
1136: bh.last_update_date = sysdate,
1137: bh.last_updated_by = fnd_global.user_id
1138: WHERE bh.trading_partner_id = c.trading_partner_id

Line 1514: FROM pon_bid_headers bh,

1510: nvl(bl.quantity,nvl(ai.quantity,1)) bid_quantity,
1511: ai.current_price,
1512: nvl(ai.quantity,1) auction_qty
1513: BULK COLLECT INTO l_line_number_tbl, l_bid_price_tbl, l_bid_qty_tbl, l_current_price_tbl, l_auction_qty_tbl
1514: FROM pon_bid_headers bh,
1515: pon_bid_item_prices bl,
1516: pon_auction_headers_all ah,
1517: pon_auction_item_prices_all ai
1518: WHERE ah.auction_header_id = bh.auction_header_id