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_DISCUSSION_PKG dependencies on PON_TE_RECIPIENTS

Line 96: FROM pon_te_recipients

92: AND pte.discussion_id = l_discussion_id
93: AND (((pte.broadcast_flag = 'N' OR pte.broadcast_flag = 'G')
94: AND
95: EXISTS (SELECT 1
96: FROM pon_te_recipients
97: WHERE entry_id = pte.entry_id
98: -- Check that the message was sent directly to the user
99: -- and has not yet been read by that user
100: AND ((to_id = p_user_id

Line 112: FROM pon_te_recipients

108: AND
109: pte.message_type='EXTERNAL'
110: AND entry_id not in
111: (SELECT entry_id
112: FROM pon_te_recipients
113: WHERE to_id = p_user_id
114: AND read_flag = 'Y'
115: AND entry_id = pte.entry_id)
116: )

Line 128: FROM pon_te_recipients

124: OR
125: (ah.trading_partner_id = p_company_id AND pte.message_type='INTERNAL')
126: AND
127: entry_id in (SELECT entry_id
128: FROM pon_te_recipients
129: WHERE to_id = p_user_id
130: AND entry_id = pte.entry_id)
131: )
132: AND

Line 134: FROM pon_te_recipients

130: AND entry_id = pte.entry_id)
131: )
132: AND
133: (entry_id not in (SELECT entry_id
134: FROM pon_te_recipients
135: WHERE to_id = p_user_id
136: AND read_flag = 'Y'
137: AND entry_id = pte.entry_id)
138: )));

Line 174: FROM PON_TE_RECIPIENTS PTR,

170:
171: BEGIN
172:
173: SELECT count(1) into l_reply_count
174: FROM PON_TE_RECIPIENTS PTR,
175: PON_THREAD_ENTRIES PTE
176: WHERE PTR.replied_flag ='Y'
177: and PTR.entry_id = p_entry_id
178: and PTE.ENTRY_ID = PTR.ENTRY_ID