View: IGI_EXP_TRAN_UNIT_V

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

View Text

SELECT DISTINCT T.ROWID ROW_ID
, T.TRANS_UNIT_ID
, T.TRANS_UNIT_NUM
, T.CREATION_DATE
, T.AMOUNT
, T.CREATED_BY
, F.USER_NAME
, X.APPLICATION
, T.DOC_TYPE_ID
, L.MEANING STATUS
FROM FND_USER F
, IGI_EXP_TRAN_UNIT_DEF T
, IGI_EXP_TRX_TYPE X
, IGI_LOOKUPS L
, PO_VENDORS P
WHERE T.CREATED_BY = F.USER_ID
AND T.DOC_TYPE_ID = X.DOC_TYPE_ID
AND T.TRANS_UNIT_STATUS = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'IGI_EXP_TRANS_UNIT_STATUS'

Columns