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.WMS_RULE_PVT dependencies on FND_FLEX_VALIDATION_TABLES

Line 1760: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;

1756: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;
1757: l_bracket_open wms_restrictions.bracket_open%TYPE;
1758: l_bracket_close wms_restrictions.bracket_close%TYPE;
1759: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1760: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1761: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1762: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1763: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1764: l_left_part_conv_fct VARCHAR2(40);

Line 1761: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

1757: l_bracket_open wms_restrictions.bracket_open%TYPE;
1758: l_bracket_close wms_restrictions.bracket_close%TYPE;
1759: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1760: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1761: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1762: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1763: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1764: l_left_part_conv_fct VARCHAR2(40);
1765: l_right_part_conv_fct VARCHAR2(40);

Line 1762: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;

1758: l_bracket_close wms_restrictions.bracket_close%TYPE;
1759: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1760: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1761: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1762: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1763: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1764: l_left_part_conv_fct VARCHAR2(40);
1765: l_right_part_conv_fct VARCHAR2(40);
1766: l_outer_join VARCHAR2(4);

Line 1763: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

1759: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1760: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1761: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1762: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1763: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1764: l_left_part_conv_fct VARCHAR2(40);
1765: l_right_part_conv_fct VARCHAR2(40);
1766: l_outer_join VARCHAR2(4);
1767: l_logical_operator mfg_lookups.meaning%TYPE;

Line 1773: l_flex_column_name fnd_flex_validation_tables.id_column_name%TYPE;

1769: l_operator mfg_lookups.meaning%TYPE;
1770: l_restriction_exist BOOLEAN := FALSE;
1771: l_rule_id NUMBER;
1772: l_sequence_number NUMBER;
1773: l_flex_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1774: l_order_by_string VARCHAR2(1000);
1775: l_new_constant_character VARCHAR2(500);
1776: --l_new_expression VARCHAR2(4100);
1777: l_consist_string VARCHAR2(1000);

Line 2012: FROM fnd_flex_validation_tables ffvt

2008: , ffvt.application_table_name
2009: , ffvt.additional_where_clause
2010: , wr.rule_id
2011: , wr.sequence_number
2012: FROM fnd_flex_validation_tables ffvt
2013: , fnd_flex_value_sets ffvs
2014: , wms_db_objects wdor
2015: , wms_parameters_b wpbr
2016: , wms_db_objects wdol