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

VIEW: APPS.IGF_AP_TD_ITEM_INST

Object Details
Object Name: IGF_AP_TD_ITEM_INST
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AP_TD_ITEM_INST
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
BASE_ID NUMBER (15) Yes
ITEM_SEQUENCE_NUMBER NUMBER (15) Yes
STATUS VARCHAR2 (30)
STATUS_DATE DATE

ADD_DATE DATE

CORSP_DATE DATE

CORSP_COUNT NUMBER (15)
INACTIVE_FLAG VARCHAR2 (1)
REQUIRED_FOR_APPLICATION VARCHAR2 (30)
FREQ_ATTEMPT NUMBER (15)
MAX_ATTEMPT NUMBER (15)
LEGACY_RECORD_FLAG VARCHAR2 (1)
Indicates this student award record is imported through legacy import process
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
ORG_ID NUMBER (15)
CLPRL_ID NUMBER

Lender that the student selected as preferred
Query Text

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


SELECT ROW_ID
,      BASE_ID
,      ITEM_SEQUENCE_NUMBER
,      STATUS
,      STATUS_DATE
,      ADD_DATE
,      CORSP_DATE
,      CORSP_COUNT
,      INACTIVE_FLAG
,      REQUIRED_FOR_APPLICATION
,      FREQ_ATTEMPT
,      MAX_ATTEMPT
,      LEGACY_RECORD_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      CLPRL_ID
FROM APPS.IGF_AP_TD_ITEM_INST;

Dependencies

[top of page]

APPS.IGF_AP_TD_ITEM_INST references the following:

SchemaAPPS
SynonymIGF_AP_TD_ITEM_INST_ALL
APPS.IGF_AP_TD_ITEM_INST is referenced by following:

SchemaAPPS
Package BodyIGF_AP_ISIR_GEN_PKG - show dependent code
Package BodyIGF_AP_LG_TD_IMP - show dependent code
Package BodyIGF_AP_MATCHING_PROCESS_PKG - show dependent code
Package BodyIGF_AP_PROFILE_MATCHING_PKG - show dependent code
ViewIGF_AP_TD_ITEM_INST_V
Package BodyIGF_AP_TODO_GRPS_PRC_PKG - show dependent code
Package BodyIGF_AW_GEN_004 - show dependent code
Package BodyIGF_AW_LI_IMPORT - show dependent code