/* CHART OF ACCOUNTS STRUCTURE Gives an overview of the chart of accounts definitions and also status. This is used when implementing multiple charts of accounts to ensure consistent setup across countries and between environments. Where clause can be added or commented out to just look at specific countries. */ SELECT FST.ID_FLEX_STRUCTURE_NAME --, FST.DESCRIPTION --, FST.ID_FLEX_NUM --, FST.ID_FLEX_STRUCTURE_CODE , FST.CROSS_SEGMENT_VALIDATION_FLAG"X-VAL" , FST.FREEZE_STRUCTURED_HIER_FLAG"FZ-HIER" , FST.FREEZE_FLEX_DEFINITION_FLAG"FZ-DEFN" , FSEG.SEGMENT_NUM "SEG#" , FSEG.SEGMENT_NAME "SEG NAME" , VS.FLEX_VALUE_SET_NAME "VALUE SET" , FSEG.FLEX_VALUE_SET_ID"VAL_SET_ID" , FSEG.DEFAULT_TYPE"DEF TYPE" , FSEG.DEFAULT_VALUE"DEF. VALUE" , FSEG.ENABLED_FLAG"ENBLD" , FSEG.REQUIRED_FLAG"REQD" FROM FND_ID_FLEX_STRUCTURES_VL FST, FND_ID_FLEX_SEGMENTS FSEG, FND_FLEX_VALUE_SETS VS WHERE FST.ID_FLEX_NUM = FSEG.ID_FLEX_NUM AND FSEG.FLEX_VALUE_SET_ID = VS.FLEX_VALUE_SET_ID --AND SUBSTR(FST.ID_FLEX_STRUCTURE_CODE,1,2) IN ('BE','LU','ES','IT','HU','CZ','PL','RU') AND FST.APPLICATION_ID = 101 AND FST.ID_FLEX_CODE = 'GL#' ORDER BY 1, FSEG.SEGMENT_NUM
Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Thursday, November 17, 2011
CHART OF ACCOUNTS STRUCTURE
Subscribe to:
Post Comments (Atom)
If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
No comments:
Post a Comment