Product: | IGI - Public Sector Financials International |
---|---|
Description: | Displays all information about Exchange Protocol transmission units |
Implementation/DBA Data: | APPS.IGI_EXP_EPTU_TRANS_V |
SELECT ETUD.ROWID ROW_ID
, ETUD.TRANS_UNIT_ID
, ETUD.TRANS_UNIT_STATUS
, ILU.MEANING
, ETUD.TRANS_UNIT_NUM
, ETUD.TRANS_UNIT_NUM_TYPE
, ETUD.DOC_TYPE_ID
, DOC.DESCRIPTION
, ETUD.AMOUNT
, ETUD.CREATION_DATE
, ETUD.CREATED_BY
, ETUD.LAST_UPDATE_DATE
, ETUD.LAST_UPDATED_BY
, ETUD.LAST_UPDATE_LOGIN
, ETUD.TRAN_UNIT_CALL_NUM
FROM IGI_EXP_DOC_TYPE DOC
, IGI_EXP_TRAN_UNIT_DEF ETUD
, IGI_LOOKUPS ILU
WHERE ETUD.DOC_TYPE_ID = DOC.DOC_TYPE_ID AND ETUD.TRANS_UNIT_STATUS = ILU.LOOKUP_CODE AND ILU.LOOKUP_TYPE = 'IGI_EXP_TRANS_UNIT_STATUS'