eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGI_STP_BATCHES_V

Source

View Text - Preformatted


SELECT STPB.ORG_ID ORG_ID , 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_ALL 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'

View Text - HTML Formatted

SELECT STPB.ORG_ID ORG_ID
, 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_ALL 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'