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: ZX.ZX_REP_CONTEXT_T#

Source

View Text - Preformatted


select REP_CONTEXT_ID REP_CONTEXT_ID, REP_ENTITY_ID REP_ENTITY_ID, ORG_INFORMATION2 ORG_INFORMATION2, REP_CONTEXT_ENTITY_LOCATION_ID REP_CONTEXT_ENTITY_LOCATION_ID, REP_CONTEXT_ENTITY_NAME REP_CONTEXT_ENTITY_NAME, REP_CONTEXT_ENTITY_CITY REP_CONTEXT_ENTITY_CITY, REP_CONTEXT_ENTITY_COUNTY REP_CONTEXT_ENTITY_COUNTY, REP_CONTEXT_ENTITY_STATE REP_CONTEXT_ENTITY_STATE, REP_CONTEXT_ENTITY_PROVINCE REP_CONTEXT_ENTITY_PROVINCE, REP_CONTEXT_ENTITY_ADDRESS1 REP_CONTEXT_ENTITY_ADDRESS1, REP_CONTEXT_ENTITY_ADDRESS2 REP_CONTEXT_ENTITY_ADDRESS2, REP_CONTEXT_ENTITY_ADDRESS3 REP_CONTEXT_ENTITY_ADDRESS3, REP_CONTEXT_ENTITY_COUNTRY REP_CONTEXT_ENTITY_COUNTRY, REP_CONTEXT_ENTITY_POSTAL_CODE REP_CONTEXT_ENTITY_POSTAL_CODE, REP_CONTEXT_ENTITY_TEL_NUMBER REP_CONTEXT_ENTITY_TEL_NUMBER, REP_CONTEXT_LVL_MNG REP_CONTEXT_LVL_MNG, REP_CONTEXT_LVL_CODE REP_CONTEXT_LVL_CODE, EXTRACT_SUMMARY_CODE EXTRACT_SUMMARY_CODE, MATRIX_REPORT_FLAG MATRIX_REPORT_FLAG, LEGAL_CONTACT_PRE_NAME_ADJUNCT LEGAL_CONTACT_PRE_NAME_ADJUNCT, LEGAL_CONTACT_PARTY_NAME LEGAL_CONTACT_PARTY_NAME, TAXPAYER_ID TAXPAYER_ID, LEGAL_CONTACT_TITLE LEGAL_CONTACT_TITLE, ACTIVITY_CODE ACTIVITY_CODE, SUB_ACTIVITY_CODE SUB_ACTIVITY_CODE, INCEPTION_DATE INCEPTION_DATE, LEGAL_CONTACT_PARTY_NUM LEGAL_CONTACT_PARTY_NUM, LEGAL_AUTH_ADDRESS_LINE2 LEGAL_AUTH_ADDRESS_LINE2, LEGAL_AUTH_ADDRESS_LINE3 LEGAL_AUTH_ADDRESS_LINE3, LEGAL_AUTH_CITY LEGAL_AUTH_CITY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, LEGAL_AUTHORITY_NAME LEGAL_AUTHORITY_NAME from "ZX"."ZX_REP_CONTEXT_T"

View Text - HTML Formatted

SELECT REP_CONTEXT_ID REP_CONTEXT_ID
, REP_ENTITY_ID REP_ENTITY_ID
, ORG_INFORMATION2 ORG_INFORMATION2
, REP_CONTEXT_ENTITY_LOCATION_ID REP_CONTEXT_ENTITY_LOCATION_ID
, REP_CONTEXT_ENTITY_NAME REP_CONTEXT_ENTITY_NAME
, REP_CONTEXT_ENTITY_CITY REP_CONTEXT_ENTITY_CITY
, REP_CONTEXT_ENTITY_COUNTY REP_CONTEXT_ENTITY_COUNTY
, REP_CONTEXT_ENTITY_STATE REP_CONTEXT_ENTITY_STATE
, REP_CONTEXT_ENTITY_PROVINCE REP_CONTEXT_ENTITY_PROVINCE
, REP_CONTEXT_ENTITY_ADDRESS1 REP_CONTEXT_ENTITY_ADDRESS1
, REP_CONTEXT_ENTITY_ADDRESS2 REP_CONTEXT_ENTITY_ADDRESS2
, REP_CONTEXT_ENTITY_ADDRESS3 REP_CONTEXT_ENTITY_ADDRESS3
, REP_CONTEXT_ENTITY_COUNTRY REP_CONTEXT_ENTITY_COUNTRY
, REP_CONTEXT_ENTITY_POSTAL_CODE REP_CONTEXT_ENTITY_POSTAL_CODE
, REP_CONTEXT_ENTITY_TEL_NUMBER REP_CONTEXT_ENTITY_TEL_NUMBER
, REP_CONTEXT_LVL_MNG REP_CONTEXT_LVL_MNG
, REP_CONTEXT_LVL_CODE REP_CONTEXT_LVL_CODE
, EXTRACT_SUMMARY_CODE EXTRACT_SUMMARY_CODE
, MATRIX_REPORT_FLAG MATRIX_REPORT_FLAG
, LEGAL_CONTACT_PRE_NAME_ADJUNCT LEGAL_CONTACT_PRE_NAME_ADJUNCT
, LEGAL_CONTACT_PARTY_NAME LEGAL_CONTACT_PARTY_NAME
, TAXPAYER_ID TAXPAYER_ID
, LEGAL_CONTACT_TITLE LEGAL_CONTACT_TITLE
, ACTIVITY_CODE ACTIVITY_CODE
, SUB_ACTIVITY_CODE SUB_ACTIVITY_CODE
, INCEPTION_DATE INCEPTION_DATE
, LEGAL_CONTACT_PARTY_NUM LEGAL_CONTACT_PARTY_NUM
, LEGAL_AUTH_ADDRESS_LINE2 LEGAL_AUTH_ADDRESS_LINE2
, LEGAL_AUTH_ADDRESS_LINE3 LEGAL_AUTH_ADDRESS_LINE3
, LEGAL_AUTH_CITY LEGAL_AUTH_CITY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, LEGAL_AUTHORITY_NAME LEGAL_AUTHORITY_NAME
FROM "ZX"."ZX_REP_CONTEXT_T"