DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_ORG_CONTACTS_S

Line 2304: nvl(cont_mosr.owner_table_id, hz_org_contacts_s.NextVal) cont_id,

2300: cont_int.start_date,
2301: cont_int.end_date,
2302: cont_int.sub_orig_system sos,
2303: cont_int.sub_orig_system_reference sosr,
2304: nvl(cont_mosr.owner_table_id, hz_org_contacts_s.NextVal) cont_id,
2305: cont_int.contact_orig_system cont_orig_system,
2306: cont_int.contact_orig_system_reference cont_orig_system_reference,
2307: /*6913856 */
2308: coalesce(sub_sg.party_id, sub_int.party_id,sub_mosr.owner_table_id) sub_id,

Line 2387: nvl(cont_mosr.owner_table_id, hz_org_contacts_s.NextVal) cont_id,

2383: cont_int.start_date,
2384: cont_int.end_date,
2385: cont_int.sub_orig_system sos,
2386: cont_int.sub_orig_system_reference sosr,
2387: nvl(cont_mosr.owner_table_id, hz_org_contacts_s.NextVal) cont_id,
2388: cont_int.contact_orig_system cont_orig_system,
2389: cont_int.contact_orig_system_reference cont_orig_system_reference,
2390: coalesce(sub_sg.party_id, sub_int.party_id,sub_mosr.owner_table_id) sub_id,
2391: coalesce(obj_sg.party_id, obj_int.party_id,obj_mosr.owner_table_id) obj_id,