Oracle ebs Access hours (table) to APEX

Elco

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

Elco

It are not the tables :

CSF_ACCESS_HOURS_B

CSF_ACCESS_HOURS_TL

Elco

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

Does anybody has an idea?

Thanks in advange

Regards

Elco