eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_STAGE_MAP_TRANSFORM dependencies on HZ_IMP_PARTIES_SG

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