VIEW: APPS.IGI_EXP_DUS_V

Source

View Text - Preformatted

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 , SUBSTRB(PARTY.PARTY_NAME, 1, 50) 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_ALL TU , IGI_LOOKUPS LOOK , FND_USER FU1 , FND_USER FU2 , IGI_EXP_DU_TYPE_HEADERS_ALL DU_TYPE , HZ_CUST_ACCOUNTS CUST , HZ_PARTIES PARTY , HZ_CUST_SITE_USES_ALL 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 = CUST.CUST_ACCOUNT_ID(+) AND CUST.PARTY_ID = PARTY.PARTY_ID(+) AND DU.DU_STP_SITE_ID = SITE_USES.SITE_USE_ID(+) AND DU.ORG_ID = SITE_USES.ORG_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_ALL TU , IGI_LOOKUPS LOOK , FND_USER FU1 , FND_USER FU2 , IGI_EXP_DU_TYPE_HEADERS_ALL DU_TYPE , PO_VENDORS VENDOR , AP_SUPPLIER_SITES_ALL 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.ORG_ID = VENDOR_SITE.ORG_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

View Text - HTML Formatted

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
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) 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_ALL TU
, IGI_LOOKUPS LOOK
, FND_USER FU1
, FND_USER FU2
, IGI_EXP_DU_TYPE_HEADERS_ALL DU_TYPE
, HZ_CUST_ACCOUNTS CUST
, HZ_PARTIES PARTY
, HZ_CUST_SITE_USES_ALL 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 = CUST.CUST_ACCOUNT_ID(+)
AND CUST.PARTY_ID = PARTY.PARTY_ID(+)
AND DU.DU_STP_SITE_ID = SITE_USES.SITE_USE_ID(+)
AND DU.ORG_ID = SITE_USES.ORG_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_ALL TU
, IGI_LOOKUPS LOOK
, FND_USER FU1
, FND_USER FU2
, IGI_EXP_DU_TYPE_HEADERS_ALL DU_TYPE
, PO_VENDORS VENDOR
, AP_SUPPLIER_SITES_ALL 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.ORG_ID = VENDOR_SITE.ORG_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