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

Line 110: WHERE hr.owner_table_name = 'HZ_PARTIES'

106: BEGIN
107: SELECT owner_table_id
108: INTO l_party_id
109: FROM hz_orig_sys_references hr
110: WHERE hr.owner_table_name = 'HZ_PARTIES'
111: AND hr.orig_system = p_orig_system
112: AND hr.orig_system_reference = p_orig_system_reference
113: AND hr.status = 'A'
114: AND nvl(hr.end_date_active, SYSDATE) >= SYSDATE;

Line 145: WHERE hr.owner_table_name = 'HZ_PARTIES'

141: UPDATE ap_suppliers_int supp
142: SET party_id =
143: (SELECT party_id
144: FROM hz_orig_sys_references hr
145: WHERE hr.owner_table_name = 'HZ_PARTIES'
146: AND hr.orig_system = supp.party_orig_system
147: AND hr.orig_system_reference =
148: supp.party_orig_system_reference
149: AND hr.status = 'A'

Line 405: WHERE hr.owner_table_name = 'HZ_PARTIES'

401: UPDATE ap_sup_site_contact_int supp
402: SET per_party_id =
403: (SELECT party_id
404: FROM hz_orig_sys_references hr
405: WHERE hr.owner_table_name = 'HZ_PARTIES'
406: AND hr.orig_system = supp.contact_orig_system
407: AND hr.orig_system_reference =
408: supp.contact_orig_system_reference
409: AND hr.status = 'A'

Line 950: FROM hz_parties

946: supp_contact_int_rec.contact_orig_system_reference);
947: IF (l_per_party_id = 0) THEN
948: SELECT party_id
949: INTO l_per_party_id
950: FROM hz_parties
951: WHERE party_name = supp_contact_int_rec.first_name || ' ' ||
952: supp_contact_int_rec.last_name
953: AND party_type = 'PERSON';
954: /*AND orig_system_reference =

Line 1049: WHERE hr.owner_table_name = 'HZ_PARTIES'

1045: UPDATE ap_suppliers_int supp
1046: SET supp.party_id =
1047: (SELECT party_id
1048: FROM hz_orig_sys_references hr
1049: WHERE hr.owner_table_name = 'HZ_PARTIES'
1050: AND hr.orig_system = supp.party_orig_system
1051: AND hr.orig_system_reference =
1052: supp.party_orig_system_reference
1053: AND hr.status = 'A'

Line 1090: WHERE hr.owner_table_name = 'HZ_PARTIES'

1086: UPDATE ap_supplier_sites_int supp
1087: SET supp.party_id =
1088: (SELECT party_id
1089: FROM hz_orig_sys_references hr
1090: WHERE hr.owner_table_name = 'HZ_PARTIES'
1091: AND hr.orig_system = supp.party_orig_system
1092: AND hr.orig_system_reference =
1093: supp.party_orig_system_reference
1094: AND hr.status = 'A'

Line 4088: AND hzr.subject_table_name = 'HZ_PARTIES'

4084: AND hzr.relationship_type = 'CONTACT'
4085: AND hzr.relationship_code = 'CONTACT_OF'
4086: AND hzr.subject_id = vendor_contact_rec.per_party_id
4087: AND hzr.subject_type = 'PERSON'
4088: AND hzr.subject_table_name = 'HZ_PARTIES'
4089: AND hzr.object_type = 'ORGANIZATION'
4090: AND hzr.object_table_name = 'HZ_PARTIES'
4091: AND hzr.object_id = pv.party_id
4092: AND hzr.status = 'A'

Line 4090: AND hzr.object_table_name = 'HZ_PARTIES'

4086: AND hzr.subject_id = vendor_contact_rec.per_party_id
4087: AND hzr.subject_type = 'PERSON'
4088: AND hzr.subject_table_name = 'HZ_PARTIES'
4089: AND hzr.object_type = 'ORGANIZATION'
4090: AND hzr.object_table_name = 'HZ_PARTIES'
4091: AND hzr.object_id = pv.party_id
4092: AND hzr.status = 'A'
4093: AND trunc(SYSDATE) BETWEEN trunc(hzr.start_date) AND
4094: nvl(trunc(hzr.end_date), trunc(SYSDATE + 1))

Line 4319: p_party_id IN hz_parties.party_id%TYPE,

4315: PROCEDURE validate_vendor_prods_services
4316: (
4317: p_batch_id IN NUMBER,
4318: p_vendor_prodsrv_rec IN pos_product_service_int%ROWTYPE,
4319: p_party_id IN hz_parties.party_id%TYPE,
4320: x_return_status OUT NOCOPY VARCHAR2,
4321: x_msg_count OUT NOCOPY NUMBER,
4322: x_msg_data OUT NOCOPY VARCHAR2,
4323: x_prod_valid OUT NOCOPY VARCHAR2,

Line 4630: p_party_id IN hz_parties.party_id%TYPE,

4626: PROCEDURE create_vendor_prods_services
4627: (
4628: p_batch_id IN NUMBER,
4629: p_vendor_prodsrv_rec IN pos_product_service_int%ROWTYPE,
4630: p_party_id IN hz_parties.party_id%TYPE,
4631: x_return_status OUT NOCOPY VARCHAR2,
4632: x_msg_count OUT NOCOPY NUMBER,
4633: x_msg_data OUT NOCOPY VARCHAR2
4634: ) IS

Line 5328: p_party_id IN hz_parties.party_id%TYPE,

5324: PROCEDURE validate_vendor_buss_class
5325: (
5326: p_batch_id IN NUMBER,
5327: p_vendor_buss_class_rec IN pos_business_class_int%ROWTYPE,
5328: p_party_id IN hz_parties.party_id%TYPE,
5329: x_return_status OUT NOCOPY VARCHAR2,
5330: x_msg_count OUT NOCOPY NUMBER,
5331: x_msg_data OUT NOCOPY VARCHAR2,
5332: x_buss_valid OUT NOCOPY VARCHAR2

Line 5459: p_party_id IN hz_parties.party_id%TYPE,

5455: PROCEDURE create_vendor_buss_class
5456: (
5457: p_batch_id IN NUMBER,
5458: p_vendor_buss_class_rec IN pos_business_class_int%ROWTYPE,
5459: p_party_id IN hz_parties.party_id%TYPE,
5460: x_return_status OUT NOCOPY VARCHAR2,
5461: x_msg_count OUT NOCOPY NUMBER,
5462: x_msg_data OUT NOCOPY VARCHAR2
5463: ) IS

Line 6663: hz_parties hp

6659: BEGIN
6660: SELECT prof.party_id
6661: INTO l_tax_authority_party_id
6662: FROM zx_party_tax_profile prof,
6663: hz_parties hp
6664: WHERE hp.party_id = prof.party_id
6665: AND prof.party_type_code = 'TAX_AUTHORITY'
6666: AND hp.party_name = p_tax_reg_rec.tax_authority_name;
6667:

Line 8382: FROM hz_parties

8378:
8379: --getting the object version number
8380: SELECT object_version_number
8381: INTO l_new_bank_rec.object_version_number
8382: FROM hz_parties
8383: WHERE party_id = l_bank_id;
8384:
8385: iby_ext_bankacct_pub.update_ext_bank(p_api_version => 1,
8386: p_init_msg_list => fnd_api.g_true,

Line 8457: FROM hz_parties

8453: AND batch_id = p_batch_id;
8454:
8455: SELECT ROWID
8456: INTO l_bank_rowid
8457: FROM hz_parties
8458: WHERE party_id = l_bank_id;
8459:
8460: -- Update the other bank details
8461: hz_parties_pkg.update_row(x_rowid => l_bank_rowid,

Line 8461: hz_parties_pkg.update_row(x_rowid => l_bank_rowid,

8457: FROM hz_parties
8458: WHERE party_id = l_bank_id;
8459:
8460: -- Update the other bank details
8461: hz_parties_pkg.update_row(x_rowid => l_bank_rowid,
8462: x_party_id => l_bank_id,
8463: x_party_number => NULL,
8464: x_party_name => NULL,
8465: x_party_type => NULL,

Line 8698: FROM hz_parties

8694: WHERE branch_party_id = l_branch_id;*/
8695:
8696: SELECT object_version_number
8697: INTO l_new_branch_rec.bch_object_version_number
8698: FROM hz_parties
8699: WHERE party_id = l_branch_id;
8700:
8701: --Getting Bank Branch Type Object Version Number
8702: BEGIN

Line 8707: AND hca.owner_table_name = 'HZ_PARTIES'

8703: SELECT hca.object_version_number
8704: INTO l_new_branch_rec.typ_object_version_number
8705: FROM hz_code_assignments hca
8706: WHERE hca.class_category = 'BANK_BRANCH_TYPE'
8707: AND hca.owner_table_name = 'HZ_PARTIES'
8708: AND hca.owner_table_id = l_branch_id
8709: --AND hca.primary_flag='Y'
8710: AND SYSDATE BETWEEN start_date_active AND
8711: nvl(end_date_active, SYSDATE + 1)

Line 8801: FROM hz_parties

8797: AND batch_id = p_batch_id;
8798:
8799: SELECT ROWID
8800: INTO l_branch_rowid
8801: FROM hz_parties
8802: WHERE party_id = l_branch_id;
8803:
8804: -- Update the other branch details
8805: hz_parties_pkg.update_row(x_rowid => l_branch_rowid,

Line 8805: hz_parties_pkg.update_row(x_rowid => l_branch_rowid,

8801: FROM hz_parties
8802: WHERE party_id = l_branch_id;
8803:
8804: -- Update the other branch details
8805: hz_parties_pkg.update_row(x_rowid => l_branch_rowid,
8806: x_party_id => l_branch_id,
8807: x_party_number => NULL,
8808: x_party_name => NULL,
8809: x_party_type => NULL,

Line 9707: FROM hz_parties

9703: IF account_owners_rec.account_owner_party_id IS NULL THEN
9704: IF account_owners_rec.account_owner_name IS NOT NULL THEN
9705: SELECT party_id
9706: INTO l_account_owner_id
9707: FROM hz_parties
9708: WHERE party_name = account_owners_rec.account_owner_name
9709: AND rownum = 1;
9710: ELSE
9711: l_account_owner_id := get_party_id(account_owners_rec.source_system,