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

VIEW: ICX.ICX_POR_LOADER_VALUES#

Object Details
Object Name: ICX_POR_LOADER_VALUES#
Object Type: VIEW
Owner: ICX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LOAD_ITEM_MASTER VARCHAR2 (1)
LOAD_CATEGORIES VARCHAR2 (1)
LOAD_TEMPLATE_HEADERS VARCHAR2 (1)
LOAD_TEMPLATE_LINES VARCHAR2 (1)
LOAD_CATALOG_GROUPS VARCHAR2 (1)
CATALOG_GROUPS_LAST_RUN_DATE DATE

CATEGORIES_LAST_RUN_DATE DATE

TEMPLATE_HEADERS_LAST_RUN_DATE DATE

TEMPLATE_LINES_LAST_RUN_DATE DATE

ITEM_MASTER_LAST_RUN_DATE DATE

CONTRACTS_LAST_RUN_DATE DATE

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

VENDOR_LAST_RUN_DATE DATE

LOAD_INTERNAL_ITEM VARCHAR2 (1)
INTERNAL_ITEM_LAST_RUN_DATE DATE

CLEANUP_FLAG VARCHAR2 (1)
LOAD_ONETIMEITEMS_IN_ALL_LANGS VARCHAR2 (1)
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# references the following:

SchemaICX
TableICX_POR_LOADER_VALUES
ICX.ICX_POR_LOADER_VALUES# is referenced by following:

SchemaAPPS
SynonymICX_POR_LOADER_VALUES