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 1444: FROM pv_enty_attr_values a,

1440: FROM (
1441: SELECT DISTINCT
1442: a.entity_id,
1443: DENORM.child_id attr_value
1444: FROM pv_enty_attr_values a,
1445: pv_entity_attrs b,
1446: eni_prod_denorm_hrchy_v DENORM
1447: WHERE b.attribute_id = 1 AND
1448: a.latest_flag = 'Y' AND

Line 1524: FROM pv_enty_attr_values a,

1520: FROM (
1521: SELECT DISTINCT
1522: a.entity_id,
1523: DENORM.child_id attr_value
1524: FROM pv_enty_attr_values a,
1525: pv_partner_id_session b,
1526: eni_prod_denorm_hrchy_v DENORM
1527: WHERE a.attribute_id = 1 AND
1528: a.latest_flag = 'Y' AND

Line 1674: FROM pv_enty_attr_values a,

1670: SELECT DISTINCT a.entity_id,
1671: a.attr_value attr_text,
1672: pv_check_match_pub.Currency_Conversion(
1673: a.attr_value, g_common_currency) attr_value
1674: FROM pv_enty_attr_values a,
1675: pv_partner_profiles PV
1676: WHERE a.entity = 'PARTNER' AND
1677: a.latest_flag = 'Y' AND
1678: a.entity_id = PV.partner_id AND

Line 1741: FROM pv_enty_attr_values a,

1737: SELECT DISTINCT a.entity_id,
1738: a.attr_value attr_text,
1739: pv_check_match_pub.Currency_Conversion(
1740: a.attr_value, g_common_currency) attr_value
1741: FROM pv_enty_attr_values a,
1742: pv_partner_id_session b
1743: WHERE a.entity = 'PARTNER' AND
1744: a.latest_flag = 'Y' AND
1745: a.attr_value IS NOT NULL AND

Line 1870: FROM pv_enty_attr_values a,

1866: p_user_id,
1867: 1.0
1868: FROM (
1869: SELECT DISTINCT a.entity_id, a.attr_value attr_value, a.attribute_id
1870: FROM pv_enty_attr_values a,
1871: pv_partner_profiles PV
1872: WHERE a.entity = 'PARTNER' AND
1873: a.latest_flag = 'Y' AND
1874: a.attr_value IS NOT NULL AND

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

1958:
1959: -- ----------------------------------------------------------------------
1960: -- In R12, there is a concept of primary partner type and secondary
1961: -- partner type (attribute_id = 3). A primary partner type is indicated
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 (

Line 1989: FROM pv_enty_attr_values a,

1985: p_user_id,
1986: 1.0
1987: FROM (
1988: SELECT DISTINCT a.entity_id, a.attr_value attr_value, a.attribute_id
1989: FROM pv_enty_attr_values a,
1990: pv_partner_profiles PV
1991: WHERE a.entity = 'PARTNER' AND
1992: a.latest_flag = 'Y' AND
1993: a.attr_value IS NOT NULL AND

Line 2133: FROM pv_enty_attr_values a,

2129: p_user_id,
2130: 1.0
2131: FROM (
2132: SELECT DISTINCT a.entity_id, attr_value attr_value, attribute_id
2133: FROM pv_enty_attr_values a,
2134: pv_partner_id_session b
2135: WHERE a.entity = 'PARTNER' AND
2136: a.entity_id = b.partner_id AND
2137: latest_flag = 'Y' AND

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

2191:
2192: -- ----------------------------------------------------------------------
2193: -- In R12, there is a concept of primary partner type and secondary
2194: -- partner type (attribute_id = 3). A primary partner type is indicated
2195: -- by marking pv_enty_attr_values.attr_value_extn as 'Y'. Only primary
2196: -- partner type of a partner needs to be populated in the search table.
2197: -- ----------------------------------------------------------------------
2198:
2199: INSERT

Line 2223: FROM pv_enty_attr_values a,

2219: p_user_id,
2220: 1.0
2221: FROM (
2222: SELECT DISTINCT a.entity_id, attr_value attr_value, attribute_id
2223: FROM pv_enty_attr_values a,
2224: pv_partner_id_session b
2225: WHERE a.entity = 'PARTNER' AND
2226: a.entity_id = b.partner_id AND
2227: latest_flag = 'Y' AND