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.DDR_REF_UTIL_PKG dependencies on DDR_R_ORG_BSNS_ENT

Line 539: FROM DDR_R_ORG_BSNS_ENT t1 INNER JOIN DDR_R_ORG_BSNS_ENT t2

535: t1.ORG_BSNS_ENT_ID PARENT_ID, t1.BSNS_ENT_CD PARENT_CD,
536: t2.ORG_BSNS_ENT_ID CHILD_ID, t2.BSNS_ENT_CD CHILD_CD,
537: t2.SRC_SYS_DT SRC_SYS_DT, t2.SRC_SYS_IDNT SRC_SYS_IDNT,
538: t1.EFF_FROM_DT EFF_FROM_DT, t1.EFF_TO_DT, t2.EFF_FROM_DT FROM_DT_2, t2.EFF_TO_DT TO_DT_2
539: FROM DDR_R_ORG_BSNS_ENT t1 INNER JOIN DDR_R_ORG_BSNS_ENT t2
540: ON (t1.BSNS_ENT_CD = t2.BSNS_ENT_PRNT_CD AND t1.ORG_HCHY_ID =
541: t2.ORG_HCHY_ID)
542: )
543: WHERE NOT ((TO_DT_2 is not null AND TO_DT_2 < EFF_FROM_DT) OR (EFF_TO_DT is not null AND FROM_DT_2 > EFF_TO_DT))

Line 556: FROM DDR_R_ORG_BSNS_ENT

552: ORG_BSNS_ENT_ID CHILD_ID,
553: BSNS_ENT_CD CHILD_CD,
554: SRC_SYS_DT, SRC_SYS_IDNT,
555: EFF_FROM_DT, EFF_TO_DT
556: FROM DDR_R_ORG_BSNS_ENT
557: WHERE BSNS_ENT_PRNT_CD is null
558: )
559: )
560: START WITH PARENT_CD is null