VIEW: APPS.IGI_STP_AP_BAL

Source

View Text - Preformatted

SELECT NET.ORG_ID,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_ALL NET WHERE NET.APPLICATION = 'AP' AND NET.PROCESS_FLAG != 'S'

View Text - HTML Formatted

SELECT NET.ORG_ID
, 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_ALL NET
WHERE NET.APPLICATION = 'AP'
AND NET.PROCESS_FLAG != 'S'