3 Replies Latest reply: Mar 5, 2014 8:10 AM by Elco RSS

    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

        • 1. Re: Oracle ebs Access hours (table) to APEX
          Elco

          It are not the tables :

          CSF_ACCESS_HOURS_B

           

           

          CSF_ACCESS_HOURS_TL

          • 2. Re: Oracle ebs Access hours (table) to APEX
            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

            • 3. Re: Oracle ebs Access hours (table) to APEX
              Elco

              Does anybody has an idea?

               

              Thanks in advange

               

              Regards

              Elco