Product: | IGI - Public Sector Financials International |
---|---|
Description: | Displays details of Transmission Units and is primarily used by the 'Define Transmission Units' screen |
Implementation/DBA Data: | APPS.IGI_EXP_TUS_V |
SELECT IET.ROWID ROW_ID
, IET.TU_ID
, IET.TU_TYPE_HEADER_ID
, IETTH.TU_TYPE_NAME
, IET.TU_ORDER_NUMBER
, IET.TU_LEGAL_NUMBER
, IET.TU_DESCRIPTION
, IET.TU_STATUS
, IL.MEANING TU_STATUS_DESC
, IET.TU_AMOUNT
, IET.APPRV_PROFILE_ID
, IEAP.APPRV_PROFILE_NAME
, IET.NEXT_APPROVER_USER_ID
, FU.USER_NAME NEXT_APPROVER_USER_NAME
, IET.TU_FISCAL_YEAR
, IET.TU_DATE
, IET.TU_BY_USER_ID
, FU1.USER_NAME TU_BY_USER_NAME
, IET.ORG_ID
, IET.CREATION_DATE
, IET.CREATED_BY
, IET.LAST_UPDATE_LOGIN
, IET.LAST_UPDATED_BY
, IET.LAST_UPDATE_DATE
, IET.ATTRIBUTE_CATEGORY
, IET.ATTRIBUTE1
, IET.ATTRIBUTE2
, IET.ATTRIBUTE3
, IET.ATTRIBUTE4
, IET.ATTRIBUTE5
, IET.ATTRIBUTE6
, IET.ATTRIBUTE7
, IET.ATTRIBUTE8
, IET.ATTRIBUTE9
, IET.ATTRIBUTE10
, IET.ATTRIBUTE11
, IET.ATTRIBUTE12
, IET.ATTRIBUTE13
, IET.ATTRIBUTE14
, IET.ATTRIBUTE15
, IET.TU_CURRENCY_CODE
FROM IGI_EXP_TUS IET
, IGI_EXP_TU_TYPE_HEADERS IETTH
, IGI_EXP_APPRV_PROFILES IEAP
, FND_USER FU
, FND_USER FU1
, IGI_LOOKUPS IL
WHERE IET.TU_TYPE_HEADER_ID = IETTH.TU_TYPE_HEADER_ID
AND IET.APPRV_PROFILE_ID = IEAP.APPRV_PROFILE_ID
AND IL.LOOKUP_CODE = IET.TU_STATUS
AND IL.LOOKUP_TYPE = 'IGI_EXP_TU_STATUS'
AND IET.TU_BY_USER_ID = FU1.USER_ID
AND IET.NEXT_APPROVER_USER_ID = FU.USER_ID(+)