[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 |