[Home] [Help]
27: ( deposit_date ra_customer_trx.trx_date%type,
28: party_id hz_parties.party_id%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,
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,
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,
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
276:
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
343: AND Nvl(BP.EXEMPT_FLAG,'N') = 'N'