[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: |
APPS.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 |