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_AUCTION_HEADERS_ALL

Line 46: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,

42: exchange_rate pon_emd_transactions.exchange_rate%type,
43: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
44: customer_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE,
45: org_id NUMBER,
46: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
47: document_number pon_auction_headers_all.document_number%TYPE,
48: batch_source_id ra_batch_sources.batch_source_id%TYPE,
49: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
50: memo_line_id NUMBER,

Line 47: document_number pon_auction_headers_all.document_number%TYPE,

43: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
44: customer_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE,
45: org_id NUMBER,
46: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
47: document_number pon_auction_headers_all.document_number%TYPE,
48: batch_source_id ra_batch_sources.batch_source_id%TYPE,
49: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
50: memo_line_id NUMBER,
51: paying_location hz_locations.city%TYPE,

Line 141: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,

137: exchange_date ra_customer_trx.exchange_date%type,
138: exchange_rate ra_customer_trx.exchange_rate%type,
139: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
140: org_id NUMBER,
141: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
142: document_number pon_auction_headers_all.document_number%TYPE,
143: party_id hz_parties.party_id%type,
144: party_site_id hz_party_sites.party_site_id%type,
145: party_contact_id hz_parties.party_id%TYPE,

Line 142: document_number pon_auction_headers_all.document_number%TYPE,

138: exchange_rate ra_customer_trx.exchange_rate%type,
139: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
140: org_id NUMBER,
141: auction_header_id pon_auction_headers_all.auction_header_id%TYPE,
142: document_number pon_auction_headers_all.document_number%TYPE,
143: party_id hz_parties.party_id%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,

Line 176: document_number pon_auction_headers_all.document_number%TYPE,

172: customer_trx_line_id NUMBER,
173: line_amount NUMBER,
174: org_id NUMBER,
175: batch_source_id NUMBER,
176: document_number pon_auction_headers_all.document_number%TYPE,
177: party_id hz_parties.party_id%type,
178: party_site_id hz_party_sites.party_site_id%type,
179: party_contact_id hz_parties.party_id%TYPE,
180: emd_transaction_id pon_emd_transactions.emd_transaction_id%TYPE,

Line 264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,

260: PARENT_EMD_TRANSACTION_ID PON_EMD_TRANSACTIONS.PARENT_EMD_TRANSACTION_ID%TYPE,
261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,

Line 265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,

261: ORG_ID PON_EMD_TRANSACTIONS.ORG_ID%TYPE,
262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,
269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,

Line 266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,

262: AUCTION_HEADER_ID PON_EMD_TRANSACTIONS.AUCTION_HEADER_ID%TYPE,
263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,
269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,
270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,

Line 267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,

263: STATUS_LOOKUP_CODE PON_EMD_TRANSACTIONS.STATUS_LOOKUP_CODE%TYPE,
264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,
269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,
270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,
271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,

Line 268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,

264: DOCUMENT_NUMBER PON_AUCTION_HEADERS_ALL.DOCUMENT_NUMBER%TYPE,
265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,
269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,
270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,
271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,
272: VENDOR_ID AP_SUPPLIERS.VENDOR_ID%TYPE,

Line 269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,

265: EMD_ENABLE_FLAG PON_AUCTION_HEADERS_ALL.EMD_ENABLE_FLAG%TYPE,
266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,
269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,
270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,
271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,
272: VENDOR_ID AP_SUPPLIERS.VENDOR_ID%TYPE,
273: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,

Line 270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,

266: EMD_AMOUNT PON_AUCTION_HEADERS_ALL.EMD_AMOUNT%TYPE,
267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,
269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,
270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,
271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,
272: VENDOR_ID AP_SUPPLIERS.VENDOR_ID%TYPE,
273: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
274: ERROR_MESSAGE PON_EMD_TRANSACTIONS.ERROR_MESSAGE%TYPE,

Line 271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,

267: EMD_DUE_DATE PON_AUCTION_HEADERS_ALL.EMD_DUE_DATE%TYPE,
268: EMD_TYPE PON_AUCTION_HEADERS_ALL.EMD_TYPE%TYPE,
269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,
270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,
271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,
272: VENDOR_ID AP_SUPPLIERS.VENDOR_ID%TYPE,
273: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
274: ERROR_MESSAGE PON_EMD_TRANSACTIONS.ERROR_MESSAGE%TYPE,
275: EMD_TRX_GROUP_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_GROUP_ID%TYPE

Line 273: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,

269: EMD_GUARANTEE_EXPIRY_DATE PON_AUCTION_HEADERS_ALL.EMD_GUARANTEE_EXPIRY_DATE%TYPE,
270: EMD_ADDITIONAL_INFORMATION PON_AUCTION_HEADERS_ALL.EMD_ADDITIONAL_INFORMATION%TYPE,
271: POST_EMD_TO_FINANCE PON_AUCTION_HEADERS_ALL.POST_EMD_TO_FINANCE%TYPE,
272: VENDOR_ID AP_SUPPLIERS.VENDOR_ID%TYPE,
273: CURRENCY_CODE PON_AUCTION_HEADERS_ALL.CURRENCY_CODE%TYPE,
274: ERROR_MESSAGE PON_EMD_TRANSACTIONS.ERROR_MESSAGE%TYPE,
275: EMD_TRX_GROUP_ID PON_EMD_TRANSACTIONS.EMD_TRANSACTION_GROUP_ID%TYPE
276:
277: );

Line 338: PON_AUCTION_HEADERS_ALL PUH,

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
342: AND ET.SUPPLIER_SEQUENCE = BP.SEQUENCE