APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_IMP_BATCH_DETAILS

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

4308: ,op.SIC_CODE_TYPE
4309: ,p.CATEGORY_CODE
4310: ,p.REFERENCE_USE_FLAG
4311: ,op.CORPORATION_CLASS
4312: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4313: ,HZ_ORGANIZATION_PROFILES op
4314: WHERE p.request_id = bd.main_conc_req_id
4315: AND bd.batch_id = ps.batch_id
4316: AND p.PARTY_TYPE = 'ORGANIZATION'

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

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

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

4366: ,NULL
4367: ,p.CATEGORY_CODE
4368: ,p.REFERENCE_USE_FLAG
4369: ,NULL
4370: FROM HZ_PARTIES p, HZ_IMP_PARTIES_SG ps, HZ_IMP_BATCH_DETAILS bd
4371: WHERE p.request_id = bd.main_conc_req_id
4372: AND bd.batch_id = ps.batch_id
4373: AND p.party_id = ps.party_id
4374: AND ps.batch_id = p_batch_id

Line 4418: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd

4414: ,ps.IDENTIFYING_ADDRESS_FLAG
4415: ,ps.STATUS
4416: ,l.ADDRESS1
4417: FROM hz_locations l, hz_party_sites ps,
4418: hz_imp_addresses_sg addr_sg, hz_imp_batch_details bd
4419: WHERE l.request_id = bd.main_conc_req_id
4420: AND bd.batch_id = addr_sg.batch_id
4421: AND l.location_id = ps.location_id
4422: AND addr_sg.batch_id = p_batch_id

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

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

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

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

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

4531: ,translate(phone_country_code|| ' ' || phone_area_code||' ' || phone_number,'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz!"#$%&()''*+,-./:;<=>?@[\]^_`{|}~ ','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
4532: ,cp.PHONE_LINE_TYPE
4533: ,cp.STATUS
4534: ,cp.CONTACT_POINT_PURPOSE
4535: FROM hz_contact_points cp, hz_imp_contactpts_sg cps, hz_imp_batch_details bd
4536: WHERE cp.request_id = bd.main_conc_req_id
4537: AND bd.batch_id = cps.batch_id
4538: AND cp.contact_point_id = cps.contact_point_id
4539: AND cps.batch_id = p_batch_id