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.AMS_SCHEDULERULES_PVT dependencies on HZ_PARTIES

Line 4488: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel

4484: select decode(pa.party_type,'PARTY_RELATIONSHIP','ORGANIZATION','PERSON') party_type,
4485: decode(pa.party_type,'PARTY_RELATIONSHIP',rel.subject_id,null) contact_party_id,
4486: decode(pa.party_type,'PARTY_RELATIONSHIP',TO_NUMBER(le.col147),le.party_id) main_party_id,
4487: decode(pa.party_type,'PARTY_RELATIONSHIP',le.party_id,null) rel_party_id
4488: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel
4489: where la.list_header_id = le.list_header_id
4490: and la.list_act_type = 'TARGET'
4491: and la.list_used_by = 'CSCH'
4492: and la.list_used_by_id = p_obj_id

Line 4539: TYPE Main_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;

4535:
4536: TYPE Lead_Header_Id_Table IS TABLE OF as_import_interface.IMPORT_INTERFACE_ID%TYPE;
4537: l_lead_header_ids Lead_Header_Id_Table; -- no need to initialize
4538:
4539: TYPE Main_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4540: l_main_party_ids Main_Party_Id_Table; -- no need to initialize
4541:
4542: TYPE Contact_Point_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4543: l_contact_point_party_ids Contact_Point_Party_Id_Table; -- no need to initialize

Line 4542: TYPE Contact_Point_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;

4538:
4539: TYPE Main_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4540: l_main_party_ids Main_Party_Id_Table; -- no need to initialize
4541:
4542: TYPE Contact_Point_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4543: l_contact_point_party_ids Contact_Point_Party_Id_Table; -- no need to initialize
4544:
4545: TYPE Rel_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4546: l_rel_party_ids Rel_Party_Id_Table; -- no need to initialize

Line 4545: TYPE Rel_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;

4541:
4542: TYPE Contact_Point_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4543: l_contact_point_party_ids Contact_Point_Party_Id_Table; -- no need to initialize
4544:
4545: TYPE Rel_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4546: l_rel_party_ids Rel_Party_Id_Table; -- no need to initialize
4547:
4548: TYPE Party_Type_Table IS TABLE OF hz_parties.PARTY_TYPE%TYPE;
4549: l_party_types Party_Type_Table; -- no need to initialize

Line 4548: TYPE Party_Type_Table IS TABLE OF hz_parties.PARTY_TYPE%TYPE;

4544:
4545: TYPE Rel_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4546: l_rel_party_ids Rel_Party_Id_Table; -- no need to initialize
4547:
4548: TYPE Party_Type_Table IS TABLE OF hz_parties.PARTY_TYPE%TYPE;
4549: l_party_types Party_Type_Table; -- no need to initialize
4550:
4551: l_return_status VARCHAR2(1);
4552: l_party_id NUMBER;