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.HZ_CUSTOMER_INT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 42: FROM hz_cust_acct_sites_all -- bug 4454799

38: RETURN NUMBER IS
39: l_cust_acct_site_id NUMBER;
40: CURSOR c2 IS
41: SELECT cust_acct_site_id
42: FROM hz_cust_acct_sites_all -- bug 4454799
43: WHERE orig_system_reference = p_orig_system_address_ref
44: AND org_id = p_org_id; -- bug 4454799
45: BEGIN
46: OPEN c2;

Line 215: FROM hz_cust_acct_sites_all -- bug 4454799

211: RETURN NUMBER IS
212: l_party_site_id NUMBER;
213: CURSOR c5 IS
214: SELECT party_site_id
215: FROM hz_cust_acct_sites_all -- bug 4454799
216: WHERE orig_system_reference = p_orig_system_address_ref
217: AND org_id = p_org_id; -- bug 4454799
218: BEGIN
219: OPEN c5;

Line 762: hz_cust_acct_sites_all site, -- bug 4454799

758:
759: CURSOR c IS -- Checkif the customer or the related customer already exists
760: SELECT 'x'
761: FROM hz_cust_accounts cust,
762: hz_cust_acct_sites_all site, -- bug 4454799
763: hz_cust_site_uses_all su -- bug 4454799
764: WHERE cust.orig_system_reference = p_orig_system_customer_ref
765: AND site.orig_system_reference = p_bill_to_orig_address_ref
766: AND site.org_id = p_org_id -- bug 4454799

Line 776: hz_cust_acct_sites_all site, -- bug 4454799

772: AND site.status = 'A'
773: UNION ALL
774: SELECT 'x'
775: FROM hz_cust_accounts cust,
776: hz_cust_acct_sites_all site, -- bug 4454799
777: hz_cust_site_uses_all su -- bug 4454799
778: WHERE cust.orig_system_reference = p_orig_system_parent_ref
779: AND site.orig_system_reference = p_bill_to_orig_address_ref
780: AND site.org_id = p_org_id -- bug 4454799

Line 792: hz_cust_acct_sites_all site, -- bug 4454799

788: CURSOR c2 IS -- Checking if the relationship already exists
789: SELECT 'x'
790: FROM hz_cust_accounts cust,
791: hz_cust_acct_relate_all rel, -- bug 4454799
792: hz_cust_acct_sites_all site, -- bug 4454799
793: hz_cust_site_uses_all su -- bug 4454799
794: WHERE cust.orig_system_reference = p_orig_system_customer_ref
795: AND rel.related_cust_account_id = cust.cust_account_id
796: AND rel.bill_to_flag = 'Y'

Line 1312: FROM hz_cust_acct_sites_all ra, hz_cust_site_uses_all rsu, hz_cust_accounts rc -- bug 4454799

1308: AND p.site_use_id is null;
1309:
1310: CURSOR c3 IS
1311: SELECT 'x' -- The address ref should exist as Bill To and defined for the customer
1312: FROM hz_cust_acct_sites_all ra, hz_cust_site_uses_all rsu, hz_cust_accounts rc -- bug 4454799
1313: WHERE ra.orig_system_reference = v_orig_system_address_ref
1314: AND ra.org_id = v_org_id -- bug 4454799
1315: AND rc.orig_system_reference = v_orig_system_customer_ref
1316: AND rc.cust_account_id = ra.cust_account_id

Line 1336: hz_cust_acct_sites_all ra, -- bug 4454799

1332:
1333: CURSOR c4 IS -- Checking if Profile exists at Site Use Level
1334: SELECT 'x'
1335: FROM hz_customer_profiles p,
1336: hz_cust_acct_sites_all ra, -- bug 4454799
1337: hz_cust_site_uses_all rsu -- but 4454799
1338: WHERE ra.orig_system_reference = v_orig_system_address_ref
1339: AND ra.org_id = v_org_id -- bug 4454799
1340: AND ra.org_id = rsu.org_id -- bug 4454799

