Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - CSF Tables and Views

TABLE - CSF.CSF_ACCESS_HOURS_B
TABLE - CSF.CSF_ACCESS_HOURS_TL
TABLE - CSF.CSF_DC_QUERIES_B
TABLE - CSF.CSF_DC_QUERIES_TL
TABLE - CSF.CSF_DEBRIEF_HEADERS
TABLE - CSF.CSF_DEBRIEF_LINES
TABLE - CSF.CSF_EXT_LOCATIONS
TABLE - CSF.CSF_GNTICONS_SETUP_B
TABLE - CSF.CSF_LF_BLOCKS
TABLE - CSF.CSF_LF_NAMES
TABLE - CSF.CSF_LF_PLACES
TABLE - CSF.CSF_LF_PLACE_NAMES
TABLE - CSF.CSF_LF_PLACE_POSTCS
TABLE - CSF.CSF_LF_POIS
TABLE - CSF.CSF_LF_POI_NAMES
TABLE - CSF.CSF_LF_POSTCODES
TABLE - CSF.CSF_LF_ROADSEGMENTS
TABLE - CSF.CSF_LF_ROADSEGM_NAMES
TABLE - CSF.CSF_LF_ROADSEGM_PLACES
TABLE - CSF.CSF_LF_ROADSEGM_POSTS
TABLE - CSF.CSF_L_AGENDALAYOUTS
TABLE - CSF.CSF_L_QUERIES
TABLE - CSF.CSF_L_QUERYREQUESTS
TABLE - CSF.CSF_L_SODS
TABLE - CSF.CSF_L_SOTS
TABLE - CSF.CSF_MAP_ACCESS_HOURS_B
TABLE - CSF.CSF_MAP_ACCESS_HOURS_TL
TABLE - CSF.CSF_MD_ADM_BOUNDS
TABLE - CSF.CSF_MD_HYDROS
TABLE - CSF.CSF_MD_INST_STYLE_SHTS
TABLE - CSF.CSF_MD_LAND_USES
TABLE - CSF.CSF_MD_LYR_METADATA
TABLE - CSF.CSF_MD_LYR_STYLE_SHTS
TABLE - CSF.CSF_MD_NAMES
TABLE - CSF.CSF_MD_OM_ADMINS
TABLE - CSF.CSF_MD_OM_HYDROS
TABLE - CSF.CSF_MD_OM_POIS
TABLE - CSF.CSF_MD_OM_ROADS
TABLE - CSF.CSF_MD_POIS
TABLE - CSF.CSF_MD_POI_NM_ASGNS
TABLE - CSF.CSF_MD_RAIL_SEGS
TABLE - CSF.CSF_MD_RDSEG_NM_ASGNS
TABLE - CSF.CSF_MD_RD_SEGS
TABLE - CSF.CSF_MD_THEME_METADATA
TABLE - CSF.CSF_PARAMS
TABLE - CSF.CSF_PHONETIC_VALUES
TABLE - CSF.CSF_PLAN_TERRS
TABLE - CSF.CSF_RATING_SCALES_B
TABLE - CSF.CSF_RATING_SCALES_TL
TABLE - CSF.CSF_REQUIRED_SKILLS_B
TABLE - CSF.CSF_RESOURCE_SKILLS_B
TABLE - CSF.CSF_R_FILTERS_ALL_B
TABLE - CSF.CSF_R_FILTERS_ALL_TL
TABLE - CSF.CSF_R_FILTER_PARAMS_B
TABLE - CSF.CSF_R_FILTER_PARAMS_TL
TABLE - CSF.CSF_R_HZ_LOC_EXTNS
TABLE - CSF.CSF_R_MESSAGES
TABLE - CSF.CSF_R_MESSAGE_TOKENS
TABLE - CSF.CSF_R_PLAN_OPTIONS
TABLE - CSF.CSF_R_PLAN_OPTION_TASKS
TABLE - CSF.CSF_R_REQUEST_FILTERS
TABLE - CSF.CSF_R_REQUEST_TASKS
TABLE - CSF.CSF_R_REQUEST_VALUES
TABLE - CSF.CSF_R_RESOURCE_RESULTS
TABLE - CSF.CSF_R_SCENARIOS_ALL_B
TABLE - CSF.CSF_R_SCENARIOS_ALL_TL
TABLE - CSF.CSF_R_SCENARIO_FILTERS
TABLE - CSF.CSF_R_SCENARIO_VALUES
TABLE - CSF.CSF_R_SCHED_REQUESTS
TABLE - CSF.CSF_R_SPARES_OPTIONS
TABLE - CSF.CSF_R_TASK_ASSIGN_EXTNS
TABLE - CSF.CSF_R_TDS_ROUTE_CACHE
TABLE - CSF.CSF_SDM_CTRY_PROFILES
TABLE - CSF.CSF_SKILLS_B
TABLE - CSF.CSF_SKILLS_TL
TABLE - CSF.CSF_SKILL_LEVELS_B
TABLE - CSF.CSF_SKILL_LEVELS_TL
TABLE - CSF.CSF_SKILL_TYPES_B
TABLE - CSF.CSF_SKILL_TYPES_TL
TABLE - CSF.CSF_TDS_BINARY_MAPS
TABLE - CSF.CSF_TDS_BINARY_TILES
TABLE - CSF.CSF_TDS_CONDITIONS
TABLE - CSF.CSF_TDS_COND_SEGS
TABLE - CSF.CSF_TDS_INTERVALS
TABLE - CSF.CSF_TDS_NODES
TABLE - CSF.CSF_TDS_RDBLCK_INTVLS
TABLE - CSF.CSF_TDS_RDBLCK_SGMNTS
TABLE - CSF.CSF_TDS_ROADBLOCKS
TABLE - CSF.CSF_TDS_ROUTE_CACHE
TABLE - CSF.CSF_TDS_SEGMENTS
TABLE - CSF.CSF_TDS_SEGM_NODES
TABLE - CSF.CSF_TDS_TILES
VIEW - APPS.CSF_ACCESS_HOURS_VL
VIEW - APPS.CSF_CT_TASKS
VIEW - APPS.CSF_CT_TASK_ASSIGNMENTS
VIEW - APPS.CSF_DC_QUERIES_VL
VIEW - APPS.CSF_DEBRIEF_EXP_LINES_V
VIEW - APPS.CSF_DEBRIEF_HEADERS_V
VIEW - APPS.CSF_DEBRIEF_LAB_LINES_V
VIEW - APPS.CSF_DEBRIEF_MAT_LINES_V
VIEW - APPS.CSF_DEBRIEF_SRC_NUMBERS_V
VIEW - APPS.CSF_DEBRIEF_TASKS_V
VIEW - APPS.CSF_DEBRIEF_TRANS_TYPES_V
VIEW - APPS.CSF_ESC_TASKS_V
VIEW - APPS.CSF_GNTICONS_SETUP_V
VIEW - APPS.CSF_L_SODS_V
VIEW - APPS.CSF_MAP_ACCESS_HOURS_VL
VIEW - APPS.CSF_PHONETIC_VALUES_VL
VIEW - APPS.CSF_PLAN_OPTIONS_V
VIEW - APPS.CSF_PLAN_TERRS_V
VIEW - APPS.CSF_PO_CONTACT_POINTS_V
VIEW - APPS.CSF_RATING_SCALES_VL
VIEW - APPS.CSF_REQUIRED_SKILLS_V
VIEW - APPS.CSF_RESOURCE_SKILLS_V
VIEW - APPS.CSF_RES_INV_ASSIGNMENTS_V
VIEW - APPS.CSF_SELECTED_RESOURCES_V
VIEW - APPS.CSF_SKILLS_VL
VIEW - APPS.CSF_SKILL_LEVELS_VL
VIEW - APPS.CSF_SKILL_TYPES_VL
VIEW - APPS.CSF_SR_HIST_V
VIEW - APPS.CSF_VALIDATE_TASKS_V

Table: CSF_ACCESS_HOURS_B

Description:
Primary Key: CSF_ACCESS_HOURS_B_PK
  1. ACCESS_HOUR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_ACCESS_HOURS_B.TASK_ID JTF_TASKS_B

[top of page]

CSF.CSF_ACCESS_HOURS_B does not reference any database object

CSF.CSF_ACCESS_HOURS_B is referenced by following:

APPS
SYNONYM - CSF_ACCESS_HOURS_B

[top of page]

Table: CSF_ACCESS_HOURS_TL

Description:
Primary Key: CSF_ACCESS_HOURS_TL_PK
  1. LANGUAGE
  2. ACCESS_HOUR_ID

[top of page]

CSF.CSF_ACCESS_HOURS_TL does not reference any database object

CSF.CSF_ACCESS_HOURS_TL is referenced by following:

APPS
SYNONYM - CSF_ACCESS_HOURS_TL

[top of page]

Table: CSF_DC_QUERIES_B

Description: CSF_DC_QUERIES_B contains WHERE-clauses for queries to populate the Dispatch Center with tasks
Primary Key: CSF_DC_QUERIES_PK
  1. QUERY_ID

[top of page]

CSF.CSF_DC_QUERIES_B does not reference any database object

CSF.CSF_DC_QUERIES_B is referenced by following:

