FND Design Data [Home] [Help]

View: JAI_AR_TRX_TMP_E_LINE_V

Product: JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data: ViewAPPS.JAI_AR_TRX_TMP_E_LINE_V
View Text

SELECT CUSTOMER_TRX_ID
, COUNT(1) NUM_LINES
, MAX(LAST_UPDATE_DATE) WHEN_LAST_UPDATED
FROM JAI_AR_TRX_INS_LINES_T
WHERE ERROR_FLAG ='R'
AND SOURCE = 'RAXTRX' GROUP BY CUSTOMER_TRX_ID

Columns

Name
CUSTOMER_TRX_ID
NUM_LINES
WHEN_LAST_UPDATED