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_PARTNER_MIGRATIONS_PUB dependencies on PV_ENTY_ATTR_VALUES

Line 66: pv_enty_attr_values

62: version,
63: attr_value,
64: attr_value_extn
65: from
66: pv_enty_attr_values
67: where
68: entity_id = p_entity_id and
69: latest_flag = 'Y' AND
70: attribute_id = 3;

Line 85: select ATTR_VALUE from pv_enty_attr_values tabl where entity_id = CV_PARTNER_ID and ATTRIBUTE_id= 3

81: PV_PARTNER_PROFILES.PARTNER_ID = CV_PARTNER_ID;
82:
83:
84: CURSOR GET_PARTNER_TYPE_DTLS(CV_PARTNER_ID INTEGER) is
85: select ATTR_VALUE from pv_enty_attr_values tabl where entity_id = CV_PARTNER_ID and ATTRIBUTE_id= 3
86: and version = (SELECT
87: MAX(case (version -1)
88: when 0 then
89: 1

Line 92: end ) fROM pv_enty_attr_values

88: when 0 then
89: 1
90: else
91: (version -1)
92: end ) fROM pv_enty_attr_values
93: WHERE
94: entity_id = CV_PARTNER_ID AND
95: ATTRIBUTE_ID = 3 AND
96: LAST_UPDATE_DATE = (SELECT MIN(LAST_UPDATE_DATE) FROM pv_enty_attr_values WHERE ATTR_VALUE_EXTN = 'Y' AND

Line 96: LAST_UPDATE_DATE = (SELECT MIN(LAST_UPDATE_DATE) FROM pv_enty_attr_values WHERE ATTR_VALUE_EXTN = 'Y' AND

92: end ) fROM pv_enty_attr_values
93: WHERE
94: entity_id = CV_PARTNER_ID AND
95: ATTRIBUTE_ID = 3 AND
96: LAST_UPDATE_DATE = (SELECT MIN(LAST_UPDATE_DATE) FROM pv_enty_attr_values WHERE ATTR_VALUE_EXTN = 'Y' AND
97: ENTITY_ID = tabl.entity_id and attribute_id = 3)
98: )
99: union
100:

Line 101: SELECT ATTR_VALUE FROM pv_enty_attr_values

97: ENTITY_ID = tabl.entity_id and attribute_id = 3)
98: )
99: union
100:
101: SELECT ATTR_VALUE FROM pv_enty_attr_values
102: WHERE
103: entity_id = CV_PARTNER_ID and
104: ATTRIBUTE_ID = 3 AND
105: ENTITY_ID not IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE entity_id = CV_PARTNER_ID and ATTRIBUTE_ID = 3 and ATTR_VALUE_eXTN is not NULL) AND

Line 105: ENTITY_ID not IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE entity_id = CV_PARTNER_ID and ATTRIBUTE_ID = 3 and ATTR_VALUE_eXTN is not NULL) AND

101: SELECT ATTR_VALUE FROM pv_enty_attr_values
102: WHERE
103: entity_id = CV_PARTNER_ID and
104: ATTRIBUTE_ID = 3 AND
105: ENTITY_ID not IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE entity_id = CV_PARTNER_ID and ATTRIBUTE_ID = 3 and ATTR_VALUE_eXTN is not NULL) AND
106: LATEST_FLAG = 'Y';
107:
108: begin
109:

Line 254: pv_enty_attr_values

250: CURSOR Get_Unprocessed_Record_Count IS
251: select
252: count(distinct entity_id) as partner_count
253: from
254: pv_enty_attr_values
255: where
256: attribute_id = 3 and
257: attr_value_extn = 'Y';
258:

Line 264: pv_enty_attr_values

260: CURSOR Get_Primary_Partner_Type_count is
261: select
262: attr_value , count(attr_value) as partner_count
263: from
264: pv_enty_attr_values
265: where
266: attribute_id = 3 and latest_flag = 'Y' and attr_value_extn = 'Y'
267: group by
268: attr_value

Line 291: FROM pv_enty_attr_values tabl

287: FROM (
288: SELECT
289: ATTR_VALUE,
290: entity_id
291: FROM pv_enty_attr_values tabl
292: WHERE
293: ATTRIBUTE_ID = 3
294: AND ATTR_VALUE = 'VAD'
295: AND VERSION = (SELECT

Line 302: FROM pv_enty_attr_values

298: 1
299: else
300: (version -1)
301: end )
302: FROM pv_enty_attr_values
303: WHERE
304: entity_id = tabl.entity_id AND
305: LAST_UPDATE_DATE = ( SELECT MIN(LAST_UPDATE_DATE)
306: FROM pv_enty_attr_values

Line 306: FROM pv_enty_attr_values

302: FROM pv_enty_attr_values
303: WHERE
304: entity_id = tabl.entity_id AND
305: LAST_UPDATE_DATE = ( SELECT MIN(LAST_UPDATE_DATE)
306: FROM pv_enty_attr_values
307: WHERE ATTR_VALUE_EXTN = 'Y'
308: AND ENTITY_ID = tabl.entity_id
309: AND attribute_id = 3
310: )

Line 316: FROM pv_enty_attr_values

312: UNION
313: SELECT
314: ATTR_VALUE,
315: entity_id
316: FROM pv_enty_attr_values
317: WHERE
318: ATTRIBUTE_ID = 3
319: AND LATEST_FLAG = 'Y'
320: AND ATTR_VALUE = 'VAD'

Line 322: FROM pv_enty_attr_values

318: ATTRIBUTE_ID = 3
319: AND LATEST_FLAG = 'Y'
320: AND ATTR_VALUE = 'VAD'
321: AND entity_id in ( SELECT entity_id
322: FROM pv_enty_attr_values
323: WHERE ATTRIBUTE_ID = 3
324: AND attr_value = 'VAD'
325: AND latest_flag = 'Y'
326: )

Line 328: FROM pv_enty_attr_values

324: AND attr_value = 'VAD'
325: AND latest_flag = 'Y'
326: )
327: AND ENTITY_ID NOT IN (SELECT ENTITY_ID
328: FROM pv_enty_attr_values
329: WHERE ATTRIBUTE_ID = 3
330: AND attr_value_extn is not null
331: )
332: )

Line 351: FROM pv_enty_attr_values tabl

347: entity_id
348: FROM
349: (
350: SELECT ATTR_VALUE,entity_id
351: FROM pv_enty_attr_values tabl
352: WHERE
353: ENTITY_ID IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE ATTRIBUTE_ID = 3 AND ATTR_VALUE_EXTN = 'Y') AND
354: ATTRIBUTE_ID = 3 AND
355: VERSION = (SELECT

Line 353: ENTITY_ID IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE ATTRIBUTE_ID = 3 AND ATTR_VALUE_EXTN = 'Y') AND

349: (
350: SELECT ATTR_VALUE,entity_id
351: FROM pv_enty_attr_values tabl
352: WHERE
353: ENTITY_ID IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE ATTRIBUTE_ID = 3 AND ATTR_VALUE_EXTN = 'Y') AND
354: ATTRIBUTE_ID = 3 AND
355: VERSION = (SELECT
356: MAX(case (version -1)
357: when 0 then

Line 362: FROM pv_enty_attr_values

358: 1
359: else
360: (version -1)
361: end )
362: FROM pv_enty_attr_values
363: WHERE
364: entity_id = tabl.entity_id and
365: LAST_UPDATE_DATE = (SELECT MIN(LAST_UPDATE_DATE)
366: FROM pv_enty_attr_values

Line 366: FROM pv_enty_attr_values

362: FROM pv_enty_attr_values
363: WHERE
364: entity_id = tabl.entity_id and
365: LAST_UPDATE_DATE = (SELECT MIN(LAST_UPDATE_DATE)
366: FROM pv_enty_attr_values
367: WHERE ATTR_VALUE_EXTN = 'Y'
368: AND ENTITY_ID = tabl.entity_id
369: AND attribute_id = 3)
370: )

Line 375: FROM pv_enty_attr_values

371:
372: UNION
373:
374: SELECT ATTR_VALUE,entity_id
375: FROM pv_enty_attr_values
376: WHERE
377: ATTRIBUTE_ID = 3 AND
378: ENTITY_ID NOT IN (SELECT ENTITY_ID
379: FROM pv_enty_attr_values

Line 379: FROM pv_enty_attr_values

375: FROM pv_enty_attr_values
376: WHERE
377: ATTRIBUTE_ID = 3 AND
378: ENTITY_ID NOT IN (SELECT ENTITY_ID
379: FROM pv_enty_attr_values
380: WHERE ATTRIBUTE_ID = 3
381: AND attr_value_extn is not null ) AND
382: LATEST_FLAG = 'Y'
383:

Line 387: ENTITY_ID NOT IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE ENTITY_ID = attr.entity_id and ATTR_VALUE = 'VAD') and

383:
384:
385: ) attr,
386: fnd_lookup_values lkp where
387: ENTITY_ID NOT IN (SELECT ENTITY_ID FROM pv_enty_attr_values WHERE ENTITY_ID = attr.entity_id and ATTR_VALUE = 'VAD') and
388: attr.attr_value = lkp.lookup_code and
389: lkp.language = userenv('LANG') and
390: lkp.lookup_type = 'PV_PARTNER_TYPE_RANKING'
391: group by entity_id

Line 393: pv_enty_attr_values details,

389: lkp.language = userenv('LANG') and
390: lkp.lookup_type = 'PV_PARTNER_TYPE_RANKING'
391: group by entity_id
392: ) sorted,
393: pv_enty_attr_values details,
394: fnd_lookup_values match,
395: pv_partner_profiles ppp
396: where
397: details.attr_value = lookup_code and

Line 423: pv_enty_attr_values

419: AND partners.entity_id not in (
420: SELECT
421: distinct entity_id
422: FROM
423: pv_enty_attr_values
424: WHERE
425: attribute_id = 3
426: AND attr_value_extn is not null
427: AND latest_flag = 'Y'

Line 436: FROM pv_enty_attr_values attr,

432: CURSOR GET_PRTNR_TYP_MIGRN IS
433: SELECT distinct
434: attr_value,
435: entity_id
436: FROM pv_enty_attr_values attr,
437: fnd_lookup_values lkp,
438: pv_partner_profiles ppp
439: WHERE
440: attribute_id = 3

Line 446: pv_enty_attr_values

442: AND entity_id not in (
443: select
444: distinct entity_id
445: from
446: pv_enty_attr_values
447: where
448: attribute_id = 3 and
449: latest_flag = 'Y' AND
450: (attr_value = 'VAD' OR attr_value_extn is not null )

Line 461: from pv_enty_attr_values

457: AND to_number(tag) = (select min(to_number(tag))
458: from fnd_lookup_values
459: where
460: lookup_code in (select attr_value
461: from pv_enty_attr_values
462: where attribute_id=3
463: and entity_id = attr.entity_id
464: and latest_flag = 'Y')
465: and lookup_type = 'PV_PARTNER_TYPE_RANKING'