APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_IMP_BATCH_DETAILS

Line 4338: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd

4334: ,op.SIC_CODE_TYPE
4335: ,p.CATEGORY_CODE
4336: ,p.REFERENCE_USE_FLAG
4337: ,op.CORPORATION_CLASS
4338: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4339: ,HZ_ORGANIZATION_PROFILES op
4340: WHERE p.request_id = bd.main_conc_req_id
4341: AND bd.batch_id = ps.batch_id
4342: AND p.PARTY_TYPE = 'ORGANIZATION'

Line 4367: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd

4363: ,NULL
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'

Line 4396: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd

4392: ,NULL
4393: ,p.CATEGORY_CODE
4394: ,p.REFERENCE_USE_FLAG
4395: ,NULL
4396: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4397: WHERE p.request_id = bd.main_conc_req_id
4398: AND bd.batch_id = ps.batch_id
4399: AND p.party_id = ps.party_id
4400: AND ps.batch_id = p_batch_id

Line 4444: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd

4440: ,ps.IDENTIFYING_ADDRESS_FLAG
4441: ,ps.STATUS
4442: ,l.ADDRESS1
4443: FROM hz_locations l, hz_party_sites ps,
4444: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd
4445: WHERE l.request_id = bd.main_conc_req_id
4446: AND bd.batch_id = addr_sg.batch_id
4447: AND l.location_id = ps.location_id
4448: AND addr_sg.batch_id = p_batch_id

Line 4479: FROM hz_org_contacts oc, hz_imp_contacts_sg ocsg, hz_imp_batch_details bd,

4475: ,oc.ROWID
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

Line 4509: FROM hz_org_contacts oc, hz_imp_relships_sg rsg, hz_imp_batch_details bd

4505: ,oc.ROWID
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

Line 4561: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd

4557: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
4558: ,cp.PHONE_LINE_TYPE
4559: ,cp.STATUS
4560: ,cp.CONTACT_POINT_PURPOSE
4561: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd
4562: WHERE cp.request_id = bd.main_conc_req_id
4563: AND bd.batch_id = cps.batch_id
4564: AND cp.contact_point_id = cps.contact_point_id
4565: AND cps.batch_id = p_batch_id