APPS
SYNONYM - CSF_DC_QUERIES_B

[top of page]

Table: CSF_DC_QUERIES_TL

Description:
Primary Key: CSF_DC_QUERIES_TL_PK
  1. QUERY_ID
  2. LANGUAGE

[top of page]

CSF.CSF_DC_QUERIES_TL does not reference any database object

CSF.CSF_DC_QUERIES_TL is referenced by following:

APPS
SYNONYM - CSF_DC_QUERIES_TL

[top of page]

Table: CSF_DEBRIEF_HEADERS

Description: Field Service Report header information
Primary Key: CSF_DEBRIEF_HEADERS_PK
  1. DEBRIEF_HEADER_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_DEBRIEF_HEADERS.TASK_ASSIGNMENT_ID JTF_TASK_ASSIGNMENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_DEBRIEF_LINES.DEBRIEF_HEADER_ID CSF_DEBRIEF_HEADERS

[top of page]

CSF.CSF_DEBRIEF_HEADERS does not reference any database object

CSF.CSF_DEBRIEF_HEADERS is referenced by following:

APPS
SYNONYM - CSF_DEBRIEF_HEADERS

[top of page]

Table: CSF_DEBRIEF_LINES

Description: Field Service Report lines information
Primary Key: CSF_DEBRIEF_LINES_PK
  1. DEBRIEF_LINE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_DEBRIEF_LINES.DEBRIEF_HEADER_ID CSF_DEBRIEF_HEADERS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CS_ESTIMATE_DETAILS.ORIGINAL_SOURCE_ID CSF_DEBRIEF_LINES

[top of page]

CSF.CSF_DEBRIEF_LINES does not reference any database object

CSF.CSF_DEBRIEF_LINES is referenced by following:

APPS
SYNONYM - CSF_DEBRIEF_LINES

[top of page]

Table: CSF_EXT_LOCATIONS

Description:

[top of page]

CSF.CSF_EXT_LOCATIONS does not reference any database object

CSF.CSF_EXT_LOCATIONS is referenced by following:

APPS
SYNONYM - CSF_EXT_LOCATIONS

[top of page]

Table: CSF_GNTICONS_SETUP_B

Description:

[top of page]

CSF.CSF_GNTICONS_SETUP_B does not reference any database object

CSF.CSF_GNTICONS_SETUP_B is referenced by following:

APPS
SYNONYM - CSF_GNTICONS_SETUP_B

[top of page]

Table: CSF_LF_BLOCKS

Description: Defines the available address range for a segment
Primary Key: CSF_LF_BLOCKS_PK
  1. BLOCK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_BLOCKS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS

[top of page]

CSF.CSF_LF_BLOCKS does not reference any database object

CSF.CSF_LF_BLOCKS is referenced by following:

APPS
SYNONYM - CSF_LF_BLOCKS

[top of page]

Table: CSF_LF_NAMES

Description: Stores all Name information for the Location Finder
Primary Key: CSF_LF_NAMES_PK
  1. NAME_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_NAMES.NAME_ID CSF_LF_NAMES
CSF_LF_POI_NAMES.NAME_ID CSF_LF_NAMES
CSF_LF_ROADSEGM_NAMES.NAME_ID CSF_LF_NAMES

[top of page]

CSF.CSF_LF_NAMES does not reference any database object

CSF.CSF_LF_NAMES is referenced by following:

APPS
SYNONYM - CSF_LF_NAMES

[top of page]

Table: CSF_LF_PLACES

Description: Contains all Administrative areas and Zones
Primary Key: CSF_LF_PLACES_PK
  1. PLACE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_NAMES.PLACE_ID CSF_LF_PLACES
CSF_LF_PLACE_POSTCS.PLACE_ID CSF_LF_PLACES
CSF_LF_POIS.PLACE_ID CSF_LF_PLACES
CSF_LF_ROADSEGM_PLACES.PLACE_ID CSF_LF_PLACES

[top of page]

CSF.CSF_LF_PLACES does not reference any database object

CSF.CSF_LF_PLACES is referenced by following:

APPS
SYNONYM - CSF_LF_PLACES

[top of page]

Table: CSF_LF_PLACE_NAMES

Description: Defines relation between Place and Name
Primary Key: CSF_LF_PLACE_NAMES_PK
  1. PLACE_NAME_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_NAMES.PLACE_ID CSF_LF_PLACES
CSF_LF_PLACE_NAMES.NAME_ID CSF_LF_NAMES

[top of page]

CSF.CSF_LF_PLACE_NAMES does not reference any database object

CSF.CSF_LF_PLACE_NAMES is referenced by following:

APPS
SYNONYM - CSF_LF_PLACE_NAMES

[top of page]

Table: CSF_LF_PLACE_POSTCS

Description: Defines relation between Place and Postcode tables
Primary Key: CSF_LF_PLACE_POSTCS_PK
  1. PLACE_POSTCODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_POSTCS.PLACE_ID CSF_LF_PLACES
CSF_LF_PLACE_POSTCS.POSTAL_CODE_ID CSF_LF_POSTCODES

[top of page]

CSF.CSF_LF_PLACE_POSTCS does not reference any database object

CSF.CSF_LF_PLACE_POSTCS is referenced by following:

APPS
SYNONYM - CSF_LF_PLACE_POSTCS

[top of page]

Table: CSF_LF_POIS

Description: Stores POI (points of interests) in the roadnetwork that are known by the name for LF
Primary Key: CSF_LF_POIS_PK
  1. POI_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_POIS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_POIS.PLACE_ID CSF_LF_PLACES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_POI_NAMES.POI_ID CSF_LF_POIS

[top of page]

CSF.CSF_LF_POIS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_LF_POIS is referenced by following:

APPS
SYNONYM - CSF_LF_POIS

[top of page]

Table: CSF_LF_POI_NAMES

Description: Defines the relation between POI and Name tables
Primary Key: CSF_LF_POI_NAMES_PK
  1. POI_NAME_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_POI_NAMES.NAME_ID CSF_LF_NAMES
CSF_LF_POI_NAMES.POI_ID CSF_LF_POIS

[top of page]

CSF.CSF_LF_POI_NAMES does not reference any database object

CSF.CSF_LF_POI_NAMES is referenced by following:

APPS
SYNONYM - CSF_LF_POI_NAMES

[top of page]

Table: CSF_LF_POSTCODES

Description: Stores the Postcode information and the centroid of each Postcode area
Primary Key: CSF_LF_POSTCODES_PK
  1. POSTAL_CODE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_PLACE_POSTCS.POSTAL_CODE_ID CSF_LF_POSTCODES
CSF_LF_ROADSEGM_POSTS.POSTAL_CODE_ID CSF_LF_POSTCODES

[top of page]

CSF.CSF_LF_POSTCODES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_LF_POSTCODES is referenced by following:

APPS
SYNONYM - CSF_LF_POSTCODES

[top of page]

Table: CSF_LF_ROADSEGMENTS

Description: Stores roadsegments with their navigable attributes
Primary Key: CSF_LF_ROADSEGMENTS_PK
  1. ROADSEGMENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_LF_BLOCKS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_POIS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_ROADSEGM_NAMES.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_ROADSEGM_PLACES.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS
CSF_LF_ROADSEGM_POSTS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS

[top of page]

CSF.CSF_LF_ROADSEGMENTS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_LF_ROADSEGMENTS is referenced by following:

APPS
SYNONYM - CSF_LF_ROADSEGMENTS

[top of page]

Table: CSF_LF_ROADSEGM_NAMES

Description: Defines the relation between roadsegments and the name table
Primary Key: CSF_LF_ROADSEGM_NAMES_PK
  1. ROADSEGMENT_NAME_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_ROADSEGM_NAMES.NAME_ID CSF_LF_NAMES
CSF_LF_ROADSEGM_NAMES.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS

[top of page]

CSF.CSF_LF_ROADSEGM_NAMES does not reference any database object

CSF.CSF_LF_ROADSEGM_NAMES is referenced by following:

APPS
SYNONYM - CSF_LF_ROADSEGM_NAMES

[top of page]

Table: CSF_LF_ROADSEGM_PLACES

Description: Defines relation between Roadsegments and Places
Primary Key: CSF_LF_ROADSEGM_PLACES_PK
  1. ROADSEGM_PLACE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_ROADSEGM_PLACES.PLACE_ID CSF_LF_PLACES
CSF_LF_ROADSEGM_PLACES.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS

[top of page]

CSF.CSF_LF_ROADSEGM_PLACES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_LF_ROADSEGM_PLACES is referenced by following:

APPS
SYNONYM - CSF_LF_ROADSEGM_PLACES

[top of page]

Table: CSF_LF_ROADSEGM_POSTS

Description: Defines relation between Roadsegment and Postcodes
Primary Key: CSF_LF_ROADSEGM_POSTS_PK
  1. ROADSEGMENT_POSTCODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_LF_ROADSEGM_POSTS.POSTAL_CODE_ID CSF_LF_POSTCODES
CSF_LF_ROADSEGM_POSTS.ROADSEGMENT_ID CSF_LF_ROADSEGMENTS

[top of page]

CSF.CSF_LF_ROADSEGM_POSTS does not reference any database object

CSF.CSF_LF_ROADSEGM_POSTS is referenced by following:

APPS
SYNONYM - CSF_LF_ROADSEGM_POSTS

[top of page]

Table: CSF_L_AGENDALAYOUTS

Description: Agenda Layout on the Laptop
Primary Key: CSF_L_AGENDALAYOUTS_PK
  1. AGENDALAYOUT_ID

[top of page]

CSF.CSF_L_AGENDALAYOUTS does not reference any database object

CSF.CSF_L_AGENDALAYOUTS is referenced by following:

APPS
SYNONYM - CSF_L_AGENDALAYOUTS

[top of page]

Table: CSF_L_QUERIES

Description: List of Queries
Primary Key: CSF_L_QUERIES_PK
  1. QUERY_ID

[top of page]

CSF.CSF_L_QUERIES does not reference any database object

CSF.CSF_L_QUERIES is referenced by following:

APPS
SYNONYM - CSF_L_QUERIES

[top of page]

Table: CSF_L_QUERYREQUESTS

Description: Requests for executing Queries
Primary Key: CSF_L_QUERYREQUESTS_PK
  1. QUERYREQUEST_ID

[top of page]

CSF.CSF_L_QUERYREQUESTS does not reference any database object

CSF.CSF_L_QUERYREQUESTS is referenced by following:

APPS
SYNONYM - CSF_L_QUERYREQUESTS

[top of page]

Table: CSF_L_SODS

Description: Service Order Description
Primary Key: CSF_L_SODS_PK
  1. SOD_ID

[top of page]

CSF.CSF_L_SODS does not reference any database object

CSF.CSF_L_SODS is referenced by following:

APPS
SYNONYM - CSF_L_SODS

[top of page]

Table: CSF_L_SOTS

Description: Service Order Types
Primary Key: CSF_L_SOTS_PK
  1. SOT_ID

[top of page]

CSF.CSF_L_SOTS does not reference any database object

CSF.CSF_L_SOTS is referenced by following:

APPS
SYNONYM - CSF_L_SOTS

[top of page]

Table: CSF_MAP_ACCESS_HOURS_B

Description:
Primary Key: CSF_MAP_ACCESS_HOURS_B_PK
  1. ACCESS_HOUR_MAP_ID

[top of page]

CSF.CSF_MAP_ACCESS_HOURS_B does not reference any database object

CSF.CSF_MAP_ACCESS_HOURS_B is referenced by following:

APPS
SYNONYM - CSF_MAP_ACCESS_HOURS_B

[top of page]

Table: CSF_MAP_ACCESS_HOURS_TL

Description:
Primary Key: CSF_MAP_ACCESS_HOURS_TL_PK
  1. ACCESS_HOUR_MAP_ID
  2. LANGUAGE

[top of page]

CSF.CSF_MAP_ACCESS_HOURS_TL does not reference any database object

CSF.CSF_MAP_ACCESS_HOURS_TL is referenced by following:

APPS
SYNONYM - CSF_MAP_ACCESS_HOURS_TL

[top of page]

Table: CSF_MD_ADM_BOUNDS

Description: Defines an administrative boundary defined in a country.
Primary Key: CSF_MD_ADM_BOUNDS_PK
  1. ADMIN_BOUND_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_ADM_BOUNDS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.ADMIN_BOUND_ID CSF_MD_ADM_BOUNDS

[top of page]

CSF.CSF_MD_ADM_BOUNDS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_ADM_BOUNDS is referenced by following:

APPS
SYNONYM - CSF_MD_ADM_BOUNDS
MATERIALIZED VIEW - CSF_MD_ADM_BOUNDS_MAT_V

[top of page]

Table: CSF_MD_HYDROS

Description: Defines a hydrographic feature.
Primary Key: CSF_MD_HYDROS_PK
  1. HYDROGRAPHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_HYDROS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.HYDROGRAPHY_ID CSF_MD_HYDROS

[top of page]

CSF.CSF_MD_HYDROS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_HYDROS is referenced by following:

APPS
SYNONYM - CSF_MD_HYDROS
MATERIALIZED VIEW - CSF_MD_HYDROS_MAT_V

[top of page]

Table: CSF_MD_INST_STYLE_SHTS

Description: Defines map instance style sheets
Primary Key: CSF_MS_INST_STYLE_SHTS_PK
  1. INST_STYLE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_ADM_BOUNDS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_HYDROS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_RD_SEGS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_LAND_USES.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_LYR_METADATA.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_POIS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_RAIL_SEGS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS

[top of page]

CSF.CSF_MD_INST_STYLE_SHTS does not reference any database object

CSF.CSF_MD_INST_STYLE_SHTS is referenced by following:

APPS
SYNONYM - CSF_MD_INST_STYLE_SHTS

[top of page]

Table: CSF_MD_LAND_USES

Description: Defines the geometry of various land usages
Primary Key: CSF_MD_LAND_USES_PK
  1. LANDUSE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_LAND_USES.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.LANDUSE_ID CSF_MD_LAND_USES

[top of page]

CSF.CSF_MD_LAND_USES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_LAND_USES is referenced by following:

APPS
SYNONYM - CSF_MD_LAND_USES
MATERIALIZED VIEW - CSF_MD_LAND_USES_MAT_V

[top of page]

Table: CSF_MD_LYR_METADATA

Description: Defines map display layer metadata
Primary Key: CSF_MD_LYR_METADATA_PK
  1. LAYER_METADATA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_LYR_METADATA.LAYER_STYLE_SHEET_ID CSF_MD_LYR_STYLE_SHTS
CSF_MD_LYR_METADATA.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
CSF_MD_LYR_METADATA.THEME_METADATA_ID CSF_MD_THEME_METADATA

[top of page]

CSF.CSF_MD_LYR_METADATA does not reference any database object

CSF.CSF_MD_LYR_METADATA is referenced by following:

APPS
SYNONYM - CSF_MD_LYR_METADATA

[top of page]

Table: CSF_MD_LYR_STYLE_SHTS

Description: Defines the visual display characteristics of a map layer
Primary Key: CSF_MD_LYR_STYLE_SHTS_PK
  1. LAYER_STYLE_SHEET_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_LYR_METADATA.LAYER_STYLE_SHEET_ID CSF_MD_LYR_STYLE_SHTS

[top of page]

CSF.CSF_MD_LYR_STYLE_SHTS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_LYR_STYLE_SHTS is referenced by following:

APPS
SYNONYM - CSF_MD_LYR_STYLE_SHTS

[top of page]

Table: CSF_MD_NAMES

Description: Defines the name of the given geographic entities in the model.
Primary Key: CSF_MD_NAMES_PK
  1. NAME_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.HYDROGRAPHY_ID CSF_MD_HYDROS
CSF_MD_NAMES.ADMIN_BOUND_ID CSF_MD_ADM_BOUNDS
CSF_MD_NAMES.LANDUSE_ID CSF_MD_LAND_USES
CSF_MD_NAMES.RAILROAD_SEGMENT_ID CSF_MD_RAIL_SEGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_POI_NM_ASGNS.NAME_ID CSF_MD_NAMES
CSF_MD_RDSEG_NM_ASGNS.NAME_ID CSF_MD_NAMES

[top of page]

CSF.CSF_MD_NAMES does not reference any database object

CSF.CSF_MD_NAMES is referenced by following:

APPS
MATERIALIZED VIEW - CSF_MD_ADM_BOUNDS_MAT_V
MATERIALIZED VIEW - CSF_MD_HYDROS_MAT_V
MATERIALIZED VIEW - CSF_MD_LAND_USES_MAT_V
SYNONYM - CSF_MD_NAMES
MATERIALIZED VIEW - CSF_MD_POIS_MAT_V
MATERIALIZED VIEW - CSF_MD_RAIL_SEGS_MAT_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN0_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN1_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN2_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN3_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN4_V

[top of page]

Table: CSF_MD_OM_ADMINS

Description:
Primary Key: CSF_MD_OM_ADMINS_PK
  1. ADMIN_BOUND_ID

[top of page]

CSF.CSF_MD_OM_ADMINS references the following:

MDSYS
TYPE - SDO_ELEM_INFO_ARRAY
TYPE - SDO_GEOMETRY
TYPE - SDO_ORDINATE_ARRAY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_OM_ADMINS is referenced by following:

APPS
SYNONYM - CSF_MD_OM_ADMINS

[top of page]

Table: CSF_MD_OM_HYDROS

Description:
Primary Key: CSF_MD_OM_HYDROS_PK
  1. HYDROGRAPHY_ID

[top of page]

CSF.CSF_MD_OM_HYDROS references the following:

MDSYS
TYPE - SDO_ELEM_INFO_ARRAY
TYPE - SDO_GEOMETRY
TYPE - SDO_ORDINATE_ARRAY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_OM_HYDROS is referenced by following:

APPS
SYNONYM - CSF_MD_OM_HYDROS

[top of page]

Table: CSF_MD_OM_POIS

Description:
Primary Key: CSF_MD_OM_POIS_PK
  1. POI_ID

[top of page]

CSF.CSF_MD_OM_POIS references the following:

MDSYS
TYPE - SDO_ELEM_INFO_ARRAY
TYPE - SDO_GEOMETRY
TYPE - SDO_ORDINATE_ARRAY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_OM_POIS is referenced by following:

APPS
SYNONYM - CSF_MD_OM_POIS

[top of page]

Table: CSF_MD_OM_ROADS

Description:
Primary Key: CSF_MD_OM_ROADS_PK
  1. ROAD_SEGMENT_ID

[top of page]

CSF.CSF_MD_OM_ROADS references the following:

MDSYS
TYPE - SDO_ELEM_INFO_ARRAY
TYPE - SDO_GEOMETRY
TYPE - SDO_ORDINATE_ARRAY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_OM_ROADS is referenced by following:

APPS
SYNONYM - CSF_MD_OM_ROADS

[top of page]

Table: CSF_MD_POIS

Description: This table defines POI (point of interest) for Map Display
Primary Key: CSF_MD_POIS_PK
  1. POI_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_POIS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_POI_NM_ASGNS.POI_ID CSF_MD_POIS

[top of page]

CSF.CSF_MD_POIS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_POIS is referenced by following:

APPS
SYNONYM - CSF_MD_POIS
MATERIALIZED VIEW - CSF_MD_POIS_MAT_V

[top of page]

Table: CSF_MD_POI_NM_ASGNS

Description: Defines the relationship between the MD NAME and the MD NAMES and MD POI tables.
Primary Key: CSF_MD_POI_NM_ASGNS_PK
  1. POI_NM_ASGN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_POI_NM_ASGNS.NAME_ID CSF_MD_NAMES
CSF_MD_POI_NM_ASGNS.POI_ID CSF_MD_POIS

[top of page]

CSF.CSF_MD_POI_NM_ASGNS does not reference any database object

CSF.CSF_MD_POI_NM_ASGNS is referenced by following:

APPS
MATERIALIZED VIEW - CSF_MD_POIS_MAT_V
SYNONYM - CSF_MD_POI_NM_ASGNS

[top of page]

Table: CSF_MD_RAIL_SEGS

Description: Defines an individual line segment representing a railroad.
Primary Key: CSF_MD_RAIL_SEGS_PK
  1. RAILROAD_SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_RAIL_SEGS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_NAMES.RAILROAD_SEGMENT_ID CSF_MD_RAIL_SEGS

[top of page]

CSF.CSF_MD_RAIL_SEGS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_RAIL_SEGS is referenced by following:

APPS
SYNONYM - CSF_MD_RAIL_SEGS
MATERIALIZED VIEW - CSF_MD_RAIL_SEGS_MAT_V

[top of page]

Table: CSF_MD_RDSEG_NM_ASGNS

Description: Defines the relation between the road segments and names table.
Primary Key: CSF_MD_RDSEG_NM_ASGNS_PK
  1. RD_SEG_NM_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_RDSEG_NM_ASGNS.ROAD_SEGMENT_ID CSF_MD_RD_SEGS
CSF_MD_RDSEG_NM_ASGNS.NAME_ID CSF_MD_NAMES

[top of page]

CSF.CSF_MD_RDSEG_NM_ASGNS does not reference any database object

CSF.CSF_MD_RDSEG_NM_ASGNS is referenced by following:

APPS
SYNONYM - CSF_MD_RDSEG_NM_ASGNS
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN0_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN1_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN2_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN3_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN4_V

[top of page]

Table: CSF_MD_RD_SEGS

Description: Defines a navigable feature.
Primary Key: CSF_MD_RD_SEGS_PK
  1. ROAD_SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_MD_RD_SEGS.INST_STYLE_ID CSF_MD_INST_STYLE_SHTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_RDSEG_NM_ASGNS.ROAD_SEGMENT_ID CSF_MD_RD_SEGS

[top of page]

CSF.CSF_MD_RD_SEGS references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_MD_RD_SEGS is referenced by following:

APPS
SYNONYM - CSF_MD_RD_SEGS
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN0_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN1_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN2_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN3_V
MATERIALIZED VIEW - CSF_MD_RD_SEGS_FUN4_V

[top of page]

Table: CSF_MD_THEME_METADATA

Description: Defines the version information of an entire theme.
Primary Key: CSF_MD_THEME_METADATA_PK
  1. THEME_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_MD_LYR_METADATA.THEME_METADATA_ID CSF_MD_THEME_METADATA

[top of page]

CSF.CSF_MD_THEME_METADATA does not reference any database object

CSF.CSF_MD_THEME_METADATA is referenced by following:

APPS
SYNONYM - CSF_MD_THEME_METADATA

[top of page]

Table: CSF_PARAMS

Description: Parameters for Laptop and Palm
Primary Key: CSF_PARAMS_PK
  1. PARAM_ID

[top of page]

CSF.CSF_PARAMS does not reference any database object

CSF.CSF_PARAMS is referenced by following:

APPS
SYNONYM - CSF_PARAMS

[top of page]

Table: CSF_PHONETIC_VALUES

Description:
Primary Key: CSF_PH_VAL_PK
  1. PHONETICS_ID

[top of page]

CSF.CSF_PHONETIC_VALUES does not reference any database object

CSF.CSF_PHONETIC_VALUES is referenced by following:

APPS
SYNONYM - CSF_PHONETIC_VALUES

[top of page]

Table: CSF_PLAN_TERRS

Description: Associative (relationship) table to map between the territory and resource group tables
Primary Key: CSF_PLAN_TERRS_PK
  1. PLAN_TERR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_PLAN_TERRS.GROUP_ID JTF_RS_GROUPS_B
CSF_PLAN_TERRS.TERR_ID JTF_TERR_ALL

[top of page]

CSF.CSF_PLAN_TERRS does not reference any database object

CSF.CSF_PLAN_TERRS is referenced by following:

APPS
SYNONYM - CSF_PLAN_TERRS

[top of page]

Table: CSF_RATING_SCALES_B

Description: Skill types
Primary Key: CSF_RATING_SCALE_B_PK
  1. RATING_SCALE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_SKILL_LEVELS_B.RATING_SCALE_ID CSF_RATING_SCALES_B
CSF_SKILL_TYPES_B.RATING_SCALE_ID CSF_RATING_SCALES_B

[top of page]

CSF.CSF_RATING_SCALES_B does not reference any database object

CSF.CSF_RATING_SCALES_B is referenced by following:

APPS
SYNONYM - CSF_RATING_SCALES_B

[top of page]

Table: CSF_RATING_SCALES_TL

Description: Skill types
Primary Key: CSF_RATING_SCALES_TL_PK
  1. RATING_SCALE_ID
  2. LANGUAGE

[top of page]

CSF.CSF_RATING_SCALES_TL does not reference any database object

CSF.CSF_RATING_SCALES_TL is referenced by following:

APPS
SYNONYM - CSF_RATING_SCALES_TL

[top of page]

Table: CSF_REQUIRED_SKILLS_B

Description: This table is used to see which object has required skills
Primary Key: CSF_REQUIRED_SKILLS_B_PK
  1. REQUIRED_SKILL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_REQUIRED_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
CSF_REQUIRED_SKILLS_B.SKILL_ID CSF_SKILLS_B
CSF_REQUIRED_SKILLS_B.SKILL_LEVEL_ID CSF_SKILL_LEVELS_B

[top of page]

CSF.CSF_REQUIRED_SKILLS_B does not reference any database object

CSF.CSF_REQUIRED_SKILLS_B is referenced by following:

APPS
SYNONYM - CSF_REQUIRED_SKILLS_B

[top of page]

Table: CSF_RESOURCE_SKILLS_B

Description: Skill types
Primary Key: CSF_RESOURCE_SKILLS_B_PK
  1. RESOURCE_SKILL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_RESOURCE_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
CSF_RESOURCE_SKILLS_B.SKILL_ID CSF_SKILLS_B
CSF_RESOURCE_SKILLS_B.SKILL_LEVEL_ID CSF_SKILL_LEVELS_B

[top of page]

CSF.CSF_RESOURCE_SKILLS_B does not reference any database object

CSF.CSF_RESOURCE_SKILLS_B is referenced by following:

APPS
SYNONYM - CSF_RESOURCE_SKILLS_B

[top of page]

Table: CSF_R_FILTERS_ALL_B

Description: Data table with scheduler filter definitions
Primary Key: CSF_R_FILTERS_ALL_B_PK
  1. FILTER_ID

[top of page]

CSF.CSF_R_FILTERS_ALL_B does not reference any database object

CSF.CSF_R_FILTERS_ALL_B is referenced by following:

APPS
SYNONYM - CSF_R_FILTERS_ALL_B

[top of page]

Table: CSF_R_FILTERS_ALL_TL

Description: Translated companion to table CSF_R_FILTER_DEFS_ALL_B.
Primary Key: CSF_R_FILTERS_ALL_TL_PK
  1. FILTER_ID
  2. LANGUAGE

[top of page]

CSF.CSF_R_FILTERS_ALL_TL does not reference any database object

CSF.CSF_R_FILTERS_ALL_TL is referenced by following:

APPS
SYNONYM - CSF_R_FILTERS_ALL_TL

[top of page]

Table: CSF_R_FILTER_PARAMS_B

Description: Filter parameters.
Primary Key: CSF_R_FILTER_PARAMS_B_PK
  1. FILTER_PARAM_ID

