DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_ORG_CONTACTS_S

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

2330: cont_int.start_date,
2331: cont_int.end_date,
2332: cont_int.sub_orig_system sos,
2333: cont_int.sub_orig_system_reference sosr,
2334: nvl(cont_mosr.owner_table_id, hz_org_contacts_s.NextVal) cont_id,
2335: cont_int.contact_orig_system cont_orig_system,
2336: cont_int.contact_orig_system_reference cont_orig_system_reference,
2337: /*6913856 */
2338: coalesce(sub_sg.party_id, sub_int.party_id,sub_mosr.owner_table_id) sub_id,

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

2413: cont_int.start_date,
2414: cont_int.end_date,
2415: cont_int.sub_orig_system sos,
2416: cont_int.sub_orig_system_reference sosr,
2417: nvl(cont_mosr.owner_table_id, hz_org_contacts_s.NextVal) cont_id,
2418: cont_int.contact_orig_system cont_orig_system,
2419: cont_int.contact_orig_system_reference cont_orig_system_reference,
2420: coalesce(sub_sg.party_id, sub_int.party_id,sub_mosr.owner_table_id) sub_id,
2421: coalesce(obj_sg.party_id, obj_int.party_id,obj_mosr.owner_table_id) obj_id,