View: IGI_EXP_DUS_V

Product:	IGI - Public Sector Financials International
Description:	Returns details of all dialog units. Primarily used in 'define Dialog Units' form.
Implementation/DBA Data:	APPS.IGI_EXP_DUS_V

View Text

SELECT DU.ROWID ROW_ID
, DU.DU_ORDER_NUMBER DU_ORDER_NUMBER
, DU.DU_LEGAL_NUMBER DU_LEGAL_NUMBER
, LOOK.MEANING DU_STATUS_DESC
, FU1.USER_NAME NEXT_APPROVER
, DU.DU_AMOUNT DU_AMOUNT
, DU.DU_PREPAY_AMOUNT DU_PREPAY_AMOUNT
, TU.TU_ORDER_NUMBER TU_ORDER_NUMBER
, TU.TU_LEGAL_NUMBER TU_LEGAL_NUMBER
, DU_TYPE.DU_TYPE_NAME DU_TYPE
, DU.DU_CURRENCY_CODE DU_CURRENCY_CODE
, CUSTOMER.CUSTOMER_NAME DU_THIRD_PARTY
, SITE_USES.LOCATION DU_THIRD_PARTY_SITE
, DU.DU_DATE DU_DATE
, DU.DU_FISCAL_YEAR DU_FISCAL_YEAR
, DU.DU_DESCRIPTION DU_DESCRIPTION
, DU.DU_ID DU_ID
, DU.DU_STATUS DU_STATUS
, TU.NEXT_APPROVER_USER_ID NEXT_APPROVER_USER_ID
, DU.TU_ID TU_ID
, DU.DU_TYPE_HEADER_ID DU_TYPE_HEADER_ID
, DU_TYPE.APPLICATION_ID APPLICATION_ID
, DU.DU_STP_ID DU_STP_ID
, DU.DU_STP_SITE_ID DU_STP_SITE_ID
, DU.PRINT_DATE PRINT_DATE
, DU.DU_BY_USER_ID DU_BY_USER_ID
, DU.ORG_ID ORG_ID
, DU.CREATION_DATE CREATION_DATE
, DU.CREATED_BY CREATED_BY
, DU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DU.LAST_UPDATED_BY LAST_UPDATED_BY
, DU.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DU.ATTRIBUTE1 ATTRIBUTE1
, DU.ATTRIBUTE2 ATTRIBUTE2
, DU.ATTRIBUTE3 ATTRIBUTE3
, DU.ATTRIBUTE4 ATTRIBUTE4
, DU.ATTRIBUTE5 ATTRIBUTE5
, DU.ATTRIBUTE6 ATTRIBUTE6
, DU.ATTRIBUTE7 ATTRIBUTE7
, DU.ATTRIBUTE8 ATTRIBUTE8
, DU.ATTRIBUTE9 ATTRIBUTE9
, DU.ATTRIBUTE10 ATTRIBUTE10
, DU.ATTRIBUTE11 ATTRIBUTE11
, DU.ATTRIBUTE12 ATTRIBUTE12
, DU.ATTRIBUTE13 ATTRIBUTE13
, DU.ATTRIBUTE14 ATTRIBUTE14
, DU.ATTRIBUTE15 ATTRIBUTE15
FROM IGI_EXP_DUS DU
, IGI_EXP_TUS TU
, IGI_LOOKUPS LOOK
, FND_USER FU1
, FND_USER FU2
, IGI_EXP_DU_TYPE_HEADERS DU_TYPE
, AR_CUSTOMERS_V CUSTOMER
, HZ_CUST_SITE_USES SITE_USES
, FND_APPLICATION_VL FAL
, FND_CURRENCIES FC
WHERE DU.TU_ID = TU.TU_ID(+)
AND TU.NEXT_APPROVER_USER_ID = FU1.USER_ID(+)
AND LOOK.LOOKUP_TYPE = 'IGI_EXP_DU_STATUS'
AND LOOK.LOOKUP_CODE = DU.DU_STATUS
AND DU.DU_TYPE_HEADER_ID = DU_TYPE.DU_TYPE_HEADER_ID
AND DU.DU_STP_ID = CUSTOMER.CUSTOMER_ID(+)
AND DU.DU_STP_SITE_ID = SITE_USES.SITE_USE_ID(+)
AND DU.DU_CURRENCY_CODE = FC.CURRENCY_CODE
AND DU_TYPE.APPLICATION_ID = FAL.APPLICATION_ID
AND DU.DU_BY_USER_ID = FU2.USER_ID
AND DU_TYPE.APPLICATION_ID = 222 UNION SELECT DU.ROWID ROW_ID
, DU.DU_ORDER_NUMBER DU_ORDER_NUMBER
, DU.DU_LEGAL_NUMBER DU_LEGAL_NUMBER
, LOOK.MEANING DU_STATUS_DESC
, FU1.USER_NAME NEXT_APPROVER
, DU.DU_AMOUNT DU_AMOUNT
, DU.DU_PREPAY_AMOUNT DU_PREPAY_AMOUNT
, TU.TU_ORDER_NUMBER TU_ORDER_NUMBER
, TU.TU_LEGAL_NUMBER TU_LEGAL_NUMBER
, DU_TYPE.DU_TYPE_NAME DU_TYPE
, DU.DU_CURRENCY_CODE DU_CURRENCY_CODE
, VENDOR.VENDOR_NAME DU_THIRD_PARTY
, VENDOR_SITE.VENDOR_SITE_CODE DU_THIRD_PARTY_SITE
, DU.DU_DATE DU_DATE
, DU.DU_FISCAL_YEAR DU_FISCAL_YEAR
, DU.DU_DESCRIPTION DU_DESCRIPTION
, DU.DU_ID DU_ID
, DU.DU_STATUS DU_STATUS
, TU.NEXT_APPROVER_USER_ID NEXT_APPROVER_USER_ID
, DU.TU_ID TU_ID
, DU.DU_TYPE_HEADER_ID DU_TYPE_HEADER_ID
, DU_TYPE.APPLICATION_ID APPLICATION_ID
, DU.DU_STP_ID DU_STP_ID
, DU.DU_STP_SITE_ID DU_STP_SITE_ID
, DU.PRINT_DATE PRINT_DATE
, DU.DU_BY_USER_ID DU_BY_USER_ID
, DU.ORG_ID ORG_ID
, DU.CREATION_DATE CREATION_DATE
, DU.CREATED_BY CREATED_BY
, DU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DU.LAST_UPDATED_BY LAST_UPDATED_BY
, DU.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, DU.ATTRIBUTE1 ATTRIBUTE1
, DU.ATTRIBUTE2 ATTRIBUTE2
, DU.ATTRIBUTE3 ATTRIBUTE3
, DU.ATTRIBUTE4 ATTRIBUTE4
, DU.ATTRIBUTE5 ATTRIBUTE5
, DU.ATTRIBUTE6 ATTRIBUTE6
, DU.ATTRIBUTE7 ATTRIBUTE7
, DU.ATTRIBUTE8 ATTRIBUTE8
, DU.ATTRIBUTE9 ATTRIBUTE9
, DU.ATTRIBUTE10 ATTRIBUTE10
, DU.ATTRIBUTE11 ATTRIBUTE11
, DU.ATTRIBUTE12 ATTRIBUTE12
, DU.ATTRIBUTE13 ATTRIBUTE13
, DU.ATTRIBUTE14 ATTRIBUTE14
, DU.ATTRIBUTE15 ATTRIBUTE15
FROM IGI_EXP_DUS DU
, IGI_EXP_TUS TU
, IGI_LOOKUPS LOOK
, FND_USER FU1
, FND_USER FU2
, IGI_EXP_DU_TYPE_HEADERS DU_TYPE
, PO_VENDORS VENDOR
, PO_VENDOR_SITES VENDOR_SITE
, FND_APPLICATION_VL FAL
, FND_CURRENCIES FC
WHERE DU.TU_ID = TU.TU_ID(+)
AND TU.NEXT_APPROVER_USER_ID = FU1.USER_ID(+)
AND LOOK.LOOKUP_TYPE = 'IGI_EXP_DU_STATUS'
AND LOOK.LOOKUP_CODE = DU.DU_STATUS
AND DU.DU_TYPE_HEADER_ID = DU_TYPE.DU_TYPE_HEADER_ID
AND DU.DU_STP_ID = VENDOR.VENDOR_ID(+)
AND DU.DU_STP_SITE_ID = VENDOR_SITE.VENDOR_SITE_ID(+)
AND DU.DU_STP_ID = VENDOR_SITE.VENDOR_ID(+)
AND DU.DU_CURRENCY_CODE = FC.CURRENCY_CODE
AND DU_TYPE.APPLICATION_ID = FAL.APPLICATION_ID
AND DU.DU_BY_USER_ID = FU2.USER_ID
AND DU_TYPE.APPLICATION_ID = 200

Columns