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.PV_CONTEXT_VALUES dependencies on PV_SEARCH_ATTR_MIRROR

Line 187: synonym_name IN ('PV_SEARCH_ATTR_VALUES', 'PV_SEARCH_ATTR_MIRROR');

183: CURSOR c_underlying_tables IS
184: SELECT synonym_name, table_name
185: FROM dba_synonyms
186: WHERE owner = g_apps_schema AND
187: synonym_name IN ('PV_SEARCH_ATTR_VALUES', 'PV_SEARCH_ATTR_MIRROR');
188:
189: CURSOR c_pv_schema IS
190: SELECT i.tablespace,
191: i.index_tablespace,

Line 431: p_mirror_synonym_name => 'PV_SEARCH_ATTR_MIRROR',

427:
428: Pre_Processing (
429: p_refresh_type => l_refresh_type,
430: p_synonym_name => 'PV_SEARCH_ATTR_VALUES',
431: p_mirror_synonym_name => 'PV_SEARCH_ATTR_MIRROR',
432: p_temp_synonym_name => 'PV_SEARCH_ATTR_VALUES_TMP',
433: p_partner_id_temp_table => 'PV_PARTNER_ID_SESSION',
434: p_temp_table_processed => TRUE,
435: p_last_incr_refresh_str => l_last_incr_refresh_str,

Line 486: INSERT /+ APPEND / INTO pv_search_attr_mirror

482: action_name => 'Processing Non-Refreshables'
483: );
484:
485: IF (l_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
486: INSERT /*+ APPEND */ INTO pv_search_attr_mirror
487: (SEARCH_ATTR_VALUES_ID,
488: PARTY_ID,
489: SHORT_NAME,
490: ATTR_TEXT,

Line 760: p_mirror_synonym_name => 'PV_SEARCH_ATTR_MIRROR',

756:
757: Post_Processing (
758: p_refresh_type => l_refresh_type,
759: p_synonym_name => 'PV_SEARCH_ATTR_VALUES',
760: p_mirror_synonym_name => 'PV_SEARCH_ATTR_MIRROR',
761: p_temp_synonym_name => 'PV_SEARCH_ATTR_VALUES_TMP',
762: p_pv_schema_name => l_pv_schema_name,
763: p_search_table => l_search_table,
764: p_mirror_table => l_mirror_table,

Line 1440: INTO pv_search_attr_mirror (

1436:
1437:
1438: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1439: INSERT /*+ APPEND */
1440: INTO pv_search_attr_mirror (
1441: SEARCH_ATTR_VALUES_ID,
1442: PARTY_ID,
1443: ATTRIBUTE_ID,
1444: ATTR_TEXT,

Line 1668: INTO pv_search_attr_mirror (

1664: -- Full Refresh
1665: -- --------------------------------------------------------------
1666: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1667: INSERT /*+ APPEND */
1668: INTO pv_search_attr_mirror (
1669: SEARCH_ATTR_VALUES_ID,
1670: PARTY_ID,
1671: ATTRIBUTE_ID,
1672: ATTR_TEXT,

Line 1811: INSERT /+ APPEND / INTO pv_search_attr_mirror

1807: -- back changes. In our case, this means copy from the search table
1808: -- and insert into the mirror table.
1809: -- -------------------------------------------------------------------
1810: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1811: INSERT /*+ APPEND */ INTO pv_search_attr_mirror
1812: (SEARCH_ATTR_VALUES_ID,
1813: PARTY_ID,
1814: SHORT_NAME,
1815: ATTR_TEXT,

Line 1869: INTO pv_search_attr_mirror (

1865: action_name => 'Internal - NUMBER'
1866: );
1867:
1868: INSERT /*+ APPEND */
1869: INTO pv_search_attr_mirror (
1870: SEARCH_ATTR_VALUES_ID,
1871: PARTY_ID,
1872: ATTRIBUTE_ID,
1873: ATTR_VALUE,

Line 1988: INTO pv_search_attr_mirror (

1984: -- by marking pv_enty_attr_values.attr_value_extn as 'Y'. Only primary
1985: -- partner type of a partner needs to be populated in the search table.
1986: -- ----------------------------------------------------------------------
1987: INSERT /*+ APPEND */
1988: INTO pv_search_attr_mirror (
1989: SEARCH_ATTR_VALUES_ID,
1990: PARTY_ID,
1991: ATTRIBUTE_ID,
1992: ATTR_TEXT,

Line 2376: INTO pv_search_attr_mirror (

2372: -- to create the full insert statment.
2373: -- --------------------------------------------------------------------------
2374: l_insert_sql :=
2375: 'INSERT /*+ APPEND */
2376: INTO pv_search_attr_mirror (
2377: SEARCH_ATTR_VALUES_ID,
2378: PARTY_ID,
2379: ATTRIBUTE_ID,
2380: ATTR_TEXT_DUMMY,

Line 2402: l_insert_sql := REPLACE(l_insert_sql, 'pv_search_attr_mirror (',

2398:
2399:
2400: IF (p_refresh_type = g_incr_refresh) THEN
2401: l_insert_sql := REPLACE(l_insert_sql, '/*+ APPEND */', ' ');
2402: l_insert_sql := REPLACE(l_insert_sql, 'pv_search_attr_mirror (',
2403: 'pv_search_attr_values (');
2404: END IF;
2405:
2406: -- --------------------------------------------------------------------------

Line 2628: INSERT /+ APPEND / INTO pv_search_attr_mirror

2624: -- back changes. In our case, this means copy from the search table
2625: -- and insert into the mirror table.
2626: -- -------------------------------------------------------------------
2627: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
2628: INSERT /*+ APPEND */ INTO pv_search_attr_mirror
2629: (SEARCH_ATTR_VALUES_ID,
2630: PARTY_ID,
2631: SHORT_NAME,
2632: ATTR_TEXT,

Line 2676: INSERT /+ APPEND / INTO pv_search_attr_mirror

2672: -- back changes. In our case, this means copy from the search table
2673: -- and insert into the mirror table.
2674: -- -------------------------------------------------------------------
2675: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
2676: INSERT /*+ APPEND */ INTO pv_search_attr_mirror
2677: (SEARCH_ATTR_VALUES_ID,
2678: PARTY_ID,
2679: SHORT_NAME,
2680: ATTR_TEXT,

Line 3281: INSERT INTO pv_search_attr_mirror (

3277: -- Full Refresh
3278: -- ------------------------------------------------------------------
3279: ELSE
3280: IF (l_attr_text IS NOT NULL OR l_attr_value IS NOT NULL) THEN
3281: INSERT INTO pv_search_attr_mirror (
3282: SEARCH_ATTR_VALUES_ID,
3283: PARTY_ID,
3284: ATTRIBUTE_ID,
3285: ATTR_TEXT,