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 ISC_BOOK_SUM2_F

Line 69: FROM isc_book_sum2_f f

65: /* Insert into ISC_TMP_BOOK_SUM2 all the orders lines for orders having at least 1 line that is present in ISC_TMP_BOOK_SUM2 */
66: FII_UTIL.Start_Timer;
67: INSERT INTO isc_tmp_book_sum2 (pk1)
68: SELECT f.line_id
69: FROM isc_book_sum2_f f
70: WHERE f.header_id IN (SELECT fact.header_id
71: FROM isc_sales_credits_f fact,
72: isc_tmp_book_sum2 tmp
73: WHERE fact.line_id = tmp.pk1

Line 84: FROM isc_book_sum2_f f

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
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: )

Line 102: FROM isc_book_sum2_f f

98: -- SERVICE rows whose ORDER or CUSTOMER_PRODUCT parent line_id has been updated
99: FII_UTIL.Start_Timer;
100: INSERT INTO ISC_TMP_BOOK_SUM2 (pk1)
101: SELECT f.line_id
102: FROM isc_book_sum2_f f
103: WHERE f.header_id IN
104: (SELECT fact.header_id
105: FROM isc_tmp_book_sum2 tmp,
106: isc_book_sum2_f fact

Line 106: isc_book_sum2_f fact

102: FROM isc_book_sum2_f f
103: WHERE f.header_id IN
104: (SELECT fact.header_id
105: FROM isc_tmp_book_sum2 tmp,
106: isc_book_sum2_f fact
107: WHERE tmp.pk1 = fact.service_parent_line_id
108: AND EXISTS (SELECT 1 FROM isc_book_sum2_f WHERE line_id = fact.service_parent_line_id))
109: AND NOT EXISTS( SELECT 1 FROM isc_tmp_book_sum2 a WHERE a.pk1 = f.line_id);
110:

Line 108: AND EXISTS (SELECT 1 FROM isc_book_sum2_f WHERE line_id = fact.service_parent_line_id))

104: (SELECT fact.header_id
105: FROM isc_tmp_book_sum2 tmp,
106: isc_book_sum2_f fact
107: WHERE tmp.pk1 = fact.service_parent_line_id
108: AND EXISTS (SELECT 1 FROM isc_book_sum2_f WHERE line_id = fact.service_parent_line_id))
109: AND NOT EXISTS( SELECT 1 FROM isc_tmp_book_sum2 a WHERE a.pk1 = f.line_id);
110:
111: FII_UTIL.Stop_Timer;
112: FII_UTIL.Print_Timer('Inserted '||sql%rowcount||' rows into isc_tmp_book_sum2 (service_parent_line_id...) in');

Line 171: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t5, s

167: 'DIRECT-'||s.sales_credit_id pk,
168: s.sales_credit_id, s.group_id, t5.header_id, t5.line_id,
169: 1 rnk, s.resource_id, s.percent, s.sales_credit_type_id, s.created_by,
170: s.creation_date, s.last_updated_by, s.last_update_date, s.last_update_login
171: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t5, s
172: WHERE tmp.pk1 = t5.line_id
173: AND s.org_id = t5.org_ou_id
174: AND s.line_id = t5.line_id
175: UNION ALL

Line 181: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t7a, s

177: 'SERVICE_PARENT-'||t7a.line_id||'-'||s.sales_credit_id pk,
178: s.sales_credit_id, s.group_id, t7a.header_id, t7a.line_id,
179: 2 rnk, s.resource_id, s.percent, s.sales_credit_type_id, s.created_by,
180: s.creation_date, s.last_updated_by, s.last_update_date, s.last_update_login
181: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t7a, s
182: WHERE tmp.pk1 = t7a.line_id
183: AND s.org_id = t7a.org_ou_id
184: AND s.line_id = t7a.service_parent_line_id
185: AND t7a.item_type_code = 'SERVICE'

Line 194: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t7b1, isc_book_sum2_f t7b2, s

190: s.sales_credit_id, s.group_id group_id, t7b2.header_id, t7b2.line_id,
191: 3 rnk, s.resource_id,
192: s.percent, s.sales_credit_type_id, s.created_by,
193: s.creation_date, s.last_updated_by, s.last_update_date, s.last_update_login
194: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t7b1, isc_book_sum2_f t7b2, s
195: WHERE tmp.pk1 = t7b2.line_id
196: AND t7b2.item_type_code = 'SERVICE'
197: AND t7b1.line_id = t7b2.service_parent_line_id
198: AND s.line_id = t7b1.top_model_line_id

Line 207: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t7b1, s

203: s.sales_credit_id, s.group_id, t7b1.header_id, t7b1.line_id,
204: 4 rnk, s.resource_id,
205: s.percent, s.sales_credit_type_id, s.created_by,
206: s.creation_date, s.last_updated_by, s.last_update_date, s.last_update_login
207: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t7b1, s
208: WHERE tmp.pk1 = t7b1.line_id
209: AND s.line_id = t7b1.top_model_line_id
210: AND s.org_id = t7b1.org_ou_id
211: UNION ALL

Line 217: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t11, s

213: 'HEADER-'||t11.line_id||'-'||s.sales_credit_id pk,
214: s.sales_credit_id, s.group_id, t11.header_id, t11.line_id,
215: 5 rnk, s.resource_id, s.percent, s.sales_credit_type_id, s.created_by,
216: s.creation_date, s.last_updated_by, s.last_update_date, s.last_update_login
217: FROM isc_tmp_book_sum2 tmp, isc_book_sum2_f t11, s
218: WHERE tmp.pk1 = t11.line_id
219: AND s.line_id IS NULL
220: AND s.org_id = t11.org_ou_id
221: AND s.header_id = t11.header_id))

Line 583: DELETE FROM isc_book_sum2_f

579:
580: BIS_COLLECTION_UTILITIES.put_line('Deleting obsolete records from the base summary');
581: FII_UTIL.Start_Timer;
582:
583: DELETE FROM isc_book_sum2_f
584: WHERE line_id IN (select pk1
585: from isc_tmp_book_sum2
586: where view_type = -1)
587: AND fulfilled_flag = 'N';

Line 1648: INSERT /+ APPEND PARALLEL(F) / INTO ISC_BOOK_SUM2_F F

