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_CONTACT_USER_BATCH_PUB dependencies on HZ_ORIG_SYS_REFERENCES

Line 341: HZ_ORIG_SYS_REFERENCES,

337: CURSOR get_party_id_from_ref(orig_system IN VARCHAR2, orig_system_ref IN VARCHAR2, l_party_type IN VARCHAR2) IS
338: SELECT
339: HZ_PARTIES.PARTY_ID
340: FROM
341: HZ_ORIG_SYS_REFERENCES,
342: HZ_PARTIES
343: WHERE
344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND

Line 344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

340: FROM
341: HZ_ORIG_SYS_REFERENCES,
342: HZ_PARTIES
343: WHERE
344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

Line 346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND

342: HZ_PARTIES
343: WHERE
344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
349: HZ_PARTIES.STATUS = 'A';
350:

Line 347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND

343: WHERE
344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
349: HZ_PARTIES.STATUS = 'A';
350:
351:

Line 348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

344: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
345: HZ_PARTIES.PARTY_TYPE = l_party_type AND
346: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
347: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
348: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
349: HZ_PARTIES.STATUS = 'A';
350:
351:
352:

Line 357: HZ_ORIG_SYS_REFERENCES,

353: CURSOR get_party_id_all_data(orig_system IN VARCHAR2, orig_system_ref IN VARCHAR2,l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS
354: SELECT
355: HZ_PARTIES.PARTY_ID
356: FROM
357: HZ_ORIG_SYS_REFERENCES,
358: HZ_PARTIES
359: WHERE
360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
361: HZ_PARTIES.PARTY_TYPE = l_party_type AND

Line 360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

356: FROM
357: HZ_ORIG_SYS_REFERENCES,
358: HZ_PARTIES
359: WHERE
360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND

Line 363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND

359: WHERE
360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
366: HZ_PARTIES.STATUS = 'A';
367:

Line 364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND

360: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
366: HZ_PARTIES.STATUS = 'A';
367:
368:

Line 365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

361: HZ_PARTIES.PARTY_TYPE = l_party_type AND
362: HZ_PARTIES.party_id = l_party_id and
363: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
364: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
365: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
366: HZ_PARTIES.STATUS = 'A';
367:
368:
369:

Line 376: HZ_ORIG_SYS_REFERENCES,

372: CURSOR get_party_id_only_sys(orig_system IN VARCHAR2, l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS
373: SELECT
374: HZ_PARTIES.PARTY_ID
375: FROM
376: HZ_ORIG_SYS_REFERENCES,
377: HZ_PARTIES
378: WHERE
379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND

Line 379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

375: FROM
376: HZ_ORIG_SYS_REFERENCES,
377: HZ_PARTIES
378: WHERE
379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and
382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

Line 382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND

378: WHERE
379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and
382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
384: HZ_PARTIES.STATUS = 'A';
385:
386:

Line 383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

379: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
380: HZ_PARTIES.PARTY_TYPE = l_party_type AND
381: HZ_PARTIES.party_id = l_party_id and
382: HZ_ORIG_SYS_REFERENCES.orig_system = orig_system AND
383: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
384: HZ_PARTIES.STATUS = 'A';
385:
386:
387: CURSOR get_party_id_only_ref( orig_system_ref IN VARCHAR2,l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS

Line 391: HZ_ORIG_SYS_REFERENCES,

387: CURSOR get_party_id_only_ref( orig_system_ref IN VARCHAR2,l_party_id VARCHAR2, l_party_type IN VARCHAR2) IS
388: SELECT
389: HZ_PARTIES.PARTY_ID
390: FROM
391: HZ_ORIG_SYS_REFERENCES,
392: HZ_PARTIES
393: WHERE
394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND

Line 394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND

390: FROM
391: HZ_ORIG_SYS_REFERENCES,
392: HZ_PARTIES
393: WHERE
394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and
397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

Line 397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND

393: WHERE
394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and
397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
399: HZ_PARTIES.STATUS = 'A';
400:
401:

Line 398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND

394: HZ_ORIG_SYS_REFERENCES.OWNER_TABLE_ID = HZ_PARTIES.PARTY_ID AND
395: HZ_PARTIES.PARTY_TYPE = l_party_type AND
396: HZ_PARTIES.party_id = l_party_id and
397: HZ_ORIG_SYS_REFERENCES.orig_system_reference = orig_system_ref AND
398: HZ_ORIG_SYS_REFERENCES.owner_table_name = 'HZ_PARTIES' AND
399: HZ_PARTIES.STATUS = 'A';
400:
401:
402: