APPS.DDR_ODI dependencies on DDR_R_ORG_BSNS_ENT

Line 499: FROM DDR_R_ORG_BSNS_ENT t1 INNER JOIN DDR_R_ORG_BSNS_ENT t2

495: t1.ORG_BSNS_ENT_ID PARENT_ID, t1.BSNS_ENT_CD PARENT_CD,
496: t2.ORG_BSNS_ENT_ID CHILD_ID, t2.BSNS_ENT_CD CHILD_CD,
497: t2.SRC_SYS_DT SRC_SYS_DT, t2.SRC_SYS_IDNT SRC_SYS_IDNT,
498: 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
499: FROM DDR_R_ORG_BSNS_ENT t1 INNER JOIN DDR_R_ORG_BSNS_ENT t2
500: ON (t1.BSNS_ENT_CD = t2.BSNS_ENT_PRNT_CD AND t1.ORG_HCHY_ID = t2.ORG_HCHY_ID)
501: )
502: 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))
503: UNION

Line 515: FROM DDR_R_ORG_BSNS_ENT

511: ORG_BSNS_ENT_ID CHILD_ID,
512: BSNS_ENT_CD CHILD_CD,
513: SRC_SYS_DT, SRC_SYS_IDNT,
514: EFF_FROM_DT, EFF_TO_DT
515: FROM DDR_R_ORG_BSNS_ENT
516: WHERE BSNS_ENT_PRNT_CD is null
517: )
518: )
519: START WITH PARENT_CD is null