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_ATTR_LOAD_PUB dependencies on HZ_PARTIES

Line 441: hz_parties.party_id

437:
438: CURSOR l_valid_OSR(cv_orig_system IN VARCHAR2, cv_orig_system_ref IN VARCHAR2) IS
439: select
440: 'Y',
441: hz_parties.party_id
442:
443: from
444: hz_orig_sys_references,
445: hz_parties

Line 445: hz_parties

441: hz_parties.party_id
442:
443: from
444: hz_orig_sys_references,
445: hz_parties
446:
447: where
448: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
449: hz_parties.party_type = 'ORGANIZATION' AND

Line 448: hz_orig_sys_references.owner_table_id = hz_parties.party_id and

444: hz_orig_sys_references,
445: hz_parties
446:
447: where
448: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
449: hz_parties.party_type = 'ORGANIZATION' AND
450: hz_orig_sys_references.orig_system = cv_orig_system and
451: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
452: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND

Line 449: hz_parties.party_type = 'ORGANIZATION' AND

445: hz_parties
446:
447: where
448: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
449: hz_parties.party_type = 'ORGANIZATION' AND
450: hz_orig_sys_references.orig_system = cv_orig_system and
451: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
452: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
453: hz_parties.status = 'A';

Line 452: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND

448: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
449: hz_parties.party_type = 'ORGANIZATION' AND
450: hz_orig_sys_references.orig_system = cv_orig_system and
451: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
452: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
453: hz_parties.status = 'A';
454:
455:
456: cursor l_valid_POSR(cv_party_id IN NUMBER, cv_osr in varchar2) IS

Line 453: hz_parties.status = 'A';

449: hz_parties.party_type = 'ORGANIZATION' AND
450: hz_orig_sys_references.orig_system = cv_orig_system and
451: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
452: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
453: hz_parties.status = 'A';
454:
455:
456: cursor l_valid_POSR(cv_party_id IN NUMBER, cv_osr in varchar2) IS
457: select

Line 460: hz_parties

456: cursor l_valid_POSR(cv_party_id IN NUMBER, cv_osr in varchar2) IS
457: select
458: 'Y'
459: FROM
460: hz_parties
461: where
462: party_id = cv_party_id and
463: orig_system_reference = cv_osr and
464: party_type = 'ORGANIZATION' and

Line 472: hz_parties

468: cursor l_valid_PartyId(cv_party_id IN NUMBER) IS
469: select
470: 'Y'
471: FROM
472: hz_parties
473: where
474: party_id = cv_party_id and
475: party_type = 'ORGANIZATION' and
476: status = 'A';

Line 483: hz_parties

479: cursor l_valid_Party(cv_party_id IN NUMBER) IS
480: select
481: 'Y'
482: FROM
483: hz_parties
484: where
485: party_id = cv_party_id and
486: party_type = 'ORGANIZATION' and
487: status = 'A';

Line 494: hz_parties

490: select
491: 'Y'
492: from
493: hz_orig_sys_references,
494: hz_parties
495:
496: where
497: hz_parties.party_id = cv_party_id and
498: hz_orig_sys_references.owner_table_id = hz_parties.party_id and

Line 497: hz_parties.party_id = cv_party_id and

493: hz_orig_sys_references,
494: hz_parties
495:
496: where
497: hz_parties.party_id = cv_party_id and
498: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
499: hz_parties.party_type = 'ORGANIZATION' AND
500: hz_orig_sys_references.orig_system = cv_os and
501: hz_orig_sys_references.orig_system_reference = cv_osr and

Line 498: hz_orig_sys_references.owner_table_id = hz_parties.party_id and

494: hz_parties
495:
496: where
497: hz_parties.party_id = cv_party_id and
498: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
499: hz_parties.party_type = 'ORGANIZATION' AND
500: hz_orig_sys_references.orig_system = cv_os and
501: hz_orig_sys_references.orig_system_reference = cv_osr and
502: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND

Line 499: hz_parties.party_type = 'ORGANIZATION' AND

495:
496: where
497: hz_parties.party_id = cv_party_id and
498: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
499: hz_parties.party_type = 'ORGANIZATION' AND
500: hz_orig_sys_references.orig_system = cv_os and
501: hz_orig_sys_references.orig_system_reference = cv_osr and
502: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
503: hz_parties.status = 'A';

Line 502: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND

498: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
499: hz_parties.party_type = 'ORGANIZATION' AND
500: hz_orig_sys_references.orig_system = cv_os and
501: hz_orig_sys_references.orig_system_reference = cv_osr and
502: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
503: hz_parties.status = 'A';
504:
505: cursor l_valid_partner_id(cv_partner_id IN NUMBER, cv_party_id IN Number) is
506: select

Line 503: hz_parties.status = 'A';

499: hz_parties.party_type = 'ORGANIZATION' AND
500: hz_orig_sys_references.orig_system = cv_os and
501: hz_orig_sys_references.orig_system_reference = cv_osr and
502: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
503: hz_parties.status = 'A';
504:
505: cursor l_valid_partner_id(cv_partner_id IN NUMBER, cv_party_id IN Number) is
506: select
507: 'Y'

Line 519: hz_parties.party_id

515:
516: cursor l_valid_PartnerParty(cv_partner_id number) IS
517: select
518: 'Y',
519: hz_parties.party_id
520:
521: from
522: pv_partner_profiles,
523: hz_parties

Line 523: hz_parties

519: hz_parties.party_id
520:
521: from
522: pv_partner_profiles,
523: hz_parties
524:
525: where
526: partner_id = cv_partner_id and
527: -- pv_partner_profiles.status = 'A' and

Line 529: hz_parties.status = 'A' and

