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_ENTY_ATTR_VALUES

Line 1466: FROM pv_enty_attr_values a,

1462: FROM (
1463: SELECT DISTINCT
1464: a.entity_id,
1465: DENORM.child_id attr_value
1466: FROM pv_enty_attr_values a,
1467: pv_entity_attrs b,
1468: eni_prod_denorm_hrchy_v DENORM
1469: WHERE b.attribute_id = 1 AND
1470: a.latest_flag = 'Y' AND

Line 1546: FROM pv_enty_attr_values a,

1542: FROM (
1543: SELECT DISTINCT
1544: a.entity_id,
1545: DENORM.child_id attr_value
1546: FROM pv_enty_attr_values a,
1547: pv_partner_id_session b,
1548: eni_prod_denorm_hrchy_v DENORM
1549: WHERE a.attribute_id = 1 AND
1550: a.latest_flag = 'Y' AND

Line 1696: FROM pv_enty_attr_values a,

1692: SELECT DISTINCT a.entity_id,
1693: a.attr_value attr_text,
1694: pv_check_match_pub.Currency_Conversion(
1695: a.attr_value, g_common_currency) attr_value
1696: FROM pv_enty_attr_values a,
1697: pv_partner_profiles PV
1698: WHERE a.entity = 'PARTNER' AND
1699: a.latest_flag = 'Y' AND
1700: a.entity_id = PV.partner_id AND

Line 1763: FROM pv_enty_attr_values a,

1759: SELECT DISTINCT a.entity_id,
1760: a.attr_value attr_text,
1761: pv_check_match_pub.Currency_Conversion(
1762: a.attr_value, g_common_currency) attr_value
1763: FROM pv_enty_attr_values a,
1764: pv_partner_id_session b
1765: WHERE a.entity = 'PARTNER' AND
1766: a.latest_flag = 'Y' AND
1767: a.attr_value IS NOT NULL AND

Line 1892: FROM pv_enty_attr_values a,

1888: p_user_id,
1889: 1.0
1890: FROM (
1891: SELECT DISTINCT a.entity_id, a.attr_value attr_value, a.attribute_id
1892: FROM pv_enty_attr_values a,
1893: pv_partner_profiles PV
1894: WHERE a.entity = 'PARTNER' AND
1895: a.latest_flag = 'Y' AND
1896: a.attr_value IS NOT NULL AND

Line 1984: -- by marking pv_enty_attr_values.attr_value_extn as 'Y'. Only primary

1980:
1981: -- ----------------------------------------------------------------------
1982: -- In R12, there is a concept of primary partner type and secondary
1983: -- partner type (attribute_id = 3). A primary partner type is indicated
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 (

Line 2011: FROM pv_enty_attr_values a,

2007: p_user_id,
2008: 1.0
2009: FROM (
2010: SELECT DISTINCT a.entity_id, a.attr_value attr_value, a.attribute_id
2011: FROM pv_enty_attr_values a,
2012: pv_partner_profiles PV
2013: WHERE a.entity = 'PARTNER' AND
2014: a.latest_flag = 'Y' AND
2015: a.attr_value IS NOT NULL AND

Line 2155: FROM pv_enty_attr_values a,

2151: p_user_id,
2152: 1.0
2153: FROM (
2154: SELECT DISTINCT a.entity_id, attr_value attr_value, attribute_id
2155: FROM pv_enty_attr_values a,
2156: pv_partner_id_session b
2157: WHERE a.entity = 'PARTNER' AND
2158: a.entity_id = b.partner_id AND
2159: latest_flag = 'Y' AND

Line 2217: -- by marking pv_enty_attr_values.attr_value_extn as 'Y'. Only primary

2213:
2214: -- ----------------------------------------------------------------------
2215: -- In R12, there is a concept of primary partner type and secondary
2216: -- partner type (attribute_id = 3). A primary partner type is indicated
2217: -- by marking pv_enty_attr_values.attr_value_extn as 'Y'. Only primary
2218: -- partner type of a partner needs to be populated in the search table.
2219: -- ----------------------------------------------------------------------
2220:
2221: INSERT

Line 2245: FROM pv_enty_attr_values a,

2241: p_user_id,
2242: 1.0
2243: FROM (
2244: SELECT DISTINCT a.entity_id, attr_value attr_value, attribute_id
2245: FROM pv_enty_attr_values a,
2246: pv_partner_id_session b
2247: WHERE a.entity = 'PARTNER' AND
2248: a.entity_id = b.partner_id AND
2249: latest_flag = 'Y' AND