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_ORGANIZATION_PROFILES

Line 2355: FROM hz_organization_profiles org,

2351: decode(sst.organization_name_phonetic, '', 'Y', 'N'),
2352: nvl(i.cust_tax_reference, org.tax_reference),
2353: i.cust_tax_reference,
2354: decode(sst.tax_reference, '', 'Y', 'N'),nvl(org.version_number,1)+1
2355: FROM hz_organization_profiles org,
2356: hz_organization_profiles sst,
2357: ra_customers_interface_all i, -- Bug 4956131
2358: hz_cust_accounts cust,
2359: (SELECT min(i1.rowid) myrowid

Line 2356: hz_organization_profiles sst,

2352: nvl(i.cust_tax_reference, org.tax_reference),
2353: i.cust_tax_reference,
2354: decode(sst.tax_reference, '', 'Y', 'N'),nvl(org.version_number,1)+1
2355: FROM hz_organization_profiles org,
2356: hz_organization_profiles sst,
2357: ra_customers_interface_all i, -- Bug 4956131
2358: hz_cust_accounts cust,
2359: (SELECT min(i1.rowid) myrowid
2360: FROM ra_customers_interface_all i1 -- Bug 4956131

Line 2425: -- check if mix-n-match is set up on hz_organization_profiles.

2421: l_last_fetch BOOLEAN := FALSE;
2422:
2423: BEGIN
2424:
2425: -- check if mix-n-match is set up on hz_organization_profiles.
2426: l_enabled :=
2427: HZ_MIXNM_UTILITY.isMixNMatchEnabled(
2428: 'HZ_ORGANIZATION_PROFILES', l_entity_attr_id);
2429: IF l_enabled = 'N' THEN

Line 2428: 'HZ_ORGANIZATION_PROFILES', l_entity_attr_id);

2424:
2425: -- check if mix-n-match is set up on hz_organization_profiles.
2426: l_enabled :=
2427: HZ_MIXNM_UTILITY.isMixNMatchEnabled(
2428: 'HZ_ORGANIZATION_PROFILES', l_entity_attr_id);
2429: IF l_enabled = 'N' THEN
2430: RETURN;
2431: END IF;
2432:

Line 2495: UPDATE hz_organization_profiles

2491:
2492: -- end-dated user-entered profiles for which we need to create new.
2493:
2494: FORALL i IN create_start..create_end
2495: UPDATE hz_organization_profiles
2496: SET effective_end_date = decode(trunc(effective_start_date),trunc(sysdate),trunc(sysdate),TRUNC(SYSDATE-1))
2497: WHERE organization_profile_id = i_ue_profile_id(i);
2498:
2499: -- create new user entered profiles

Line 2502: INSERT INTO hz_organization_profiles (

2498:
2499: -- create new user entered profiles
2500:
2501: FORALL i IN create_start..create_end
2502: INSERT INTO hz_organization_profiles (
2503: created_by,
2504: creation_date,
2505: last_update_login,
2506: last_update_date,

Line 2539: hz_organization_profiles_s.nextval,

2535: 'USER_ENTERED',
2536: 'USER_ENTERED',
2537: 'TCA-CUSTOMER-INTERFACE',
2538: 222,
2539: hz_organization_profiles_s.nextval,
2540: i_party_id(i),
2541: SYSDATE,
2542: 1,
2543: i_jgzz_fiscal_code(i),

Line 2553: UPDATE hz_organization_profiles

2549:
2550: -- update user entered profiles
2551:
2552: FORALL i IN update_start..update_end
2553: UPDATE hz_organization_profiles
2554: SET
2555: last_updated_by = g_last_updated_by,
2556: last_update_login = g_last_update_login,
2557: last_update_date = SYSDATE,