View: IGI_EXP_DUS_NOT_IN_TUS_V

Product:	IGI - Public Sector Financials International
Description:	Displays Dialog Units which are not included in Transmission Units. primarily used by form 'Define Transmission Units'
Implementation/DBA Data:	APPS.IGI_EXP_DUS_NOT_IN_TUS_V

View Text

SELECT IED.ROWID ROW_ID
, FAL.APPLICATION_NAME
, IEDTH.APPLICATION_ID
, IED.DU_ID
, IED.DU_TYPE_HEADER_ID
, IEDTH.DU_TYPE_NAME
, IED.DU_ORDER_NUMBER
, IED.DU_LEGAL_NUMBER
, IED.DU_DESCRIPTION
, FC.DESCRIPTION DU_CURRENCY
, IED.DU_CURRENCY_CODE
, IL.MEANING STATUS_DESC
, IED.DU_STATUS
, IED.DU_AMOUNT
, IED.DU_STP_ID
, IED.DU_STP_SITE_ID
, IED.DU_PREPAY_AMOUNT
, IED.TU_ID
, IED.PRINT_DATE
, IED.DU_DATE
, IED.DU_BY_USER_ID
, FU.USER_NAME DU_BY_USER_NAME
, IED.DU_FISCAL_YEAR
, IED.CREATION_DATE
, IED.CREATED_BY
, IED.LAST_UPDATE_LOGIN
, IED.LAST_UPDATE_DATE
, IED.LAST_UPDATED_BY
, IED.ATTRIBUTE_CATEGORY
, IED.ATTRIBUTE1
, IED.ATTRIBUTE2
, IED.ATTRIBUTE3
, IED.ATTRIBUTE4
, IED.ATTRIBUTE5
, IED.ATTRIBUTE6
, IED.ATTRIBUTE7
, IED.ATTRIBUTE8
, IED.ATTRIBUTE9
, IED.ATTRIBUTE10
, IED.ATTRIBUTE11
, IED.ATTRIBUTE12
, IED.ATTRIBUTE13
, IED.ATTRIBUTE14
, IED.ATTRIBUTE15
FROM IGI_EXP_DUS IED
, FND_APPLICATION_VL FAL
, IGI_EXP_DU_TYPE_HEADERS IEDTH
, FND_CURRENCIES FC
, FND_USER FU
, IGI_LOOKUPS IL
WHERE IED.TU_ID IS NULL
AND IED.DU_TYPE_HEADER_ID = IEDTH.DU_TYPE_HEADER_ID
AND FC.CURRENCY_CODE = IED.DU_CURRENCY_CODE
AND IEDTH.APPLICATION_ID = FAL.APPLICATION_ID
AND IL.LOOKUP_CODE = IED.DU_STATUS
AND IL.LOOKUP_TYPE = 'IGI_EXP_DU_STATUS'
AND FU.USER_ID = IED.DU_BY_USER_ID

Columns