eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_PKG dependencies on HZ_PARTIES

Line 1440: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt

1436: hz.person_first_name || ' ' || hz.person_last_name,
1437: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 7), 1, nvl(view_by_date, open_bidding_date)+3,
1438: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 1), 1, nvl(view_by_date, open_bidding_date) + 1,
1439: nvl(view_by_date, open_bidding_date) + 1/24)) reminder_time
1440: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt
1441: where hz.party_id = auh.trading_partner_contact_id
1442: and auh.doctype_id = dt.doctype_id
1443: and auction_header_id = p_auction_header_id;
1444: BEGIN

Line 2104: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt

2100: nvl(substr(bhz.attribute2,0,3),''),
2101: bhz.person_first_name || ' ' || bhz.person_last_name,
2102: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2103: ah.view_by_date, ah.staggered_closing_interval
2104: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2105: where bhz.party_id = bih.trading_partner_contact_id
2106: and bih.bid_number = p_bid_id
2107: and ah.auction_header_id = bih.auction_header_id
2108: and ah.doctype_id = dt.doctype_id;

Line 2674: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt

2670: ah.document_number, dt.doctype_group_name, dt.doctype_id,
2671: bhz.person_first_name || ' ' || bhz.person_last_name, ah.trading_partner_contact_name,
2672: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2673: view_by_date, nvl(ah.has_items_flag, 'Y'), ah.staggered_closing_interval,bih.award_status
2674: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2675: where bhz.party_id = bih.trading_partner_contact_id
2676: and bih.bid_number = p_bid_id
2677: and ah.auction_header_id = bih.auction_header_id
2678: and ah.doctype_id = dt.doctype_id;

Line 4018: from hz_parties where party_id = x_prev_trading_partner_id;

4014: begin
4015: -- Bug 3824928: Deleted IF condition that tested if trading_partner_id is not null
4016: -- since the condition is always true.
4017: select party_name into x_bidder_name
4018: from hz_parties where party_id = x_prev_trading_partner_id;
4019:
4020: exception
4021: when others then
4022: null;

Line 4028: from hz_parties where

4024:
4025: if (x_bidder_name is null or x_bidder_name = '') then
4026: begin
4027: select party_name into x_bidder_name
4028: from hz_parties where
4029: party_id = (select person_party_id from fnd_user where user_name = prevBidder.user_name);
4030: exception
4031: when others then
4032: x_bidder_name := prevBidder.user_name;

Line 10657: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

10653: l_auction_end_date DATE;
10654: l_preview_date DATE;
10655: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10656: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10657: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10658: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10659: l_task_target_date DATE;
10660: l_task_assignment_date DATE;
10661: l_task_assigned_subject VARCHAR2(2000);

Line 10731: hz_parties hz,

10727: l_open_auction_now_flag,
10728: l_publish_auction_now_flag
10729:
10730: from pon_auction_headers_all auh,
10731: hz_parties hz,
10732: pon_neg_team_members pntm,
10733: fnd_user fu,
10734: pon_auc_doctypes pad
10735: where auh.auction_header_id = p_auction_header_id

Line 10988: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

10984: l_auction_end_date DATE;
10985: l_preview_date DATE;
10986: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10987: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10988: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10989: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10990: l_task_target_date DATE;
10991: l_task_completion_date DATE;
10992: l_task_completed_subject VARCHAR2(2000);

Line 11143: from hz_parties hz,

11139: l_task_name,
11140: l_task_target_date,
11141: l_task_completion_date,
11142: l_user_name
11143: from hz_parties hz,
11144: pon_neg_team_members pntm,
11145: fnd_user fu
11146: where pntm.auction_header_id = p_auction_header_id
11147: AND hz.party_id = l_trading_partner_id

Line 11381: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

11377: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
11378: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
11379: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
11380: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
11381: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11382: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;
11383: l_timezone_disp VARCHAR2(240);
11384: l_bid_contact_dp_name VARCHAR2(350);
11385: l_bidder_dp_name VARCHAR2(350);

Line 11837: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

11833: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
11834: l_subject PON_THREADS.SUBJECT%TYPE;
11835: l_sender_name VARCHAR2(350);
11836: l_recipient_name VARCHAR2(350);
11837: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11838: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
11839: l_task_target_date DATE;
11840: l_task_assignment_date DATE;
11841: l_msg_sent_subject VARCHAR2(2000);

Line 11875: HZ_PARTIES hz,

11871: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11872: hz.person_first_name FIRST_NAME,
11873: hz.person_last_name LAST_NAME
11874: FROM pon_neg_team_members pntm,
11875: HZ_PARTIES hz,
11876: fnd_user fu
11877: WHERE hz.party_id=fu.person_party_id
11878: AND nvl(fu.end_date,sysdate+1) > sysdate
11879: AND fu.user_id=pntm.user_id

Line 11907: HZ_PARTIES HZ,

11903: HZ1.PERSON_LAST_NAME LAST_NAME,
11904: HZ.PARTY_ID COMPANY_ID,
11905: HZ.PARTY_NAME COMPANY_NAME
11906: FROM PON_BIDDING_PARTIES PBP,
11907: HZ_PARTIES HZ,
11908: HZ_PARTIES HZ1
11909: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
11910: AND HZ.PARTY_ID=PBP.TRADING_PARTNER_ID
11911: AND HZ1.PARTY_ID= PBP.TRADING_PARTNER_CONTACT_ID

Line 11908: HZ_PARTIES HZ1

11904: HZ.PARTY_ID COMPANY_ID,
11905: HZ.PARTY_NAME COMPANY_NAME
11906: FROM PON_BIDDING_PARTIES PBP,
11907: HZ_PARTIES HZ,
11908: HZ_PARTIES HZ1
11909: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
11910: AND HZ.PARTY_ID=PBP.TRADING_PARTNER_ID
11911: AND HZ1.PARTY_ID= PBP.TRADING_PARTNER_CONTACT_ID
11912: UNION

Line 11921: HZ_PARTIES HZ,

11917: HZ1.PERSON_LAST_NAME LAST_NAME,
11918: HZ.PARTY_ID COMPANY_ID,
11919: HZ.PARTY_NAME COMPANY_NAME
11920: FROM PON_BID_HEADERS PBH,
11921: HZ_PARTIES HZ,
11922: HZ_PARTIES HZ1
11923: WHERE PBH.AUCTION_HEADER_ID = p_auction_header_id
11924: AND HZ.PARTY_ID=PBH.TRADING_PARTNER_ID
11925: AND HZ1.PARTY_ID=PBH.TRADING_PARTNER_CONTACT_ID

Line 11922: HZ_PARTIES HZ1

11918: HZ.PARTY_ID COMPANY_ID,
11919: HZ.PARTY_NAME COMPANY_NAME
11920: FROM PON_BID_HEADERS PBH,
11921: HZ_PARTIES HZ,
11922: HZ_PARTIES HZ1
11923: WHERE PBH.AUCTION_HEADER_ID = p_auction_header_id
11924: AND HZ.PARTY_ID=PBH.TRADING_PARTNER_ID
11925: AND HZ1.PARTY_ID=PBH.TRADING_PARTNER_CONTACT_ID
11926: AND PBH.BID_STATUS NOT IN ('ARCHIVED','DISQUALIFIED')

Line 11956: HZ_PARTIES hz,

11952: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11953: hz.person_first_name FIRST_NAME,
11954: hz.person_last_name LAST_NAME
11955: FROM pon_scoring_team_members pntm,
11956: HZ_PARTIES hz,
11957: fnd_user fu
11958: WHERE hz.party_id=fu.person_party_id
11959: AND fu.user_id=pntm.user_id
11960: AND nvl(fu.end_date,sysdate+1) > sysdate

Line 11974: HZ_PARTIES hz,

11970: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11971: hz.person_first_name FIRST_NAME,
11972: hz.person_last_name LAST_NAME
11973: FROM pon_scoring_team_members pntm,
11974: HZ_PARTIES hz,
11975: fnd_user fu
11976: WHERE hz.party_id=fu.person_party_id
11977: AND fu.user_id=pntm.user_id
11978: AND nvl(fu.end_date,sysdate+1) > sysdate