View: IGI_EXP_DIAL_UNIT_DEF

Product:	IGI - Public Sector Financials International
Description:	Multi org view which displays all information pertaining to dialog unit setup.
Implementation/DBA Data:	APPS.IGI_EXP_DIAL_UNIT_DEF

View Text

SELECT "DIAL_UNIT_ID"
, "DIAL_UNIT_NUM"
, "TRX_TYPE_ID"
, "DOC_TYPE_ID"
, "THIRD_PARTY_ID"
, "DIAL_UNIT_NUM_TYPE"
, "ACT_NUMBER"
, "STATUS"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_LOGIN"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "ORG_ID"
, "CURRENCY_CODE"
, "SITE_ID"
, "MRC_EXCHANGE_RATE_TYPE"
, "MRC_EXCHANGE_RATE"
, "MRC_EXCHANGE_DATE"
, "LEGAL_NUMBER"
, "AMOUNT"
, "MRC_AMOUNT"
, "MRC_AMOUNT_EXCHANGE_RATE_TYPE"
, "MRC_AMOUNT_EXCHANGE_DATE"
, "MRC_AMOUNT_EXCHANGE_RATE"
, "DESCRIPTION"
, "TRANS_UNIT_ID"
, "DIAL_UNIT_SELECTED_FLAG"
, "DIAL_UNIT_CALL_NUM"
, "MAIN_AUTHORIZER"
, "ACCOUNT_OFFICER"
, "PRINT_DATE"
, "REQ_REJECT"
, "UPGRADE_STATUS"
FROM IGI_EXP_DIAL_UNIT_DEF_ALL
WHERE NVL(ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns