View: IGI_EXP_DIAL_UNIT_V

Product:	IGI - Public Sector Financials International
Description:	Displays all information pertaining to dialog unit setup
Implementation/DBA Data:	APPS.IGI_EXP_DIAL_UNIT_V

View Text

SELECT D.ROWID ROW_ID
, D.DIAL_UNIT_ID
, D.DIAL_UNIT_NUM
, D.DESCRIPTION
, D.CREATION_DATE
, D.THIRD_PARTY_ID
, P.VENDOR_NAME THIRD_PARTY_NAME
, D.SITE_ID
, S.VENDOR_SITE_CODE SITE_NAME
, D.AMOUNT
, D.CREATED_BY
, F.USER_NAME
, T.APPLICATION
, D.TRX_TYPE_ID
, D.DOC_TYPE_ID
, D.STATUS
, D.CURRENCY_CODE
FROM FND_USER F
, IGI_EXP_DIAL_UNIT_DEF D
, IGI_EXP_TRX_TYPE T
, PO_VENDORS P
, PO_VENDOR_SITES S
, RA_HCUSTOMERS C
, RA_SITE_USES S
WHERE D.THIRD_PARTY_ID = P.VENDOR_ID
AND D.SITE_ID = S.VENDOR_SITE_ID
AND D.CREATED_BY = F.USER_ID AND T.APPLICATION = 'P'
AND D.TRX_TYPE_ID = T.TRX_TYPE_ID UNION SELECT D.ROWID ROW_ID
, D.DIAL_UNIT_ID
, D.DIAL_UNIT_NUM
, D.DESCRIPTION
, D.CREATION_DATE
, D.THIRD_PARTY_ID
, C.CUSTOMER_NAME THIRD_PARTY_NAME
, D.SITE_ID
, NVL(A.STP_COMMON_REF
, S.LOCATION) SITE_NAME
, D.AMOUNT
, D.CREATED_BY
, F.USER_NAME
, T.APPLICATION
, D.TRX_TYPE_ID
, D.DOC_TYPE_ID
, D.STATUS
, D.CURRENCY_CODE
FROM IGI_EXP_DIAL_UNIT_DEF D
, RA_CUSTOMERS C
, RA_SITE_USES S
, IGI_AR_ADDRESSES_V A
, FND_USER F
, IGI_EXP_TRX_TYPE T
WHERE D.THIRD_PARTY_ID = C.CUSTOMER_ID
AND D.SITE_ID = S.SITE_USE_ID
AND S.ADDRESS_ID = A.ADDRESS_ID
AND D.CREATED_BY = F.USER_ID AND T.APPLICATION = 'R'
AND D.TRX_TYPE_ID = T.TRX_TYPE_ID

Columns