Search from 700 + Posts

Jan 24, 2011

Queries to Get Customer Relationship and Contact in Oracle TCA(Part-2)

Some More Interesting TCA Queries .

Query #1
      SELECT cust_account_role_id, status
      FROM hz_cust_account_roles
      WHERE party_id = p_party_id
      AND cust_account_id = p_cust_account_id
      AND role_type ='CONTACT'
      AND cust_acct_site_id is null
     and status = 'A';

Query #2



 SELECT par.party_id
      FROM hz_relationships par,
           hz_org_contacts     org ,
           hz_cust_accounts acc
      WHERE org.party_relationship_id = par.relationship_id
      AND org.org_contact_id  = p_org_contact_id
      and par.status = 'A'
      and (sysdate between nvl(par.start_date, sysdate) and nvl(par.end_date, sysdate))
      AND acc.cust_account_id = p_cust_account_id
      AND par.object_id = acc.party_id
      AND acc.status = 'A'
      AND (sysdate BETWEEN NVL(acc.account_activation_date, sysdate) AND
                           NVL(acc.account_termination_date, sysdate));

8 comments:

  1. Well as usual , these helps to save lot of time...and i am able to focus more on my Mobile stuff

    ReplyDelete
  2. The client experience is an intricate procedure that can comprise of different touch focuses; a procedure that can be wide, long-running, traverse various channels, and can be impacted by any mix of interior and outer elements. Viably measuring the aggregate client encounter requires a more intense comprehension of its individual parts. http://www.lifehack.org/493121/6-tips-to-build-relationship-with-customers

    ReplyDelete
  3. odern techniques have gotten the accuracy rate well above the 90% range. That is, if the test is done correctly lie detector test

    ReplyDelete
  4. We primarily attract situations to ourselves that create interactions, allowing us to continue to accelerate, serve, and learn who we are. We can do this with ease, grace, love, and joy, or through the school of hard knocks. The choice is always ours.Denver escorts

    ReplyDelete
  5. You delivered such an impressive piece to read, giving every subject enlightenment for us to gain information. Thanks for sharing such information with us due to which my several concepts have been cleared. Name ideas for whatsapp group

    ReplyDelete
  6. Customer Relation is the key-point of any business. Kanhasoft is crm software development company providing solutions to offshore clients. Our CRM developers build CRM system from the scratch to meet your business needs.

    ReplyDelete
  7. There is an adage that says a revealed war does not gobble up the debilitated individual. Esteeming the peculiarity and the qualifications of each person in a relationship would go far in ensuring that these refinements don't surrender the relationship. http://www.fidelitydating.com/his-secret-obsession-hero-instinct-review

    ReplyDelete
  8. Whether one agrees, and supports, or disagrees, and strongly opposes, the administration of President Donald Trump, and the apparent direction, he is guiding our nation towards, all should recognize and admit, we are experiencing a period of time, which is the most polarizing, in recent memory!

    Sharon White

    ReplyDelete