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.OKS_COVERAGE_MIGRATION dependencies on OKS_ACTION_TIMES

Line 1572: AND NOT EXISTS (Select cov_action_type_id FROM OKS_ACTION_TIMES WHERE COV_ACTION_TYPE_ID =TYP.id)

1568: AND TIM.DNZ_CHR_ID = RIN.DNZ_CHR_ID
1569: AND TIM.DNZ_CHR_ID = RGP.DNZ_CHR_ID
1570: AND TIM.DNZ_CHR_ID = RUL.DNZ_CHR_ID
1571: AND TIM.DNZ_CHR_ID = TYP.DNZ_CHR_ID
1572: AND NOT EXISTS (Select cov_action_type_id FROM OKS_ACTION_TIMES WHERE COV_ACTION_TYPE_ID =TYP.id)
1573: ORDER BY RUL.ID;
1574:
1575:
1576: TYPE RowId_Tbl_Type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 4701: AND NOT EXISTS (Select cle_id FROM OKS_ACTION_TIMES_H WHERE CLE_ID = TYP.cle_id and major_version = typ.major_version)

4697: AND rul.major_version = TYP.major_version
4698: AND RIN.major_version = TYP.major_version
4699: AND RIN.major_version = RUL.major_version
4700: AND TIM.major_version = RIN.major_version
4701: AND NOT EXISTS (Select cle_id FROM OKS_ACTION_TIMES_H WHERE CLE_ID = TYP.cle_id and major_version = typ.major_version)
4702: ORDER BY RUL.ID;
4703:
4704:
4705: TYPE RowId_Tbl_Type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 4868: INSERT INTO OKS_ACTION_TIMES_H(

4864: l_tabsize := i_acmv_tbl_in.COUNT;
4865: -- l_status := 'Before Insert';
4866:
4867: FORALL I IN 1 .. l_tabsize
4868: INSERT INTO OKS_ACTION_TIMES_H(
4869: ID,
4870: COV_ACTION_TYPE_ID,
4871: CLE_ID,
4872: DNZ_CHR_ID,