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 RA_CUSTOMER_TRX

Line 27: ( deposit_date ra_customer_trx.trx_date%type,

23: G_BANK_ACCT_XFER CONSTANT VARCHAR2(50) := 'BANK_ACCT_XFER';
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,

Line 36: customer_id ra_customer_trx.bill_to_customer_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,
40: exchange_rate_type pon_emd_transactions.exchange_rate_type%type,

Line 37: bill_to_site_use_id ra_customer_trx.bill_to_site_use_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,
40: exchange_rate_type pon_emd_transactions.exchange_rate_type%type,
41: exchange_date pon_emd_transactions.exchange_date%type,

Line 44: customer_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE,

40: exchange_rate_type pon_emd_transactions.exchange_rate_type%type,
41: exchange_date pon_emd_transactions.exchange_date%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,

Line 67: ( deposit_trx_number ra_customer_trx.trx_number%TYPE,

63: EMD_TRX_GROUP_ID pon_emd_transactions.emd_transaction_group_id%TYPE
64: );
65:
66: TYPE DEPOSIT_INFO_OUT_RECTYPE IS RECORD
67: ( deposit_trx_number ra_customer_trx.trx_number%TYPE,
68: deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,
69: deposit_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE
70: );
71:

Line 68: deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,

64: );
65:
66: TYPE DEPOSIT_INFO_OUT_RECTYPE IS RECORD
67: ( deposit_trx_number ra_customer_trx.trx_number%TYPE,
68: deposit_trx_id ra_customer_trx.customer_trx_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

Line 69: deposit_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE

65:
66: TYPE DEPOSIT_INFO_OUT_RECTYPE IS RECORD
67: ( deposit_trx_number ra_customer_trx.trx_number%TYPE,
68: deposit_trx_id ra_customer_trx.customer_trx_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,

Line 75: customer_id ra_customer_trx.bill_to_customer_id%TYPE,

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,
78: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
79: exchange_date ra_customer_trx.exchange_date%type,

Line 78: exchange_rate_type ra_customer_trx.exchange_rate_type%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,
78: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
79: exchange_date ra_customer_trx.exchange_date%type,
80: exchange_rate ra_customer_trx.exchange_rate%type,
81: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
82: receipt_amount ar_cash_receipts.amount%TYPE,

Line 79: exchange_date ra_customer_trx.exchange_date%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,
78: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
79: exchange_date ra_customer_trx.exchange_date%type,
80: exchange_rate ra_customer_trx.exchange_rate%type,
81: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
82: receipt_amount ar_cash_receipts.amount%TYPE,
83: receipt_date ar_cash_receipts.receipt_date%TYPE,

Line 80: exchange_rate ra_customer_trx.exchange_rate%type,

76: party_site_id hz_party_sites.party_site_id%type,
77: vendor_contact_id ap_supplier_contacts.vendor_contact_id%type,
78: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
79: exchange_date ra_customer_trx.exchange_date%type,
80: exchange_rate ra_customer_trx.exchange_rate%type,
81: receipt_method_id ar_receipt_methods.RECEIPT_METHOD_ID%TYPE,
82: receipt_amount ar_cash_receipts.amount%TYPE,
83: receipt_date ar_cash_receipts.receipt_date%TYPE,
84: deposit_date ar_cash_receipts.deposit_date%TYPE,

Line 95: deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,

91:
92: TYPE UNAPPLY_INFO_IN_RECTYPE IS RECORD
93: (
94: cash_receipt_id NUMBER,
95: deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,
96: transaction_date DATE,
97: receivable_app_id NUMBER,
98: org_id NUMBER
99: );

Line 130: deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,

126:
127: TYPE FORFEIT_INFO_IN_RECTYPE IS RECORD
128: (
129: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
130: deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,
131: transaction_currency_code ra_customer_trx.invoice_currency_code%TYPE,
132: transaction_date DATE,
133: cust_account_id ra_customer_trx.bill_to_customer_id%TYPE,
134: cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,

Line 131: transaction_currency_code ra_customer_trx.invoice_currency_code%TYPE,

127: TYPE FORFEIT_INFO_IN_RECTYPE IS RECORD
128: (
129: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
130: deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,
131: transaction_currency_code ra_customer_trx.invoice_currency_code%TYPE,
132: transaction_date DATE,
133: cust_account_id ra_customer_trx.bill_to_customer_id%TYPE,
134: cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,
135: site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,

Line 133: cust_account_id ra_customer_trx.bill_to_customer_id%TYPE,

129: trx_type_id ra_cust_trx_types.cust_trx_type_id%TYPE,
130: deposit_trx_id ra_customer_trx.customer_trx_id%TYPE,
131: transaction_currency_code ra_customer_trx.invoice_currency_code%TYPE,
132: transaction_date DATE,
133: cust_account_id ra_customer_trx.bill_to_customer_id%TYPE,
134: cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,
135: site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
136: exchange_rate_type ra_customer_trx.exchange_rate_type%type,
137: exchange_date ra_customer_trx.exchange_date%type,

Line 135: site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,

131: transaction_currency_code ra_customer_trx.invoice_currency_code%TYPE,
132: transaction_date DATE,
133: cust_account_id ra_customer_trx.bill_to_customer_id%TYPE,
134: cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,
135: site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
136: exchange_rate_type ra_customer_trx.exchange_rate_type%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,

Line 136: exchange_rate_type ra_customer_trx.exchange_rate_type%type,

132: transaction_date DATE,
133: cust_account_id ra_customer_trx.bill_to_customer_id%TYPE,
134: cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,
135: site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
136: exchange_rate_type ra_customer_trx.exchange_rate_type%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,

Line 137: exchange_date ra_customer_trx.exchange_date%type,

133: cust_account_id ra_customer_trx.bill_to_customer_id%TYPE,
134: cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,
135: site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
136: exchange_rate_type ra_customer_trx.exchange_rate_type%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,

Line 138: exchange_rate ra_customer_trx.exchange_rate%type,

134: cust_acct_site_id HZ_CUST_ACCT_SITES.cust_acct_site_id%TYPE,
135: site_use_id ra_customer_trx.bill_to_site_use_id%TYPE,
136: exchange_rate_type ra_customer_trx.exchange_rate_type%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,