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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ZX.ZX_REP_CONTEXT_T

Object Details

Object Name:	ZX_REP_CONTEXT_T
Object Type:	TABLE
Owner:	ZX
FND Design Data:	ZX.ZX_REP_CONTEXT_T
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_REP_CONTEXT_T_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REP_CONTEXT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REP_CONTEXT_ID	NUMBER	(15)	Yes	Unique identifier
REP_ENTITY_ID	NUMBER	(15)		Operating unit identifier or legal entity identifier based on whether this reporting context is for operating unit based reports or legal entity based reports
ORG_INFORMATION2	VARCHAR2	(150)		Tax registration number
REP_CONTEXT_ENTITY_LOCATION_ID	NUMBER	(15)		Location identifier for this reporting context
REP_CONTEXT_ENTITY_NAME	VARCHAR2	(240)		Legal entity name or Operating unit name for this report context
REP_CONTEXT_ENTITY_CITY	VARCHAR2	(120)		City field for the address of this report context
REP_CONTEXT_ENTITY_COUNTY	VARCHAR2	(120)		County field for the address of this report context
REP_CONTEXT_ENTITY_STATE	VARCHAR2	(120)		State field for the address of this report context
REP_CONTEXT_ENTITY_PROVINCE	VARCHAR2	(120)		Province field for the address of this report context
REP_CONTEXT_ENTITY_ADDRESS1	VARCHAR2	(240)		Address line 1 of this report context
REP_CONTEXT_ENTITY_ADDRESS2	VARCHAR2	(240)		Address line 2 of this report context
REP_CONTEXT_ENTITY_ADDRESS3	VARCHAR2	(240)		Address line 3 of this report context
REP_CONTEXT_ENTITY_COUNTRY	VARCHAR2	(60)		Country code of the address for this report context
REP_CONTEXT_ENTITY_POSTAL_CODE	VARCHAR2	(30)		Postal code field of the address for this report context
REP_CONTEXT_ENTITY_TEL_NUMBER	VARCHAR2	(60)		Telephone number field of the address for this report context
REP_CONTEXT_LVL_MNG	VARCHAR2	(80)		Reporting context level description
REP_CONTEXT_LVL_CODE	VARCHAR2	(30)		Lookup code to indicate whether this reporting context is at the level of ledger or legal entity or a single operating unit or multiple operating units.
EXTRACT_SUMMARY_CODE	VARCHAR2	(30)		Lookup code to indicate the summary level at which the data is extracted for this report context
MATRIX_REPORT_FLAG	VARCHAR2	(1)		Y or N indicates whether this report context is for matrix reports
LEGAL_CONTACT_PRE_NAME_ADJUNCT	VARCHAR2	(30)		Title of the legal contact
LEGAL_CONTACT_PARTY_NAME	VARCHAR2	(360)		Legal contact name
TAXPAYER_ID	VARCHAR2	(30)		Tax payer identifier
LEGAL_CONTACT_TITLE	VARCHAR2	(100)		Job title of the legal contact
ACTIVITY_CODE	VARCHAR2	(150)		Activity code
SUB_ACTIVITY_CODE	VARCHAR2	(150)		Sub activity code
INCEPTION_DATE	DATE			Inception date
LEGAL_CONTACT_PARTY_NUM	VARCHAR2	(30)		Legal contact party number
LEGAL_AUTH_ADDRESS_LINE2	VARCHAR2	(240)		Legal authority address line 2
LEGAL_AUTH_ADDRESS_LINE3	VARCHAR2	(240)		Legal authority address line 3
LEGAL_AUTH_CITY	VARCHAR2	(60)		Legal authority city
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER			Program identifier of last concurrent program to update this record
PROGRAM_LOGIN_ID	NUMBER			Login user identifier of last concurrent program to update this record
LEGAL_AUTHORITY_NAME	VARCHAR2	(360)		Legal authority name

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

ZX.ZX_REP_CONTEXT_T does not reference any database object

ZX.ZX_REP_CONTEXT_T is referenced by following:

APPS: ZX_REP_CONTEXT_T