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_TERR_ASSIGN_PUB dependencies on PV_PARTNER_PROFILES

Line 765: pv_partner_profiles PROFILE,

761: CURSOR l_res_is_vad_emp_csr(cv_partner_id NUMBER, cv_resource_id NUMBER) IS
762: -- PINAGARA Changed the code to use subquery as a fix for bug # 4869726
763: SELECT 'Y'
764: FROM
765: pv_partner_profiles PROFILE,
766: hz_relationships HZPR_PART_CONT ,
767: hz_parties CONTACT ,
768: jtf_rs_resource_extns RES
769: WHERE

Line 2298: FROM pv_partner_profiles ppp,

2294:
2295: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.
2296: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
2297: SELECT partner_party_id, pacv.attr_code
2298: FROM pv_partner_profiles ppp,
2299: PV_ATTRIBUTE_CODES_VL pacv
2300: WHERE ppp.partner_id = cv_partner_id
2301: AND ppp.status = 'A'
2302: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);

Line 3370: FROM pv_partner_profiles ppp,

3366:
3367:
3368: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
3369: SELECT partner_party_id, pacv.attr_code
3370: FROM pv_partner_profiles ppp,
3371: PV_ATTRIBUTE_CODES_VL pacv
3372: WHERE ppp.partner_id = cv_partner_id
3373: AND ppp.status = 'A'
3374: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);

Line 3559: FROM pv_partner_profiles ppp,

3555:
3556: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.
3557: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
3558: SELECT partner_party_id, pacv.attr_code
3559: FROM pv_partner_profiles ppp,
3560: PV_ATTRIBUTE_CODES_VL pacv
3561: WHERE ppp.partner_id = cv_partner_id
3562: AND ppp.status = 'A'
3563: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);

Line 4125: FROM pv_partner_profiles ppp,

4121:
4122: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.
4123: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
4124: SELECT partner_party_id, pacv.attr_code
4125: FROM pv_partner_profiles ppp,
4126: PV_ATTRIBUTE_CODES_VL pacv
4127: WHERE ppp.partner_id = cv_partner_id
4128: AND ppp.status = 'A'
4129: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);

Line 4634: FROM pv_partner_profiles a,

4630: -- Cursor l_party_id_csr to get the VAD Partner Org Id by supplying the
4631: -- VAD Partner id.
4632: CURSOR l_VAD_party_id_csr (cv_vad_partner_id NUMBER) IS
4633: SELECT partner_party_id
4634: FROM pv_partner_profiles a,
4635: pv_enty_attr_values b
4636: WHERE a.partner_id = cv_vad_partner_id
4637: AND a.status = 'A'
4638: AND a.partner_id = b.entity_id

Line 4952: FROM pv_partner_profiles

4948:
4949: -- Cursor l_party_id_csr to get the party_id and partner_level for a given partner_id.
4950: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
4951: SELECT partner_party_id, partner_level
4952: FROM pv_partner_profiles
4953: WHERE partner_id = cv_partner_id
4954: AND status = 'A';
4955:
4956: BEGIN

Line 5179: FROM pv_partner_profiles ppp,

5175:
5176:
5177: CURSOR l_party_id_csr (cv_partner_id NUMBER) IS
5178: SELECT partner_party_id, pacv.attr_code
5179: FROM pv_partner_profiles ppp,
5180: PV_ATTRIBUTE_CODES_VL pacv
5181: WHERE ppp.partner_id = cv_partner_id
5182: AND ppp.status = 'A'
5183: AND ppp.partner_level = pacv.ATTR_CODE_ID(+);

Line 5377: -- for all the Partner Organizations stored in PV_PARTNER_PROFILES

5373: -- Version :
5374: -- Initial version 1.0
5375: --
5376: -- Notes: Concurrent request program for re-assignment of Channel Team
5377: -- for all the Partner Organizations stored in PV_PARTNER_PROFILES
5378: -- table.
5379: --
5380: --
5381: -- End of Comments

Line 5456: PV_PARTNER_PROFILES ppp,

5452: */
5453: --New
5454: SELECT hzp.party_name partner_name,ptbcp.partner_id, ptbcp.vad_partner_id, ptbcp.object_version_number,ptbcp.created_by
5455: FROM PV_TAP_BATCH_CHG_PARTNERS ptbcp,
5456: PV_PARTNER_PROFILES ppp,
5457: HZ_PARTIES hzp
5458: WHERE ptbcp.PROCESSED_FLAG = 'P'
5459: -- AND ptbcp.PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id
5460: AND ptbcp.PARTNER_ID >= cv_first_partner_id AND ptbcp.PARTNER_ID <= cv_last_partner_id

Line 5466: -- from PV_PARTNER_PROFILES table for channel team re-assignment in case of TOTAL mode.

