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_ORGANIZATION_PROFILES

Line 469: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

465: ,op.SIC_CODE_TYPE
466: ,p.CATEGORY_CODE
467: ,p.REFERENCE_USE_FLAG
468: ,op.CORPORATION_CLASS
469: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
470: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
471: AND p.party_id = op.party_id
472: AND op.effective_end_date is NULL
473: AND p.PARTY_TYPE ='ORGANIZATION';

Line 534: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

530: ,op.SIC_CODE_TYPE
531: ,p.CATEGORY_CODE
532: ,p.REFERENCE_USE_FLAG
533: ,op.CORPORATION_CLASS
534: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
535: WHERE mod(p.PARTY_ID, p_num_workers) = p_worker_number
536: AND NOT EXISTS (select 1 FROM HZ_STAGED_PARTIES sp
537: WHERE sp.party_id = p.party_id)
538: AND p.party_id = op.party_id

Line 817: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

813: , H_TX47(1)
814: , H_TX48(1)
815: , H_TX156(1)
816: , H_TX157(1)
817: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
818: WHERE p.party_id = p_party_id
819: AND p.party_id = op.party_id
820: AND (p.status = 'M' or op.effective_end_date is NULL) AND ROWNUM=1;
821: ELSIF p_party_type = 'PERSON' THEN

Line 1129: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op

1125: , H_TX47(1)
1126: , H_TX48(1)
1127: , H_TX156(1)
1128: , H_TX157(1)
1129: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op
1130: WHERE p.party_id = p_party_id
1131: AND p.party_id = op.party_id
1132: AND (p.status = 'M' or op.effective_end_date is NULL) AND ROWNUM=1;
1133: ELSIF l_party_type = 'PERSON' THEN

Line 2976: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi

2972: ,op.SIC_CODE_TYPE
2973: ,p.CATEGORY_CODE
2974: ,p.REFERENCE_USE_FLAG
2975: ,op.CORPORATION_CLASS
2976: FROM HZ_PARTIES p, HZ_ORGANIZATION_PROFILES op, HZ_DQM_SYNC_INTERFACE dsi
2977: WHERE p.party_id = op.party_id
2978: AND p.party_id = dsi.party_id
2979: AND p.PARTY_TYPE = 'ORGANIZATION'
2980: AND dsi.entity = 'PARTY'

Line 4313: ,HZ_ORGANIZATION_PROFILES op

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'
4317: AND p.party_id = ps.party_id