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