[Home] [Help]
View: IGI_STP_BATCHES_V
Product: | IGI - Public Sector Financials International |
Description: | Displays netting batch information. |
Implementation/DBA Data: |
APPS.IGI_STP_BATCHES_V
|
View Text
SELECT STPB.ROWID ROW_ID
, STPB.BATCH_ID
, STPB.BATCH_STATUS
, NTYPE.MEANING NETTING_TRX_TYPE
, BTYPE.MEANING BATCH_MEANING
FROM IGI_LOOKUPS NTYPE
, IGI_STP_BATCHES STPB
, IGI_LOOKUPS BTYPE
WHERE NTYPE.LOOKUP_CODE = NETTING_TRX_TYPE_ID
AND NTYPE.LOOKUP_TYPE = 'STP_NETTING_TYPE'
AND BTYPE.LOOKUP_CODE = STPB.BATCH_STATUS
AND BTYPE.LOOKUP_TYPE = 'STP BATCH STATUS'
Columns
Name |
ROW_ID |
BATCH_ID |
BATCH_STATUS |
NETTING_TRX_TYPE |
BATCH_MEANING |