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 1467: pv_entity_attrs b,

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

Line 1607: FROM pv_entity_attrs a,

1603: -- Currency Attributes - Internal
1604: -- ----------------------------------------------------------------------
1605: CURSOR c_currency_attrs IS
1606: SELECT a.attribute_id, b.name
1607: FROM pv_entity_attrs a,
1608: pv_attributes_vl b
1609: WHERE b.attribute_id <> 1 AND
1610: a.attribute_id = b.attribute_id AND
1611: a.enabled_flag = 'Y' AND

Line 1902: FROM pv_entity_attrs a,

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

Line 1933: FROM pv_entity_attrs a,

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

Line 2022: FROM pv_entity_attrs a,

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

Line 2054: FROM pv_entity_attrs a,

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

Line 2118: FROM pv_entity_attrs a,

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

Line 2163: FROM pv_entity_attrs a,

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

Line 2202: FROM pv_entity_attrs a,

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

Line 2254: FROM pv_entity_attrs a,

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

Line 2314: FROM pv_entity_attrs a,

2310: IS
2311: CURSOR c_num_cur_attributes IS
2312: SELECT a.attribute_id, a.batch_sql_text, b.name, b.return_type,
2313: b.performance_flag
2314: FROM pv_entity_attrs a,
2315: pv_attributes_vl b
2316: WHERE b.attribute_id <> 1 AND
2317: a.attribute_id = b.attribute_id AND
2318: a.enabled_flag = 'Y' AND

Line 2333: FROM pv_entity_attrs a,

2329:
2330: CURSOR c_other_attributes IS
2331: SELECT a.attribute_id, a.batch_sql_text, b.name, b.return_type,
2332: b.performance_flag
2333: FROM pv_entity_attrs a,
2334: pv_attributes_vl b
2335: WHERE b.attribute_id <> 1 AND
2336: a.attribute_id = b.attribute_id AND
2337: a.enabled_flag = 'Y' AND

Line 2427: FROM pv_entity_attrs

2423: -- frequency.
2424: -- -----------------------------------------------------------------
2425: IF (p_refresh_type <> g_incr_refresh) THEN
2426: FOR y IN (SELECT COUNT(*) cnt
2427: FROM pv_entity_attrs
2428: WHERE attribute_id = x.attribute_id AND
2429: entity = 'PARTNER' AND
2430: (last_refresh_date IS NULL OR
2431: refresh_frequency IS NULL OR

Line 2741: FROM pv_entity_attrs

2737: -- frequency.
2738: -- -----------------------------------------------------------------
2739: IF (p_refresh_type <> g_incr_refresh) THEN
2740: FOR y IN (SELECT COUNT(*) cnt
2741: FROM pv_entity_attrs
2742: WHERE attribute_id = x.attribute_id AND
2743: entity = 'PARTNER' AND
2744: (last_refresh_date IS NULL OR
2745: refresh_frequency IS NULL OR

Line 2885: FROM pv_entity_attrs a,

2881: -- -----------------------------------------------------------------------
2882: CURSOR lc_template IS
2883: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2884: a.sql_text, b.name, b.return_type
2885: FROM pv_entity_attrs a,
2886: pv_attributes_vl b
2887: WHERE a.attribute_id = b.attribute_id;
2888:
2889: x lc_template%ROWTYPE;

Line 2917: FROM pv_entity_attrs a,

2913: IF (p_refresh_type = g_incr_refresh) THEN
2914: OPEN c_func_perf_attrs FOR
2915: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2916: a.sql_text, b.name, b.return_type
2917: FROM pv_entity_attrs a,
2918: pv_attributes_vl b
2919: WHERE a.attribute_id = b.attribute_id AND
2920: a.entity = 'PARTNER' AND
2921: a.enabled_flag = 'Y' AND

Line 2937: FROM pv_entity_attrs a,

2933: ELSE
2934: OPEN c_func_perf_attrs FOR
2935: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2936: a.sql_text, b.name, b.return_type
2937: FROM pv_entity_attrs a,
2938: pv_attributes_vl b
2939: WHERE a.attribute_id = b.attribute_id AND
2940: a.entity = 'PARTNER' AND
2941: a.enabled_flag = 'Y' AND

Line 3535: UPDATE pv_entity_attrs

3531: )
3532: IS
3533:
3534: BEGIN
3535: UPDATE pv_entity_attrs
3536: SET last_refresh_date = p_timestamp
3537: WHERE entity = 'PARTNER' AND
3538: attribute_id = p_attribute_id;
3539: