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 PON_NEG_TEAM_MEMBERS

Line 1270: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u

1266: select u.user_name,
1267: a.trading_partner_name,
1268: a.auction_title,
1269: a.document_number, a.cancel_date, a.event_title, a.publish_date
1270: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u
1271: where b.menu_name = 'EMD_ADMIN'
1272: and b.approver_flag = 'Y'
1273: and a.auction_header_id = b.auction_header_id
1274: and u.user_id = b.user_id

Line 10327: from pon_neg_team_members

10323: BEGIN
10324: v_member_type := 'X';
10325: select nvl(member_type,'X')
10326: into v_member_type
10327: from pon_neg_team_members
10328: where auction_header_id =p_auction_header_id
10329: and user_id = p_user_id;
10330:
10331: return v_member_type;

Line 10658: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;

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);
10662: l_timezone_disp VARCHAR2(240);

Line 10732: pon_neg_team_members pntm,

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
10736: AND hz.party_id = auh.trading_partner_id

Line 10989: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%TYPE;

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);
10993: l_timezone_disp VARCHAR2(240);

Line 11144: pon_neg_team_members pntm,

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
11148: AND pntm.user_id = p_user_id

Line 11838: l_task_name PON_NEG_TEAM_MEMBERS.TASK_NAME%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);
11842: l_timezone_disp VARCHAR2(240);

Line 11874: FROM pon_neg_team_members pntm,

11870: hz.party_id TO_PARTY_ID,
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