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_EMD_AR_INTEGRATION_GRP dependencies on PON_BIDDING_PARTIES

Line 33: vendor_name pon_bidding_parties.trading_partner_name%TYPE,

29: party_site_id hz_party_sites.party_site_id%type,
30: party_contact_id hz_parties.party_id%TYPE,
31: vendor_id ap_suppliers.vendor_id%type,
32: vendor_site_id ap_supplier_sites.vendor_site_id%type,
33: vendor_name pon_bidding_parties.trading_partner_name%TYPE,
34: vendor_site_name hz_party_sites.party_site_name%TYPE,
35: vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,
36: customer_id ra_customer_trx.bill_to_customer_id%TYPE,
37: bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,

Line 35: vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,

31: vendor_id ap_suppliers.vendor_id%type,
32: vendor_site_id ap_supplier_sites.vendor_site_id%type,
33: vendor_name pon_bidding_parties.trading_partner_name%TYPE,
34: vendor_site_name hz_party_sites.party_site_name%TYPE,
35: vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,
36: customer_id ra_customer_trx.bill_to_customer_id%TYPE,
37: bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
38: deposit_amount NUMBER,
39: deposit_currency pon_emd_transactions.transaction_currency_code%type,

Line 148: vendor_name pon_bidding_parties.trading_partner_name%TYPE,

144: party_site_id hz_party_sites.party_site_id%type,
145: party_contact_id hz_parties.party_id%TYPE,
146: vendor_id ap_suppliers.vendor_id%type,
147: vendor_site_id ap_supplier_sites.vendor_site_id%type,
148: vendor_name pon_bidding_parties.trading_partner_name%TYPE,
149: vendor_site_name hz_party_sites.party_site_name%TYPE,
150: vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,
151: amount NUMBER,
152: memo_line_id NUMBER,

Line 150: vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,

146: vendor_id ap_suppliers.vendor_id%type,
147: vendor_site_id ap_supplier_sites.vendor_site_id%type,
148: vendor_name pon_bidding_parties.trading_partner_name%TYPE,
149: vendor_site_name hz_party_sites.party_site_name%TYPE,
150: vendor_contact_name pon_bidding_parties.trading_partner_contact_name%TYPE,
151: amount NUMBER,
152: memo_line_id NUMBER,
153: batch_source_id ra_batch_sources.batch_source_id%TYPE,
154: payment_term_id NUMBER,

Line 228: TRADING_PARTNER_ID PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE,

224:
225:
226: TYPE pon_emd_trx_rec IS RECORD
227: (
228: TRADING_PARTNER_ID PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE,
229: TRADING_PARTNER_CONTACT_ID PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE,
230: TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,
231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,

Line 229: TRADING_PARTNER_CONTACT_ID PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE,

225:
226: TYPE pon_emd_trx_rec IS RECORD
227: (
228: TRADING_PARTNER_ID PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE,
229: TRADING_PARTNER_CONTACT_ID PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE,
230: TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,
231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,

Line 230: TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,

226: TYPE pon_emd_trx_rec IS RECORD
227: (
228: TRADING_PARTNER_ID PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE,
229: TRADING_PARTNER_CONTACT_ID PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE,
230: TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,
231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,

Line 231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,

227: (
228: TRADING_PARTNER_ID PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE,
229: TRADING_PARTNER_CONTACT_ID PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE,
230: TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,
231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,

Line 232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,

228: TRADING_PARTNER_ID PON_BIDDING_PARTIES.TRADING_PARTNER_ID%TYPE,
229: TRADING_PARTNER_CONTACT_ID PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_ID%TYPE,
230: TRADING_PARTNER_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_NAME%TYPE,
231: TRADING_PARTNER_CONTACT_NAME PON_BIDDING_PARTIES.TRADING_PARTNER_CONTACT_NAME%TYPE,
232: VENDOR_SITE_ID PON_BIDDING_PARTIES.VENDOR_SITE_ID%TYPE,
233: EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_ID%TYPE,
234: TRANSACTION_TYPE_CODE PON_EMD_TRANSACTIONS.TRANSACTION_TYPE_CODE%TYPE,
235: TRANSACTION_DATE PON_EMD_TRANSACTIONS.TRANSACTION_DATE%TYPE,
236: PAYMENT_TYPE_CODE PON_EMD_TRANSACTIONS.PAYMENT_TYPE_CODE%TYPE,

Line 337: PON_BIDDING_PARTIES BP,

333: PUH.CURRENCY_CODE,
334: ET.ERROR_MESSAGE,
335: ET.EMD_TRANSACTION_GROUP_ID
336: FROM PON_EMD_TRANSACTIONS ET,
337: PON_BIDDING_PARTIES BP,
338: PON_AUCTION_HEADERS_ALL PUH,
339: AP_SUPPLIERS sup
340: WHERE ET.AUCTION_HEADER_ID = BP.AUCTION_HEADER_ID
341: AND PUH.AUCTION_HEADER_ID = ET.AUCTION_HEADER_ID