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

Line 75: hz_parties party,

71:
72: cursor c_customer_contact is
73: select distinct acct_role.cust_account_role_id contact_id
74: from hz_cust_account_roles acct_role,
75: hz_parties party,
76: hz_relationships rel,
77: hz_org_contacts org_cont,
78: hz_parties rel_party
79: where acct_role.party_id = rel.party_id

Line 78: hz_parties rel_party

74: from hz_cust_account_roles acct_role,
75: hz_parties party,
76: hz_relationships rel,
77: hz_org_contacts org_cont,
78: hz_parties rel_party
79: where acct_role.party_id = rel.party_id
80: and acct_role.role_type = 'CONTACT'
81: and org_cont.party_relationship_id = rel.relationship_id
82: and rel.subject_id = party.party_id

Line 84: and rel.subject_table_name = 'HZ_PARTIES'

80: and acct_role.role_type = 'CONTACT'
81: and org_cont.party_relationship_id = rel.relationship_id
82: and rel.subject_id = party.party_id
83: and rel.party_id = rel_party.party_id
84: and rel.subject_table_name = 'HZ_PARTIES'
85: and rel.object_table_name = 'HZ_PARTIES'
86: and rel.directional_flag = 'F'
87: and acct_role.cust_account_id = p_bill_to_customer_id
88: and acct_role.cust_acct_site_id is null

Line 85: and rel.object_table_name = 'HZ_PARTIES'

81: and org_cont.party_relationship_id = rel.relationship_id
82: and rel.subject_id = party.party_id
83: and rel.party_id = rel_party.party_id
84: and rel.subject_table_name = 'HZ_PARTIES'
85: and rel.object_table_name = 'HZ_PARTIES'
86: and rel.directional_flag = 'F'
87: and acct_role.cust_account_id = p_bill_to_customer_id
88: and acct_role.cust_acct_site_id is null
89: /* the contact must be active. however, for credit memos

Line 99: hz_parties party,

95:
96: cursor c_address_contact is
97: select distinct acct_role.cust_account_role_id contact_id
98: from hz_cust_account_roles acct_role,
99: hz_parties party,
100: hz_relationships rel,
101: hz_org_contacts org_cont,
102: hz_parties rel_party,
103: hz_cust_acct_sites acct_site,

Line 102: hz_parties rel_party,

98: from hz_cust_account_roles acct_role,
99: hz_parties party,
100: hz_relationships rel,
101: hz_org_contacts org_cont,
102: hz_parties rel_party,
103: hz_cust_acct_sites acct_site,
104: hz_cust_site_uses site_uses
105: where acct_role.party_id = rel.party_id
106: and acct_role.role_type = 'CONTACT'

Line 110: and rel.subject_table_name = 'HZ_PARTIES'

106: and acct_role.role_type = 'CONTACT'
107: and org_cont.party_relationship_id = rel.relationship_id
108: and rel.subject_id = party.party_id
109: and rel.party_id = rel_party.party_id
110: and rel.subject_table_name = 'HZ_PARTIES'
111: and rel.object_table_name = 'HZ_PARTIES'
112: and rel.directional_flag = 'F'
113: and acct_role.cust_account_id = p_bill_to_customer_id
114: and site_uses.site_use_id = p_bill_to_site_use_id

Line 111: and rel.object_table_name = 'HZ_PARTIES'

107: and org_cont.party_relationship_id = rel.relationship_id
108: and rel.subject_id = party.party_id
109: and rel.party_id = rel_party.party_id
110: and rel.subject_table_name = 'HZ_PARTIES'
111: and rel.object_table_name = 'HZ_PARTIES'
112: and rel.directional_flag = 'F'
113: and acct_role.cust_account_id = p_bill_to_customer_id
114: and site_uses.site_use_id = p_bill_to_site_use_id
115: and acct_site.cust_account_id = acct_role.cust_account_id

Line 793: hz_parties party,

789: begin
790: SELECT acct_role.cust_account_role_id
791: INTO l_selected_id
792: from hz_cust_account_roles acct_role,
793: hz_parties party,
794: hz_relationships rel,
795: hz_org_contacts org_cont,
796: hz_parties rel_party
797: where acct_role.party_id = rel.party_id

Line 796: hz_parties rel_party

792: from hz_cust_account_roles acct_role,
793: hz_parties party,
794: hz_relationships rel,
795: hz_org_contacts org_cont,
796: hz_parties rel_party
797: where acct_role.party_id = rel.party_id
798: and acct_role.role_type = 'CONTACT'
799: and org_cont.party_relationship_id =
800: rel.relationship_id

Line 803: and rel.subject_table_name = 'HZ_PARTIES'

799: and org_cont.party_relationship_id =
800: rel.relationship_id
801: and rel.subject_id = party.party_id
802: and rel.party_id = rel_party.party_id
803: and rel.subject_table_name = 'HZ_PARTIES'
804: and rel.object_table_name = 'HZ_PARTIES'
805: and rel.directional_flag = 'F'
806: and acct_role.cust_account_id = p_customer_id
807: /* the contact must be active. however, for credit memos

Line 804: and rel.object_table_name = 'HZ_PARTIES'

800: rel.relationship_id
801: and rel.subject_id = party.party_id
802: and rel.party_id = rel_party.party_id
803: and rel.subject_table_name = 'HZ_PARTIES'
804: and rel.object_table_name = 'HZ_PARTIES'
805: and rel.directional_flag = 'F'
806: and acct_role.cust_account_id = p_customer_id
807: /* the contact must be active. however, for credit memos
808: against specific transactions, the credited transaction's

Line 859: hz_parties party

855: SELECT c.cust_account_id
856: INTO l_selected_id
857: FROM hz_cust_accounts c,
858: hz_customer_profiles cp,
859: hz_parties party
860: WHERE c.cust_account_id = cp.cust_account_id (+) and
861: cp.site_use_id is null and
862: c.account_number = p_value and
863: c.status <> 'I'

Line 873: hz_parties party

869: SELECT cust_acct.cust_account_id
870: INTO l_selected_id
871: FROM hz_cust_accounts cust_acct,
872: hz_customer_profiles cp,
873: hz_parties party
874: WHERE cust_acct.cust_account_id = cp.cust_account_id (+)
875: and cust_acct.party_id = party.party_id(+)
876: and cp.site_use_id is null
877: and cust_acct.status <> 'I'

Line 1391: p_bill_to_customer_name IN hz_parties.party_name%TYPE,

1387: x_cust_trx_type_id IN OUT NOCOPY NUMBER,
1388: p_cust_trx_type IN varchar2,
1389: x_bill_to_customer_id IN OUT NOCOPY NUMBER,
1390: x_bill_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1391: p_bill_to_customer_name IN hz_parties.party_name%TYPE,
1392: p_bill_to_customer_number IN
1393: hz_cust_accounts.account_number%TYPE,
1394: p_bill_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
1395: x_bill_to_contact_id IN OUT NOCOPY NUMBER,

Line 1400: p_ship_to_customer_name IN hz_parties.party_name%TYPE,

1396: p_bill_to_contact_first_name IN VARCHAR2,
1397: p_bill_to_contact_last_name IN VARCHAR2,
1398: x_ship_to_customer_id IN OUT NOCOPY NUMBER,
1399: x_ship_to_customer_site_use_id IN OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1400: p_ship_to_customer_name IN hz_parties.party_name%TYPE,
1401: p_ship_to_customer_number IN
1402: hz_cust_accounts.account_number%TYPE,
1403: p_ship_to_location IN OUT NOCOPY hz_cust_site_uses.location%type,
1404: x_ship_to_contact_id IN OUT NOCOPY NUMBER,

Line 1815: hz_parties party

1811: SELECT cust.cust_account_id
1812: INTO l_customer_id
1813: FROM hz_cust_accounts cust,
1814: hz_customer_profiles cp,
1815: hz_parties party
1816: WHERE cust.cust_account_id = cp.cust_account_id (+) and
1817: cp.site_use_id is null and
1818: cust.cust_account_id = x_bill_to_customer_id and
1819: cust.status <> 'I' and

Line 1908: hz_parties party

1904: SELECT cust.cust_account_id
1905: INTO l_customer_id
1906: FROM hz_cust_accounts cust,
1907: hz_customer_profiles cp,
1908: hz_parties party
1909: WHERE cust.cust_account_id = cp.cust_account_id (+) and
1910: cp.site_use_id is null and
1911: cust.cust_account_id = x_ship_to_customer_id and
1912: cust.status <> 'I' and

Line 2079: hz_parties party,

2075: begin
2076: SELECT acct_role.cust_account_role_id
2077: INTO l_dummy
2078: from hz_cust_account_roles acct_role,
2079: hz_parties party,
2080: hz_relationships rel,
2081: hz_org_contacts org_cont,
2082: hz_parties rel_party
2083: where acct_role.party_id = rel.party_id

Line 2082: hz_parties rel_party

2078: from hz_cust_account_roles acct_role,
2079: hz_parties party,
2080: hz_relationships rel,
2081: hz_org_contacts org_cont,
2082: hz_parties rel_party
2083: where acct_role.party_id = rel.party_id
2084: and acct_role.role_type = 'CONTACT'
2085: and org_cont.party_relationship_id =
2086: rel.relationship_id

Line 2089: and rel.subject_table_name = 'HZ_PARTIES'

2085: and org_cont.party_relationship_id =
2086: rel.relationship_id
2087: and rel.subject_id = party.party_id
2088: and rel.party_id = rel_party.party_id
2089: and rel.subject_table_name = 'HZ_PARTIES'
2090: and rel.object_table_name = 'HZ_PARTIES'
2091: and rel.directional_flag = 'F'
2092: and acct_role.cust_account_id = x_bill_to_customer_id
2093: /* the contact must be active. however, for credit memos

Line 2090: and rel.object_table_name = 'HZ_PARTIES'

2086: rel.relationship_id
2087: and rel.subject_id = party.party_id
2088: and rel.party_id = rel_party.party_id
2089: and rel.subject_table_name = 'HZ_PARTIES'
2090: and rel.object_table_name = 'HZ_PARTIES'
2091: and rel.directional_flag = 'F'
2092: and acct_role.cust_account_id = x_bill_to_customer_id
2093: /* the contact must be active. however, for credit memos
2094: against specific transactions, the credited transaction's

Line 2162: hz_parties party,

2158: begin
2159: SELECT acct_role.cust_account_role_id
2160: INTO l_dummy
2161: from hz_cust_account_roles acct_role,
2162: hz_parties party,
2163: hz_relationships rel,
2164: hz_org_contacts org_cont,
2165: hz_parties rel_party
2166: where acct_role.party_id = rel.party_id

Line 2165: hz_parties rel_party

2161: from hz_cust_account_roles acct_role,
2162: hz_parties party,
2163: hz_relationships rel,
2164: hz_org_contacts org_cont,
2165: hz_parties rel_party
2166: where acct_role.party_id = rel.party_id
2167: and acct_role.role_type = 'CONTACT'
2168: and org_cont.party_relationship_id =
2169: rel.relationship_id

Line 2172: and rel.subject_table_name = 'HZ_PARTIES'

2168: and org_cont.party_relationship_id =
2169: rel.relationship_id
2170: and rel.subject_id = party.party_id
2171: and rel.party_id = rel_party.party_id
2172: and rel.subject_table_name = 'HZ_PARTIES'
2173: and rel.object_table_name = 'HZ_PARTIES'
2174: and rel.directional_flag = 'F'
2175: and acct_role.cust_account_id = x_ship_to_customer_id
2176: /* the contact must be active. however, for credit memos

Line 2173: and rel.object_table_name = 'HZ_PARTIES'

2169: rel.relationship_id
2170: and rel.subject_id = party.party_id
2171: and rel.party_id = rel_party.party_id
2172: and rel.subject_table_name = 'HZ_PARTIES'
2173: and rel.object_table_name = 'HZ_PARTIES'
2174: and rel.directional_flag = 'F'
2175: and acct_role.cust_account_id = x_ship_to_customer_id
2176: /* the contact must be active. however, for credit memos
2177: against specific transactions, the credited transaction's

Line 2451: hz_parties party

2447: SELECT cust.cust_account_id
2448: INTO l_customer_id
2449: FROM hz_cust_accounts cust,
2450: hz_customer_profiles cp,
2451: hz_parties party
2452: WHERE cust.cust_account_id = cp.cust_account_id (+) and
2453: cp.site_use_id is null and
2454: cust.cust_account_id = x_sold_to_customer_id and
2455: cust.status <> 'I' and

Line 2539: hz_parties party

2535: SELECT cust.cust_account_id
2536: INTO l_customer_id
2537: FROM hz_cust_accounts cust,
2538: hz_customer_profiles cp,
2539: hz_parties party
2540: WHERE cust.cust_account_id = cp.cust_account_id (+) and
2541: cp.site_use_id is null and
2542: cust.cust_account_id = x_paying_customer_id and
2543: cust.status <> 'I' and