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.OKI_DBI_SRM_RNWL_PVT dependencies on BIS_BUCKET_PUB

Line 1768: l_bucket_rec bis_bucket_pub.BIS_BUCKET_REC_TYPE;

1764: l_to_date_xtd VARCHAR2 (3);
1765:
1766: l_curr_sql VARCHAR2(32767) ;
1767: l_rep_sql VARCHAR2(32767) ;
1768: l_bucket_rec bis_bucket_pub.BIS_BUCKET_REC_TYPE;
1769: l_error_tbl bis_utilities_pub.ERROR_TBL_TYPE;
1770: l_status VARCHAR2(10000);
1771:
1772: --Amount columns

Line 1825: bis_bucket_pub.RETRIEVE_BIS_BUCKET('OKI_DBI_SRM_LATE_AGING', l_bucket_rec, l_status, l_error_tbl);

1821: l_b9_amt := 'bucket9_amt_' || l_cur_suffix ;
1822: l_b10_amt := 'bucket10_amt_' || l_cur_suffix ;
1823:
1824: -- Retrieve record to get bucket labels
1825: bis_bucket_pub.RETRIEVE_BIS_BUCKET('OKI_DBI_SRM_LATE_AGING', l_bucket_rec, l_status, l_error_tbl);
1826:
1827: /* sum(decode(cal.report_date, &BIS_CURRENT_ASOF_DATE,
1828: (case when ' || l_b1_amt || '> 0
1829: then fact.bucket1_cnt_g