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: ITG.ITG_ORG_EFFECTIVITY

Object Details

Object Name:	ITG_ORG_EFFECTIVITY
Object Type:	TABLE
Owner:	ITG
Subobject Name:
Status:	VALID

This table contains the individual effectivity for a particular organization (or none), document type and direction.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ITG_ORG_EFFECTIVITY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EFFECTIVITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EFFECTIVITY_ID	NUMBER		Yes	Primary key.
ORGANIZATION_ID	NUMBER			Effective organization. This value should be NULL for document type/direction combinations that are non-org controlled (according to the itg_org_indicator table).
CLN_DOC_TYPE	VARCHAR2	(30)	Yes	The CLN document type: The possible values here are liated in the FND_LOOKUPS rows with a lookup_type of 'CLN_COLLABORATION_DOC_TYPE'.
DOC_DIRECTION	VARCHAR2	(1)	Yes	The document direction: 'P' for publish (outbound) or 'S' for subscribe (inbound).
START_DATE	DATE			The date that the effectiveness begins. A default value of NULL means the minimum possible date, resulting in an open beginning to the range.
END_DATE	DATE			The date that the effectiveness ends. A default value of NULL means the maximum possible date, resulting in an open end to the range.
EFFECTIVITY_ENABLED	VARCHAR2	(1)	Yes	A seperate FND_API boolean (i.e. containing the values 'T' or 'F') indicating if the effectivity is enabled at all. This allows the effectivity to be enabled/disabled on the screen without changing the effectivity date range.
CREATED_BY	NUMBER		Yes	Who field
CREATION_DATE	DATE		Yes	Who field
LAST_UPDATED_BY	NUMBER		Yes	Who field
LAST_UPDATE_DATE	DATE		Yes	Who field
LAST_UPDATE_LOGIN	NUMBER			Who field

Query Text

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


SELECT EFFECTIVITY_ID
,      ORGANIZATION_ID
,      CLN_DOC_TYPE
,      DOC_DIRECTION
,      START_DATE
,      END_DATE
,      EFFECTIVITY_ENABLED
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ITG.ITG_ORG_EFFECTIVITY;

Dependencies

[top of page]

ITG.ITG_ORG_EFFECTIVITY does not reference any database object

ITG.ITG_ORG_EFFECTIVITY is referenced by following:

APPS: ITG_ORG_EFFECTIVITY