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.ISC_DBI_BOOK_SUM2_F_C dependencies on OE_SALES_CREDITS

Line 80: /* Insert into ISC_TMP_BOOK_SUM2 order lines from ISC_SALES_CREDITS_F to be recollected because their sales credit have been deleted from OE_SALES_CREDITS */

76:
77: FII_UTIL.Stop_Timer;
78: FII_UTIL.Print_Timer('Inserted '||sql%rowcount||' rows into isc_tmp_book_sum2 (updated lines) in');
79:
80: /* Insert into ISC_TMP_BOOK_SUM2 order lines from ISC_SALES_CREDITS_F to be recollected because their sales credit have been deleted from OE_SALES_CREDITS */
81: FII_UTIL.Start_Timer;
82: INSERT INTO isc_tmp_book_sum2 (pk1)
83: SELECT f.line_id
84: FROM isc_book_sum2_f f

Line 87: WHERE NOT EXISTS (SELECT 1 FROM oe_sales_credits WHERE sales_credit_id = fact.sales_credit_id)

83: SELECT f.line_id
84: FROM isc_book_sum2_f f
85: WHERE header_id IN (SELECT fact.header_id
86: FROM isc_sales_credits_f fact
87: WHERE NOT EXISTS (SELECT 1 FROM oe_sales_credits WHERE sales_credit_id = fact.sales_credit_id)
88: )
89: AND NOT EXISTS (SELECT 1 FROM isc_tmp_book_sum2 a WHERE a.pk1 = f.line_id);
90:
91: FII_UTIL.Stop_Timer;

Line 138: oe_sales_credits sc,

134: sc.salesrep_id, sc.header_id, sc.line_id, sr.resource_id,
135: sr.org_id, sc.sales_group_id group_id, sc.created_by, sc.creation_date,
136: sc.last_updated_by, sc.last_update_date, sc.last_update_login
137: from oe_sales_credit_types sc_typ,
138: oe_sales_credits sc,
139: jtf_rs_salesreps sr
140: where sc.sales_group_id is not null
141: and sc.salesrep_id = sr.salesrep_id
142: and sc.sales_credit_type_id = sc_typ.sales_credit_type_id

Line 152: oe_sales_credits sc,

148: sc.salesrep_id, sc.header_id, sc.line_id, sg.resource_id,
149: sg.org_id, sg.group_id, sc.created_by, sc.creation_date,
150: sc.last_updated_by, sc.last_update_date, sc.last_update_login
151: from oe_sales_credit_types sc_typ,
152: oe_sales_credits sc,
153: jtf_rs_srp_groups sg
154: where sc.sales_group_id is null
155: and sc.salesrep_id = sg.salesrep_id
156: and sc.last_update_date between sg.start_date and sg.end_date

Line 2856: oe_sales_credits sc,

2852: sc.salesrep_id, sc.header_id, sc.line_id, sr.resource_id,
2853: sr.org_id, sc.sales_group_id group_id, sc.created_by, sc.creation_date,
2854: sc.last_updated_by, sc.last_update_date, sc.last_update_login
2855: from oe_sales_credit_types sc_typ,
2856: oe_sales_credits sc,
2857: jtf_rs_salesreps sr
2858: where sc.sales_group_id is not null
2859: and sc.salesrep_id = sr.salesrep_id
2860: and sc.sales_credit_type_id = sc_typ.sales_credit_type_id

Line 2870: oe_sales_credits sc,

2866: sc.salesrep_id, sc.header_id, sc.line_id, sg.resource_id,
2867: sg.org_id, sg.group_id, sc.created_by, sc.creation_date,
2868: sc.last_updated_by, sc.last_update_date, sc.last_update_login
2869: from oe_sales_credit_types sc_typ,
2870: oe_sales_credits sc,
2871: jtf_rs_srp_groups sg
2872: where sc.sales_group_id is null
2873: and sc.salesrep_id = sg.salesrep_id
2874: and sc.last_update_date between sg.start_date and sg.end_date