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.OPI_EDW_FACT_SZ dependencies on OPI_EDW_JOB_DETAIL_FOPM_SZ

Line 65: OPI_EDW_JOB_DETAIL_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;

61: p_opi_num_rows NUMBER := 0 ;
62: p_pmi_num_rows NUMBER := 0 ;
63: BEGIN
64: OPI_EDW_JOB_DETAIL_F_SZ.cnt_rows(p_from_date, p_to_date, p_opi_num_rows) ;
65: OPI_EDW_JOB_DETAIL_FOPM_SZ.cnt_rows(p_from_date, p_to_date, p_pmi_num_rows) ;
66: p_num_rows := p_opi_num_rows + p_pmi_num_rows ;
67: END;
68:
69: -- procedure to get average row length Job Details Fact rows.

Line 78: OPI_EDW_JOB_DETAIL_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;

74: p_opi_row_len NUMBER := 0 ;
75: p_pmi_row_len NUMBER := 0 ;
76: BEGIN
77: OPI_EDW_JOB_DETAIL_F_SZ.est_row_len(p_from_date, p_to_date, p_opi_row_len) ;
78: OPI_EDW_JOB_DETAIL_FOPM_SZ.est_row_len(p_from_date, p_to_date, p_pmi_row_len) ;
79: p_avg_row_len := greatest(p_opi_row_len + p_pmi_row_len);
80: END;
81:
82: