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.EDW_GEOGRAPHY_M_C dependencies on POA_EDW_TEMP_GEOG

Line 204: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

200:
201:
202: -------- To get PK info from the warehouse (bug #1757640) ------
203:
204: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
205: EXECUTE IMMEDIATE g_stmt;
206:
207: /* Insert from remote warehouse level table */
208: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 208: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

204: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
205: EXECUTE IMMEDIATE g_stmt;
206:
207: /* Insert from remote warehouse level table */
208: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
209: 'SELECT POSTCODE_CITY_PK FROM EDW_GEOG_POSTCODE_CITY_LTC@' ||
210: g_target_link;
211: EXECUTE IMMEDIATE g_stmt;
212:

Line 273: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where POSTCODE_CITY_PK = TEMP_PK);

269: postcode_city_pk, city_fk, postcode_fk, postcode_city_dp,
270: name, instance, user_attribute1, user_attribute2,
271: user_attribute3, user_attribute4, user_attribute5)
272: where
273: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where POSTCODE_CITY_PK = TEMP_PK);
274:
275: l_rows_inserted := sql%rowcount;
276: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
277:

Line 299: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

295: edw_log.put_line('Starting Push_EDW_GEOG_CITY_LSTG');
296:
297: -------- To get PK info from the warehouse (bug #1757640) ------
298:
299: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
300: EXECUTE IMMEDIATE g_stmt;
301:
302: /* Insert from remote warehouse level table */
303: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 303: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

299: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
300: EXECUTE IMMEDIATE g_stmt;
301:
302: /* Insert from remote warehouse level table */
303: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
304: 'SELECT CITY_PK FROM EDW_GEOG_CITY_LTC@' ||
305: g_target_link;
306: EXECUTE IMMEDIATE g_stmt;
307:

Line 364: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where CITY_PK = TEMP_PK);

360: city_pk, state_region_fk, city_dp, name, instance,
361: user_attribute1, user_attribute2, user_attribute3,
362: user_attribute4, user_attribute5)
363: where
364: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where CITY_PK = TEMP_PK);
365:
366: l_rows_inserted := sql%rowcount;
367: g_row_count := g_row_count + l_rows_inserted ;
368:

Line 390: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

386: edw_log.put_line('Starting Push_EDW_GEOG_POSTCODE_LSTG');
387:
388: -------- To get PK info from the warehouse (bug #1757640) ------
389:
390: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
391: EXECUTE IMMEDIATE g_stmt;
392:
393: /* Insert from remote warehouse level table */
394: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 394: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

390: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
391: EXECUTE IMMEDIATE g_stmt;
392:
393: /* Insert from remote warehouse level table */
394: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
395: 'SELECT POSTCODE_PK FROM EDW_GEOG_POSTCODE_LTC@' ||
396: g_target_link;
397: EXECUTE IMMEDIATE g_stmt;
398:

Line 455: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where POSTCODE_PK = TEMP_PK);

451: postcode_pk, state_region_fk, postcode_dp, name, instance,
452: user_attribute1, user_attribute2, user_attribute3,
453: user_attribute4, user_attribute5)
454: where
455: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where POSTCODE_PK = TEMP_PK);
456:
457: l_rows_inserted := sql%rowcount;
458: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
459:

Line 482: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

478: edw_log.put_line('Starting Push_EDW_GEOG_STATE_REGION_LSTG');
479:
480: -------- To get PK info from the warehouse (bug #1757640) ------
481:
482: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
483: EXECUTE IMMEDIATE g_stmt;
484:
485: /* Insert from remote warehouse level table */
486: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 486: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

482: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
483: EXECUTE IMMEDIATE g_stmt;
484:
485: /* Insert from remote warehouse level table */
486: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
487: 'SELECT STATE_REGION_PK FROM EDW_GEOG_STATE_REGION_LTC@' ||
488: g_target_link;
489: EXECUTE IMMEDIATE g_stmt;
490:

Line 554: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where STATE_REGION_PK = TEMP_PK);

550: state_region_pk, state_fk, state_region_dp, name, instance,
551: user_attribute1, user_attribute2, user_attribute3,
552: user_attribute4, user_attribute5)
553: where
554: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where STATE_REGION_PK = TEMP_PK);
555:
556: l_rows_inserted := sql%rowcount;
557: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
558:

Line 580: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

576: edw_log.put_line('Starting Push_EDW_GEOG_STATE_LSTG');
577:
578: -------- To get PK info from the warehouse (bug #1757640) ------
579:
580: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
581: EXECUTE IMMEDIATE g_stmt;
582:
583: /* Insert from remote warehouse level table */
584: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 584: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

580: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
581: EXECUTE IMMEDIATE g_stmt;
582:
583: /* Insert from remote warehouse level table */
584: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
585: 'SELECT STATE_PK FROM EDW_GEOG_STATE_LTC@' ||
586: g_target_link;
587: EXECUTE IMMEDIATE g_stmt;
588:

Line 646: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where STATE_PK = TEMP_PK);

