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 995: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt

991: hz.person_first_name || ' ' || hz.person_last_name,
992: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 7), 1, nvl(view_by_date, open_bidding_date)+3,
993: decode(sign(close_bidding_date - nvl(view_by_date, open_bidding_date) - 1), 1, nvl(view_by_date, open_bidding_date) + 1,
994: nvl(view_by_date, open_bidding_date) + 1/24)) reminder_time
995: from pon_auction_headers_all auh, hz_parties hz, pon_auc_doctypes dt
996: where hz.party_id = auh.trading_partner_contact_id
997: and auh.doctype_id = dt.doctype_id
998: and auction_header_id = p_auction_header_id;
999: BEGIN

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

1638: nvl(substr(bhz.attribute2,0,3),''),
1639: bhz.person_first_name || ' ' || bhz.person_last_name,
1640: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
1641: ah.view_by_date, ah.staggered_closing_interval
1642: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
1643: where bhz.party_id = bih.trading_partner_contact_id
1644: and bih.bid_number = p_bid_id
1645: and ah.auction_header_id = bih.auction_header_id
1646: and ah.doctype_id = dt.doctype_id;

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

2198: ah.document_number, dt.doctype_group_name, dt.doctype_id,
2199: bhz.person_first_name || ' ' || bhz.person_last_name, ah.trading_partner_contact_name,
2200: bih.trading_partner_name, decode(bih.vendor_site_code, '-1', null, bih.vendor_site_code) vendor_site_code,
2201: view_by_date, nvl(ah.has_items_flag, 'Y'), ah.staggered_closing_interval,bih.award_status
2202: from hz_parties bhz, pon_bid_headers bih, pon_auction_headers_all ah, pon_auc_doctypes dt
2203: where bhz.party_id = bih.trading_partner_contact_id
2204: and bih.bid_number = p_bid_id
2205: and ah.auction_header_id = bih.auction_header_id
2206: and ah.doctype_id = dt.doctype_id;

Line 3497: from hz_parties where party_id = x_prev_trading_partner_id;

3493: begin
3494: -- Bug 3824928: Deleted IF condition that tested if trading_partner_id is not null
3495: -- since the condition is always true.
3496: select party_name into x_bidder_name
3497: from hz_parties where party_id = x_prev_trading_partner_id;
3498:
3499: exception
3500: when others then
3501: null;

Line 3507: from hz_parties where

3503:
3504: if (x_bidder_name is null or x_bidder_name = '') then
3505: begin
3506: select party_name into x_bidder_name
3507: from hz_parties where
3508: party_id = (select person_party_id from fnd_user where user_name = prevBidder.user_name);
3509: exception
3510: when others then
3511: x_bidder_name := prevBidder.user_name;

Line 9821: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

9817: l_auction_end_date DATE;
9818: l_preview_date DATE;
9819: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
9820: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
9821: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
9822: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
9823: l_task_target_date DATE;
9824: l_task_assignment_date DATE;
9825: l_task_assigned_subject VARCHAR2(2000);

Line 9895: hz_parties hz,

9891: l_open_auction_now_flag,
9892: l_publish_auction_now_flag
9893:
9894: from pon_auction_headers_all auh,
9895: hz_parties hz,
9896: pon_neg_team_members pntm,
9897: fnd_user fu,
9898: pon_auc_doctypes pad
9899: where auh.auction_header_id = p_auction_header_id

Line 10152: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

10148: l_auction_end_date DATE;
10149: l_preview_date DATE;
10150: l_msg_suffix PON_AUC_DOCTYPES.MESSAGE_SUFFIX%TYPE;
10151: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10152: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10153: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
10154: l_task_target_date DATE;
10155: l_task_completion_date DATE;
10156: l_task_completed_subject VARCHAR2(2000);

Line 10307: from hz_parties hz,

10303: l_task_name,
10304: l_task_target_date,
10305: l_task_completion_date,
10306: l_user_name
10307: from hz_parties hz,
10308: pon_neg_team_members pntm,
10309: fnd_user fu
10310: where pntm.auction_header_id = p_auction_header_id
10311: AND hz.party_id = l_trading_partner_id

Line 10545: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

10541: l_trading_partner_id PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_ID%TYPE;
10542: l_preparer_tp_name PON_AUCTION_HEADERS_ALL.TRADING_PARTNER_NAME%TYPE;
10543: l_response_number PON_BID_HEADERS.BID_NUMBER%TYPE;
10544: l_bidder_tpc_id PON_BID_HEADERS.TRADING_PARTNER_CONTACT_ID%TYPE;
10545: l_bidder_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
10546: l_tp_contact_usr_id FND_USER.USER_ID%TYPE;
10547: l_timezone_disp VARCHAR2(240);
10548: l_bid_contact_dp_name VARCHAR2(350);
10549: l_bidder_dp_name VARCHAR2(350);

