DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_THREAD_ENTRIES

Line 11888: pon_thread_entries pte

11884: distinct pte.from_id TO_PARTY_ID,
11885: PON_LOCALE_PKG.get_party_display_name(pte.from_id,2, userenv('LANG')) TO_PARTY_NAME,
11886: pte.from_first_name FIRST_NAME, pte.from_last_name LAST_NAME
11887: FROM pon_threads pt,
11888: pon_thread_entries pte
11889: WHERE pt.discussion_id = p_discussion_id
11890: AND pt.discussion_id = pte.discussion_id
11891: AND pt.thread_number = pte.thread_number
11892: AND pte.from_id <> p_sender_id

Line 11936: PON_THREAD_ENTRIES PTE,

11932: PTE.FROM_LAST_NAME LAST_NAME,
11933: PTE.FROM_COMPANY_ID COMPANY_ID,
11934: PTE.FROM_COMPANY_NAME COMPANY_NAME
11935: FROM PON_THREADS PT,
11936: PON_THREAD_ENTRIES PTE,
11937: PON_TE_RECIPIENTS PTR
11938: WHERE PT.DISCUSSION_ID = p_discussion_id
11939: AND PT.DISCUSSION_ID = PTE.DISCUSSION_ID
11940: AND PT.THREAD_NUMBER = PTE.THREAD_NUMBER

Line 12064: pon_thread_entries pte,

12060: l_open_auction_now_flag ,
12061: l_publish_auction_now_flag
12062: FROM pon_auction_headers_all auh,
12063: pon_auc_doctypes pad,
12064: pon_thread_entries pte,
12065: pon_threads pt,
12066: pon_discussions pd
12067: WHERE pte.entry_id = p_entryid
12068: AND pd.discussion_id = pte.discussion_id