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_ATTRIBUTES_B

Line 517: FROM pv_attributes_b a,

513: ATTR_VALUE
514: FROM pv_search_attr_values
515: WHERE attribute_id IN (
516: SELECT a.attribute_id
517: FROM pv_attributes_b a,
518: pv_entity_attrs b
519: WHERE a.attribute_id = b.attribute_id AND
520: b.entity = 'PARTNER' AND
521: a.enabled_flag = 'Y' AND

Line 1903: pv_attributes_b b

1899: PV.status = 'A' AND
1900: a.attribute_id IN (
1901: SELECT a.attribute_id
1902: FROM pv_entity_attrs a,
1903: pv_attributes_b b
1904: WHERE b.attribute_id <> 1 AND
1905: a.attribute_id = b.attribute_id AND
1906: a.enabled_flag = 'Y' AND
1907: b.enabled_flag = 'Y' AND

Line 1934: pv_attributes_b b

1930: -- Update timestamp
1931: -- --------------------------------------------------------------------------
1932: FOR x IN (SELECT a.attribute_id
1933: FROM pv_entity_attrs a,
1934: pv_attributes_b b
1935: WHERE b.attribute_id <> 1 AND
1936: a.attribute_id = b.attribute_id AND
1937: a.enabled_flag = 'Y' AND
1938: b.enabled_flag = 'Y' AND

Line 2023: pv_attributes_b b

2019: PV.status = 'A' AND
2020: a.attribute_id IN (
2021: SELECT a.attribute_id
2022: FROM pv_entity_attrs a,
2023: pv_attributes_b b
2024: WHERE b.attribute_id <> 1 AND
2025: a.attribute_id = b.attribute_id AND
2026: a.enabled_flag = 'Y' AND
2027: b.enabled_flag = 'Y' AND

Line 2055: pv_attributes_b b

2051: -- Update timestamp
2052: -- --------------------------------------------------------------------------
2053: FOR x IN (SELECT a.attribute_id
2054: FROM pv_entity_attrs a,
2055: pv_attributes_b b
2056: WHERE b.attribute_id <> 1 AND
2057: a.attribute_id = b.attribute_id AND
2058: a.enabled_flag = 'Y' AND
2059: b.enabled_flag = 'Y' AND

Line 2119: pv_attributes_b b

2115: WHERE party_id IN (SELECT partner_id FROM pv_partner_id_session) AND
2116: attribute_id IN (
2117: SELECT a.attribute_id
2118: FROM pv_entity_attrs a,
2119: pv_attributes_b b
2120: WHERE b.attribute_id <> 1 AND
2121: a.attribute_id = b.attribute_id AND
2122: a.enabled_flag = 'Y' AND
2123: b.enabled_flag = 'Y' AND

Line 2164: pv_attributes_b b

2160: attr_value IS NOT NULL AND
2161: attribute_id IN (
2162: SELECT a.attribute_id
2163: FROM pv_entity_attrs a,
2164: pv_attributes_b b
2165: WHERE b.attribute_id <> 1 AND
2166: a.attribute_id = b.attribute_id AND
2167: a.enabled_flag = 'Y' AND
2168: b.enabled_flag = 'Y' AND

Line 2203: pv_attributes_b b

2199: WHERE party_id IN (SELECT partner_id FROM pv_partner_id_session) AND
2200: attribute_id IN (
2201: SELECT a.attribute_id
2202: FROM pv_entity_attrs a,
2203: pv_attributes_b b
2204: WHERE b.attribute_id <> 1 AND
2205: a.attribute_id = b.attribute_id AND
2206: a.enabled_flag = 'Y' AND
2207: b.enabled_flag = 'Y' AND

Line 2255: pv_attributes_b b

2251: DECODE(a.attribute_id, 3, attr_value_extn, 'Y') = 'Y' AND
2252: attribute_id IN (
2253: SELECT a.attribute_id
2254: FROM pv_entity_attrs a,
2255: pv_attributes_b b
2256: WHERE b.attribute_id <> 1 AND
2257: a.attribute_id = b.attribute_id AND
2258: a.enabled_flag = 'Y' AND
2259: b.enabled_flag = 'Y' AND