[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	Tablespace	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

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