1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Count the custom OAF Page

Discussion in 'Oracle Apps Technical' started by mr.ashutosh.kr, Feb 11, 2014.

  1. mr.ashutosh.kr

    mr.ashutosh.kr Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Query to count the Customized OAF page ?
    Help !
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
  3. mr.ashutosh.kr

    mr.ashutosh.kr Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Thanks for the link.

    But it's not helpful for the problem I quoted.
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi what exactly you want?

    Do you want count of oaf pages that you customized?
     
  5. mr.ashutosh.kr

    mr.ashutosh.kr Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Yes.

    Count the customized oaf page.
     
  6. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Check the below quey..

    Code (SQL):
       

    SELECT  jdr_mds_internal.getDocumentName(path_docid)
          FROM   jdr_paths, jdr_attributes
          WHERE  path_docid   = att_comp_docid
           AND   att_comp_seq = 0              
           AND   att_name     = 'customizes'

     
     
  7. mr.ashutosh.kr

    mr.ashutosh.kr Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Does this include personalization as well ?

    I am very much new to OAF. What I used is attached. Please guide me.
     

    Attached Files:

    • 1.JPG
      1.JPG
      File size:
      96.9 KB
      Views:
      17