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

Line 428: FROM HZ_PARTIES

424: l_party_object_version_number := FND_API.G_MISS_NUM;
425:
426: SELECT OBJECT_VERSION_NUMBER
427: INTO l_party_object_version_number
428: FROM HZ_PARTIES
429: WHERE PARTY_ID = p_party_rec.party_id;
430:
431: EXCEPTION
432: WHEN OTHERS THEN

Line 481: FROM HZ_PARTIES

477: l_party_object_version_number := FND_API.G_MISS_NUM;
478:
479: SELECT OBJECT_VERSION_NUMBER
480: INTO l_party_object_version_number
481: FROM HZ_PARTIES
482: WHERE PARTY_ID = p_party_rec.party_id;
483:
484: EXCEPTION
485: WHEN OTHERS THEN

Line 518: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

514: SELECT last_update_date, relationship_id
515: INTO l_party_rel_last_update_date,l_party_relationship_id
516: from hz_relationships
517: where party_id = p_party_rec.party_id
518: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
519: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
520:
521:
522: l_party_rel_rec.relationship_id := l_party_relationship_id;

Line 519: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';

515: INTO l_party_rel_last_update_date,l_party_relationship_id
516: from hz_relationships
517: where party_id = p_party_rec.party_id
518: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
519: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
520:
521:
522: l_party_rel_rec.relationship_id := l_party_relationship_id;
523:

Line 539: FROM HZ_PARTIES

535: l_party_object_version_number := FND_API.G_MISS_NUM;
536:
537: SELECT OBJECT_VERSION_NUMBER
538: INTO l_party_object_version_number
539: FROM HZ_PARTIES
540: WHERE PARTY_ID = p_party_rec.party_id;
541:
542: SELECT OBJECT_VERSION_NUMBER
543: INTO l_object_version_number

Line 723: FROM hz_parties

719: WHERE source_code_id = l_source_code_id;
720:
721: CURSOR C_party_info (l_party_id NUMBER) IS
722: SELECT party_type, party_name
723: FROM hz_parties
724: WHERE party_id = l_party_id;
725:
726: CURSOR C_acct_number IS
727: SELECT aso_account_number_s.nextval

Line 734: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'

730: CURSOR c_party_rel_rec(l_party_id NUMBER) IS
731: SELECT object_id from
732: hz_relationships
733: where party_id = l_party_id
734: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
735: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
736:
737: -- The record definitions have been moved to a different package in version 2 api
738: -- account_rec hz_customer_accounts_pub.account_rec_type;

Line 735: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';

731: SELECT object_id from
732: hz_relationships
733: where party_id = l_party_id
734: and SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
735: and OBJECT_TABLE_NAME(+) = 'HZ_PARTIES';
736:
737: -- The record definitions have been moved to a different package in version 2 api
738: -- account_rec hz_customer_accounts_pub.account_rec_type;
739: account_rec HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type;

Line 1427: and par.subject_table_name ='HZ_PARTIES';

1423: hz_org_contacts org
1424: WHERE org.party_relationship_id = par.relationship_id
1425: AND org.org_contact_id = l_org_contact_id
1426: and par.subject_type = 'PERSON'
1427: and par.subject_table_name ='HZ_PARTIES';
1428:
1429: l_api_version CONSTANT NUMBER := 1.0;
1430: l_api_name CONSTANT VARCHAR2(45) := 'Create_Contact';
1431: l_role_type VARCHAR2(30);

Line 1627: FROM hz_org_contacts oc, hz_parties p, hz_relationships pr

1623: l_api_name CONSTANT VARCHAR2(45) := 'Create_ORG_CONTACT_ORD';
1624:
1625: Cursor C_org_contact (l_party_id NUMBER, l_header_party_id NUMBER) IS
1626: SELECT OC.org_contact_id
1627: FROM hz_org_contacts oc, hz_parties p, hz_relationships pr
1628: WHERE p.party_id = l_party_id
1629: AND p.party_id = pr.subject_id
1630: AND pr.object_id = l_header_party_id
1631: AND (pr.relationship_type = 'CONTACT'

Line 2092: FROM hz_parties

2088: WHERE source_code_id = l_source_code_id;
2089:
2090: CURSOR C_party_info (l_party_id NUMBER) IS
2091: SELECT party_type, party_name
2092: FROM hz_parties
2093: WHERE party_id = l_party_id;
2094:
2095: CURSOR C_acct_number IS
2096: SELECT aso_account_number_s.nextval

Line 2103: and object_table_name = 'HZ_PARTIES'

2099: CURSOR c_party_rel_rec(l_party_id NUMBER) IS
2100: SELECT object_id from
2101: hz_relationships
2102: where party_id = l_party_id
2103: and object_table_name = 'HZ_PARTIES'
2104: and subject_type = 'PERSON'
2105: and subject_table_name = 'HZ_PARTIES';
2106:
2107: -- The record definitions have been moved to a different package in version 2 api

Line 2105: and subject_table_name = 'HZ_PARTIES';

2101: hz_relationships
2102: where party_id = l_party_id
2103: and object_table_name = 'HZ_PARTIES'
2104: and subject_type = 'PERSON'
2105: and subject_table_name = 'HZ_PARTIES';
2106:
2107: -- The record definitions have been moved to a different package in version 2 api
2108: -- account_rec hz_customer_accounts_pub.account_rec_type;
2109: account_rec HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type;