Search 800 + 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));


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

    1. IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation. For experts, it's an alternate ball game through and through. Smaller than expected IEEE Final Year project centers ground for all fragments of CSE & IT engineers hoping to assemble. IEEE Project Domains It gives you tips and rules that is progressively critical to consider while choosing any final year project point.

      JavaScript Online Training in India

      JavaScript Training in India

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

  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.

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

  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

  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

  6. 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.

  7. 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

  8. Thank you so much for sharing this worth able content with us. The concept taken here will be useful for my future programs and i will surely implement them in my study. Keep blogging article like this.
    CRM Software