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

TABLE: IGS.IGR_I_LINES_INT

Object Details
Object Name: IGR_I_LINES_INT
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGR_I_LINES_INT
Subobject Name:
Status: VALID


Stores academic interests for the inquiry interface. This table is a child to IGR_I_APPL_INT and the value in the INTERFACE_INQ_APPL_ID column links rows in these tables. The corresponding production table is IGR_I_A_LINES
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Inquiry Lines
Category: BUSINESS_ENTITY IGS_INQ_APPLICATION


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGR_I_LINES_INT_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_LINES_ID
IGR_I_LINES_INT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_INQ_APPL_ID
IGR_I_LINES_INT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTATUS
IGR_I_LINES_INT_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_RUN_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_LINES_ID NUMBER (15) Yes Interface Lines ID Generated from sequence
INTERFACE_INQ_APPL_ID NUMBER (15) Yes Inquiry Instance ID
PREFERENCE NUMBER (15)
Preference for the Inquiry Program and Unit Set pair
PROGRAM_CODE_ID NUMBER (15)
Obsolete
UNIT_SET_CODE_ID NUMBER (15)
Obsolete
STATUS VARCHAR2 (1) Yes Importing Status
MATCH_IND VARCHAR2 (2)
Import Matching Indicator
ERROR_CODE VARCHAR2 (30)
Import Error Code
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
REQUEST_ID NUMBER (15)
Request Identifier of Last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER (15)
Application Identifier of Last concurrent program to update this record
PROGRAM_ID NUMBER (15)
Program Identifier of Last concurrent program to update this record
PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program
INTERFACE_RUN_ID NUMBER

Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user
ERROR_TEXT VARCHAR2 (2000)
Error Text
PERSON_ID NUMBER (15)
Person Identifier. This column will be populated by the import process
ENQUIRY_APPL_NUMBER NUMBER (15)
Enquiry Application Number. This column will be populated by the import process
INQUIRY_ENTRY_STATUS_ID NUMBER (15)
Obsolete
SALES_LEAD_ID NUMBER (15)
Sales Lead Identifier. This column will be populated by the import process
INQUIRY_DATE DATE

Inquiry Date. This column will be populated by the import process
INQUIRY_SOURCE_TYPE VARCHAR2 (30)
Inquiry Source Type. This column will be populated by the import process
PRODUCT_CATEGORY_ID NUMBER (15)
Product Category ID
PRODUCT_CATEGORY_SET_ID NUMBER (15)
Product Category Set ID
Query Text

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


SELECT INTERFACE_LINES_ID
,      INTERFACE_INQ_APPL_ID
,      PREFERENCE
,      PROGRAM_CODE_ID
,      UNIT_SET_CODE_ID
,      STATUS
,      MATCH_IND
,      ERROR_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INTERFACE_RUN_ID
,      ERROR_TEXT
,      PERSON_ID
,      ENQUIRY_APPL_NUMBER
,      INQUIRY_ENTRY_STATUS_ID
,      SALES_LEAD_ID
,      INQUIRY_DATE
,      INQUIRY_SOURCE_TYPE
,      PRODUCT_CATEGORY_ID
,      PRODUCT_CATEGORY_SET_ID
FROM IGS.IGR_I_LINES_INT;

Dependencies

[top of page]

IGS.IGR_I_LINES_INT does not reference any database object

IGS.IGR_I_LINES_INT is referenced by following:

SchemaAPPS
SynonymIGR_I_LINES_INT