Line 1982: FROM hz_party_sites site, hz_cust_acct_sites_all cust_site -- bug 4454799

1978:
1979:
1980: CURSOR c IS -- Check if the party_site_number already exists
1981: SELECT decode(cust_site.orig_system_reference,p_orig_system_address_ref,'','Y6,')
1982: FROM hz_party_sites site, hz_cust_acct_sites_all cust_site -- bug 4454799
1983: WHERE site.party_site_number = p_party_site_number
1984: AND cust_site.org_id = p_org_id -- bug 4454799
1985: AND site.party_site_id = cust_site.party_site_id;
1986:

Line 2086: FROM hz_cust_acct_sites_all cs, -- bug 4454799

2082: l_is_remit_to_location VARCHAR2(1) := 'N';
2083: CURSOR C1 IS
2084: SELECT loc.location_id,loc.country,loc.city, loc.state,
2085: loc.county, loc.province, loc.postal_code
2086: FROM hz_cust_acct_sites_all cs, -- bug 4454799
2087: hz_party_sites ps,
2088: hz_locations loc
2089: WHERE cs.orig_system_reference = p_orig_system_address_ref
2090: AND cs.org_id = p_org_id -- bug 4454799

Line 3045: hz_cust_acct_sites_all site, -- bug 4454799

3041: /* 4588090. Modified site use condition in the cursor. */
3042: CURSOR pflag is
3043: SELECT su.primary_flag
3044: FROM hz_cust_accounts cust,
3045: hz_cust_acct_sites_all site, -- bug 4454799
3046: hz_cust_site_uses_all su -- bug 4454799
3047: WHERE cust.orig_system_reference = p_orig_system_customer_ref
3048: and cust.cust_account_id = site.cust_account_id
3049: and site.cust_acct_site_id = su.cust_acct_site_id

Line 3096: l_acct_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

3092: PROCEDURE set_primary_flag( p_orig_system_customer_ref IN VARCHAR2,
3093: p_site_use_code IN VARCHAR2,
3094: p_org_id IN NUMBER)
3095: IS
3096: l_acct_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
3097: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
3098:
3099: CURSOR pflag is
3100: SELECT site.cust_acct_site_id,suse.site_use_id

Line 3102: hz_cust_acct_sites_all site,

3098:
3099: CURSOR pflag is
3100: SELECT site.cust_acct_site_id,suse.site_use_id
3101: FROM hz_cust_accounts cust,
3102: hz_cust_acct_sites_all site,
3103: hz_cust_site_uses_all suse
3104: WHERE cust.orig_system_reference = p_orig_system_customer_ref
3105: and cust.cust_account_id = site.cust_account_id
3106: and site.cust_acct_site_id = suse.cust_acct_site_id

Line 3128: update hz_cust_acct_sites_all

3124: program_application_id = hz_utility_v2pub.program_application_id,
3125: program_id = hz_utility_v2pub.program_id
3126: where site_use_id = l_site_use_id;
3127:
3128: update hz_cust_acct_sites_all
3129: set BILL_TO_FLAG = decode(p_site_use_code,'BILL_TO','Y',BILL_TO_FLAG),
3130: SHIP_TO_FLAG = decode(p_site_use_code,'SHIP_TO','Y',SHIP_TO_FLAG),
3131: MARKET_FLAG = decode(p_site_use_code,'MARKET','Y',MARKET_FLAG),
3132: last_update_login = hz_utility_v2pub.last_update_login,

Line 4179: hz_cust_acct_sites_all hca,

4175: select ipi.instrument_payment_use_id, ipi.order_of_preference
4176: FROM iby_external_payers_all iep,
4177: iby_pmt_instr_uses_all ipi,
4178: iby_ext_bank_accounts eba,
4179: hz_cust_acct_sites_all hca,
4180: hz_cust_site_uses_all hcs,
4181: hz_cust_accounts hcu,
4182: ra_customer_banks_int_all cbi
4183: WHERE cbi.request_id = p_request_id