1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| SELECT REGEXP_INSTR(FORMULE, LC_PATTERN_SPEC, 1, LN_I, 0) SPEC_DEBUT,
REGEXP_REPLACE(
REGEXP_SUBSTR(FORMULE, LC_PATTERN_SPEC, 1, LN_I),
LC_PATTERN_SPEC,
'SELECT SPEC_\1 ' || CHR(10) ||
'FROM B2820 R,' || CHR(10) ||
' B2821 S' || CHR(10) ||
'WHERE R.SPEC_CODE = S.SPEC_CODE ' || CHR(10) ||
'AND R.ST_CODE = ''' || LC_ST_CODE || ''' ' || CHR(10) ||
'AND NVL(R.CL_CODE, ''@~@##@]@'') = NVL(' || DECODE(LC_CL_CODE, NULL, 'NULL', LC_CL_CODE) || ', ''@~@##@]@'') ' || CHR(10) ||
'AND S.T37_CODE = ''\2'' '
) SPEC_STR
INTO LN_DEBUT,
LC_FORMULE
FROM B03FS
WHERE T81_FAM = 'Q'
AND MS_CODE = 'X00002'; |
Partager