5462: AND ppp.partner_party_id= hzp.party_id
5463: ORDER BY hzp.party_name ;
5464:
5465: -- Cursor to select all the partner_id's between cv_first_partner_id and cv_last_partner_id
5466: -- from PV_PARTNER_PROFILES table for channel team re-assignment in case of TOTAL mode.
5467: CURSOR l_profile_partners_csr(cv_first_partner_id NUMBER, cv_last_partner_id NUMBER) IS
5468: /*
5469: SELECT distinct partner_id, NULL "vad_partner_id", NULL "object_version_number" , created_by
5470: FROM PV_PARTNER_PROFILES

Line 5470: FROM PV_PARTNER_PROFILES

5466: -- from PV_PARTNER_PROFILES table for channel team re-assignment in case of TOTAL mode.
5467: CURSOR l_profile_partners_csr(cv_first_partner_id NUMBER, cv_last_partner_id NUMBER) IS
5468: /*
5469: SELECT distinct partner_id, NULL "vad_partner_id", NULL "object_version_number" , created_by
5470: FROM PV_PARTNER_PROFILES
5471: WHERE STATUS = 'A'
5472: AND PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id;
5473: */
5474: --New

Line 5477: FROM PV_PARTNER_PROFILES ppp,

5473: */
5474: --New
5475: SELECT distinct hzp.party_name partner_name, partner_id,
5476: NULL "vad_partner_id", NULL "object_version_number" , ppp.created_by
5477: FROM PV_PARTNER_PROFILES ppp,
5478: HZ_PARTIES hzp
5479: WHERE ppp.partner_party_id = hzp.party_id
5480: -- AND ppp.PARTNER_ID BETWEEN cv_first_partner_id AND cv_last_partner_id;
5481: AND ppp.PARTNER_ID >= cv_first_partner_id AND ppp.PARTNER_ID <= cv_last_partner_id

Line 5794: -- It reads all the partner_id from PV_PARTNER_PROFILES table and re-assign the

5790: -- Type : Public
5791: -- Function : The purpose of this procedure is to Update the Channel
5792: -- team for all partner_id by running in TOTAL_MODE. This procedure attached to
5793: -- 'Territory assignment for partners in TOTAL mode' concurrent request program.
5794: -- It reads all the partner_id from PV_PARTNER_PROFILES table and re-assign the
5795: -- channel team.
5796: --
5797: -- Pre-reqs :
5798: --

Line 5810: -- for all the Partner Organizations stored in PV_PARTNER_PROFILES

5806: -- Version :
5807: -- Initial version 1.0
5808: --
5809: -- Notes: Concurrent request program for re-assignment of Channel Team
5810: -- for all the Partner Organizations stored in PV_PARTNER_PROFILES
5811: -- table.
5812: --
5813: --
5814: -- End of Comments

Line 5831: -- Cursor to select all count of all the partner_id's from PV_PARTNER_PROFILES table

5827: SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ count(*)
5828: FROM PV_TAP_BATCH_CHG_PARTNERS
5829: WHERE PROCESSED_FLAG = 'P' ;
5830:
5831: -- Cursor to select all count of all the partner_id's from PV_PARTNER_PROFILES table
5832: -- for channel team re-assignment in case of TOTAL mode.
5833: CURSOR l_profile_partners_count_csr IS
5834: SELECT count(*)
5835: FROM PV_PARTNER_PROFILES

Line 5835: FROM PV_PARTNER_PROFILES

5831: -- Cursor to select all count of all the partner_id's from PV_PARTNER_PROFILES table
5832: -- for channel team re-assignment in case of TOTAL mode.
5833: CURSOR l_profile_partners_count_csr IS
5834: SELECT count(*)
5835: FROM PV_PARTNER_PROFILES
5836: WHERE STATUS = 'A' ;
5837:
5838: -- Cursor to select single partner_id from PV_TAP_BATCH_CHG_PARTNERS table
5839: -- for channel team re-assignment in case if only one partner exist.

Line 5845: -- Cursor to select single partner_id from PV_PARTNER_PROFILES table

5841: SELECT /*+ index(ptbcp1 PV_TAP_BATCH_CHG_PARTNERS_N1) */ partner_id
5842: FROM PV_TAP_BATCH_CHG_PARTNERS
5843: WHERE PROCESSED_FLAG = 'P' ;
5844:
5845: -- Cursor to select single partner_id from PV_PARTNER_PROFILES table
5846: -- for channel team re-assignment in case if only one partner exist.
5847: CURSOR l_single_profile_partner_csr IS
5848: SELECT partner_id
5849: FROM PV_PARTNER_PROFILES

Line 5849: FROM PV_PARTNER_PROFILES

5845: -- Cursor to select single partner_id from PV_PARTNER_PROFILES table
5846: -- for channel team re-assignment in case if only one partner exist.
5847: CURSOR l_single_profile_partner_csr IS
5848: SELECT partner_id
5849: FROM PV_PARTNER_PROFILES
5850: WHERE STATUS = 'A' ;
5851:
5852: -- Cursor to select partner_id's in batches from PV_TAP_BATCH_CHG_PARTNERS table
5853: -- for channel team re-assignment in case of INCREMENTAL mode based on batch size.

