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 366: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;

362: l_where_clause Varchar2(2000) Default Null;
363: l_order_by_clause Varchar2(2000) Default Null;
364: l_longlist_flag Varchar2(1) Default 'Y';
365: l_format_type Varchar2(1) Default Null;
366: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
367: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
368: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
369: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
370: l_object_code VARCHAR2(240) default null;

Line 367: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;

363: l_order_by_clause Varchar2(2000) Default Null;
364: l_longlist_flag Varchar2(1) Default 'Y';
365: l_format_type Varchar2(1) Default Null;
366: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
367: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
368: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
369: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
370: l_object_code VARCHAR2(240) default null;
371: l_object_code1 VARCHAR2(240) default null;

Line 368: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;

364: l_longlist_flag Varchar2(1) Default 'Y';
365: l_format_type Varchar2(1) Default Null;
366: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
367: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
368: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
369: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
370: l_object_code VARCHAR2(240) default null;
371: l_object_code1 VARCHAR2(240) default null;
372: --l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE Default Null;

Line 369: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;

365: l_format_type Varchar2(1) Default Null;
366: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
367: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
368: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
369: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
370: l_object_code VARCHAR2(240) default null;
371: l_object_code1 VARCHAR2(240) default null;
372: --l_object_code JTF_OBJECTS_B.OBJECT_CODE%TYPE Default Null;
373: l_flex_value_set_id Number;

Line 600: p_ruleinfo_column IN DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

596: x_msg_data OUT NOCOPY VARCHAR2,
597: p_chr_id IN NUMBER,
598: p_segment IN FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE,
599: p_longlist_flag IN VARCHAR2,
600: p_ruleinfo_column IN DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
601: p_name_column IN DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
602: p_id1 IN VARCHAR2,
603: P_id2 IN VARCHAR2,
604: p_select_clause IN VARCHAR2,

Line 601: p_name_column IN DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,

597: p_chr_id IN NUMBER,
598: p_segment IN FND_DESCR_FLEX_COL_USAGE_VL.APPLICATION_COLUMN_NAME%TYPE,
599: p_longlist_flag IN VARCHAR2,
600: p_ruleinfo_column IN DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
601: p_name_column IN DBA_TAB_COLUMNS.COLUMN_NAME%TYPE,
602: p_id1 IN VARCHAR2,
603: P_id2 IN VARCHAR2,
604: p_select_clause IN VARCHAR2,
605: p_from_clause IN VARCHAR2,

Line 735: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;

731: l_from_clause Varchar2(2000) Default Null;
732: l_where_clause Varchar2(2000) Default Null;
733: l_order_by_clause Varchar2(2000) Default Null;
734:
735: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
736: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
737: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
738: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
739: l_object_code VARCHAR2(240) default null;

Line 736: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;

732: l_where_clause Varchar2(2000) Default Null;
733: l_order_by_clause Varchar2(2000) Default Null;
734:
735: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
736: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
737: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
738: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
739: l_object_code VARCHAR2(240) default null;
740: l_object_code1 VARCHAR2(240) default null;

Line 737: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;

733: l_order_by_clause Varchar2(2000) Default Null;
734:
735: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
736: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
737: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
738: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
739: l_object_code VARCHAR2(240) default null;
740: l_object_code1 VARCHAR2(240) default null;
741:

Line 738: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;

734:
735: l_id1_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
736: l_id2_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
737: l_rule_info_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
738: l_name_col DBA_TAB_COLUMNS.COLUMN_NAME%TYPE Default Null;
739: l_object_code VARCHAR2(240) default null;
740: l_object_code1 VARCHAR2(240) default null;
741:
742: l_chr_id OKC_K_HEADERS_B.ID%TYPE := p_contract_id;