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 HZ_CUST_ACCOUNTS

Line 46: l_bill_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;

42: l_exchange_date ra_customer_trx.exchange_date%TYPE := NULL;
43: l_gl_date DATE := NULL;
44: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
45: l_bill_to_customer_name hz_parties.party_name%TYPE := NULL;
46: l_bill_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
47: l_bill_to_location hz_cust_site_uses.location%TYPE := NULL;
48: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%TYPE := NULL;
49: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%TYPE := NULL;
50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;

Line 54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;

50: l_bill_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;
51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;
52: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
53: l_ship_to_customer_name hz_parties.party_name%TYPE := NULL;
54: l_ship_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
55: l_ship_to_location hz_cust_site_uses.location%TYPE := NULL;
56: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%TYPE := NULL;
57: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%TYPE := NULL;
58: l_ship_to_contact_first_name hz_parties.person_first_name%TYPE := NULL;

Line 112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;

108: l_purchase_order_date ra_customer_trx.purchase_order_date%TYPE := NULL;
109: l_remit_to_address_id ra_customer_trx.remit_to_address_id%TYPE := NULL;
110: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE := NULL;
111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;
112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;
115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;
116: l_paying_location hz_cust_site_uses.location%TYPE := NULL;

Line 115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;

111: l_sold_to_customer_name hz_parties.party_name%TYPE := NULL;
112: l_sold_to_customer_number hz_cust_accounts.account_number%TYPE := NULL;
113: l_paying_customer_id ra_customer_trx.ship_to_customer_id%TYPE := NULL;
114: l_paying_customer_name hz_parties.party_name%TYPE := NULL;
115: l_paying_customer_number hz_cust_accounts.account_number%TYPE := NULL;
116: l_paying_location hz_cust_site_uses.location%TYPE := NULL;
117: l_receipt_method_id ra_customer_trx.receipt_method_id%TYPE := NULL;
118: l_receipt_method_name ar_receipt_methods.name%TYPE := NULL;
119: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%TYPE := NULL;

Line 1258: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE;

1254: l_cust_account_rec hz_cust_account_v2pub.CUST_ACCOUNT_REC_TYPE;
1255: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE := HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC;
1256: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1257: l_create_profile_amt VARCHAR2(1) := FND_API.G_TRUE;
1258: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
1259: x_account_number hz_cust_accounts.account_number%TYPE;
1260: x_party_id hz_cust_accounts.party_id%TYPE;
1261: x_party_number hz_parties.party_number%TYPE;
1262: x_profile_id hz_customer_profiles.cust_account_profile_id%TYPE;

Line 1259: x_account_number hz_cust_accounts.account_number%TYPE;

1255: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE := HZ_PARTY_V2PUB.G_MISS_ORGANIZATION_REC;
1256: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1257: l_create_profile_amt VARCHAR2(1) := FND_API.G_TRUE;
1258: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
1259: x_account_number hz_cust_accounts.account_number%TYPE;
1260: x_party_id hz_cust_accounts.party_id%TYPE;
1261: x_party_number hz_parties.party_number%TYPE;
1262: x_profile_id hz_customer_profiles.cust_account_profile_id%TYPE;
1263: l_party_rec HZ_PARTY_V2PUB.party_rec_type := HZ_PARTY_V2PUB.G_MISS_PARTY_REC;

Line 1260: x_party_id hz_cust_accounts.party_id%TYPE;

1256: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1257: l_create_profile_amt VARCHAR2(1) := FND_API.G_TRUE;
1258: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
1259: x_account_number hz_cust_accounts.account_number%TYPE;
1260: x_party_id hz_cust_accounts.party_id%TYPE;
1261: x_party_number hz_parties.party_number%TYPE;
1262: x_profile_id hz_customer_profiles.cust_account_profile_id%TYPE;
1263: l_party_rec HZ_PARTY_V2PUB.party_rec_type := HZ_PARTY_V2PUB.G_MISS_PARTY_REC;
1264: l_cust_acct_site_rec hz_cust_account_site_v2pub.cust_acct_site_rec_type;

Line 1513: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;

1509: l_pon_emd_fin_parameters pon_emd_fin_parameters%ROWTYPE;
1510: l_org_return_status VARCHAR2(1);
1511: l_found BOOLEAN;
1512: l_emd_transactions_info pon_emd_trx_rec;
1513: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
1514: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;
1515: x_party_name hz_parties.party_name%TYPE := NULL;
1516: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
1517: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;

Line 2165: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;

2161: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2162: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2163: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2164:
2165: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2166: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;
2167: x_party_name hz_parties.party_name%TYPE := NULL;
2168: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
2169: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;

Line 2790: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;

2786:
2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2788: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2789:
2790: x_cust_account_id hz_cust_accounts.cust_account_id%TYPE := NULL;
2791: x_cust_acct_site_id hz_cust_acct_sites.cust_acct_site_id%TYPE := NULL;
2792: x_party_name hz_parties.party_name%TYPE := NULL;
2793: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;
2794: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;

Line 3380: FROM hz_cust_accounts hca,

3376: SELECT hca.cust_account_id,
3377: hp.party_name
3378: INTO x_cust_account_id,
3379: x_party_name
3380: FROM hz_cust_accounts hca,
3381: hz_parties hp
3382: WHERE Nvl(hca.customer_type,'I') = 'R'
3383: AND hca.party_id = hp.party_id
3384: AND hca.account_name = hp.party_name