Line 11001: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;

10997: l_auction_title PON_AUCTION_HEADERS_ALL.AUCTION_TITLE%TYPE;
10998: l_subject PON_THREADS.SUBJECT%TYPE;
10999: l_sender_name VARCHAR2(350);
11000: l_recipient_name VARCHAR2(350);
11001: l_preparer_tp_name HZ_PARTIES.PARTY_NAME%TYPE;
11002: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;
11003: l_task_target_date DATE;
11004: l_task_assignment_date DATE;
11005: l_msg_sent_subject VARCHAR2(2000);

Line 11039: HZ_PARTIES hz,

11035: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11036: hz.person_first_name FIRST_NAME,
11037: hz.person_last_name LAST_NAME
11038: FROM pon_neg_team_members pntm,
11039: HZ_PARTIES hz,
11040: fnd_user fu
11041: WHERE hz.party_id=fu.person_party_id
11042: AND nvl(fu.end_date,sysdate+1) > sysdate
11043: AND fu.user_id=pntm.user_id

Line 11071: HZ_PARTIES HZ,

11067: HZ1.PERSON_LAST_NAME LAST_NAME,
11068: HZ.PARTY_ID COMPANY_ID,
11069: HZ.PARTY_NAME COMPANY_NAME
11070: FROM PON_BIDDING_PARTIES PBP,
11071: HZ_PARTIES HZ,
11072: HZ_PARTIES HZ1
11073: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
11074: AND HZ.PARTY_ID=PBP.TRADING_PARTNER_ID
11075: AND HZ1.PARTY_ID= PBP.TRADING_PARTNER_CONTACT_ID

Line 11072: HZ_PARTIES HZ1

11068: HZ.PARTY_ID COMPANY_ID,
11069: HZ.PARTY_NAME COMPANY_NAME
11070: FROM PON_BIDDING_PARTIES PBP,
11071: HZ_PARTIES HZ,
11072: HZ_PARTIES HZ1
11073: WHERE PBP.AUCTION_HEADER_ID = p_auction_header_id
11074: AND HZ.PARTY_ID=PBP.TRADING_PARTNER_ID
11075: AND HZ1.PARTY_ID= PBP.TRADING_PARTNER_CONTACT_ID
11076: UNION

Line 11085: HZ_PARTIES HZ,

11081: HZ1.PERSON_LAST_NAME LAST_NAME,
11082: HZ.PARTY_ID COMPANY_ID,
11083: HZ.PARTY_NAME COMPANY_NAME
11084: FROM PON_BID_HEADERS PBH,
11085: HZ_PARTIES HZ,
11086: HZ_PARTIES HZ1
11087: WHERE PBH.AUCTION_HEADER_ID = p_auction_header_id
11088: AND HZ.PARTY_ID=PBH.TRADING_PARTNER_ID
11089: AND HZ1.PARTY_ID=PBH.TRADING_PARTNER_CONTACT_ID

Line 11086: HZ_PARTIES HZ1

11082: HZ.PARTY_ID COMPANY_ID,
11083: HZ.PARTY_NAME COMPANY_NAME
11084: FROM PON_BID_HEADERS PBH,
11085: HZ_PARTIES HZ,
11086: HZ_PARTIES HZ1
11087: WHERE PBH.AUCTION_HEADER_ID = p_auction_header_id
11088: AND HZ.PARTY_ID=PBH.TRADING_PARTNER_ID
11089: AND HZ1.PARTY_ID=PBH.TRADING_PARTNER_CONTACT_ID
11090: AND PBH.BID_STATUS NOT IN ('ARCHIVED','DISQUALIFIED')

Line 11120: HZ_PARTIES hz,

11116: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11117: hz.person_first_name FIRST_NAME,
11118: hz.person_last_name LAST_NAME
11119: FROM pon_scoring_team_members pntm,
11120: HZ_PARTIES hz,
11121: fnd_user fu
11122: WHERE hz.party_id=fu.person_party_id
11123: AND fu.user_id=pntm.user_id
11124: AND nvl(fu.end_date,sysdate+1) > sysdate

Line 11138: HZ_PARTIES hz,

11134: PON_LOCALE_PKG.get_party_display_name(hz.party_id,2, userenv('LANG')) TO_PARTY_NAME,
11135: hz.person_first_name FIRST_NAME,
11136: hz.person_last_name LAST_NAME
11137: FROM pon_scoring_team_members pntm,
11138: HZ_PARTIES hz,
11139: fnd_user fu
11140: WHERE hz.party_id=fu.person_party_id
11141: AND fu.user_id=pntm.user_id
11142: AND nvl(fu.end_date,sysdate+1) > sysdate