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_SITE_USES

Line 47: l_bill_to_location hz_cust_site_uses.location%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;
51: l_bill_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;

Line 55: l_ship_to_location hz_cust_site_uses.location%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;
59: l_ship_to_contact_last_name hz_parties.person_last_name%TYPE := NULL;

Line 116: l_paying_location hz_cust_site_uses.location%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;
120: l_cust_bank_account_name ap_bank_accounts.bank_account_name%TYPE := NULL;

Line 473: l_location hz_cust_site_uses.location%TYPE DEFAULT NULL;

469: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
470: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL;
471: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL;
472: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL; --payment uptake changes bichatte
473: l_location hz_cust_site_uses.location%TYPE DEFAULT NULL;
474: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL;
475: l_default_site_use VARCHAR2(1) DEFAULT 'Y';
476: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL;
477: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL;

Line 474: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL;

470: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL;
471: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL;
472: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL; --payment uptake changes bichatte
473: l_location hz_cust_site_uses.location%TYPE DEFAULT NULL;
474: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL;
475: l_default_site_use VARCHAR2(1) DEFAULT 'Y';
476: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL;
477: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL;
478: l_remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL;

Line 1388: x_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE;

1384: l_cust_site_use_rec hz_cust_account_site_v2pub.CUST_SITE_USE_REC_TYPE;
1385: l_customer_profile_rec HZ_CUSTOMER_PROFILE_V2PUB.CUSTOMER_PROFILE_REC_TYPE;
1386: l_create_profile VARCHAR2(1) := FND_API.G_TRUE;
1387: l_create_profile_amt VARCHAR2(1) := FND_API.G_TRUE;
1388: x_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE;
1389: x_site_return_status VARCHAR2(1);
1390: x_msg_data VARCHAR2(1000);
1391: x_msg_count NUMBER;
1392: BEGIN

Line 1518: x_site_use_id hz_cust_site_uses.site_use_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;
1518: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;
1519: x_location hz_locations.city%TYPE := NULL;
1520: x_bank_id hz_parties.party_id%TYPE := NULL;
1521: x_branch_id hz_parties.party_id%TYPE := NULL;
1522: x_acct_id IBY_EXT_BANK_ACCOUNTS.EXT_BANK_ACCOUNT_ID%TYPE := NULL;

Line 2170: x_site_use_id hz_cust_site_uses.site_use_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;
2170: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;
2171: x_location hz_locations.city%TYPE := NULL;
2172:
2173:
2174:

Line 2795: x_site_use_id hz_cust_site_uses.site_use_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;
2795: x_site_use_id hz_cust_site_uses.site_use_id%TYPE := NULL;
2796: x_location hz_locations.city%TYPE := NULL;
2797:
2798: l_inv_trx_type_id NUMBER;
2799:

Line 3453: HZ_CUST_SITE_USES_ALL use

3449: USE.site_use_id
3450: INTO x_cust_acct_site_id,
3451: x_site_use_id
3452: FROM HZ_CUST_ACCT_SITES_ALL site,
3453: HZ_CUST_SITE_USES_ALL use
3454: WHERE cust_account_id = x_cust_account_id
3455: AND site.org_id = p_org_id
3456: AND site.party_site_id = x_party_site_id
3457: AND site.cust_acct_site_id = USE.cust_acct_site_id