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.

VIEW: APPS.DDR_R_AOH_LVL_3_ATTR_MV#

Source

View Text - Preformatted


select distinct
         hchy.ORG_HCHY_ID HRCHY_ID
,        hchy.HRCHY_CD HRCHY_CD
,        hchy.HRCHY_NAME
,        bent.ORG_BSNS_ENT_ID BSNS_ENT_ID
,        bent.BSNS_ENT_CD
,        bent.BSNS_ENT_NAME
,        bent.BSNS_ENT_TYPE
,        bent.BSNS_ENT_PLANNING
,        bent.BSNS_ENT_HEAD_NAME
,        ald.PRNT1_BSNS_ENT_CD
,        ald.PRNT1_BSNS_ENT_ID
,        ald.PRNT2_BSNS_ENT_CD
,        ald.PRNT2_BSNS_ENT_ID
from     DDR_R_ORG_HCHY hchy
,        DDR_R_ORG_BSNS_ENT bent
,        DDR_R_AOH_LVL_DTL ald
where   hchy.ORG_HCHY_ID = ald.ORG_HCHY_ID
and     bent.ORG_BSNS_ENT_ID = ald.PRNT3_BSNS_ENT_ID
and     bent.BSNS_ENT_CD = ald.PRNT3_BSNS_ENT_CD

View Text - HTML Formatted

SELECT DISTINCT HCHY.ORG_HCHY_ID HRCHY_ID
, HCHY.HRCHY_CD HRCHY_CD
, HCHY.HRCHY_NAME
, BENT.ORG_BSNS_ENT_ID BSNS_ENT_ID
, BENT.BSNS_ENT_CD
, BENT.BSNS_ENT_NAME
, BENT.BSNS_ENT_TYPE
, BENT.BSNS_ENT_PLANNING
, BENT.BSNS_ENT_HEAD_NAME
, ALD.PRNT1_BSNS_ENT_CD
, ALD.PRNT1_BSNS_ENT_ID
, ALD.PRNT2_BSNS_ENT_CD
, ALD.PRNT2_BSNS_ENT_ID FROM DDR_R_ORG_HCHY HCHY
, DDR_R_ORG_BSNS_ENT BENT
, DDR_R_AOH_LVL_DTL ALD WHERE HCHY.ORG_HCHY_ID = ALD.ORG_HCHY_ID AND BENT.ORG_BSNS_ENT_ID = ALD.PRNT3_BSNS_ENT_ID AND BENT.BSNS_ENT_CD = ALD.PRNT3_BSNS_ENT_CD