VIEW: APPS.IGI_EXP_DIAL_UNIT_DEF

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)