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: AHL.AHL_APPLICABLE_MRS

Object Details

Object Name:	AHL_APPLICABLE_MRS
Object Type:	TABLE
Owner:	AHL
FND Design Data:	AHL.AHL_APPLICABLE_MRS
Subobject Name:
Status:	VALID

Temporary Table Details

AHL.AHL_APPLICABLE_MRS is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Column
AHL_APPLICABLE_MRS_N1	NORMAL	NONUNIQUE	MR_HEADER_ID CSI_ITEM_INSTANCE_ID
AHL_APPLICABLE_MRS_N2	NORMAL	NONUNIQUE	CSI_ITEM_INSTANCE_ID
AHL_APPLICABLE_MRS_N3	NORMAL	NONUNIQUE	PROGRAM_MR_HEADER_ID PM_SCHEDULE_EXISTS

Columns

Name	Datatype	Length	Mandatory
CSI_ITEM_INSTANCE_ID	NUMBER		Yes
MR_HEADER_ID	NUMBER		Yes
MR_EFFECTIVITY_ID	NUMBER		Yes
WHICHEVER_FIRST_CODE	VARCHAR2	(5)
REPETITIVE_FLAG	VARCHAR2	(1)	Yes
SHOW_REPETITIVE_CODE	VARCHAR2	(4)	Yes
COPY_ACCOMPLISHMENT_CODE	VARCHAR2	(1)
PRECEDING_MR_HEADER_ID	NUMBER
IMPLEMENT_STATUS_CODE	VARCHAR2	(30)	Yes
DESCENDENT_COUNT	NUMBER
SERVICE_LINE_ID	NUMBER
COVERAGE_IMP_LEVEL	NUMBER
CONTRACT_START_DATE	DATE
CONTRACT_END_DATE	DATE
PM_SCHEDULE_EXISTS	VARCHAR2	(1)
PROGRAM_MR_HEADER_ID	NUMBER
PROGRAM_END_DATE	DATE

Query Text

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


SELECT CSI_ITEM_INSTANCE_ID
,      MR_HEADER_ID
,      MR_EFFECTIVITY_ID
,      WHICHEVER_FIRST_CODE
,      REPETITIVE_FLAG
,      SHOW_REPETITIVE_CODE
,      COPY_ACCOMPLISHMENT_CODE
,      PRECEDING_MR_HEADER_ID
,      IMPLEMENT_STATUS_CODE
,      DESCENDENT_COUNT
,      SERVICE_LINE_ID
,      COVERAGE_IMP_LEVEL
,      CONTRACT_START_DATE
,      CONTRACT_END_DATE
,      PM_SCHEDULE_EXISTS
,      PROGRAM_MR_HEADER_ID
,      PROGRAM_END_DATE
FROM AHL.AHL_APPLICABLE_MRS;

Dependencies

[top of page]

AHL.AHL_APPLICABLE_MRS does not reference any database object

AHL.AHL_APPLICABLE_MRS is referenced by following:

APPS: AHL_APPLICABLE_MRS