View: IGI_EXP_DIAL_UNIT_DEF_V

Product:	IGI - Public Sector Financials International
Description:	Displays all information pertaining to dialog unit setup.
Implementation/DBA Data:	APPS.IGI_EXP_DIAL_UNIT_DEF_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
, ILU.MEANING STATUS
, D.STATUS STATUS_CODE
, D.AMOUNT
, F.USER_NAME
, D.CREATED_BY
, EDT.DESCRIPTION DIAL_DOC_TYPE
, ETT.DESCRIPTION DIAL_TRANS_TYPE
, EDT.APPLICATION
, T.TRANS_UNIT_NUM
, T.TRANS_UNIT_ID
, D.DIAL_UNIT_CALL_NUM
, EDT.DOC_TYPE_ID
, ETT.TRX_TYPE_ID
, D.CURRENCY_CODE
, T.TRAN_UNIT_CALL_NUM
FROM RA_HCUSTOMERS C
, RA_SITE_USES S
, FND_USER F
, IGI_EXP_DIAL_UNIT_DEF D
, IGI_EXP_DOC_TYPE EDT
, IGI_EXP_TRAN_UNIT_DEF T
, IGI_EXP_TRX_TYPE ETT
, IGI_LOOKUPS ILU
, PO_VENDORS P
, PO_VENDOR_SITES 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 D.TRANS_UNIT_ID = T.TRANS_UNIT_ID(+)
AND EDT.DOC_TYPE_ID = D.DOC_TYPE_ID
AND EDT.APPLICATION = 'P'
AND ETT.TRX_TYPE_ID = D.TRX_TYPE_ID
AND ETT.APPLICATION = 'P'
AND ILU.LOOKUP_CODE = D.STATUS
AND ILU.LOOKUP_TYPE = 'IGI_EXP_DIAL_UNIT_STATUS' 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
, S.LOCATION SITE_NAME
, ILU.MEANING STATUS
, D.STATUS STATUS_CODE
, D.AMOUNT
, F.USER_NAME
, D.CREATED_BY
, EDT.DESCRIPTION DIAL_DOC_TYPE
, ETT.DESCRIPTION DIAL_TRANS_TYPE
, EDT.APPLICATION
, T.TRANS_UNIT_NUM
, T.TRANS_UNIT_ID
, D.DIAL_UNIT_CALL_NUM
, EDT.DOC_TYPE_ID
, ETT.TRX_TYPE_ID
, D.CURRENCY_CODE
, T.TRAN_UNIT_CALL_NUM
FROM IGI_EXP_DIAL_UNIT_DEF D
, IGI_EXP_DOC_TYPE EDT
, IGI_EXP_TRX_TYPE ETT
, RA_CUSTOMERS C
, RA_SITE_USES_ALL S
, FND_USER F
, IGI_EXP_TRAN_UNIT_DEF T
, IGI_LOOKUPS ILU
WHERE D.THIRD_PARTY_ID = C.CUSTOMER_ID
AND D.SITE_ID = S.SITE_USE_ID
AND D.CREATED_BY = F.USER_ID
AND D.TRANS_UNIT_ID = T.TRANS_UNIT_ID(+)
AND EDT.DOC_TYPE_ID = D.DOC_TYPE_ID
AND EDT.APPLICATION = 'R'
AND ETT.TRX_TYPE_ID = D.TRX_TYPE_ID
AND ETT.APPLICATION = 'R'
AND ILU.LOOKUP_CODE = D.STATUS
AND ILU.LOOKUP_TYPE = 'IGI_EXP_DIAL_UNIT_STATUS'

Columns