DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on HZ_ORGANIZATION_PROFILES_S

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 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),