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 |
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