APPS.PON_SUPPLIER_RESEARCH_PVT dependencies on PON_BIDDING_PARTIES

Line 47: FROM pon_bidding_parties pbp,

43: -- Fetch the total invited negotiations
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

Line 88: pon_bidding_parties pbp

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
92: AND pah.auction_status IN ('ACTIVE', 'AUCTION_CLOSED')

Line 137: FROM pon_bidding_parties pbp

133: AND pah.auction_status IN ('ACTIVE', 'AUCTION_CLOSED')
134: AND NVL(pah.is_template_flag, 'N') = 'N'
135: AND pbh.auction_header_id NOT IN -- invited parties list
136: ( SELECT pbp.auction_header_id
137: FROM pon_bidding_parties pbp
138: WHERE pbh.trading_partner_id = pbp.trading_partner_id
139: AND pbp.list_id = -1)
140: AND pbh.creation_date >= ADD_MONTHS(TRUNC(SYSDATE), -(l_txn_history_range_in_months));
141:

Line 490: -- Fetch total invited negotiations from pon bidding parties.

486:
487: -- Fetch the profile value for data range in months.
488: l_txn_history_range_in_months := get_txn_history_range_profile;
489:
490: -- Fetch total invited negotiations from pon bidding parties.
491: l_total_invited := get_total_invited_negotiations (p_tp_id,
492: l_txn_history_range_in_months);
493:
494: -- Fetch the total Invited responses to negotiations for a given supplier.