DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on POS_CONTACT_REQUESTS

Line 244: pos_contact_requests pcr

240: pbp.requested_supp_contact_name,
241: pcr.email_address rs_contact_email
242: -- lxchen
243: from pon_bidding_parties pbp,
244: pos_contact_requests pcr
245: where pbp.auction_header_id = x_auction_header_id and
246: pbp.requested_supplier_contact_id = pcr.contact_request_id (+)
247: union
248: select distinct trading_partner_name,

Line 4353: from pon_bidding_parties pbp, pos_contact_requests pcr

4349: pbp.vendor_site_id,
4350: pbp.requested_supplier_id,
4351: pbp.requested_supplier_contact_id,
4352: pcr.email_address rs_contact_email
4353: from pon_bidding_parties pbp, pos_contact_requests pcr
4354: where pbp.auction_header_id = x_auction_header_id
4355: and pbp.requested_supplier_contact_id = pcr.contact_request_id (+);
4356:
4357: CURSOR c_user_name IS

Line 7232: pos_contact_requests pcr

7228: pbp.requested_supplier_contact_id,
7229: pbp.requested_supp_contact_name,
7230: pcr.email_address rs_contact_email
7231: from pon_bidding_parties pbp,
7232: pos_contact_requests pcr
7233: where auction_header_id = x_auction_header_id
7234: and pbp.requested_supplier_contact_id = pcr.contact_request_id(+)
7235: and wf_item_key IS NULL;
7236: