Oracle Fusion TCA Concept
There are some queries, which is mostly we need in TCA 1. Get the contact information for a party or account in Oracle Fusion applications. SELECT PartyPEO.PARTY_NAME, PartyPEO.EMAIL_ADDRESS, OrganizationContactPEO.JOB_TITLE, OrganizationContactPEO.DEPARTMENT, PartyPEO.STATUS AS STATUS1, CustomerAccountContactPEO.CUST_ACCOUNT_ROLE_ID, CustomerAccountContactPEO.CUST_ACCOUNT_ID, CustomerAccountContactPEO.CONTACT_PERSON_ID, CustomerAccountContactPEO.STATUS, CustomerAccountContactRolePE1.CUST_ACCOUNT_ROLE_ID AS CUST_ACCOUNT_ROLE_ID1, CustomerAccountContactRolePE1.RESPONSIBILITY_ID, CustomerAccountContactRolePE1.RESPONSIBILITY_TYPE, CustomerAccountContactPEO.ROLE_TYPE, PartyPEO.PARTY_ID, RelationshipPEO.OBJECT_ID, RelationshipPEO.RELATIONSHIP_REC_ID, RelationshipPEO.OBJECT_TYPE, RelationshipPEO.RELATIONSHIP_CODE, RelationshipPEO.RELATIONSHIP_ID, OrganizationContactPEO.ORG_CONTACT_ID, OrganizationContactPEO.PARTY_RELATIONSHIP_ID FROM HZ_CUST_ACCO