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 1418: INTO pv_search_attr_mirror (

1414:
1415:
1416: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1417: INSERT /*+ APPEND */
1418: INTO pv_search_attr_mirror (
1419: SEARCH_ATTR_VALUES_ID,
1420: PARTY_ID,
1421: ATTRIBUTE_ID,
1422: ATTR_TEXT,

Line 1646: INTO pv_search_attr_mirror (

1642: -- Full Refresh
1643: -- --------------------------------------------------------------
1644: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1645: INSERT /*+ APPEND */
1646: INTO pv_search_attr_mirror (
1647: SEARCH_ATTR_VALUES_ID,
1648: PARTY_ID,
1649: ATTRIBUTE_ID,
1650: ATTR_TEXT,

Line 1789: INSERT /+ APPEND / INTO pv_search_attr_mirror

1785: -- back changes. In our case, this means copy from the search table
1786: -- and insert into the mirror table.
1787: -- -------------------------------------------------------------------
1788: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
1789: INSERT /*+ APPEND */ INTO pv_search_attr_mirror
1790: (SEARCH_ATTR_VALUES_ID,
1791: PARTY_ID,
1792: SHORT_NAME,
1793: ATTR_TEXT,

Line 1847: INTO pv_search_attr_mirror (

1843: action_name => 'Internal - NUMBER'
1844: );
1845:
1846: INSERT /*+ APPEND */
1847: INTO pv_search_attr_mirror (
1848: SEARCH_ATTR_VALUES_ID,
1849: PARTY_ID,
1850: ATTRIBUTE_ID,
1851: ATTR_VALUE,

Line 1966: INTO pv_search_attr_mirror (

1962: -- by marking pv_enty_attr_values.attr_value_extn as 'Y'. Only primary
1963: -- partner type of a partner needs to be populated in the search table.
1964: -- ----------------------------------------------------------------------
1965: INSERT /*+ APPEND */
1966: INTO pv_search_attr_mirror (
1967: SEARCH_ATTR_VALUES_ID,
1968: PARTY_ID,
1969: ATTRIBUTE_ID,
1970: ATTR_TEXT,

Line 2354: INTO pv_search_attr_mirror (

2350: -- to create the full insert statment.
2351: -- --------------------------------------------------------------------------
2352: l_insert_sql :=
2353: 'INSERT /*+ APPEND */
2354: INTO pv_search_attr_mirror (
2355: SEARCH_ATTR_VALUES_ID,
2356: PARTY_ID,
2357: ATTRIBUTE_ID,
2358: ATTR_TEXT_DUMMY,

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

2376:
2377:
2378: IF (p_refresh_type = g_incr_refresh) THEN
2379: l_insert_sql := REPLACE(l_insert_sql, '/*+ APPEND */', ' ');
2380: l_insert_sql := REPLACE(l_insert_sql, 'pv_search_attr_mirror (',
2381: 'pv_search_attr_values (');
2382: END IF;
2383:
2384: -- --------------------------------------------------------------------------

Line 2606: INSERT /+ APPEND / INTO pv_search_attr_mirror

2602: -- back changes. In our case, this means copy from the search table
2603: -- and insert into the mirror table.
2604: -- -------------------------------------------------------------------
2605: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
2606: INSERT /*+ APPEND */ INTO pv_search_attr_mirror
2607: (SEARCH_ATTR_VALUES_ID,
2608: PARTY_ID,
2609: SHORT_NAME,
2610: ATTR_TEXT,

Line 2654: INSERT /+ APPEND / INTO pv_search_attr_mirror

2650: -- back changes. In our case, this means copy from the search table
2651: -- and insert into the mirror table.
2652: -- -------------------------------------------------------------------
2653: IF (p_refresh_type IN (g_full_refresh, g_incr_full_refresh)) THEN
2654: INSERT /*+ APPEND */ INTO pv_search_attr_mirror
2655: (SEARCH_ATTR_VALUES_ID,
2656: PARTY_ID,
2657: SHORT_NAME,
2658: ATTR_TEXT,

Line 3259: INSERT INTO pv_search_attr_mirror (

3255: -- Full Refresh
3256: -- ------------------------------------------------------------------
3257: ELSE
3258: IF (l_attr_text IS NOT NULL OR l_attr_value IS NOT NULL) THEN
3259: INSERT INTO pv_search_attr_mirror (
3260: SEARCH_ATTR_VALUES_ID,
3261: PARTY_ID,
3262: ATTRIBUTE_ID,
3263: ATTR_TEXT,