Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle ebs Access hours (table) to APEX

ElcoFeb 10 2014 — edited Mar 5 2014

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

Comments

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

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 2 2014
Added on Feb 10 2014
#access, #apex, #apex-discussions, #oracle, #table
3 comments
1,685 views