View: IGI_EXP_TRAN_UNIT_DEF

Product:	IGI - Public Sector Financials International
Description:	Displays information about Echange Protocol transmission units.
Implementation/DBA Data:	APPS.IGI_EXP_TRAN_UNIT_DEF

View Text

SELECT "TRANS_UNIT_ID"
, "TRANS_UNIT_NUM"
, "DOC_TYPE_ID"
, "ACT_NUMBER"
, "TRANS_UNIT_STATUS"
, "TRANS_UNIT_NUM_TYPE"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_LOGIN"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "ORG_ID"
, "LEGAL_NUMBER"
, "MRC_EXCHANGE_RATE_TYPE"
, "THIRD_PARTY_ID"
, "TRAN_UNIT_CALL_NUM"
, "AMOUNT"
, "MRC_AMOUNT"
, "MRC_EXCHANGE_RATE"
, "MRC_EXCHANGE_DATE"
, "MRC_AMOUNT_EXCHANGE_RATE_TYPE"
, "PRINT_DATE"
, "UPGRADE_STATUS"
FROM IGI_EXP_TRAN_UNIT_DEF_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns