Skip to content

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

TABLE: ICX.ICX_POR_LOADER_VALUES

Object Details
Object Name: ICX_POR_LOADER_VALUES
Object Type: TABLE
Owner: ICX
FND Design Data: TableICX.ICX_POR_LOADER_VALUES
Subobject Name:
Status: VALID


Stores a single record with the setup data for the Extraction process. This row is updated with last run dates each time the extractor runs.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LOAD_ITEM_MASTER VARCHAR2 (1)
Flag indicating whether Item Master/ASL records should be extracted
LOAD_CATEGORIES VARCHAR2 (1)
Flag indicating whether Item Categories should be extracted
LOAD_TEMPLATE_HEADERS VARCHAR2 (1)
Flag indicating whether ReqExpress Template Headers should be extracted
LOAD_TEMPLATE_LINES VARCHAR2 (1)
Flag indicating whether ReqExpress Template Lines should be extracted
LOAD_CATALOG_GROUPS VARCHAR2 (1)
Not used in WebReqs 4 deprecated
CATALOG_GROUPS_LAST_RUN_DATE DATE

Not used in WebReq 4 (future) deprecated
CATEGORIES_LAST_RUN_DATE DATE

Date when extract program last extracted item Cage
TEMPLATE_HEADERS_LAST_RUN_DATE DATE

Date when extract program last extracted Template Headers
TEMPLATE_LINES_LAST_RUN_DATE DATE

Date when extract program last extracted Template Lines
ITEM_MASTER_LAST_RUN_DATE DATE

Date when extract program last extracted Item Master/ASL data
CONTRACTS_LAST_RUN_DATE DATE

Date when extract program last extracted Contract Lines
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Request unique identifier
PROGRAM_APPLICATION_ID NUMBER

Program application unique identifier
PROGRAM_ID NUMBER

Program unique identifier
PROGRAM_UPDATE_DATE DATE

Program update date
VENDOR_LAST_RUN_DATE DATE

Date when extract program last extracted Vendor Name changes
LOAD_INTERNAL_ITEM VARCHAR2 (1)
Flag that specifies if the internal items are to be extracted
INTERNAL_ITEM_LAST_RUN_DATE DATE

Date when the internal items were last extracted
CLEANUP_FLAG VARCHAR2 (1)
cleanup flag
LOAD_ONETIMEITEMS_IN_ALL_LANGS VARCHAR2 (1)
Flag indicating whether One Time Items should be extracted in all languages.
Query Text

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


SELECT LOAD_ITEM_MASTER
,      LOAD_CATEGORIES
,      LOAD_TEMPLATE_HEADERS
,      LOAD_TEMPLATE_LINES
,      LOAD_CATALOG_GROUPS
,      CATALOG_GROUPS_LAST_RUN_DATE
,      CATEGORIES_LAST_RUN_DATE
,      TEMPLATE_HEADERS_LAST_RUN_DATE
,      TEMPLATE_LINES_LAST_RUN_DATE
,      ITEM_MASTER_LAST_RUN_DATE
,      CONTRACTS_LAST_RUN_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      VENDOR_LAST_RUN_DATE
,      LOAD_INTERNAL_ITEM
,      INTERNAL_ITEM_LAST_RUN_DATE
,      CLEANUP_FLAG
,      LOAD_ONETIMEITEMS_IN_ALL_LANGS
FROM ICX.ICX_POR_LOADER_VALUES;

Dependencies

[top of page]

ICX.ICX_POR_LOADER_VALUES does not reference any database object

ICX.ICX_POR_LOADER_VALUES is referenced by following:

SchemaICX
ViewICX_POR_LOADER_VALUES#