FND Design Data [Home] [Help]

View: IGI_STP_AR_BAL

Product: IGI - Public Sector Financials International
Description: Displays all Receivables transactions available for Single Third Party netting.
Implementation/DBA Data: ViewAPPS.IGI_STP_AR_BAL
View Text

SELECT NET.USER_ID
, NET.STP_ID
, NET.TRX_ID
, NET.TRX_NUMBER
, NET.AMOUNT
, NET.NETTING_AMOUNT
, NET.PROCESS_FLAG
, NET.CURRENCY_CODE
FROM IGI_STP_CANDIDATES NET
WHERE NET.APPLICATION = 'AR'
AND NET.PROCESS_FLAG != 'S'

Columns

Name
USER_ID
STP_ID
TRX_ID
TRX_NUMBER
AMOUNT
NETTING_AMOUNT
PROCESS_FLAG
CURRENCY_CODE