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.FII_AR_REC_AGING_PKG dependencies on BIS_BUCKET

Line 102: FROM bis_bucket_customizations bbc,

98: decode(bbc.range8_low, null, 0, 1) +
99: decode(bbc.range9_low, null, 0, 1) +
100: decode(bbc.range10_low, null, 0, 1)) bucket_count
101: INTO l_bucket_ct
102: FROM bis_bucket_customizations bbc,
103: bis_bucket bb
104: WHERE bb.short_name = 'FII_DBI_PAST_DUE_REC_BUCKET'
105: AND bbc.bucket_id = bb.bucket_id;
106:

Line 103: bis_bucket bb

99: decode(bbc.range9_low, null, 0, 1) +
100: decode(bbc.range10_low, null, 0, 1)) bucket_count
101: INTO l_bucket_ct
102: FROM bis_bucket_customizations bbc,
103: bis_bucket bb
104: WHERE bb.short_name = 'FII_DBI_PAST_DUE_REC_BUCKET'
105: AND bbc.bucket_id = bb.bucket_id;
106:
107: -- Construct the self node clause

Line 780: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

776: l_sqlstmt VARCHAR2(30000);
777: l_where_clause VARCHAR2(2000);
778: l_return_status VARCHAR2(10);
779: l_curr_label VARCHAR2(240);
780: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
781: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
782: l_bucket_ct NUMBER;
783: l_as_of_date DATE;
784: l_cust_suffix VARCHAR2(6);

Line 887: FROM bis_bucket_customizations bbc,

883: decode(bbc.range8_low, null, 0, 1) +
884: decode(bbc.range9_low, null, 0, 1) +
885: decode(bbc.range10_low, null, 0, 1)) bucket_count
886: INTO l_bucket_ct
887: FROM bis_bucket_customizations bbc,
888: bis_bucket bb
889: WHERE bb.short_name = 'FII_DBI_PAST_DUE_REC_BUCKET'
890: AND bbc.bucket_id = bb.bucket_id;
891:

Line 888: bis_bucket bb

884: decode(bbc.range9_low, null, 0, 1) +
885: decode(bbc.range10_low, null, 0, 1)) bucket_count
886: INTO l_bucket_ct
887: FROM bis_bucket_customizations bbc,
888: bis_bucket bb
889: WHERE bb.short_name = 'FII_DBI_PAST_DUE_REC_BUCKET'
890: AND bbc.bucket_id = bb.bucket_id;
891:
892: -------------------------------------------------------------------------

Line 923: BIS_BUCKET_PUB.retrieve_bis_bucket (

919: -- Clean up temp table
920: delete from FII_AR_REC_AGING_SUM_GT;
921:
922: -- Retrieve the bucket labels for this report and insert into temp table
923: BIS_BUCKET_PUB.retrieve_bis_bucket (
924: p_short_name => 'FII_DBI_PAST_DUE_REC_BUCKET',
925: x_bis_bucket_rec => l_bis_bucket_rec,
926: x_return_status => l_return_status,
927: x_error_tbl => l_error_tbl

Line 925: x_bis_bucket_rec => l_bis_bucket_rec,

921:
922: -- Retrieve the bucket labels for this report and insert into temp table
923: BIS_BUCKET_PUB.retrieve_bis_bucket (
924: p_short_name => 'FII_DBI_PAST_DUE_REC_BUCKET',
925: x_bis_bucket_rec => l_bis_bucket_rec,
926: x_return_status => l_return_status,
927: x_error_tbl => l_error_tbl
928: );
929:

Line 940: l_bis_bucket_rec.range1_name || ''' ,''' ||

936: --------------------------------------------------------------------
937: l_sqlstmt :=
938: 'SELECT /*+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/ ''' ||
939: l_curr_label || ''' ,''' ||
940: l_bis_bucket_rec.range1_name || ''' ,''' ||
941: l_bis_bucket_rec.range2_name || ''' ,''' ||
942: l_bis_bucket_rec.range3_name || ''' ,''' ||
943: l_bis_bucket_rec.range4_name || ''' ,''' ||
944: l_bis_bucket_rec.range5_name || ''' ,''' ||

Line 941: l_bis_bucket_rec.range2_name || ''' ,''' ||

937: l_sqlstmt :=
938: 'SELECT /*+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/ ''' ||
939: l_curr_label || ''' ,''' ||
940: l_bis_bucket_rec.range1_name || ''' ,''' ||
941: l_bis_bucket_rec.range2_name || ''' ,''' ||
942: l_bis_bucket_rec.range3_name || ''' ,''' ||
943: l_bis_bucket_rec.range4_name || ''' ,''' ||
944: l_bis_bucket_rec.range5_name || ''' ,''' ||
945: l_bis_bucket_rec.range6_name || ''' ,''' ||

Line 942: l_bis_bucket_rec.range3_name || ''' ,''' ||

938: 'SELECT /*+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/ ''' ||
939: l_curr_label || ''' ,''' ||
940: l_bis_bucket_rec.range1_name || ''' ,''' ||
941: l_bis_bucket_rec.range2_name || ''' ,''' ||
942: l_bis_bucket_rec.range3_name || ''' ,''' ||
943: l_bis_bucket_rec.range4_name || ''' ,''' ||
944: l_bis_bucket_rec.range5_name || ''' ,''' ||
945: l_bis_bucket_rec.range6_name || ''' ,''' ||
946: l_bis_bucket_rec.range7_name || ''' ,

Line 943: l_bis_bucket_rec.range4_name || ''' ,''' ||

939: l_curr_label || ''' ,''' ||
940: l_bis_bucket_rec.range1_name || ''' ,''' ||
941: l_bis_bucket_rec.range2_name || ''' ,''' ||
942: l_bis_bucket_rec.range3_name || ''' ,''' ||
943: l_bis_bucket_rec.range4_name || ''' ,''' ||
944: l_bis_bucket_rec.range5_name || ''' ,''' ||
945: l_bis_bucket_rec.range6_name || ''' ,''' ||
946: l_bis_bucket_rec.range7_name || ''' ,
947: SUM(f.current_bucket_1_amount) + SUM(f.current_bucket_2_amount)

Line 944: l_bis_bucket_rec.range5_name || ''' ,''' ||

940: l_bis_bucket_rec.range1_name || ''' ,''' ||
941: l_bis_bucket_rec.range2_name || ''' ,''' ||
942: l_bis_bucket_rec.range3_name || ''' ,''' ||
943: l_bis_bucket_rec.range4_name || ''' ,''' ||
944: l_bis_bucket_rec.range5_name || ''' ,''' ||
945: l_bis_bucket_rec.range6_name || ''' ,''' ||
946: l_bis_bucket_rec.range7_name || ''' ,
947: SUM(f.current_bucket_1_amount) + SUM(f.current_bucket_2_amount)
948: + SUM(f.current_bucket_3_amount),

Line 945: l_bis_bucket_rec.range6_name || ''' ,''' ||

941: l_bis_bucket_rec.range2_name || ''' ,''' ||
942: l_bis_bucket_rec.range3_name || ''' ,''' ||
943: l_bis_bucket_rec.range4_name || ''' ,''' ||
944: l_bis_bucket_rec.range5_name || ''' ,''' ||
945: l_bis_bucket_rec.range6_name || ''' ,''' ||
946: l_bis_bucket_rec.range7_name || ''' ,
947: SUM(f.current_bucket_1_amount) + SUM(f.current_bucket_2_amount)
948: + SUM(f.current_bucket_3_amount),
949: SUM(f.past_due_bucket_1_amount),

Line 946: l_bis_bucket_rec.range7_name || ''' ,

942: l_bis_bucket_rec.range3_name || ''' ,''' ||
943: l_bis_bucket_rec.range4_name || ''' ,''' ||
944: l_bis_bucket_rec.range5_name || ''' ,''' ||
945: l_bis_bucket_rec.range6_name || ''' ,''' ||
946: l_bis_bucket_rec.range7_name || ''' ,
947: SUM(f.current_bucket_1_amount) + SUM(f.current_bucket_2_amount)
948: + SUM(f.current_bucket_3_amount),
949: SUM(f.past_due_bucket_1_amount),
950: SUM(f.past_due_bucket_2_amount),