[top of page]

CSF.CSF_R_FILTER_PARAMS_B does not reference any database object

CSF.CSF_R_FILTER_PARAMS_B is referenced by following:

APPS
SYNONYM - CSF_R_FILTER_PARAMS_B

[top of page]

Table: CSF_R_FILTER_PARAMS_TL

Description: Translated companion to table CSF_R_FILTER_PARAMS_B.
Primary Key: CSF_R_FILTER_PARAMS_TL_PK
  1. FILTER_PARAM_ID
  2. LANGUAGE

[top of page]

CSF.CSF_R_FILTER_PARAMS_TL does not reference any database object

CSF.CSF_R_FILTER_PARAMS_TL is referenced by following:

APPS
SYNONYM - CSF_R_FILTER_PARAMS_TL

[top of page]

Table: CSF_R_HZ_LOC_EXTNS

Description: This table is for storing locations
Primary Key: CSF_R_HZ_LOC_EXTNS_PK
  1. LOCATION_ID

[top of page]

CSF.CSF_R_HZ_LOC_EXTNS does not reference any database object

CSF.CSF_R_HZ_LOC_EXTNS is referenced by following:

APPS
SYNONYM - CSF_R_HZ_LOC_EXTNS

[top of page]

Table: CSF_R_MESSAGES

Description: Messages
Primary Key: CSF_R_MESSAGES_PK
  1. MESSAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_MESSAGES.REQUEST_TASK_ID CSF_R_REQUEST_TASKS

[top of page]

CSF.CSF_R_MESSAGES does not reference any database object

CSF.CSF_R_MESSAGES is referenced by following:

APPS
SYNONYM - CSF_R_MESSAGES

[top of page]

Table: CSF_R_MESSAGE_TOKENS

Description: Message tokens
Primary Key: CSF_R_MESSAGE_TOKENS_PK
  1. MESSAGE_TOKEN_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_MESSAGE_TOKENS.MESSAGE_ID CSF_R_SCHED_REQUESTS

[top of page]

CSF.CSF_R_MESSAGE_TOKENS does not reference any database object

CSF.CSF_R_MESSAGE_TOKENS is referenced by following:

APPS
SYNONYM - CSF_R_MESSAGE_TOKENS

[top of page]

Table: CSF_R_PLAN_OPTIONS

Description: This table is for storing the planoptions
Primary Key: CSF_R_PLAN_OPTIONS_PK
  1. PLAN_OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_PLAN_OPTIONS.RESOURCE_RESULT_ID CSF_R_RESOURCE_RESULTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_R_PLAN_OPTION_TASKS.PLAN_OPTION_ID CSF_R_PLAN_OPTIONS

[top of page]

CSF.CSF_R_PLAN_OPTIONS does not reference any database object

CSF.CSF_R_PLAN_OPTIONS is referenced by following:

APPS
SYNONYM - CSF_R_PLAN_OPTIONS

[top of page]

Table: CSF_R_PLAN_OPTION_TASKS

Description: This is a table to store the trips for which the planoptions apply
Primary Key: CSF_R_PLAN_OPTION_TASKS_PK
  1. PLAN_OPTION_TASK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_PLAN_OPTION_TASKS.PLAN_OPTION_ID CSF_R_PLAN_OPTIONS

[top of page]

CSF.CSF_R_PLAN_OPTION_TASKS does not reference any database object

CSF.CSF_R_PLAN_OPTION_TASKS is referenced by following:

APPS
SYNONYM - CSF_R_PLAN_OPTION_TASKS

[top of page]

Table: CSF_R_REQUEST_FILTERS

Description: This table is for storing the filter settings for a request
Primary Key: CSF_R_REQUEST_FILTERS_PK
  1. REQUEST_FILTER_ID

[top of page]

CSF.CSF_R_REQUEST_FILTERS does not reference any database object

CSF.CSF_R_REQUEST_FILTERS is referenced by following:

APPS
SYNONYM - CSF_R_REQUEST_FILTERS

[top of page]

Table: CSF_R_REQUEST_TASKS

Description: This table stores the task needs to be scheduled for a request
Primary Key: CSF_R_REQUEST_TASKS_PK
  1. REQUEST_TASK_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_REQUEST_TASKS.SCHED_REQUEST_ID CSF_R_SCHED_REQUESTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_R_MESSAGES.REQUEST_TASK_ID CSF_R_REQUEST_TASKS
CSF_R_RESOURCE_RESULTS.REQUEST_TASK_ID CSF_R_REQUEST_TASKS

[top of page]

CSF.CSF_R_REQUEST_TASKS does not reference any database object

CSF.CSF_R_REQUEST_TASKS is referenced by following:

APPS
SYNONYM - CSF_R_REQUEST_TASKS

[top of page]

Table: CSF_R_REQUEST_VALUES

Description: This table is the table tostore the values of the filters
Primary Key: CSF_R_REQUEST_VALUES_PK
  1. REQUEST_VALUE_ID

[top of page]

CSF.CSF_R_REQUEST_VALUES does not reference any database object

CSF.CSF_R_REQUEST_VALUES is referenced by following:

APPS
SYNONYM - CSF_R_REQUEST_VALUES

[top of page]

Table: CSF_R_RESOURCE_RESULTS

Description: Table containing the result of the 'resoure filters' (Prefferred, Territory, Geography, Skills)
Primary Key: CSF_R_RESOURCE_RESULTS_PK
  1. RESOURCE_RESULT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_RESOURCE_RESULTS.REQUEST_TASK_ID CSF_R_REQUEST_TASKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_R_PLAN_OPTIONS.RESOURCE_RESULT_ID CSF_R_RESOURCE_RESULTS
CSF_R_SPARES_OPTIONS.RESOURCE_RESULT_ID CSF_R_RESOURCE_RESULTS

[top of page]

CSF.CSF_R_RESOURCE_RESULTS does not reference any database object

CSF.CSF_R_RESOURCE_RESULTS is referenced by following:

APPS
SYNONYM - CSF_R_RESOURCE_RESULTS

[top of page]

Table: CSF_R_SCENARIOS_ALL_B

Description: Scenario definitions.
Primary Key: CSF_R_SCENARIOS_ALL_B_PK
  1. SCENARIO_ID

[top of page]

CSF.CSF_R_SCENARIOS_ALL_B does not reference any database object

CSF.CSF_R_SCENARIOS_ALL_B is referenced by following:

APPS
SYNONYM - CSF_R_SCENARIOS_ALL_B

[top of page]

Table: CSF_R_SCENARIOS_ALL_TL

Description: Translated companion to table CSF_R_SCENAR_DEFS_ALL_TL.
Primary Key: CSF_R_SCENAR_DEFS_ALL_TL_PK
  1. SCENARIO_ID
  2. LANGUAGE

[top of page]

CSF.CSF_R_SCENARIOS_ALL_TL does not reference any database object

CSF.CSF_R_SCENARIOS_ALL_TL is referenced by following:

APPS
SYNONYM - CSF_R_SCENARIOS_ALL_TL

[top of page]

Table: CSF_R_SCENARIO_FILTERS

Description: Defines the associations between scenarios and filters.
Primary Key: CSF_R_SCENARIO_FILTERS_PK
  1. SCENARIO_FILTER_ID

[top of page]

CSF.CSF_R_SCENARIO_FILTERS does not reference any database object

CSF.CSF_R_SCENARIO_FILTERS is referenced by following:

APPS
SYNONYM - CSF_R_SCENARIO_FILTERS

[top of page]

Table: CSF_R_SCENARIO_VALUES

Description: Filter parameter values.
Primary Key: CSF_R_SCENARIO_VALUES_PK
  1. SCENARIO_VALUE_ID

[top of page]

CSF.CSF_R_SCENARIO_VALUES does not reference any database object

CSF.CSF_R_SCENARIO_VALUES is referenced by following:

APPS
SYNONYM - CSF_R_SCENARIO_VALUES

[top of page]

Table: CSF_R_SCHED_REQUESTS

Description: Scheduler requests.
Primary Key: CSF_R_SCHED_REQUEST_PK
  1. SCHED_REQUEST_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_R_MESSAGE_TOKENS.MESSAGE_ID CSF_R_SCHED_REQUESTS
CSF_R_REQUEST_TASKS.SCHED_REQUEST_ID CSF_R_SCHED_REQUESTS

[top of page]

CSF.CSF_R_SCHED_REQUESTS does not reference any database object

CSF.CSF_R_SCHED_REQUESTS is referenced by following:

APPS
SYNONYM - CSF_R_SCHED_REQUESTS

[top of page]

Table: CSF_R_SPARES_OPTIONS

Description: The table that contains the result(s) after the spares api is called
Primary Key: CSF_R_SPARES_OPTIONS_PK
  1. SPARES_OPTION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_R_SPARES_OPTIONS.RESOURCE_RESULT_ID CSF_R_RESOURCE_RESULTS

[top of page]

CSF.CSF_R_SPARES_OPTIONS does not reference any database object

CSF.CSF_R_SPARES_OPTIONS is referenced by following:

APPS
SYNONYM - CSF_R_SPARES_OPTIONS

[top of page]

Table: CSF_R_TASK_ASSIGN_EXTNS

Description: Table to store the task assignment extensions
Primary Key: CSF_R_TASK_ASSIGN_PK
  1. TASK_ASSIGNMENT_ID

[top of page]

CSF.CSF_R_TASK_ASSIGN_EXTNS does not reference any database object

CSF.CSF_R_TASK_ASSIGN_EXTNS is referenced by following:

APPS
SYNONYM - CSF_R_TASK_ASSIGN_EXTNS

[top of page]

Table: CSF_R_TDS_ROUTE_CACHE

Description: Table to store cache routes

[top of page]

CSF.CSF_R_TDS_ROUTE_CACHE does not reference any database object

CSF.CSF_R_TDS_ROUTE_CACHE is referenced by following:

APPS
SYNONYM - CSF_R_TDS_ROUTE_CACHE

[top of page]

Table: CSF_SDM_CTRY_PROFILES

Description: Defines country profiles
Primary Key: CSF_SDM_CTRY_PROFILES_PK
  1. COUNTRY_PROFILE_ID

[top of page]

CSF.CSF_SDM_CTRY_PROFILES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_SDM_CTRY_PROFILES is referenced by following:

APPS
SYNONYM - CSF_SDM_CTRY_PROFILES

[top of page]

Table: CSF_SKILLS_B

Description: Skill types
Primary Key: CSF_SKILLS_B_PK
  1. SKILL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_REQUIRED_SKILLS_B.SKILL_ID CSF_SKILLS_B
CSF_RESOURCE_SKILLS_B.SKILL_ID CSF_SKILLS_B

[top of page]

CSF.CSF_SKILLS_B does not reference any database object

CSF.CSF_SKILLS_B is referenced by following:

APPS
SYNONYM - CSF_SKILLS_B

[top of page]

Table: CSF_SKILLS_TL

Description: Skill types
Primary Key: CSF_SKILLS_TL_PK
  1. SKILL_ID
  2. LANGUAGE

[top of page]

CSF.CSF_SKILLS_TL does not reference any database object

CSF.CSF_SKILLS_TL is referenced by following:

APPS
SYNONYM - CSF_SKILLS_TL

[top of page]

Table: CSF_SKILL_LEVELS_B

Description: Skill types
Primary Key: CSF_SKILL_LEVELS_B_PK
  1. SKILL_LEVEL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_SKILL_LEVELS_B.RATING_SCALE_ID CSF_RATING_SCALES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_REQUIRED_SKILLS_B.SKILL_LEVEL_ID CSF_SKILL_LEVELS_B
CSF_RESOURCE_SKILLS_B.SKILL_LEVEL_ID CSF_SKILL_LEVELS_B

[top of page]

CSF.CSF_SKILL_LEVELS_B does not reference any database object

CSF.CSF_SKILL_LEVELS_B is referenced by following:

APPS
SYNONYM - CSF_SKILL_LEVELS_B

[top of page]

Table: CSF_SKILL_LEVELS_TL

Description: Skill types
Primary Key: CSF_SKILL_LEVELS_TL_PK
  1. SKILL_LEVEL_ID

[top of page]

CSF.CSF_SKILL_LEVELS_TL does not reference any database object

CSF.CSF_SKILL_LEVELS_TL is referenced by following:

APPS
SYNONYM - CSF_SKILL_LEVELS_TL

[top of page]

Table: CSF_SKILL_TYPES_B

Description: Skill types
Primary Key: CSF_SKILL_TYPES_B_PK
  1. SKILL_TYPE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_SKILL_TYPES_B.RATING_SCALE_ID CSF_RATING_SCALES_B
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_REQUIRED_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
CSF_RESOURCE_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B
CSF_SKILLS_B.SKILL_TYPE_ID CSF_SKILL_TYPES_B

[top of page]

CSF.CSF_SKILL_TYPES_B does not reference any database object

CSF.CSF_SKILL_TYPES_B is referenced by following:

APPS
SYNONYM - CSF_SKILL_TYPES_B

[top of page]

Table: CSF_SKILL_TYPES_TL

Description: Skill types
Primary Key: CSF_SKILL_TYPES_TL_PK
  1. SKILL_TYPE_ID

[top of page]

CSF.CSF_SKILL_TYPES_TL does not reference any database object

CSF.CSF_SKILL_TYPES_TL is referenced by following:

APPS
SYNONYM - CSF_SKILL_TYPES_TL

[top of page]

Table: CSF_TDS_BINARY_MAPS

Description: Defines the digital roadmap for route calculation.
Primary Key: CSF_TDS_BINARY_MAPS_PK
  1. BINARY_MAP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_BINARY_TILES.BINARY_MAP_ID CSF_TDS_BINARY_MAPS

[top of page]

CSF.CSF_TDS_BINARY_MAPS does not reference any database object

CSF.CSF_TDS_BINARY_MAPS is referenced by following:

APPS
SYNONYM - CSF_TDS_BINARY_MAPS

[top of page]

Table: CSF_TDS_BINARY_TILES

Description: Defines a spatial index to a digital map.
Primary Key: CSF_TDS_BINARY_TILES_PK
  1. BINARY_TILE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_BINARY_TILES.BINARY_MAP_ID CSF_TDS_BINARY_MAPS

[top of page]

CSF.CSF_TDS_BINARY_TILES does not reference any database object

CSF.CSF_TDS_BINARY_TILES is referenced by following:

APPS
SYNONYM - CSF_TDS_BINARY_TILES

[top of page]

Table: CSF_TDS_CONDITIONS

Description: This table stores the conditions for the TDS.
Primary Key: CSF_TDS_CONDITIONS_PK
  1. CONDITION_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_CONDITIONS.INTERVAL_ID CSF_TDS_INTERVALS
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_COND_SEGS.CONDITION_ID CSF_TDS_CONDITIONS

[top of page]

CSF.CSF_TDS_CONDITIONS does not reference any database object

CSF.CSF_TDS_CONDITIONS is referenced by following:

APPS
SYNONYM - CSF_TDS_CONDITIONS

[top of page]

Table: CSF_TDS_COND_SEGS

Description: Intersection table for condition and segments
Primary Key: CSF_TDS_COND_SEGS_PK
  1. CONDITION_SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_COND_SEGS.CONDITION_ID CSF_TDS_CONDITIONS
CSF_TDS_COND_SEGS.SEGMENT_ID CSF_TDS_SEGMENTS

[top of page]

CSF.CSF_TDS_COND_SEGS does not reference any database object

CSF.CSF_TDS_COND_SEGS is referenced by following:

APPS
SYNONYM - CSF_TDS_COND_SEGS

[top of page]

Table: CSF_TDS_INTERVALS

Description: The intervals table
Primary Key: CSF_TDS_INTERVALS_PK
  1. INTERVAL_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_CONDITIONS.INTERVAL_ID CSF_TDS_INTERVALS
CSF_TDS_RDBLCK_INTVLS.INTERVAL_ID CSF_TDS_INTERVALS
CSF_TDS_SEGMENTS.INTERVAL_ID CSF_TDS_INTERVALS

[top of page]

CSF.CSF_TDS_INTERVALS does not reference any database object

CSF.CSF_TDS_INTERVALS is referenced by following:

APPS
SYNONYM - CSF_TDS_INTERVALS

[top of page]

Table: CSF_TDS_NODES

Description: The nodes table
Primary Key: TDS_NODES_PK
  1. NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_NODES.TILE_ID CSF_TDS_TILES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_SEGM_NODES.NODE_ID CSF_TDS_NODES

[top of page]

CSF.CSF_TDS_NODES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_TDS_NODES is referenced by following:

APPS
SYNONYM - CSF_TDS_NODES

[top of page]

Table: CSF_TDS_RDBLCK_INTVLS

Description: Intersection table for Roadblocks and intervals
Primary Key: CSF_TDS_RDBLCK_INTVLS_PK
  1. ROADBLOCK_INTERVAL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_RDBLCK_INTVLS.INTERVAL_ID CSF_TDS_INTERVALS
CSF_TDS_RDBLCK_INTVLS.ROADBLOCK_ID CSF_TDS_ROADBLOCKS

[top of page]

CSF.CSF_TDS_RDBLCK_INTVLS does not reference any database object

CSF.CSF_TDS_RDBLCK_INTVLS is referenced by following:

APPS
SYNONYM - CSF_TDS_RDBLCK_INTVLS

[top of page]

Table: CSF_TDS_RDBLCK_SGMNTS

Description: The relation between RoadBlocks and Segments
Primary Key: CSF_TDS_RDBLCK_SGMNTS_PK
  1. ROADBLOCK_SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_RDBLCK_SGMNTS.ROADBLOCK_ID CSF_TDS_ROADBLOCKS
CSF_TDS_RDBLCK_SGMNTS.SEGMENT_ID CSF_TDS_SEGMENTS

[top of page]

CSF.CSF_TDS_RDBLCK_SGMNTS does not reference any database object

CSF.CSF_TDS_RDBLCK_SGMNTS is referenced by following:

APPS
SYNONYM - CSF_TDS_RDBLCK_SGMNTS

[top of page]

Table: CSF_TDS_ROADBLOCKS

