[Home] [Help]
486: ,NULL
487: ,p.CATEGORY_CODE
488: ,p.REFERENCE_USE_FLAG
489: ,NULL
490: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
491: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
492: AND p.party_id = pe.party_id
493: AND pe.effective_end_date is NULL
494: AND p.PARTY_TYPE ='PERSON';
553: ,NULL
554: ,p.CATEGORY_CODE
555: ,p.REFERENCE_USE_FLAG
556: ,NULL
557: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
558: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
559: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
560: WHERE sp.party_id = p.party_id)
561: AND p.party_id = pe.party_id
846: , H_TX47(1)
847: , H_TX48(1)
848: , H_TX156(1)
849: , H_TX157(1)
850: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
851: WHERE p.party_id = p_party_id
852: AND p.party_id = pe.party_id
853: AND (p.status = 'M' or pe.effective_end_date is NULL) AND ROWNUM=1;
854: ELSE
1158: , H_TX47(1)
1159: , H_TX48(1)
1160: , H_TX156(1)
1161: , H_TX157(1)
1162: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe
1163: WHERE p.party_id = p_party_id
1164: AND p.party_id = pe.party_id
1165: AND (p.status = 'M' or pe.effective_end_date is NULL) AND ROWNUM=1;
1166: ELSE
1392: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
1393: ,oc.CONTACT_NUMBER
1394: ,oc.JOB_TITLE
1395: FROM HZ_DQM_STAGE_GT g, HZ_RELATIONSHIPS r,
1396: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
1397: WHERE oc.party_relationship_id = r.relationship_id
1398: AND r.object_id = g.party_id
1399: AND r.subject_id = pp.party_id
1400: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1517: , H_TX2(1)
1518: , H_TX11(1)
1519: , H_TX22(1)
1520: FROM HZ_ORG_CONTACTS oc, HZ_DQM_SYNC_INTERFACE d,
1521: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1522: WHERE d.ENTITY = 'CONTACTS'
1523: AND oc.org_contact_id = p_org_contact_id
1524: AND oc.org_contact_id = d.RECORD_ID
1525: AND oc.party_relationship_id = r.relationship_id
1652: ,H_TX2(1)
1653: ,H_TX11(1)
1654: ,H_TX22(1)
1655: FROM HZ_ORG_CONTACTS oc,
1656: HZ_RELATIONSHIPS r, HZ_PERSON_PROFILES pp
1657: WHERE
1658: oc.org_contact_id = p_org_contact_id
1659: AND oc.party_relationship_id = r.relationship_id
1660: AND r.subject_id = pp.party_id
2998: ,NULL
2999: ,p.CATEGORY_CODE
3000: ,p.REFERENCE_USE_FLAG
3001: ,NULL
3002: FROM HZ_PARTIES p, HZ_PERSON_PROFILES pe, HZ_DQM_SYNC_INTERFACE dsi
3003: WHERE p.party_id = pe.party_id
3004: AND p.party_id = dsi.party_id
3005: AND p.PARTY_TYPE = 'PERSON'
3006: AND dsi.entity = 'PARTY'
3707: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
3708: ,oc.CONTACT_NUMBER
3709: ,oc.JOB_TITLE
3710: FROM HZ_DQM_SYNC_INTERFACE dsi, HZ_RELATIONSHIPS r,
3711: HZ_ORG_CONTACTS oc, HZ_PERSON_PROFILES pp
3712: WHERE oc.party_relationship_id = r.relationship_id
3713: AND dsi.record_id = oc.org_contact_id
3714: AND r.subject_id = pp.party_id
3715: AND r.subject_type = 'PERSON'
4338: ,p.CATEGORY_CODE
4339: ,p.REFERENCE_USE_FLAG
4340: ,NULL
4341: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4342: ,HZ_PERSON_PROFILES pe
4343: WHERE p.request_id = bd.main_conc_req_id
4344: AND bd.batch_id = ps.batch_id
4345: AND p.PARTY_TYPE = 'PERSON'
4346: AND p.party_id = ps.party_id
4450: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
4451: ,oc.CONTACT_NUMBER
4452: ,oc.JOB_TITLE
4453: FROM hz_org_contacts oc, hz_imp_contacts_sg ocsg, hz_imp_batch_details bd,
4454: hz_relationships r, hz_person_profiles pp
4455: WHERE ocsg.batch_mode_flag = p_batch_mode_flag
4456: AND oc.party_relationship_id = r.relationship_id
4457: AND ocsg.batch_id = p_batch_id
4458: AND ocsg.sub_orig_system = p_os
4480: ,rtrim(pp.person_first_name || ' ' || pp.person_last_name)
4481: ,oc.CONTACT_NUMBER
4482: ,oc.JOB_TITLE
4483: FROM hz_org_contacts oc, hz_imp_relships_sg rsg, hz_imp_batch_details bd
4484: ,hz_relationships r, hz_person_profiles pp
4485: WHERE rsg.batch_mode_flag = p_batch_mode_flag
4486: AND rsg.batch_id = p_batch_id
4487: AND rsg.sub_orig_system = p_os
4488: AND rsg.relationship_id = oc.party_relationship_id