[Home] [Help] [Dependency Information]
Object Name: | ICX_CAT_ITEMS_CTX_DTLS_TLP |
---|---|
Object Type: | TABLE |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
For each item, we construct a synthetic document Oracle Text will index on. This document is basically a concatenation of all the searchable attributes. To support efficient maintenance of these documents, each document is broken up into several rows, some for base attributes, some for category attributes, some for language, and some for the org Id's for the item.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ICX_CAT_ITEMS_CTX_DTLS_TLP_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PO_LINE_ID
INVENTORY_ITEM_ID REQ_TEMPLATE_NAME REQ_TEMPLATE_LINE_NUM ORG_ID LANGUAGE SEQUENCE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Id | |
PO_LINE_ID | NUMBER | Yes | PO Line Id | |
REQ_TEMPLATE_NAME | VARCHAR2 | (25) | Yes | Express name from requisition template |
REQ_TEMPLATE_LINE_NUM | NUMBER | Yes | Sequence num from requisition template | |
ORG_ID | NUMBER | Yes | Org Id | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language |
SEQUENCE | NUMBER | The synthetic document could be broken up into several pieces. This stores the sequence of each piece. | ||
CTX_DESC | VARCHAR2 | (4000) | Stores the concatenates attributes | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
REQUEST_ID | NUMBER | Standard Concurrent Request Column: Identifies the concurrent request instance that spawned the concurrent program | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Concurrent Request Column: Identifies the Oracle Application that spawned the concurrent program | ||
PROGRAM_ID | NUMBER | Standard Concurrent Request Column: Identifies the concurrent program | ||
PROGRAM_LOGIN_ID | NUMBER | Standard Concurrent Request Column: Identifies the Oracle Applications Concurrent Program Login ID | ||
INTERNAL_REQUEST_ID | NUMBER | Internal_request_id to track the changes done in a job. Different from request_id, because source of the items may not always be concurrent jobs. |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, PO_LINE_ID
, REQ_TEMPLATE_NAME
, REQ_TEMPLATE_LINE_NUM
, ORG_ID
, LANGUAGE
, SEQUENCE
, CTX_DESC
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, INTERNAL_REQUEST_ID
FROM ICX.ICX_CAT_ITEMS_CTX_DTLS_TLP;
ICX.ICX_CAT_ITEMS_CTX_DTLS_TLP does not reference any database object
ICX.ICX_CAT_ITEMS_CTX_DTLS_TLP is referenced by following:
|
|
|