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!

query cost center organization

Discussion in 'Oracle Financials' started by haca1816, Oct 12, 2012.

  1. haca1816

    haca1816 Guest

    hi
    I need help to build the query cost center organization in Oracle EBS.
    thank you very much
     

    Attached Files:

  2. velidhu

    velidhu Active Member

    Messages:
    5
    Likes Received:
    2
    Trophy Points:
    110
    Hi haca1816, if you want to have the query to obtain all the cost centers is easy. You need to go to diagnostic-examine and then inform system-last query.
    Copy the result and paste it in your Sql program.
    If you don't have the password for diagnostic-examine, let me know and I'll inform you how to create the query
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi ,

    Please refer to the following query for your requirement.

    Code (Text):

    SQL>    SELECT
           DISTINCT FIF.ID_FLEX_CODE "Id Flex Code"
         , FIF.ID_FLEX_NAME "Title"
         , FIFST.ID_FLEX_STRUCTURE_NAME "Structure"
         , FIF.DESCRIPTION "Description"
         , FIFS.APPLICATION_COLUMN_NAME "Table Column"
         , FIFS.SEGMENT_NAME "Segment Independent"
         , FFV.FLEX_VALUE "Value"
         , FFVT.DESCRIPTION "Description"
         , FL.MEANING "Enabled"
         , FL_PARENT.MEANING "Parent"

    FROM FND_ID_FLEXS FIF
        ,FND_ID_FLEX_STRUCTURES_TL FIFST
        ,FND_ID_FLEX_SEGMENTS FIFS
        ,FND_FLEX_VALUES FFV
        ,FND_FLEX_VALUES_TL FFVT
        ,FND_LOOKUPS FL
        ,FND_LOOKUPS FL_PARENT

    WHERE
     -- RESTRICTIONS TO GET TITLE FIRST
          FIF.ID_FLEX_NAME LIKE 'Accounting Flexfield'
    -- RESTRICTIONS TO GET STRUCTURE
      AND FIFST.ID_FLEX_CODE = FIF.ID_FLEX_CODE
      AND FIFST.LANGUAGE = 'US'
    --RESTRICTIONS TO GET SEGMENT INDEPENDENT
      AND FIFS.ID_FLEX_CODE = FIF.ID_FLEX_CODE
      AND FIFS.SEGMENT_NAME = '&SEGMENT_INDEPENDENT'
    -- RESTRICTIONS TO GET VALUES (NOTHING BUT ACCOUNT NUMBERS BASED ON SEGMENT EX. DEPARTMENT, ACCOUNT, COMPANY, PRODUCT SOON.)
      AND FFV.FLEX_VALUE_SET_ID = FIFS.FLEX_VALUE_SET_ID
      AND FFVT.FLEX_VALUE_ID = FFV.FLEX_VALUE_ID
      AND FFVT.LANGUAGE = 'US'
      AND FL.LOOKUP_TYPE (+) = 'YES_NO'
      AND FL.LOOKUP_CODE (+) = FFV.ENABLED_FLAG
      AND FL_PARENT.LOOKUP_TYPE (+) = 'YES_NO'
      AND FL_PARENT.LOOKUP_CODE (+) = FFV.SUMMARY_FLAG
     
    Pass segment_independent parameter as Centro de Costos as of your screenshot.