This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,987 Users
  • 2,269,775 Discussions
  • 7,916,823 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.