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_ORIG_SYS_REFERENCES

Line 444: hz_orig_sys_references,

440: 'Y',
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

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 450: hz_orig_sys_references.orig_system = cv_orig_system and

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';
454:

Line 451: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and

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';
454:
455:

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 493: hz_orig_sys_references,

489: cursor l_valid_POSOSR(cv_party_id IN NUMBER, cv_os IN VARCHAR, cv_osr IN VARCHAR) IS
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

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 500: hz_orig_sys_references.orig_system = cv_os and

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';
504:

Line 501: hz_orig_sys_references.orig_system_reference = cv_osr and

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';
504:
505: cursor l_valid_partner_id(cv_partner_id IN NUMBER, cv_party_id IN Number) is

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 698: hz_orig_sys_references,

694: SELECT
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

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 704: hz_orig_sys_references.orig_system = cv_orig_system and

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';
708:

Line 705: hz_orig_sys_references.orig_system_reference = cv_orig_system_ref and

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';
708:
709: CURSOR l_get_partner_id(cv_party_id IN NUMBER) IS

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 1766: HZ_ORIG_SYS_REFERENCES,

1762: SELECT
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

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 1772: HZ_ORIG_SYS_REFERENCES.orig_system = cv_orig_system AND

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';
1776:

Line 1773: HZ_ORIG_SYS_REFERENCES.orig_system_reference = cv_orig_system_ref AND

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';
1776:
1777:

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