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_PARTY_SITES

Line 822: l_party_site_id hz_party_sites.party_site_id%TYPE DEFAULT NULL;

818: l_remittance_message1 ap_invoices.remittance_message1%TYPE DEFAULT NULL;
819: l_remittance_message2 ap_invoices.remittance_message2%TYPE DEFAULT NULL;
820: l_remittance_message3 ap_invoices.remittance_message3%TYPE DEFAULT NULL;
821: l_party_id hz_parties.party_id%TYPE DEFAULT NULL;
822: l_party_site_id hz_party_sites.party_site_id%TYPE DEFAULT NULL;
823: l_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
824: x_msg_count NUMBER;
825: x_msg_data VARCHAR2(1000);
826: l_organization_name hr_operating_units.NAME%TYPE;

Line 1516: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;

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

Line 1517: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;

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

Line 2168: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;

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

Line 2169: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;

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

Line 2793: x_party_site_id hz_party_sites.party_site_id%TYPE := NULL;

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

Line 2794: x_party_site_name hz_party_sites.party_site_name%TYPE := NULL;

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

Line 3408: FROM hz_party_sites hps,

3404: loc.city
3405: INTO x_party_site_id,
3406: x_party_site_name,
3407: x_location
3408: FROM hz_party_sites hps,
3409: ap_supplier_sites_all vs,
3410: hz_locations loc
3411: WHERE vs.vendor_site_id = p_vendor_site_id
3412: AND vs.party_site_id = hps.party_site_id

Line 3432: FROM hz_party_sites hps,

3428: loc.city
3429: INTO x_party_site_id,
3430: x_party_site_name,
3431: x_location
3432: FROM hz_party_sites hps,
3433: hz_locations loc
3434: WHERE hps.party_id = p_party_id
3435: AND hps.location_id = loc.location_id
3436: AND hps.identifying_address_flag = 'Y'

Line 4002: HZ_PARTY_SITES hzps,

3998: l_expiry_date,
3999: l_card_exists
4000: FROM IBY_CREDITCARD cc,
4001: HZ_PARTIES hzp,
4002: HZ_PARTY_SITES hzps,
4003: HZ_PARTY_SITE_USES hzpsu,
4004: IBY_CREDITCARD_ISSUERS_VL ccissuers
4005: WHERE ccissuers.card_issuer_code = cc.card_issuer_code
4006: AND cc.CARD_OWNER_ID = hzp.party_id