APPS.PON_SUPPLIER_RESEARCH_PVT dependencies on PON_AUCTION_HEADERS

Line 48: pon_auction_headers pah

44: -- The negotiations that have an auction status as 'Amended' are not to be counted.
45: SELECT COUNT(DISTINCT pbp.auction_header_id ) total_invited
46: INTO l_tot_inv
47: FROM pon_bidding_parties pbp,
48: pon_auction_headers pah
49: WHERE pbp.list_id = -1
50: AND pbp.trading_partner_id = p_tp_id
51: AND pah.auction_header_id = pbp.auction_header_id
52: AND pah.auction_status IN ('ACTIVE', 'AUCTION_CLOSED')

Line 87: pon_auction_headers pah,

83: -- i.e. The Supplier was been invited, and has atleast one response.
84: SELECT COUNT( DISTINCT(pbh.auction_header_id)) total_invited
85: INTO l_tot_inv
86: FROM pon_bid_headers pbh,
87: pon_auction_headers pah,
88: pon_bidding_parties pbp
89: WHERE pbh.trading_partner_id = p_tp_id
90: AND pbh. bid_status IN ('ACTIVE')
91: AND pah.auction_header_id = pbh.auction_header_id

Line 129: pon_auction_headers pah

125: -- i.e. The Supplier was not invited, but has atleast one response.
126: SELECT COUNT( DISTINCT(pbh.auction_header_id)) total_uninvited
127: INTO l_tot_uninv
128: FROM pon_bid_headers pbh,
129: pon_auction_headers pah
130: WHERE pbh.trading_partner_id = p_tp_id
131: AND bid_status IN ('ACTIVE')
132: AND pah.auction_header_id = pbh.auction_header_id
133: AND pah.auction_status IN ('ACTIVE', 'AUCTION_CLOSED')

Line 172: pon_auction_headers pah

168: -- Count the Negotiations that have atleast one bid got awarded/partially awarded.
169: SELECT COUNT(DISTINCT pbh.auction_header_id) total_awarded
170: INTO l_tot_awd
171: FROM pon_bid_headers pbh,
172: pon_auction_headers pah
173: WHERE pbh.trading_partner_id = p_tp_id
174: AND pah.auction_header_id = pbh.auction_header_id
175: AND pah.auction_status IN ('ACTIVE', 'AUCTION_CLOSED')
176: AND NVL(pah.is_template_flag, 'N') = 'N'