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 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