1644: l_total := 0;
1645:
1646:
1647:
1648: INSERT /*+ APPEND PARALLEL(F) */ INTO ISC_BOOK_SUM2_F F
1649: (line_id,
1650: item_id,
1651: inv_org_id,
1652: inv_ou_id,

Line 1889: MERGE INTO ISC_BOOK_SUM2_F f

1885:
1886: l_count := 0;
1887:
1888:
1889: MERGE INTO ISC_BOOK_SUM2_F f
1890: USING
1891: (select new.* from ISCBV_BOOK_SUM2_FCV new, ISC_BOOK_SUM2_F old
1892: where new.line_id = old.line_id(+)
1893: and new.batch_id = v_batch_id

Line 1891: (select new.* from ISCBV_BOOK_SUM2_FCV new, ISC_BOOK_SUM2_F old

1887:
1888:
1889: MERGE INTO ISC_BOOK_SUM2_F f
1890: USING
1891: (select new.* from ISCBV_BOOK_SUM2_FCV new, ISC_BOOK_SUM2_F old
1892: where new.line_id = old.line_id(+)
1893: and new.batch_id = v_batch_id
1894: and (old.line_id is null
1895: or new.customer_id <> old.customer_id

Line 2375: IF (NOT BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_F')) THEN

2371:
2372: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2373: BIS_COLLECTION_UTILITIES.put_line('Begin the ' || g_load_mode || ' load of the base summary ');
2374:
2375: IF (NOT BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_F')) THEN
2376: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
2377: return;
2378: END IF;
2379:

Line 2417: IF (truncate_table('ISC_BOOK_SUM2_F') = -1) THEN

2413: BIS_COLLECTION_UTILITIES.put_line(' ');
2414: BIS_COLLECTION_UTILITIES.put_line('Truncating the fact table');
2415: FII_UTIL.Start_Timer;
2416:
2417: IF (truncate_table('ISC_BOOK_SUM2_F') = -1) THEN
2418: RAISE l_failure;
2419: END IF;
2420:
2421: FII_UTIL.Stop_Timer;

Line 2483: IF (truncate_table('ISC_BOOK_SUM2_F') = -1) THEN

2479: BIS_COLLECTION_UTILITIES.put_line(' ');
2480: BIS_COLLECTION_UTILITIES.put_line('Truncating the fact table');
2481: FII_UTIL.Start_Timer;
2482:
2483: IF (truncate_table('ISC_BOOK_SUM2_F') = -1) THEN
2484: RAISE l_failure;
2485: END IF;
2486:
2487: FII_UTIL.Stop_Timer;

Line 2576: IF (NOT BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_F')) THEN

2572:
2573: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2574: BIS_COLLECTION_UTILITIES.put_line('Begin the ' || g_load_mode || ' load of the base summary ');
2575:
2576: IF (NOT BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_F')) THEN
2577: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
2578: return;
2579: END IF;
2580:

Line 2581: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_F', l_start, l_end, l_period_from, l_period_to);

2577: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
2578: return;
2579: END IF;
2580:
2581: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_F', l_start, l_end, l_period_from, l_period_to);
2582: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date := l_period_to;
2583: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date := sysdate;
2584:
2585: IF (CHECK_SETUP = -1)

Line 2891: from isc_book_sum2_f t5, s

2887: 'DIRECT-'||s.sales_credit_id pk, s.sales_credit_id, s.group_id,
2888: t5.header_id, t5.line_id, 1 rnk, s.resource_id, s.percent,
2889: s.sales_credit_type_id, s.created_by, s.creation_date,
2890: s.last_updated_by, s.last_update_date, s.last_update_login
2891: from isc_book_sum2_f t5, s
2892: where s.line_id = t5.line_id
2893: and s.org_id = t5.org_ou_id
2894: union all
2895: select /*+ parallel(s) parallel(t7a) use_hash(s) pq_distribute(s,hash,hash) */

Line 2901: from isc_book_sum2_f t7a, s

2897: s.sales_credit_id, s.group_id, t7a.header_id, t7a.line_id, 2 rnk,
2898: s.resource_id, s.percent, s.sales_credit_type_id, s.created_by,
2899: s.creation_date, s.last_updated_by, s.last_update_date,
2900: s.last_update_login
2901: from isc_book_sum2_f t7a, s
2902: where s.line_id = t7a.service_parent_line_id
2903: and s.org_id = t7a.org_ou_id
2904: and t7a.item_type_code = 'SERVICE'
2905: union all

Line 2913: from isc_book_sum2_f t7b2, isc_book_sum2_f t7b1, s

2909: s.sales_credit_id, s.group_id, t7b2.header_id, t7b2.line_id, 3 rnk,
2910: s.resource_id, s.percent, s.sales_credit_type_id, s.created_by,
2911: s.creation_date, s.last_updated_by, s.last_update_date,
2912: s.last_update_login
2913: from isc_book_sum2_f t7b2, isc_book_sum2_f t7b1, s
2914: where s.line_id = t7b1.top_model_line_id
2915: and s.org_id = t7b1.org_ou_id
2916: and t7b1.line_id = t7b2.service_parent_line_id
2917: and t7b2.item_type_code = 'SERVICE'

Line 2925: from isc_book_sum2_f t7b1, s

2921: s.sales_credit_id, s.group_id, t7b1.header_id, t7b1.line_id, 4 rnk,
2922: s.resource_id, s.percent, s.sales_credit_type_id, s.created_by,
2923: s.creation_date, s.last_updated_by, s.last_update_date,
2924: s.last_update_login
2925: from isc_book_sum2_f t7b1, s
2926: where s.line_id = t7b1.top_model_line_id
2927: and s.org_id = t7b1.org_ou_id
2928: union all
2929: select /*+ ordered parallel(s) parallel(t11) use_hash(s) pq_distribute(s,hash,hash) */

Line 2935: from isc_book_sum2_f t11, s

2931: s.sales_credit_id, s.group_id, t11.header_id, t11.line_id, 5 rnk,
2932: s.resource_id, s.percent, s.sales_credit_type_id, s.created_by,
2933: s.creation_date, s.last_updated_by, s.last_update_date,
2934: s.last_update_login
2935: from isc_book_sum2_f t11, s
2936: where s.line_id is null
2937: and s.org_id = t11.org_ou_id
2938: and s.header_id = t11.header_id))
2939: where low_rnk = 1;