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_OTM_REF_DATA_GEN_PKG dependencies on WSH_OTM_LOC_CONTACTS_GTMP

Line 360: FROM WSH_OTM_LOC_CONTACTS_GTMP

356: p_location_id IN NUMBER,
357: p_corporation_id IN NUMBER
358: ) is
359: SELECT 'X'
360: FROM WSH_OTM_LOC_CONTACTS_GTMP
361: WHERE CONTACT_ID = p_contact_id
362: AND LOCATION_ID = p_location_id
363: AND CORPORATION_ID = p_corporation_id
364: AND LOCATION_TYPE = 'CUST_LOC';

Line 616: insert into WSH_OTM_LOC_CONTACTS_GTMP

612: WSH_DEBUG_SV.log(l_module_name,'contact exists',l_contact_exists);
613: END IF;
614: IF (l_contact_exists IS NULL) THEN
615: --{
616: insert into WSH_OTM_LOC_CONTACTS_GTMP
617: (contact_id, location_id, corporation_id, location_type)
618: values(del_contact_rec.contact_id, l_st_loc_id,del_contact_rec.customer_id, 'CUST_LOC');
619: --}
620: END IF;

Line 1529: WSH_OTM_LOC_CONTACTS_GTMP WLCT

1525: HZ_RELATIONSHIPS HREL,
1526: HZ_ORG_CONTACTS HOC,
1527: HZ_CONTACT_POINTS PHONE_CONTACT,
1528: HZ_PARTIES PER_CONTACT,
1529: WSH_OTM_LOC_CONTACTS_GTMP WLCT
1530: WHERE HREL.PARTY_ID = HCAR.PARTY_ID
1531: AND HCAR.ROLE_TYPE = 'CONTACT'
1532: AND HREL.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
1533: AND HREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'