View: IGI_EXP_EPTU_DIAL_V

Product:	IGI - Public Sector Financials International
Description:	Displays all information pertaining to exchange protocol dialog units contained in transmission units
Implementation/DBA Data:	APPS.IGI_EXP_EPTU_DIAL_V

View Text

SELECT EDUD.ROWID ROW_ID
, EDUD.DIAL_UNIT_ID
, EDUD.TRANS_UNIT_ID
, EDUD.DIAL_UNIT_NUM
, EDUD.DOC_TYPE_ID
, EDUD.DESCRIPTION
, EDUD.STATUS
, ILU.MEANING
, EDUD.THIRD_PARTY_ID
, RAC.CUSTOMER_NAME
, EDUD.CREATION_DATE
, EDUD.AMOUNT
, EDUD.DIAL_UNIT_SELECTED_FLAG
, EDUD.CREATED_BY
, EDUD.LAST_UPDATE_DATE
, EDUD.LAST_UPDATED_BY
, EDUD.LAST_UPDATE_LOGIN
, EDUD.CURRENCY_CODE
, EDUD.REQ_REJECT
, EDUD.ACT_NUMBER
, EDUD.LEGAL_NUMBER
FROM FND_USER F
, IGI_EXP_DIAL_UNIT_DEF EDUD
, IGI_EXP_TRX_TYPE ETT
, IGI_LOOKUPS ILU
, RA_HCUSTOMERS RAC
, PO_VENDORS VEN
WHERE EDUD.STATUS = ILU.LOOKUP_CODE AND ILU.LOOKUP_TYPE = 'IGI_EXP_DIAL_UNIT_STATUS' AND EDUD.THIRD_PARTY_ID = RAC.CUSTOMER_ID
AND ETT.TRX_TYPE_ID = EDUD.TRX_TYPE_ID
AND F.USER_ID = EDUD.CREATED_BY
AND ETT.APPLICATION = 'R' UNION SELECT EDUD.ROWID ROW_ID
, EDUD.DIAL_UNIT_ID
, EDUD.TRANS_UNIT_ID
, EDUD.DIAL_UNIT_NUM
, EDUD.DOC_TYPE_ID
, EDUD.DESCRIPTION
, EDUD.STATUS
, ILU.MEANING
, EDUD.THIRD_PARTY_ID
, VEN.VENDOR_NAME
, EDUD.CREATION_DATE
, EDUD.AMOUNT
, EDUD.DIAL_UNIT_SELECTED_FLAG
, EDUD.CREATED_BY
, EDUD.LAST_UPDATE_DATE
, EDUD.LAST_UPDATED_BY
, EDUD.LAST_UPDATE_LOGIN
, EDUD.CURRENCY_CODE
, EDUD.REQ_REJECT
, EDUD.ACT_NUMBER
, EDUD.LEGAL_NUMBER FROM IGI_EXP_DIAL_UNIT_DEF EDUD
, IGI_LOOKUPS ILU
, PO_VENDORS VEN
, IGI_EXP_TRX_TYPE ETT
, FND_USER F WHERE EDUD.STATUS = ILU.LOOKUP_CODE AND ILU.LOOKUP_TYPE = 'IGI_EXP_DIAL_UNIT_STATUS' AND EDUD.THIRD_PARTY_ID = VEN.VENDOR_ID
AND ETT.TRX_TYPE_ID = EDUD.TRX_TYPE_ID
AND F.USER_ID = EDUD.CREATED_BY
AND ETT.APPLICATION = 'P'

Columns