Discussion in 'Oracle Financials' started by haca1816, Oct 12, 2012.
I need help to build the query cost center organization in Oracle EBS.
thank you very much
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
Please refer to the following query for your requirement.
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
-- 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.