Line 5877: -- Cursor to select partner_id's in batches from PV_PARTNER_PROFILES table

5873: ORDER BY partner_id asc) )
5874: WHERE decode(mod(rn,cv_batch_size),0,partner_id,null) is not null) last
5875: WHERE first.rn=last.rn(+);
5876:
5877: -- Cursor to select partner_id's in batches from PV_PARTNER_PROFILES table
5878: -- for channel team re-assignment in case of TOTAL mode based on batch size.
5879: CURSOR l_profile_partners_csr(cv_batch_size NUMBER) IS
5880: SELECT first.f,decode(last.l,null,(SELECT max(partner_id)
5881: FROM PV_PARTNER_PROFILES

Line 5881: FROM PV_PARTNER_PROFILES

5877: -- Cursor to select partner_id's in batches from PV_PARTNER_PROFILES table
5878: -- for channel team re-assignment in case of TOTAL mode based on batch size.
5879: CURSOR l_profile_partners_csr(cv_batch_size NUMBER) IS
5880: SELECT first.f,decode(last.l,null,(SELECT max(partner_id)
5881: FROM PV_PARTNER_PROFILES
5882: WHERE partner_id >= first.f
5883: AND STATUS = 'A'
5884: AND last.l is null),last.l) la
5885: FROM

Line 5889: FROM PV_PARTNER_PROFILES

5885: FROM
5886: (SELECT decode(mod(rn,cv_batch_size),1,partner_id,null) f,null last,rownum rn
5887: FROM ( SELECT PARTNER_ID,ROWNUM RN
5888: FROM ( SELECT partner_id
5889: FROM PV_PARTNER_PROFILES
5890: WHERE STATUS = 'A'
5891: ORDER BY partner_id asc ) )
5892: WHERE decode(mod(rn,cv_batch_size),1,partner_id,null) IS NOT null ) first ,
5893: (SELECT null first,decode(mod(rn,cv_batch_size),0,partner_id,null) l,rownum rn

Line 5896: FROM PV_PARTNER_PROFILES

5892: WHERE decode(mod(rn,cv_batch_size),1,partner_id,null) IS NOT null ) first ,
5893: (SELECT null first,decode(mod(rn,cv_batch_size),0,partner_id,null) l,rownum rn
5894: FROM ( SELECT PARTNER_ID,ROWNUM RN
5895: FROM( SELECT partner_id
5896: FROM PV_PARTNER_PROFILES
5897: WHERE STATUS = 'A'
5898: ORDER BY partner_id asc) )
5899: WHERE decode(mod(rn,cv_batch_size),0,partner_id,null) is not null) last
5900: WHERE first.rn=last.rn(+);

Line 6102: -- for all the Partner Organizations stored in PV_PARTNER_PROFILES

6098: -- Version :
6099: -- Initial version 1.0
6100: --
6101: -- Notes: Concurrent request program for re-assignment of Channel Team
6102: -- for all the Partner Organizations stored in PV_PARTNER_PROFILES
6103: -- table.
6104: --
6105: --
6106: -- End of Comments

Line 6193: pv_partner_profiles ppp,

6189: cv_terr_id17 NUMBER, cv_terr_id18 NUMBER,
6190: cv_terr_id19 NUMBER, cv_terr_id20 NUMBER ) IS
6191: SELECT ppa.partner_id
6192: FROM pv_partner_accesses ppa,
6193: pv_partner_profiles ppp,
6194: pv_tap_access_terrs ptat
6195: WHERE ppa.partner_access_id = ptat.partner_access_id
6196: AND ppa.partner_id = ppp.partner_id
6197: AND ppp.status = 'A'

Line 6214: -- PV_PARTNER_PROFILES table for channel team re-assignment in case of Process

6210: WHERE partner_id = cv_partner_id
6211: AND processed_flag = 'P';
6212:
6213: -- Cursor to select partner detail for the given partner_id's from
6214: -- PV_PARTNER_PROFILES table for channel team re-assignment in case of Process
6215: -- territories.
6216: CURSOR l_prof_partner_info_csr(cv_partner_id NUMBER) IS
6217: SELECT distinct hzp.party_name partner_name
6218: FROM PV_PARTNER_PROFILES ppp,

Line 6218: FROM PV_PARTNER_PROFILES ppp,

6214: -- PV_PARTNER_PROFILES table for channel team re-assignment in case of Process
6215: -- territories.
6216: CURSOR l_prof_partner_info_csr(cv_partner_id NUMBER) IS
6217: SELECT distinct hzp.party_name partner_name
6218: FROM PV_PARTNER_PROFILES ppp,
6219: HZ_PARTIES hzp
6220: WHERE ppp.partner_id = cv_partner_id
6221: AND ppp.partner_party_id = hzp.party_id
6222: AND ppp.STATUS = 'A';