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

Line 24: FROM hz_parties

20:
21:
22: CURSOR c_party(in_customer_id IN NUMBER) IS
23: SELECT party_name,party_type,party_id
24: FROM hz_parties
25: WHERE party_id = in_customer_id;
26:
27: CURSOR c_customer(in_party_id IN VARCHAR2) IS
28: SELECT cust_account_id,

Line 30: FROM hz_parties h,hz_cust_accounts c

26:
27: CURSOR c_customer(in_party_id IN VARCHAR2) IS
28: SELECT cust_account_id,
29: party_name
30: FROM hz_parties h,hz_cust_accounts c
31: WHERE c.party_id = h.party_id
32: AND h.party_id = ( SELECT object_id
33: FROM hz_relationships r
34: WHERE r.party_id = in_party_id

Line 35: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

31: WHERE c.party_id = h.party_id
32: AND h.party_id = ( SELECT object_id
33: FROM hz_relationships r
34: WHERE r.party_id = in_party_id
35: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
36: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
37: AND r.DIRECTIONAL_FLAG = 'F'
38: );
39:

Line 36: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

32: AND h.party_id = ( SELECT object_id
33: FROM hz_relationships r
34: WHERE r.party_id = in_party_id
35: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
36: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
37: AND r.DIRECTIONAL_FLAG = 'F'
38: );
39:
40: CURSOR c_user(in_party_id IN VARCHAR2) IS

Line 42: FROM hz_parties h,hz_cust_account_roles c

38: );
39:
40: CURSOR c_user(in_party_id IN VARCHAR2) IS
41: SELECT cust_account_role_id,party_name
42: FROM hz_parties h,hz_cust_account_roles c
43: WHERE c.party_id = h.party_id
44: AND h.party_id = ( SELECT subject_id
45: FROM hz_relationships r
46: WHERE r.party_id = in_party_id

Line 47: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

43: WHERE c.party_id = h.party_id
44: AND h.party_id = ( SELECT subject_id
45: FROM hz_relationships r
46: WHERE r.party_id = in_party_id
47: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
48: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
49: AND r.DIRECTIONAL_FLAG = 'F' );
50:
51:

Line 48: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

44: AND h.party_id = ( SELECT subject_id
45: FROM hz_relationships r
46: WHERE r.party_id = in_party_id
47: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
48: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'
49: AND r.DIRECTIONAL_FLAG = 'F' );
50:
51:
52: CURSOR c_employee(in_employee IN NUMBER) IS

Line 57: vc_party_name hz_parties.party_name%TYPE;

53: SELECT full_name
54: FROM per_all_people_f
55: WHERE person_id = in_employee;
56:
57: vc_party_name hz_parties.party_name%TYPE;
58: vn_party_id hz_parties.party_id%TYPE;
59: vc_party_type hz_parties.party_type%TYPE;
60: e_invalid_party_type EXCEPTION;
61:

Line 58: vn_party_id hz_parties.party_id%TYPE;

54: FROM per_all_people_f
55: WHERE person_id = in_employee;
56:
57: vc_party_name hz_parties.party_name%TYPE;
58: vn_party_id hz_parties.party_id%TYPE;
59: vc_party_type hz_parties.party_type%TYPE;
60: e_invalid_party_type EXCEPTION;
61:
62: vn_customer_id fnd_user.customer_id%TYPE;

Line 59: vc_party_type hz_parties.party_type%TYPE;

55: WHERE person_id = in_employee;
56:
57: vc_party_name hz_parties.party_name%TYPE;
58: vn_party_id hz_parties.party_id%TYPE;
59: vc_party_type hz_parties.party_type%TYPE;
60: e_invalid_party_type EXCEPTION;
61:
62: vn_customer_id fnd_user.customer_id%TYPE;
63: vn_emp_id fnd_user.employee_id%TYPE;