DBA Data[Home] [Help]

APPS.PON_EMD_AR_INTEGRATION_GRP dependencies on HZ_PARTIES

Line 28: party_id hz_parties.party_id%type,

24: G_CORPORATE_EMD CONSTANT VARCHAR2(50) := 'CORPORATE_EMD';
25:
26: TYPE DEPOSIT_INFO_IN_RECTYPE IS RECORD
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,

Line 30: party_contact_id hz_parties.party_id%TYPE,

26: TYPE DEPOSIT_INFO_IN_RECTYPE IS RECORD
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,

Line 73: ( party_id hz_parties.party_id%type,

69: deposit_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE
70: );
71:
72: TYPE RECEIPT_INFO_IN_RECTYPE IS RECORD
73: ( party_id hz_parties.party_id%type,
74: vendor_site_id ap_supplier_sites.vendor_site_id%type,
75: customer_id ra_customer_trx.bill_to_customer_id%TYPE,
76: party_site_id hz_party_sites.party_site_id%type,
77: vendor_contact_id ap_supplier_contacts.vendor_contact_id%type,

Line 143: party_id hz_parties.party_id%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,
147: vendor_site_id ap_supplier_sites.vendor_site_id%type,

Line 145: party_contact_id hz_parties.party_id%TYPE,

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,
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,

Line 177: party_id hz_parties.party_id%type,

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,
181: emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE

Line 179: party_contact_id hz_parties.party_id%TYPE,

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,
181: emd_trx_group_id pon_emd_transactions.emd_transaction_group_id%TYPE
182: );
183:

Line 194: party_id hz_parties.party_id%TYPE,

190:
191:
192: TYPE PARTY_INFO_IN_RECTYPE IS RECORD
193: (
194: party_id hz_parties.party_id%TYPE,
195: party_name hz_parties.party_name%TYPE,
196: terms_id NUMBER
197: );
198:

Line 195: party_name hz_parties.party_name%TYPE,

191:
192: TYPE PARTY_INFO_IN_RECTYPE IS RECORD
193: (
194: party_id hz_parties.party_id%TYPE,
195: party_name hz_parties.party_name%TYPE,
196: terms_id NUMBER
197: );
198:
199: TYPE PARTY_INFO_OUT_RECTYPE IS RECORD

Line 201: party_id hz_parties.party_id%TYPE,

197: );
198:
199: TYPE PARTY_INFO_OUT_RECTYPE IS RECORD
200: (
201: party_id hz_parties.party_id%TYPE,
202: party_NUMBER hz_parties.party_number%TYPE,
203: cust_account_id hz_cust_accounts.cust_account_id%TYPE,
204: account_number hz_cust_accounts.account_number%TYPE
205: );

Line 202: party_NUMBER hz_parties.party_number%TYPE,

198:
199: TYPE PARTY_INFO_OUT_RECTYPE IS RECORD
200: (
201: party_id hz_parties.party_id%TYPE,
202: party_NUMBER hz_parties.party_number%TYPE,
203: cust_account_id hz_cust_accounts.cust_account_id%TYPE,
204: account_number hz_cust_accounts.account_number%TYPE
205: );
206:

Line 209: party_id hz_parties.party_id%TYPE,

205: );
206:
207: TYPE PARTY_SITE_INFO_IN_RECTYPE IS RECORD
208: (
209: party_id hz_parties.party_id%TYPE,
210: party_name hz_parties.party_name%TYPE,
211: party_site_id hz_party_sites.party_site_id%TYPE,
212: cust_account_id hz_cust_accounts.cust_account_id%TYPE,
213: org_id NUMBER,

Line 210: party_name hz_parties.party_name%TYPE,

206:
207: TYPE PARTY_SITE_INFO_IN_RECTYPE IS RECORD
208: (
209: party_id hz_parties.party_id%TYPE,
210: party_name hz_parties.party_name%TYPE,
211: party_site_id hz_party_sites.party_site_id%TYPE,
212: cust_account_id hz_cust_accounts.cust_account_id%TYPE,
213: org_id NUMBER,
214: location hz_locations.city%TYPE,