Forum Stats

  • 3,872,692 Users
  • 2,266,458 Discussions
  • 7,911,285 Comments

Discussions

Oracle ebs Access hours (table) to APEX

Elco
Elco Member Posts: 91
edited Mar 5, 2014 9:10AM in APEX Discussions

Hello,

I want to make the current Access Hours table in APEX with some extra attributes. The problem is now I don't know how to find it in Toad. I can't find the name. The option that I want to make additional is that people can search with the instance number.

I hope somebody knows how I can find the Aceess hours table in Toad (Oracle ebs > field dispatch center > cntr L > aceess hours

Thanks in advanged

Regards
Elco

Answers

  • Elco
    Elco Member Posts: 91

    It are not the tables :

    CSF_ACCESS_HOURS_B

    CSF_ACCESS_HOURS_TL

  • Elco
    Elco Member Posts: 91

    I don't know how I can do the relation with party_id and customer_name

    I have now this SQL code:

    SELECT

           hp.party_name

         , hca.account_number

         , hca.cust_account_id

         , hp.party_id

         , hl.address1

         , hl.address2

         , hl.address3

         , hl.city

         , hl.state

         , hl.country

         , hl.postal_code

             

    FROM   hz_parties hp

         , hz_party_sites hps

         , hz_locations hl

         , hz_cust_accounts_all hca

         , hz_cust_acct_sites_all hcsa

         , hz_cust_site_uses_all hcsu

    WHERE  hp.party_id = hps.party_id

    AND    hp.party_id = hca.party_id

    AND    hcsu.cust_acct_site_id = hcsa.cust_acct_site_id

    AND    hca.cust_account_id = hcsa.cust_account_id

  • Elco
    Elco Member Posts: 91

    Does anybody has an idea?

    Thanks in advange

    Regards

    Elco

This discussion has been closed.