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.

[Home] [Help]

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 1881: pv_attributes_b b

1877: PV.status = 'A' AND
1878: a.attribute_id IN (
1879: SELECT a.attribute_id
1880: FROM pv_entity_attrs a,
1881: pv_attributes_b b
1882: WHERE b.attribute_id <> 1 AND
1883: a.attribute_id = b.attribute_id AND
1884: a.enabled_flag = 'Y' AND
1885: b.enabled_flag = 'Y' AND

Line 1912: pv_attributes_b b

1908: -- Update timestamp
1909: -- --------------------------------------------------------------------------
1910: FOR x IN (SELECT a.attribute_id
1911: FROM pv_entity_attrs a,
1912: pv_attributes_b b
1913: WHERE b.attribute_id <> 1 AND
1914: a.attribute_id = b.attribute_id AND
1915: a.enabled_flag = 'Y' AND
1916: b.enabled_flag = 'Y' AND

Line 2001: pv_attributes_b b

1997: PV.status = 'A' AND
1998: a.attribute_id IN (
1999: SELECT a.attribute_id
2000: FROM pv_entity_attrs a,
2001: pv_attributes_b b
2002: WHERE b.attribute_id <> 1 AND
2003: a.attribute_id = b.attribute_id AND
2004: a.enabled_flag = 'Y' AND
2005: b.enabled_flag = 'Y' AND

Line 2033: pv_attributes_b b

2029: -- Update timestamp
2030: -- --------------------------------------------------------------------------
2031: FOR x IN (SELECT a.attribute_id
2032: FROM pv_entity_attrs a,
2033: pv_attributes_b b
2034: WHERE b.attribute_id <> 1 AND
2035: a.attribute_id = b.attribute_id AND
2036: a.enabled_flag = 'Y' AND
2037: b.enabled_flag = 'Y' AND

Line 2097: pv_attributes_b b

2093: WHERE party_id IN (SELECT partner_id FROM pv_partner_id_session) AND
2094: attribute_id IN (
2095: SELECT a.attribute_id
2096: FROM pv_entity_attrs a,
2097: pv_attributes_b b
2098: WHERE b.attribute_id <> 1 AND
2099: a.attribute_id = b.attribute_id AND
2100: a.enabled_flag = 'Y' AND
2101: b.enabled_flag = 'Y' AND

Line 2142: pv_attributes_b b

2138: attr_value IS NOT NULL AND
2139: attribute_id IN (
2140: SELECT a.attribute_id
2141: FROM pv_entity_attrs a,
2142: pv_attributes_b b
2143: WHERE b.attribute_id <> 1 AND
2144: a.attribute_id = b.attribute_id AND
2145: a.enabled_flag = 'Y' AND
2146: b.enabled_flag = 'Y' AND

Line 2181: pv_attributes_b b

2177: WHERE party_id IN (SELECT partner_id FROM pv_partner_id_session) AND
2178: attribute_id IN (
2179: SELECT a.attribute_id
2180: FROM pv_entity_attrs a,
2181: pv_attributes_b b
2182: WHERE b.attribute_id <> 1 AND
2183: a.attribute_id = b.attribute_id AND
2184: a.enabled_flag = 'Y' AND
2185: b.enabled_flag = 'Y' AND

Line 2233: pv_attributes_b b

2229: DECODE(a.attribute_id, 3, attr_value_extn, 'Y') = 'Y' AND
2230: attribute_id IN (
2231: SELECT a.attribute_id
2232: FROM pv_entity_attrs a,
2233: pv_attributes_b b
2234: WHERE b.attribute_id <> 1 AND
2235: a.attribute_id = b.attribute_id AND
2236: a.enabled_flag = 'Y' AND
2237: b.enabled_flag = 'Y' AND