Description: Defines a travel duration delay for a segment.
Primary Key: CSF_TDS_ROADBLOCKS_PK
  1. ROADBLOCK_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_RDBLCK_INTVLS.ROADBLOCK_ID CSF_TDS_ROADBLOCKS
CSF_TDS_RDBLCK_SGMNTS.ROADBLOCK_ID CSF_TDS_ROADBLOCKS

[top of page]

CSF.CSF_TDS_ROADBLOCKS does not reference any database object

CSF.CSF_TDS_ROADBLOCKS is referenced by following:

APPS
SYNONYM - CSF_TDS_ROADBLOCKS

[top of page]

Table: CSF_TDS_ROUTE_CACHE

Description:

[top of page]

CSF.CSF_TDS_ROUTE_CACHE references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_TDS_ROUTE_CACHE is referenced by following:

APPS
SYNONYM - CSF_TDS_ROUTE_CACHE

[top of page]

Table: CSF_TDS_SEGMENTS

Description: Defines a connection between two nodes.
Primary Key: CSF_TDS_SEGMENTS_PK
  1. SEGMENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_SEGMENTS.INTERVAL_ID CSF_TDS_INTERVALS
CSF_TDS_SEGMENTS.TILE_ID CSF_TDS_TILES
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_COND_SEGS.SEGMENT_ID CSF_TDS_SEGMENTS
CSF_TDS_RDBLCK_SGMNTS.SEGMENT_ID CSF_TDS_SEGMENTS
CSF_TDS_SEGM_NODES.SEGMENT_ID CSF_TDS_SEGMENTS

[top of page]

CSF.CSF_TDS_SEGMENTS does not reference any database object

CSF.CSF_TDS_SEGMENTS is referenced by following:

APPS
SYNONYM - CSF_TDS_SEGMENTS

[top of page]

Table: CSF_TDS_SEGM_NODES

Description: Defines the relation between the segments and the nodes table
Primary Key: CSF_TDS_SEGM_NODES_PK
  1. SEGMENT_NODE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
CSF_TDS_SEGM_NODES.NODE_ID CSF_TDS_NODES
CSF_TDS_SEGM_NODES.SEGMENT_ID CSF_TDS_SEGMENTS

[top of page]

CSF.CSF_TDS_SEGM_NODES does not reference any database object

CSF.CSF_TDS_SEGM_NODES is referenced by following:

APPS
SYNONYM - CSF_TDS_SEGM_NODES

[top of page]

Table: CSF_TDS_TILES

Description: Defines the result of spatial index creation (tiling).
Primary Key: CSF_TDS_TILES_PK
  1. TILE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
CSF_TDS_NODES.TILE_ID CSF_TDS_TILES
CSF_TDS_SEGMENTS.TILE_ID CSF_TDS_TILES

[top of page]

CSF.CSF_TDS_TILES references the following:

MDSYS
TYPE - SDO_GEOMETRY
SYS
PACKAGE - STANDARD
CSF.CSF_TDS_TILES is referenced by following:

APPS
SYNONYM - CSF_TDS_TILES

[top of page]

View: CSF_ACCESS_HOURS_VL

[top of page]

APPS.CSF_ACCESS_HOURS_VL references the following:

APPS
SYNONYM - CSF_ACCESS_HOURS_B
SYNONYM - CSF_ACCESS_HOURS_TL
APPS.CSF_ACCESS_HOURS_VL is referenced by following:

APPS
PACKAGE BODY - CSFW_TASKS_PUB
PACKAGE BODY - CSF_ACCESS_HOURS_PUB

[top of page]

View: CSF_CT_TASKS

[top of page]

APPS.CSF_CT_TASKS references the following:

APPS
PACKAGE - CSF_TASKS_PUB
SYNONYM - CS_INCIDENTS_ALL_B
SYNONYM - CS_INCIDENTS_ALL_TL
SYNONYM - CS_INCIDENT_TYPES_TL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_B
SYNONYM - JTF_TASK_TYPES_TL
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.CSF_CT_TASKS is not referenced by any database object

[top of page]

View: CSF_CT_TASK_ASSIGNMENTS

[top of page]

APPS.CSF_CT_TASK_ASSIGNMENTS references the following:

APPS
PACKAGE - CSF_RESOURCE_PUB
PACKAGE - CSF_UTIL_PVT
SYNONYM - JTF_TASK_ASSIGNMENTS
VIEW - JTF_TASK_STATUSES_VL
APPS.CSF_CT_TASK_ASSIGNMENTS is referenced by following:

APPS
PACKAGE BODY - CSF_TASKS_PUB

[top of page]

View: CSF_DC_QUERIES_VL

[top of page]

APPS.CSF_DC_QUERIES_VL references the following:

APPS
SYNONYM - CSF_DC_QUERIES_B
SYNONYM - CSF_DC_QUERIES_TL
APPS.CSF_DC_QUERIES_VL is referenced by following:

APPS
PACKAGE BODY - CSF_DC_QUERIES_PKG
VIEW - CSF_DC_QUERY_EXTNS_V

[top of page]

View: CSF_DEBRIEF_EXP_LINES_V

[top of page]

APPS.CSF_DEBRIEF_EXP_LINES_V references the following:

APPS
SYNONYM - CSF_DEBRIEF_LINES
SYNONYM - CS_BILLING_TYPE_CATEGORIES
PACKAGE - CS_STD
SYNONYM - CS_TRANSACTION_TYPES
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - MTL_SYSTEM_ITEMS_B_KFV

APPS.CSF_DEBRIEF_EXP_LINES_V is not referenced by any database object

[top of page]

View: CSF_DEBRIEF_HEADERS_V

[top of page]

APPS.CSF_DEBRIEF_HEADERS_V references the following:

APPS
SYNONYM - CSF_DEBRIEF_HEADERS
PACKAGE - CSF_UTIL_PVT
SYNONYM - CS_INCIDENTS_ALL_B
VIEW - JTF_PARTIES_ALL_V
VIEW - JTF_TASKS_VL
SYNONYM - JTF_TASK_ASSIGNMENTS
VIEW - JTF_TASK_STATUSES_VL
VIEW - MTL_SYSTEM_ITEMS_B_KFV
APPS.CSF_DEBRIEF_HEADERS_V is referenced by following:

APPS
PACKAGE BODY - CSD_GEN_ERRMSGS_PVT

[top of page]

View: CSF_DEBRIEF_LAB_LINES_V

[top of page]

APPS.CSF_DEBRIEF_LAB_LINES_V references the following:

APPS
SYNONYM - CSF_DEBRIEF_LINES
SYNONYM - CS_BILLING_TYPE_CATEGORIES
PACKAGE - CS_STD
VIEW - CS_TRANSACTION_TYPES_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - MTL_SYSTEM_ITEMS_B_KFV
APPS.CSF_DEBRIEF_LAB_LINES_V is referenced by following:

APPS
PACKAGE BODY - CSF_DEBRIEF_PVT

[top of page]

View: CSF_DEBRIEF_MAT_LINES_V

[top of page]

APPS.CSF_DEBRIEF_MAT_LINES_V references the following:

APPS
VIEW - ASO_I_RETURN_CODES_V
SYNONYM - CSF_DEBRIEF_LINES
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_BILLING_TYPE_CATEGORIES
VIEW - CS_TRANSACTION_TYPES_VL
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
VIEW - MTL_SYSTEM_ITEMS_B_KFV

APPS.CSF_DEBRIEF_MAT_LINES_V is not referenced by any database object

[top of page]

View: CSF_DEBRIEF_SRC_NUMBERS_V

[top of page]

APPS.CSF_DEBRIEF_SRC_NUMBERS_V references the following:

APPS
SYNONYM - CSD_REPAIRS
SYNONYM - CS_INCIDENTS_ALL
VIEW - JTF_OBJECTS_VL
VIEW - JTF_TASKS_VL

APPS.CSF_DEBRIEF_SRC_NUMBERS_V is not referenced by any database object

[top of page]

View: CSF_DEBRIEF_TASKS_V

[top of page]

APPS.CSF_DEBRIEF_TASKS_V references the following:

APPS
SYNONYM - CSD_REPAIRS
SYNONYM - CSF_DEBRIEF_HEADERS
PACKAGE - CSF_UTIL_PVT
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_INCIDENTS_ALL
PACKAGE - CS_STD
PACKAGE - HZ_FORMAT_PUB
SYNONYM - HZ_PARTY_SITES
VIEW - JTF_OBJECTS_VL
VIEW - JTF_PARTIES_ALL_V
VIEW - JTF_TASKS_VL
SYNONYM - JTF_TASK_ASSIGNMENTS
VIEW - JTF_TASK_PRIORITIES_VL
VIEW - JTF_TASK_STATUSES_VL
VIEW - JTF_TASK_TYPES_VL
VIEW - MTL_SYSTEM_ITEMS_B_KFV
VIEW - OKS_ENT_LINE_DETAILS_V

APPS.CSF_DEBRIEF_TASKS_V is not referenced by any database object

[top of page]

View: CSF_DEBRIEF_TRANS_TYPES_V

[top of page]

APPS.CSF_DEBRIEF_TRANS_TYPES_V references the following:

APPS
SYNONYM - CSI_INSTANCE_STATUSES
VIEW - CSI_TXN_SUB_TYPES
SYNONYM - CSI_TXN_TYPES
SYNONYM - CS_BILLING_TYPE_CATEGORIES
SYNONYM - CS_BUSINESS_PROCESSES
SYNONYM - CS_BUS_PROCESS_TXNS
VIEW - CS_TRANSACTION_TYPES_VL
SYNONYM - CS_TXN_BILLING_TYPES

APPS.CSF_DEBRIEF_TRANS_TYPES_V is not referenced by any database object

[top of page]

View: CSF_ESC_TASKS_V

[top of page]

APPS.CSF_ESC_TASKS_V references the following:

APPS
PACKAGE - FND_GLOBAL
VIEW - FND_LOOKUPS
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_REFERENCES_B
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL

APPS.CSF_ESC_TASKS_V is not referenced by any database object

[top of page]

View: CSF_GNTICONS_SETUP_V

[top of page]

APPS.CSF_GNTICONS_SETUP_V references the following:

APPS
SYNONYM - CSF_GNTICONS_SETUP_B
APPS.CSF_GNTICONS_SETUP_V is referenced by following:

APPS
PACKAGE BODY - CSF_GANTT_DATA_PKG

[top of page]

View: CSF_L_SODS_V

[top of page]

APPS.CSF_L_SODS_V references the following:

APPS
SYNONYM - CSF_L_SODS
SYNONYM - CSF_L_SOTS
VIEW - JTF_TASK_TYPES_VL

APPS.CSF_L_SODS_V is not referenced by any database object

[top of page]

View: CSF_MAP_ACCESS_HOURS_VL

[top of page]

APPS.CSF_MAP_ACCESS_HOURS_VL references the following:

APPS
SYNONYM - CSF_MAP_ACCESS_HOURS_B
SYNONYM - CSF_MAP_ACCESS_HOURS_TL
APPS.CSF_MAP_ACCESS_HOURS_VL is referenced by following:

APPS
PACKAGE BODY - CSF_MAP_ACC_HRS_PKG
PACKAGE BODY - CSF_PREVENTIVE_MAINTENANCE_PVT

[top of page]

View: CSF_PHONETIC_VALUES_VL

[top of page]

APPS.CSF_PHONETIC_VALUES_VL references the following:

APPS
SYNONYM - CSF_PHONETIC_VALUES

APPS.CSF_PHONETIC_VALUES_VL is not referenced by any database object

[top of page]

View: CSF_PLAN_OPTIONS_V

[top of page]

APPS.CSF_PLAN_OPTIONS_V references the following:

APPS
PACKAGE - CSF_RESOURCE_PUB
SYNONYM - CSF_R_PLAN_OPTIONS
SYNONYM - CSF_R_PLAN_OPTION_TASKS
SYNONYM - CSF_R_REQUEST_TASKS
SYNONYM - CSF_R_RESOURCE_RESULTS
SYNONYM - CSF_R_SPARES_OPTIONS
SYNONYM - JTF_TASKS_B
APPS.CSF_PLAN_OPTIONS_V is referenced by following:

APPS
PACKAGE BODY - CSF_GANTT_DATA_PKG

[top of page]

View: CSF_PLAN_TERRS_V

[top of page]

APPS.CSF_PLAN_TERRS_V references the following:

APPS
SYNONYM - CSF_PLAN_TERRS
VIEW - JTF_RS_GROUPS_VL
SYNONYM - JTF_TERR_ALL

APPS.CSF_PLAN_TERRS_V is not referenced by any database object

[top of page]

View: CSF_PO_CONTACT_POINTS_V

[top of page]

APPS.CSF_PO_CONTACT_POINTS_V references the following:

APPS
VIEW - AR_LOOKUPS
SYNONYM - CS_HZ_SR_CONTACT_POINTS
VIEW - CS_INCIDENTS_ALL_VL
VIEW - CS_LOOKUPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PHONES
APPS.CSF_PO_CONTACT_POINTS_V is referenced by following:

APPS
PACKAGE BODY - CSP_PICK_UTILS

[top of page]

View: CSF_RATING_SCALES_VL

[top of page]

APPS.CSF_RATING_SCALES_VL references the following:

APPS
SYNONYM - CSF_RATING_SCALES_B
SYNONYM - CSF_RATING_SCALES_TL

APPS.CSF_RATING_SCALES_VL is not referenced by any database object

[top of page]

View: CSF_REQUIRED_SKILLS_V

[top of page]

APPS.CSF_REQUIRED_SKILLS_V references the following:

APPS
SYNONYM - CSF_REQUIRED_SKILLS_B
VIEW - CSF_SKILL_LEVELS_VL
VIEW - CSF_SKILL_TYPES_VL

APPS.CSF_REQUIRED_SKILLS_V is not referenced by any database object

[top of page]

View: CSF_RESOURCE_SKILLS_V

[top of page]

APPS.CSF_RESOURCE_SKILLS_V references the following:

APPS
VIEW - CSF_RESOURCES_V
SYNONYM - CSF_RESOURCE_SKILLS_B
VIEW - CSF_SKILL_LEVELS_VL
VIEW - CSF_SKILL_TYPES_VL

APPS.CSF_RESOURCE_SKILLS_V is not referenced by any database object

[top of page]

View: CSF_RES_INV_ASSIGNMENTS_V

[top of page]

APPS.CSF_RES_INV_ASSIGNMENTS_V references the following:

APPS
VIEW - CSP_INV_LOC_ASSIGNMENTS_V
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
VIEW - JTF_RS_ALL_RESOURCES_VL

APPS.CSF_RES_INV_ASSIGNMENTS_V is not referenced by any database object

[top of page]

View: CSF_SELECTED_RESOURCES_V

[top of page]

APPS.CSF_SELECTED_RESOURCES_V references the following:

APPS
PACKAGE - CSF_RESOURCE_PUB
PACKAGE - CSF_UTIL_PVT
TYPE - JTF_NUMBER_TABLE
SYNONYM - JTF_TERR_RSC_ALL
APPS.CSF_SELECTED_RESOURCES_V is referenced by following:

APPS
PACKAGE BODY - CSF_GANTT_DATA_PKG
PACKAGE BODY - CSF_PLANBOARD_TASKS
PACKAGE BODY - CSF_TRIPS_PUB

[top of page]

View: CSF_SKILLS_VL

[top of page]

APPS.CSF_SKILLS_VL references the following:

APPS
SYNONYM - CSF_SKILLS_B
SYNONYM - CSF_SKILLS_TL

APPS.CSF_SKILLS_VL is not referenced by any database object

[top of page]

View: CSF_SKILL_LEVELS_VL

[top of page]

APPS.CSF_SKILL_LEVELS_VL references the following:

APPS
SYNONYM - CSF_SKILL_LEVELS_B
SYNONYM - CSF_SKILL_LEVELS_TL
APPS.CSF_SKILL_LEVELS_VL is referenced by following:

APPS
VIEW - CSF_REQUIRED_SKILLS_V
VIEW - CSF_RESOURCE_SKILLS_V

[top of page]

View: CSF_SKILL_TYPES_VL

[top of page]

APPS.CSF_SKILL_TYPES_VL references the following:

APPS
SYNONYM - CSF_SKILL_TYPES_B
SYNONYM - CSF_SKILL_TYPES_TL
APPS.CSF_SKILL_TYPES_VL is referenced by following:

APPS
VIEW - CSF_REQUIRED_SKILLS_V
VIEW - CSF_RESOURCE_SKILLS_V

[top of page]

View: CSF_SR_HIST_V

[top of page]

APPS.CSF_SR_HIST_V references the following:

APPS
SYNONYM - CSI_ITEM_INSTANCES
SYNONYM - CS_HZ_SR_CONTACT_POINTS
SYNONYM - CS_INCIDENTS_ALL_B
SYNONYM - CS_INCIDENTS_ALL_TL
SYNONYM - CS_INCIDENT_SEVERITIES_TL
SYNONYM - CS_INCIDENT_STATUSES_TL
SYNONYM - CS_INCIDENT_TYPES_TL
SYNONYM - CS_INCIDENT_URGENCIES_TL
SYNONYM - HZ_CONTACT_POINTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_TIMEZONES
SYNONYM - MTL_SYSTEM_ITEMS_KFV

APPS.CSF_SR_HIST_V is not referenced by any database object

[top of page]

View: CSF_VALIDATE_TASKS_V

[top of page]

APPS.CSF_VALIDATE_TASKS_V references the following:

APPS
SYNONYM - CSF_EXT_LOCATIONS
PACKAGE - CSF_TASKS_PUB
SYNONYM - CS_INCIDENTS_ALL_B
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - JTF_TASKS_B
SYNONYM - JTF_TASKS_TL
SYNONYM - JTF_TASK_PRIORITIES_TL
SYNONYM - JTF_TASK_STATUSES_B
SYNONYM - JTF_TASK_STATUSES_TL
SYNONYM - JTF_TASK_TYPES_B
SYNONYM - JTF_TASK_TYPES_TL
APPS.CSF_VALIDATE_TASKS_V is referenced by following:

APPS
PACKAGE BODY - CSF_TASK_ADDRESS_PVT

[top of page]



Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract