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 795: hz_parties party,

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

Line 798: hz_parties rel_party

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

Line 805: and rel.subject_table_name = 'HZ_PARTIES'

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

Line 806: and rel.object_table_name = 'HZ_PARTIES'

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

Line 861: hz_parties party

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

Line 875: hz_parties party

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

Line 1393: p_bill_to_customer_name IN hz_parties.party_name%TYPE,

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

Line 1402: p_ship_to_customer_name IN hz_parties.party_name%TYPE,

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

Line 1817: hz_parties party

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

Line 1910: hz_parties party

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

Line 2103: hz_parties party,

2099: begin
2100: SELECT acct_role.cust_account_role_id
2101: INTO l_dummy
2102: from hz_cust_account_roles acct_role,
2103: hz_parties party,
2104: hz_relationships rel,
2105: hz_org_contacts org_cont,
2106: hz_parties rel_party
2107: where acct_role.party_id = rel.party_id

Line 2106: hz_parties rel_party

2102: from hz_cust_account_roles acct_role,
2103: hz_parties party,
2104: hz_relationships rel,
2105: hz_org_contacts org_cont,
2106: hz_parties rel_party
2107: where acct_role.party_id = rel.party_id
2108: and acct_role.role_type = 'CONTACT'
2109: and org_cont.party_relationship_id =
2110: rel.relationship_id

Line 2113: and rel.subject_table_name = 'HZ_PARTIES'

2109: and org_cont.party_relationship_id =
2110: rel.relationship_id
2111: and rel.subject_id = party.party_id
2112: and rel.party_id = rel_party.party_id
2113: and rel.subject_table_name = 'HZ_PARTIES'
2114: and rel.object_table_name = 'HZ_PARTIES'
2115: and rel.directional_flag = 'F'
2116: and acct_role.cust_account_id = x_bill_to_customer_id
2117: /* the contact must be active. however, for credit memos

Line 2114: and rel.object_table_name = 'HZ_PARTIES'

2110: rel.relationship_id
2111: and rel.subject_id = party.party_id
2112: and rel.party_id = rel_party.party_id
2113: and rel.subject_table_name = 'HZ_PARTIES'
2114: and rel.object_table_name = 'HZ_PARTIES'
2115: and rel.directional_flag = 'F'
2116: and acct_role.cust_account_id = x_bill_to_customer_id
2117: /* the contact must be active. however, for credit memos
2118: against specific transactions, the credited transaction's

Line 2186: hz_parties party,

2182: begin
2183: SELECT acct_role.cust_account_role_id
2184: INTO l_dummy
2185: from hz_cust_account_roles acct_role,
2186: hz_parties party,
2187: hz_relationships rel,
2188: hz_org_contacts org_cont,
2189: hz_parties rel_party
2190: where acct_role.party_id = rel.party_id

Line 2189: hz_parties rel_party

2185: from hz_cust_account_roles acct_role,
2186: hz_parties party,
2187: hz_relationships rel,
2188: hz_org_contacts org_cont,
2189: hz_parties rel_party
2190: where acct_role.party_id = rel.party_id
2191: and acct_role.role_type = 'CONTACT'
2192: and org_cont.party_relationship_id =
2193: rel.relationship_id

Line 2196: and rel.subject_table_name = 'HZ_PARTIES'

2192: and org_cont.party_relationship_id =
2193: rel.relationship_id
2194: and rel.subject_id = party.party_id
2195: and rel.party_id = rel_party.party_id
2196: and rel.subject_table_name = 'HZ_PARTIES'
2197: and rel.object_table_name = 'HZ_PARTIES'
2198: and rel.directional_flag = 'F'
2199: and acct_role.cust_account_id = x_ship_to_customer_id
2200: /* the contact must be active. however, for credit memos

Line 2197: and rel.object_table_name = 'HZ_PARTIES'

2193: rel.relationship_id
2194: and rel.subject_id = party.party_id
2195: and rel.party_id = rel_party.party_id
2196: and rel.subject_table_name = 'HZ_PARTIES'
2197: and rel.object_table_name = 'HZ_PARTIES'
2198: and rel.directional_flag = 'F'
2199: and acct_role.cust_account_id = x_ship_to_customer_id
2200: /* the contact must be active. however, for credit memos
2201: against specific transactions, the credited transaction's

Line 2477: hz_parties party

2473: SELECT cust.cust_account_id
2474: INTO l_customer_id
2475: FROM hz_cust_accounts cust,
2476: hz_customer_profiles cp,
2477: hz_parties party
2478: WHERE cust.cust_account_id = cp.cust_account_id (+) and
2479: cp.site_use_id is null and
2480: cust.cust_account_id = x_sold_to_customer_id and
2481: cust.status <> 'I' and

Line 2565: hz_parties party

2561: SELECT cust.cust_account_id
2562: INTO l_customer_id
2563: FROM hz_cust_accounts cust,
2564: hz_customer_profiles cp,
2565: hz_parties party
2566: WHERE cust.cust_account_id = cp.cust_account_id (+) and
2567: cp.site_use_id is null and
2568: cust.cust_account_id = x_paying_customer_id and
2569: cust.status <> 'I' and