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.WSH_SUPPLIER_PARTY dependencies on HZ_RELATIONSHIPS

Line 299: -- for existing party in hz_relationships.

295: -- API name : VENDOR_PARTY_EXISTS
296: -- Type : Public
297: -- Pre-reqs : None.
298: -- Procedure: API to find Party for a Vendor. Based on input vendor_id check
299: -- for existing party in hz_relationships.
300: -- Parameters :
301: -- IN:
302: -- p_vendor_id Vendor Id
303: -- OUT:

Line 1034: FROM hz_relationships h2,

1030: --Cursor to validate ISP user.The value for relationship type, subject and objects
1031: --is same as when user is created.
1032: CURSOR get_pos_user IS
1033: SELECT 1
1034: FROM hz_relationships h2,
1035: hz_parties hp,
1036: fnd_user fu
1037: WHERE h2.subject_type = 'ORGANIZATION'
1038: and h2.object_type = 'PERSON'

Line 2132: hz_relationships hrel

2128: hz_parties contact_person,
2129: hz_org_contacts supplier_contact,
2130: hz_contact_points phone_record,
2131: hz_contact_points email_record,
2132: hz_relationships hrel
2133: where hrel.subject_id = contact_person.party_id
2134: and hrel.subject_table_name = 'HZ_PARTIES'
2135: and hrel.subject_type = 'PERSON'
2136: and hrel.object_id = hps.party_id