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_ENTITY_ATTRS

Line 207: FROM pv_entity_attrs b,

203: WHERE synonym_name = pc_synonym_name;
204:
205: CURSOR c_attribute1_refresh IS
206: SELECT COUNT(*) count
207: FROM pv_entity_attrs b,
208: pv_attributes_vl a
209: WHERE a.attribute_id = 1 AND
210: a.attribute_id = b.attribute_id AND
211: b.entity = 'PARTNER' AND

Line 518: pv_entity_attrs b

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
522: b.enabled_flag = 'Y' AND

Line 617: FROM pv_entity_attrs a,

613: -- If yes, process these attributes partner-by-partner.
614: -- ------------------------------------------------------------------
615: IF (l_refresh_type <> g_incr_refresh) THEN
616: FOR x IN (SELECT COUNT(*) count
617: FROM pv_entity_attrs a,
618: pv_attributes_vl b
619: WHERE a.attribute_id = b.attribute_id AND
620: a.entity = 'PARTNER' AND
621: a.enabled_flag = 'Y' AND

Line 687: FROM pv_entity_attrs a,

683: END IF;
684:
685: IF (l_refresh_type <> g_incr_refresh) THEN
686: FOR x IN (SELECT a.attribute_id
687: FROM pv_entity_attrs a,
688: pv_attributes_vl b
689: WHERE a.attribute_id = b.attribute_id AND
690: a.entity = 'PARTNER' AND
691: a.enabled_flag = 'Y' AND

Line 1445: pv_entity_attrs b,

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
1449: a.entity = 'PARTNER' AND

Line 1585: FROM pv_entity_attrs a,

1581: -- Currency Attributes - Internal
1582: -- ----------------------------------------------------------------------
1583: CURSOR c_currency_attrs IS
1584: SELECT a.attribute_id, b.name
1585: FROM pv_entity_attrs a,
1586: pv_attributes_vl b
1587: WHERE b.attribute_id <> 1 AND
1588: a.attribute_id = b.attribute_id AND
1589: a.enabled_flag = 'Y' AND

Line 1880: FROM pv_entity_attrs a,

1876: PV.partner_resource_id IS NOT NULL AND
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

Line 1911: FROM pv_entity_attrs a,

1907: -- --------------------------------------------------------------------------
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

Line 2000: FROM pv_entity_attrs a,

1996: PV.partner_resource_id IS NOT NULL AND
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

Line 2032: FROM pv_entity_attrs a,

2028: -- --------------------------------------------------------------------------
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

Line 2096: FROM pv_entity_attrs a,

2092: DELETE FROM pv_search_attr_values
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

Line 2141: FROM pv_entity_attrs a,

2137: latest_flag = 'Y' AND
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

Line 2180: FROM pv_entity_attrs a,

2176: DELETE FROM pv_search_attr_values
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

Line 2232: FROM pv_entity_attrs a,

2228: attr_value IS NOT NULL AND
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

Line 2292: FROM pv_entity_attrs a,

2288: IS
2289: CURSOR c_num_cur_attributes IS
2290: SELECT a.attribute_id, a.batch_sql_text, b.name, b.return_type,
2291: b.performance_flag
2292: FROM pv_entity_attrs a,
2293: pv_attributes_vl b
2294: WHERE b.attribute_id <> 1 AND
2295: a.attribute_id = b.attribute_id AND
2296: a.enabled_flag = 'Y' AND

Line 2311: FROM pv_entity_attrs a,

2307:
2308: CURSOR c_other_attributes IS
2309: SELECT a.attribute_id, a.batch_sql_text, b.name, b.return_type,
2310: b.performance_flag
2311: FROM pv_entity_attrs a,
2312: pv_attributes_vl b
2313: WHERE b.attribute_id <> 1 AND
2314: a.attribute_id = b.attribute_id AND
2315: a.enabled_flag = 'Y' AND

Line 2405: FROM pv_entity_attrs

2401: -- frequency.
2402: -- -----------------------------------------------------------------
2403: IF (p_refresh_type <> g_incr_refresh) THEN
2404: FOR y IN (SELECT COUNT(*) cnt
2405: FROM pv_entity_attrs
2406: WHERE attribute_id = x.attribute_id AND
2407: entity = 'PARTNER' AND
2408: (last_refresh_date IS NULL OR
2409: refresh_frequency IS NULL OR

Line 2719: FROM pv_entity_attrs

2715: -- frequency.
2716: -- -----------------------------------------------------------------
2717: IF (p_refresh_type <> g_incr_refresh) THEN
2718: FOR y IN (SELECT COUNT(*) cnt
2719: FROM pv_entity_attrs
2720: WHERE attribute_id = x.attribute_id AND
2721: entity = 'PARTNER' AND
2722: (last_refresh_date IS NULL OR
2723: refresh_frequency IS NULL OR

Line 2863: FROM pv_entity_attrs a,

2859: -- -----------------------------------------------------------------------
2860: CURSOR lc_template IS
2861: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2862: a.sql_text, b.name, b.return_type
2863: FROM pv_entity_attrs a,
2864: pv_attributes_vl b
2865: WHERE a.attribute_id = b.attribute_id;
2866:
2867: x lc_template%ROWTYPE;

Line 2895: FROM pv_entity_attrs a,

2891: IF (p_refresh_type = g_incr_refresh) THEN
2892: OPEN c_func_perf_attrs FOR
2893: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2894: a.sql_text, b.name, b.return_type
2895: FROM pv_entity_attrs a,
2896: pv_attributes_vl b
2897: WHERE a.attribute_id = b.attribute_id AND
2898: a.entity = 'PARTNER' AND
2899: a.enabled_flag = 'Y' AND

Line 2915: FROM pv_entity_attrs a,

2911: ELSE
2912: OPEN c_func_perf_attrs FOR
2913: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2914: a.sql_text, b.name, b.return_type
2915: FROM pv_entity_attrs a,
2916: pv_attributes_vl b
2917: WHERE a.attribute_id = b.attribute_id AND
2918: a.entity = 'PARTNER' AND
2919: a.enabled_flag = 'Y' AND

Line 3513: UPDATE pv_entity_attrs

3509: )
3510: IS
3511:
3512: BEGIN
3513: UPDATE pv_entity_attrs
3514: SET last_refresh_date = p_timestamp
3515: WHERE entity = 'PARTNER' AND
3516: attribute_id = p_attribute_id;
3517: