eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: CZ.CZ_END_USERS#

Source

View Text - Preformatted


select END_USER_ID END_USER_ID, DBMS_ID DBMS_ID, TITLE TITLE, LASTNAME LASTNAME, FIRSTNAME FIRSTNAME, MI MI, ALLOWABLE_DISCOUNT ALLOWABLE_DISCOUNT, DESC_TEXT DESC_TEXT, ADDR_LINE1 ADDR_LINE1, ADDR_LINE2 ADDR_LINE2, CITY CITY, STATE STATE, PROVINCE PROVINCE, COUNTY COUNTY, ZIP ZIP, COUNTRY COUNTRY, PHONE PHONE, FAX FAX, PAGER PAGER, CELLULAR CELLULAR, EMAIL_ADDR EMAIL_ADDR, REPLICATE_FLAG REPLICATE_FLAG, LAST_REPLICATION LAST_REPLICATION, END_USER_ORG_ID END_USER_ORG_ID, FND_USER_ID FND_USER_ID, ORIG_SYS_REF ORIG_SYS_REF, NAME NAME, LOGIN_NAME LOGIN_NAME, USER_NUM01 USER_NUM01, USER_NUM02 USER_NUM02, USER_NUM03 USER_NUM03, USER_NUM04 USER_NUM04, USER_STR01 USER_STR01, USER_STR02 USER_STR02, USER_STR03 USER_STR03, USER_STR04 USER_STR04, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "CZ"."CZ_END_USERS"

View Text - HTML Formatted

SELECT END_USER_ID END_USER_ID
, DBMS_ID DBMS_ID
, TITLE TITLE
, LASTNAME LASTNAME
, FIRSTNAME FIRSTNAME
, MI MI
, ALLOWABLE_DISCOUNT ALLOWABLE_DISCOUNT
, DESC_TEXT DESC_TEXT
, ADDR_LINE1 ADDR_LINE1
, ADDR_LINE2 ADDR_LINE2
, CITY CITY
, STATE STATE
, PROVINCE PROVINCE
, COUNTY COUNTY
, ZIP ZIP
, COUNTRY COUNTRY
, PHONE PHONE
, FAX FAX
, PAGER PAGER
, CELLULAR CELLULAR
, EMAIL_ADDR EMAIL_ADDR
, REPLICATE_FLAG REPLICATE_FLAG
, LAST_REPLICATION LAST_REPLICATION
, END_USER_ORG_ID END_USER_ORG_ID
, FND_USER_ID FND_USER_ID
, ORIG_SYS_REF ORIG_SYS_REF
, NAME NAME
, LOGIN_NAME LOGIN_NAME
, USER_NUM01 USER_NUM01
, USER_NUM02 USER_NUM02
, USER_NUM03 USER_NUM03
, USER_NUM04 USER_NUM04
, USER_STR01 USER_STR01
, USER_STR02 USER_STR02
, USER_STR03 USER_STR03
, USER_STR04 USER_STR04
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "CZ"."CZ_END_USERS"