1、在为1069公司添加平衡段值时,值集列表中无法选到需要的平衡段值,进一步对其后台取值逻辑进行分析
SELECT *
FROM (SELECT FLEXVALUES.FLEX_VALUE, FLEXVALUES.DESCRIPTION
FROM FND_FLEX_VALUES_VL FLEXVALUES
WHERE FLEXVALUES.FLEX_VALUE_SET_ID = :1
AND FLEXVALUES.SUMMARY_FLAG = 'N'
AND NOT EXISTS
(SELECT 'X'
FROM GL_LEGAL_ENTITIES_BSVS LEB
WHERE LEB.FLEX_VALUE_SET_ID = FLEXVALUES.FLEX_VALUE_SET_ID
AND LEB.FLEX_SEGMENT_VALUE = FLEXVALUES.FLEX_VALUE
AND LEB.LEGAL_ENTITY_ID IN
(SELECT LCD.OBJECT_ID
FROM GL_LEDGER_CONFIG_DETAILS LCD,
GL_LEDGER_CONFIG_DETAILS LCD2
WHERE LCD2.OBJECT_ID = :2
AND LCD2.OBJECT_TYPE_CODE = 'LEGAL_ENTITY'
AND LCD.CONFIGURATION_ID = LCD