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.CSC_ROUTING_UTL dependencies on HZ_ORG_CONTACTS

Line 917: -- HZ_PARTIES table by traversing the relationships from HZ_ORG_CONTACTS

913: ------------------------------------------------------------------------------
914: -- Function : Get_Customer_From_ContactNum
915: -- Usage : Used to get the party ID from the Contact Number passed in the IVR parms
916: -- Description : This function retrieves a party ID from the
917: -- HZ_PARTIES table by traversing the relationships from HZ_ORG_CONTACTS
918: -- and HZ_RELATIONSHIPS.
919: -- If there is more than one party_id associated with the given ContactNum
920: -- this function will return the first party_id that it retrieves.
921: -- Parameters :

Line 937: hz_org_contacts c

933: CURSOR cnum (connum IN VARCHAR2) IS
934: SELECT p.party_id
935: FROM hz_parties p,
936: hz_relationships r,
937: hz_org_contacts c
938: WHERE c.contact_number = connum
939: AND c.party_relationship_id = r.relationship_id
940: AND r.object_id = p.party_id
941: AND r.subject_table_name = 'HZ_PARTIES'