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_SITE_USES_ALL

Line 763: hz_cust_site_uses_all su -- bug 4454799

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
767: AND site.cust_account_id = cust.cust_account_id

Line 777: hz_cust_site_uses_all su -- bug 4454799

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
781: AND site.cust_account_id = cust.cust_account_id

Line 793: hz_cust_site_uses_all su -- bug 4454799

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'
797: AND site.cust_account_id = rel.cust_account_id

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 1337: hz_cust_site_uses_all rsu -- but 4454799

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
1341: AND ra.cust_acct_site_id = rsu.cust_acct_site_id

Line 3046: hz_cust_site_uses_all su -- bug 4454799

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
3050: and site.org_id = p_org_id -- bug 4454799

Line 3097: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

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
3101: FROM hz_cust_accounts cust,

Line 3103: hz_cust_site_uses_all suse

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
3107: and site.org_id = p_org_id -- bug 4454799

Line 3118: update hz_cust_site_uses_all

3114: BEGIN
3115: open pflag;
3116: fetch pflag into l_acct_site_id,l_site_use_id;
3117: IF pflag%FOUND THEN
3118: update hz_cust_site_uses_all
3119: set primary_flag = 'N',
3120: last_update_login = hz_utility_v2pub.last_update_login,
3121: last_update_date = SYSDATE,
3122: last_updated_by = hz_utility_v2pub.last_updated_by,

Line 4180: hz_cust_site_uses_all hcs,

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
4184: AND cbi.primary_flag = 'Y'