[Home] [Help]
512: ,NULL
513: ,p.CATEGORY_CODE
514: ,p.REFERENCE_USE_FLAG
515: ,NULL
516: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
517: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
518: AND p.party_id = pe.party_id
519: AND pe.effective_end_date is NULL
520: AND p.PARTY_TYPE ='PERSON';
579: ,NULL
580: ,p.CATEGORY_CODE
581: ,p.REFERENCE_USE_FLAG
582: ,NULL
583: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
584: WHERE p.rowid BETWEEN p_start_rowid and p_end_rowid
585: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
586: WHERE sp.party_id = p.party_id)
587: AND p.party_id = pe.party_id
872: , H_TX47(1)
873: , H_TX48(1)
874: , H_TX156(1)
875: , H_TX157(1)
876: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
877: WHERE p.party_id = p_party_id
878: AND p.party_id = pe.party_id
879: AND (p.status = 'M' or pe.effective_end_date is NULL) AND ROWNUM=1;
880: ELSE
1184: , H_TX47(1)
1185: , H_TX48(1)
1186: , H_TX156(1)
1187: , H_TX157(1)
1188: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
1189: WHERE p.party_id = p_party_id
1190: AND p.party_id = pe.party_id
1191: AND (p.status = 'M' or pe.effective_end_date is NULL) AND ROWNUM=1;
1192: ELSE
1418: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
1419: ,oc.CONTACT_NUMBER
1420: ,oc.JOB_TITLE
1421: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,
1422: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
1423: WHERE oc.party_relationship_id = r.relationship_id
1424: AND r.object_id = g.party_id
1425: AND r.subject_id = pp.party_id
1426: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1543: , H_TX2(1)
1544: , H_TX11(1)
1545: , H_TX22(1)
1546: FROM HZ_ORG_CONTACTS oc, HZ_DQM_SYNC_INTERFACE d,
1547: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1548: WHERE d.ENTITY = 'CONTACTS'
1549: AND oc.org_contact_id = p_org_contact_id
1550: AND oc.org_contact_id = d.RECORD_ID
1551: AND oc.party_relationship_id = r.relationship_id
1678: ,H_TX2(1)
1679: ,H_TX11(1)
1680: ,H_TX22(1)
1681: FROM HZ_ORG_CONTACTS oc,
1682: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1683: WHERE
1684: oc.org_contact_id = p_org_contact_id
1685: AND oc.party_relationship_id = r.relationship_id
1686: AND r.subject_id = pp.party_id
3024: ,NULL
3025: ,p.CATEGORY_CODE
3026: ,p.REFERENCE_USE_FLAG
3027: ,NULL
3028: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi
3029: WHERE p.party_id = pe.party_id
3030: AND p.party_id = dsi.party_id
3031: AND p.PARTY_TYPE = 'PERSON'
3032: AND dsi.entity = 'PARTY'
3733: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
3734: ,oc.CONTACT_NUMBER
3735: ,oc.JOB_TITLE
3736: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,
3737: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
3738: WHERE oc.party_relationship_id = r.relationship_id
3739: AND dsi.record_id = oc.org_contact_id
3740: AND r.subject_id = pp.party_id
3741: AND r.subject_type = 'PERSON'
4364: ,p.CATEGORY_CODE
4365: ,p.REFERENCE_USE_FLAG
4366: ,NULL
4367: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4368: ,HZ_PERSON_PROFILES pe
4369: WHERE p.request_id = bd.main_conc_req_id
4370: AND bd.batch_id = ps.batch_id
4371: AND p.PARTY_TYPE = 'PERSON'
4372: AND p.party_id = ps.party_id
4476: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
4477: ,oc.CONTACT_NUMBER
4478: ,oc.JOB_TITLE
4479: FROM hz_org_contacts oc, hz_imp_contacts_sg ocsg, hz_imp_batch_details bd,
4480: hz_relationships r, hz_person_profiles pp
4481: WHERE ocsg.batch_mode_flag = p_batch_mode_flag
4482: AND oc.party_relationship_id = r.relationship_id
4483: AND ocsg.batch_id = p_batch_id
4484: AND ocsg.sub_orig_system = p_os
4506: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
4507: ,oc.CONTACT_NUMBER
4508: ,oc.JOB_TITLE
4509: FROM hz_org_contacts oc, hz_imp_relships_sg rsg, hz_imp_batch_details bd
4510: ,hz_relationships r, hz_person_profiles pp
4511: WHERE rsg.batch_mode_flag = p_batch_mode_flag
4512: AND rsg.batch_id = p_batch_id
4513: AND rsg.sub_orig_system = p_os
4514: AND rsg.relationship_id = oc.party_relationship_id