JA Natural Account Export Exception

Description

Categories
BI Publisher
Application
Asia/Pacific Localizations
Source
Natural Account Export Exception Report
Short Name
JACNNAER
DB package:

SQL 8 lines

SELECT ACCOUNT_SEGMENT
                   ,ACCOUNT_LEVEL
                   ,VALUE_LENGTH
                   ,DECODE(EXPECTED_LENGTH, -1, '-', EXPECTED_LENGTH) EXP_LENGTH
               FROM JA_CN_COA_NA_EXCEPTIONS
              WHERE NA_REQUEST_ID=:request_id
              ORDER BY ACCOUNT_LEVEL, ACCOUNT_SEGMENT

Parameters 1

ParameterTypeList of values SQL
Concurrent Request IdNumber