642: state_pk, region_fk, state_dp, name, instance,
643: user_attribute1, user_attribute2, user_attribute3,
644: user_attribute4, user_attribute5)
645: where
646: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where STATE_PK = TEMP_PK);
647:
648: l_rows_inserted := sql%rowcount;
649: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
650:

Line 673: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

669: edw_log.put_line('Starting Push_EDW_GEOG_REGION_LSTG');
670:
671: -------- To get PK info from the warehouse (bug #1757640) ------
672:
673: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
674: EXECUTE IMMEDIATE g_stmt;
675:
676: /* Insert from remote warehouse level table */
677: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 677: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

673: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
674: EXECUTE IMMEDIATE g_stmt;
675:
676: /* Insert from remote warehouse level table */
677: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
678: 'SELECT REGION_PK FROM EDW_GEOG_REGION_LTC@' ||
679: g_target_link;
680: EXECUTE IMMEDIATE g_stmt;
681:

Line 745: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where REGION_PK = TEMP_PK);

741: region_pk, country_fk, region_dp, name, instance,
742: user_attribute1, user_attribute2, user_attribute3,
743: user_attribute4, user_attribute5)
744: where
745: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where REGION_PK = TEMP_PK);
746:
747: l_rows_inserted := sql%rowcount;
748: g_row_count := g_row_count + l_rows_inserted ;
749:

Line 771: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

767: edw_log.put_line('Starting Push_EDW_GEOG_COUNTRY_LSTG');
768:
769: -------- To get PK info from the warehouse (bug #1757640) ------
770:
771: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
772: EXECUTE IMMEDIATE g_stmt;
773:
774: /* Insert from remote warehouse level table */
775: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 775: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

771: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
772: EXECUTE IMMEDIATE g_stmt;
773:
774: /* Insert from remote warehouse level table */
775: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
776: 'SELECT COUNTRY_PK FROM EDW_GEOG_COUNTRY_LTC@' ||
777: g_target_link;
778: EXECUTE IMMEDIATE g_stmt;
779:

Line 836: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where COUNTRY_PK = TEMP_PK);

832: country_pk, area2_fk, country_dp, name, instance,
833: user_attribute1, user_attribute2, user_attribute3,
834: user_attribute4, user_attribute5)
835: where
836: NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where COUNTRY_PK = TEMP_PK);
837:
838: l_rows_inserted := sql%rowcount;
839: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
840:

Line 864: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

860: edw_log.put_line('Starting Push_EDW_GEOG_AREA2_LSTG');
861:
862: -------- To get PK info from the warehouse (bug #1757640) ------
863:
864: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
865: EXECUTE IMMEDIATE g_stmt;
866:
867: /* Insert from remote warehouse level table */
868: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 868: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

864: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
865: EXECUTE IMMEDIATE g_stmt;
866:
867: /* Insert from remote warehouse level table */
868: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
869: 'SELECT AREA2_PK FROM EDW_GEOG_AREA2_LTC@' ||
870: g_target_link;
871: EXECUTE IMMEDIATE g_stmt;
872:

Line 919: AND NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where AREA2_PK = TEMP_PK);

915: 'READY'
916: from EDW_GEOG_AREA2_LCV
917: where (last_update_date between l_date1 and l_date2
918: OR last_update_date is NULL)
919: AND NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where AREA2_PK = TEMP_PK);
920:
921: l_rows_inserted := sql%rowcount;
922: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
923:

Line 947: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';

943: edw_log.put_line('Starting Push_EDW_GEOG_AREA1_LSTG');
944:
945: -------- To get PK info from the warehouse (bug #1757640) ------
946:
947: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
948: EXECUTE IMMEDIATE g_stmt;
949:
950: /* Insert from remote warehouse level table */
951: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

Line 951: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||

947: g_stmt := 'TRUNCATE TABLE ' || g_schema || '.POA_EDW_TEMP_GEOG';
948: EXECUTE IMMEDIATE g_stmt;
949:
950: /* Insert from remote warehouse level table */
951: g_stmt := 'INSERT INTO POA_EDW_TEMP_GEOG ' ||
952: 'SELECT AREA1_PK FROM EDW_GEOG_AREA1_LTC@' ||
953: g_target_link;
954: EXECUTE IMMEDIATE g_stmt;
955:

Line 1001: AND NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where AREA1_PK = TEMP_PK);

997: 'READY'
998: from EDW_GEOG_AREA1_LCV
999: where (last_update_date between l_date1 and l_date2
1000: OR last_update_date is NULL)
1001: AND NOT EXISTS (select 1 from POA_EDW_TEMP_GEOG where AREA1_PK = TEMP_PK);
1002:
1003: l_rows_inserted := sql%rowcount;
1004: EDW_GEOGRAPHY_M_C.g_row_count := EDW_GEOGRAPHY_M_C.g_row_count + l_rows_inserted ;
1005: