[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_APCTR_RU_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AD_APCTR_RU_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is view is for displaying the descriptions of the codes columns of admission process category tracking rules view.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Idenitier | |
APC_TRK_RU_ID | NUMBER | (15) | Yes | Admission Rule ID |
ADMISSION_CAT | VARCHAR2 | (10) | Yes | Admission Category |
S_ADMISSION_PROCESS_TYPE | VARCHAR2 | (30) | Yes | System Admission Process Category |
S_RULE_CALL_CD | VARCHAR2 | (30) | Rule Call Code | |
MEANING | VARCHAR2 | (80) | Yes | Meaning |
RUL_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Rule Sequence Number to identify the rule set up |
RUD_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Rule Description Sequence Number |
S_RETURN_TYPE | VARCHAR2 | (20) | Yes | Rule return Type |
RULE_DESCRIPTION | VARCHAR2 | (255) | Yes | This column holds the definition of rule as it will be used in the implementation |
DESCRIPTION | VARCHAR2 | (2000) | Rule Description | |
RULE_TEXT | VARCHAR2 | (2000) | Yes | Rule Text |
RUG_SEQUENCE_NUMBER | NUMBER | (6) | This field determines the rule group for this rule | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, APC_TRK_RU_ID
, ADMISSION_CAT
, S_ADMISSION_PROCESS_TYPE
, S_RULE_CALL_CD
, MEANING
, RUL_SEQUENCE_NUMBER
, RUD_SEQUENCE_NUMBER
, S_RETURN_TYPE
, RULE_DESCRIPTION
, DESCRIPTION
, RULE_TEXT
, RUG_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.IGS_AD_APCTR_RU_V;
APPS.IGS_AD_APCTR_RU_V is not referenced by any database object
|
|
|