525: where
526: partner_id = cv_partner_id and
527: -- pv_partner_profiles.status = 'A' and
528: party_id = partner_party_id and
529: hz_parties.status = 'A' and
530: hz_parties.party_type = 'ORGANIZATION';
531:
532:
533: l_valid varchar2(1);

Line 530: hz_parties.party_type = 'ORGANIZATION';

526: partner_id = cv_partner_id and
527: -- pv_partner_profiles.status = 'A' and
528: party_id = partner_party_id and
529: hz_parties.status = 'A' and
530: hz_parties.party_type = 'ORGANIZATION';
531:
532:
533: l_valid varchar2(1);
534: l_party_id NUMBER;

Line 695: hz_parties.party_id

691: IS
692:
693: CURSOR l_get_party_id(cv_orig_system IN VARCHAR2, cv_orig_system_ref IN VARCHAR2) IS
694: SELECT
695: hz_parties.party_id
696:
697: from
698: hz_orig_sys_references,
699: hz_parties

Line 699: hz_parties

695: hz_parties.party_id
696:
697: from
698: hz_orig_sys_references,
699: hz_parties
700:
701: where
702: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
703: hz_parties.party_type = 'ORGANIZATION' AND

Line 702: hz_orig_sys_references.owner_table_id = hz_parties.party_id and

698: hz_orig_sys_references,
699: hz_parties
700:
701: where
702: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
703: hz_parties.party_type = 'ORGANIZATION' AND
704: hz_orig_sys_references.orig_system = cv_orig_system and
705: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
706: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND

Line 703: hz_parties.party_type = 'ORGANIZATION' AND

699: hz_parties
700:
701: where
702: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
703: hz_parties.party_type = 'ORGANIZATION' AND
704: hz_orig_sys_references.orig_system = cv_orig_system and
705: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
706: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
707: hz_parties.status = 'A';

Line 706: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND

702: hz_orig_sys_references.owner_table_id = hz_parties.party_id and
703: hz_parties.party_type = 'ORGANIZATION' AND
704: hz_orig_sys_references.orig_system = cv_orig_system and
705: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
706: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
707: hz_parties.status = 'A';
708:
709: CURSOR l_get_partner_id(cv_party_id IN NUMBER) IS
710: SELECT

Line 707: hz_parties.status = 'A';

703: hz_parties.party_type = 'ORGANIZATION' AND
704: hz_orig_sys_references.orig_system = cv_orig_system and
705: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and
706: hz_orig_sys_references.owner_table_name = 'HZ_PARTIES' AND
707: hz_parties.status = 'A';
708:
709: CURSOR l_get_partner_id(cv_party_id IN NUMBER) IS
710: SELECT
711: partner_id

Line 745: hz_parties

741: CURSOR C_party_info (l_party_id NUMBER) IS
742: SELECT
743: party_type, party_name
744: FROM
745: hz_parties
746: WHERE
747: party_id = l_party_id;
748:
749:

Line 1763: HZ_PARTIES.PARTY_ID

1759: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;
1760:
1761: CURSOR l_get_party_id(cv_orig_system IN VARCHAR2, cv_orig_system_ref IN VARCHAR2) IS
1762: SELECT
1763: HZ_PARTIES.PARTY_ID
1764:
1765: FROM
1766: HZ_ORIG_SYS_REFERENCES,
1767: HZ_PARTIES

Line 1767: HZ_PARTIES

1763: HZ_PARTIES.PARTY_ID
1764:
1765: FROM
1766: HZ_ORIG_SYS_REFERENCES,
1767: HZ_PARTIES
1768:
1769: WHERE
1770: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
1771: HZ_PARTIES.PARTY_TYPE = 'ORGANIZATION' AND

Line 1770: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

1766: HZ_ORIG_SYS_REFERENCES,
1767: HZ_PARTIES
1768:
1769: WHERE
1770: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
1771: HZ_PARTIES.PARTY_TYPE = 'ORGANIZATION' AND
1772: HZ_ORIG_SYS_REFERENCES.orig_system = cv_orig_system AND
1773: HZ_ORIG_SYS_REFERENCES.orig_system_reference = cv_orig_system_ref AND
1774: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

Line 1771: HZ_PARTIES.PARTY_TYPE = 'ORGANIZATION' AND

1767: HZ_PARTIES
1768:
1769: WHERE
1770: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
1771: HZ_PARTIES.PARTY_TYPE = 'ORGANIZATION' AND
1772: HZ_ORIG_SYS_REFERENCES.orig_system = cv_orig_system AND
1773: HZ_ORIG_SYS_REFERENCES.orig_system_reference = cv_orig_system_ref AND
1774: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
1775: HZ_PARTIES.STATUS = 'A';

Line 1774: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

1770: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
1771: HZ_PARTIES.PARTY_TYPE = 'ORGANIZATION' AND
1772: HZ_ORIG_SYS_REFERENCES.orig_system = cv_orig_system AND
1773: HZ_ORIG_SYS_REFERENCES.orig_system_reference = cv_orig_system_ref AND
1774: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
1775: HZ_PARTIES.STATUS = 'A';
1776:
1777:
1778: CURSOR l_get_partner_id(cv_party_id IN NUMBER) IS

Line 1775: HZ_PARTIES.STATUS = 'A';

1771: HZ_PARTIES.PARTY_TYPE = 'ORGANIZATION' AND
1772: HZ_ORIG_SYS_REFERENCES.orig_system = cv_orig_system AND
1773: HZ_ORIG_SYS_REFERENCES.orig_system_reference = cv_orig_system_ref AND
1774: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
1775: HZ_PARTIES.STATUS = 'A';
1776:
1777:
1778: CURSOR l_get_partner_id(cv_party_id IN NUMBER) IS
1779: SELECT