eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RULE_EXTRACT_PVT dependencies on DBA_TAB_COLUMNS

Line 73: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

69: order_by_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
70: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
71: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
72: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
73: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
74: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
75: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
76: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
77: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,

Line 74: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

70: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
71: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
72: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
73: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
74: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
75: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
76: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
77: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
78: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE);

Line 75: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

71: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
72: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
73: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
74: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
75: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
76: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
77: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
78: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE);
79: Type rule_segment_tbl_type is table of rul_segment_rec_type index by BINARY_INTEGER;

Line 76: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

72: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
73: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
74: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
75: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
76: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
77: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
78: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE);
79: Type rule_segment_tbl_type is table of rul_segment_rec_type index by BINARY_INTEGER;
80:

Line 99: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

95: order_by_clause VARCHAR2(2000) := OKC_API.G_MISS_CHAR,
96: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
97: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
98: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
99: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
100: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
101: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
102: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
103: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,

Line 100: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

96: object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
97: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
98: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
99: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
100: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
101: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
102: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
103: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
104: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE,

Line 101: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

97: longlist_flag VARCHAR2(1) := OKC_API.G_MISS_CHAR,
98: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
99: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
100: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
101: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
102: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
103: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
104: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE,
105: x_id1 VARCHAR2(300) := OKC_API.G_MISS_CHAR,

Line 102: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

98: format_type FND_DESCR_FLEX_COL_USAGE_VL.DEFAULT_TYPE%TYPE,
99: id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
100: id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
101: rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
102: name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
103: value_set_name FND_FLEX_VALUE_SETS.FLEX_VALUE_SET_NAME%TYPE,
104: additional_columns FND_FLEX_VALIDATION_TABLES.ADDITIONAL_QUICKPICK_COLUMNS%TYPE,
105: x_id1 VARCHAR2(300) := OKC_API.G_MISS_CHAR,
106: x_id2 VARCHAR2(300) := OKC_API.G_MISS_CHAR,