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 4518: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel

4514: select decode(pa.party_type,'PARTY_RELATIONSHIP','ORGANIZATION','PERSON') party_type,
4515: decode(pa.party_type,'PARTY_RELATIONSHIP',rel.subject_id,null) contact_party_id,
4516: decode(pa.party_type,'PARTY_RELATIONSHIP',TO_NUMBER(le.col147),le.party_id) main_party_id,
4517: decode(pa.party_type,'PARTY_RELATIONSHIP',le.party_id,null) rel_party_id
4518: from ams_act_lists la, ams_list_entries le, hz_parties pa, hz_relationships rel
4519: where la.list_header_id = le.list_header_id
4520: and la.list_act_type = 'TARGET'
4521: and la.list_used_by = 'CSCH'
4522: and la.list_used_by_id = p_obj_id

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

4565:
4566: TYPE Lead_Header_Id_Table IS TABLE OF as_import_interface.IMPORT_INTERFACE_ID%TYPE;
4567: l_lead_header_ids Lead_Header_Id_Table; -- no need to initialize
4568:
4569: TYPE Main_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4570: l_main_party_ids Main_Party_Id_Table; -- no need to initialize
4571:
4572: TYPE Contact_Point_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4573: l_contact_point_party_ids Contact_Point_Party_Id_Table; -- no need to initialize

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

4568:
4569: TYPE Main_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4570: l_main_party_ids Main_Party_Id_Table; -- no need to initialize
4571:
4572: TYPE Contact_Point_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4573: l_contact_point_party_ids Contact_Point_Party_Id_Table; -- no need to initialize
4574:
4575: TYPE Rel_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4576: l_rel_party_ids Rel_Party_Id_Table; -- no need to initialize

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

4571:
4572: TYPE Contact_Point_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4573: l_contact_point_party_ids Contact_Point_Party_Id_Table; -- no need to initialize
4574:
4575: TYPE Rel_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4576: l_rel_party_ids Rel_Party_Id_Table; -- no need to initialize
4577:
4578: TYPE Party_Type_Table IS TABLE OF hz_parties.PARTY_TYPE%TYPE;
4579: l_party_types Party_Type_Table; -- no need to initialize

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

4574:
4575: TYPE Rel_Party_Id_Table IS TABLE OF hz_parties.PARTY_ID%TYPE;
4576: l_rel_party_ids Rel_Party_Id_Table; -- no need to initialize
4577:
4578: TYPE Party_Type_Table IS TABLE OF hz_parties.PARTY_TYPE%TYPE;
4579: l_party_types Party_Type_Table; -- no need to initialize
4580:
4581: l_return_status VARCHAR2(1);
4582: l_party_id NUMBER;