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

VIEW: APPS.GCS_LEX_MAP_SEQUENCES_V

Object Details
Object Name: GCS_LEX_MAP_SEQUENCES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGCS.GCS_LEX_MAP_SEQUENCES_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


GCS_LEX_MAP_SEQUENCES_V is a view used by the Interface Data Transformer application so that you can view your Transformation Rule Sets in a hierarchical fashion. The view retrieves the rule, derivation, derivation sequence number, derivation type, and condition text to be shown in the Interface Data Transformer Create Rule Set: Details page.


[View Source]

Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER (15) Yes Rule identifier
DERIVATION_ID NUMBER (15) Yes Derivation identifier
DERIVATION_SEQUENCE NUMBER
Yes Sequence number for this derivation
CONDITION VARCHAR2 (4000)
The condition that must be satisfied by the source column values for the derivation action to be applied.
DERIVATION_TYPE VARCHAR2 (80) Yes The type of action used to derive the target value: String Function, Lookup Table, or PL/SQL Function.
Query Text

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


SELECT RULE_ID
,      DERIVATION_ID
,      DERIVATION_SEQUENCE
,      CONDITION
,      DERIVATION_TYPE
FROM APPS.GCS_LEX_MAP_SEQUENCES_V;

Dependencies

[top of page]

APPS.GCS_LEX_MAP_SEQUENCES_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymFND_LOOKUP_VALUES
SynonymGCS_LEX_MAP_DERIVATIONS
PL/SQL PackageGCS_LEX_MAP_PKG - show dependent code

APPS.GCS_LEX_MAP_SEQUENCES_V is not referenced by any database object