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 1843: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;

1839: l_operand_flex_value_set_id wms_restrictions.operand_flex_value_set_id%TYPE;
1840: l_bracket_open wms_restrictions.bracket_open%TYPE;
1841: l_bracket_close wms_restrictions.bracket_close%TYPE;
1842: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1843: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1844: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1845: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1846: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1847: l_left_part_conv_fct VARCHAR2(40);

Line 1844: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;

1840: l_bracket_open wms_restrictions.bracket_open%TYPE;
1841: l_bracket_close wms_restrictions.bracket_close%TYPE;
1842: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1843: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1844: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1845: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1846: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1847: l_left_part_conv_fct VARCHAR2(40);
1848: l_right_part_conv_fct VARCHAR2(40);

Line 1845: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;

1841: l_bracket_close wms_restrictions.bracket_close%TYPE;
1842: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1843: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1844: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1845: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1846: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1847: l_left_part_conv_fct VARCHAR2(40);
1848: l_right_part_conv_fct VARCHAR2(40);
1849: l_outer_join VARCHAR2(4);

Line 1846: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;

1842: l_validation_type fnd_flex_value_sets.validation_type%TYPE;
1843: l_id_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1844: l_value_column_name fnd_flex_validation_tables.value_column_name%TYPE;
1845: l_application_table_name fnd_flex_validation_tables.application_table_name%TYPE;
1846: l_additional_where_clause fnd_flex_validation_tables.additional_where_clause%TYPE;
1847: l_left_part_conv_fct VARCHAR2(40);
1848: l_right_part_conv_fct VARCHAR2(40);
1849: l_outer_join VARCHAR2(4);
1850: l_logical_operator mfg_lookups.meaning%TYPE;

Line 1856: l_flex_column_name fnd_flex_validation_tables.id_column_name%TYPE;

1852: l_operator mfg_lookups.meaning%TYPE;
1853: l_restriction_exist BOOLEAN := FALSE;
1854: l_rule_id NUMBER;
1855: l_sequence_number NUMBER;
1856: l_flex_column_name fnd_flex_validation_tables.id_column_name%TYPE;
1857: l_order_by_string VARCHAR2(1000);
1858: l_order_by_string1 VARCHAR2(1000); -- Added for Bug 13448337
1859: l_order_by_string2 VARCHAR2(1000); -- Added for Bug 13448337
1860: l_new_constant_character VARCHAR2(500);

Line 2099: FROM fnd_flex_validation_tables ffvt

2095: , ffvt.application_table_name
2096: , ffvt.additional_where_clause
2097: , wr.rule_id
2098: , wr.sequence_number
2099: FROM fnd_flex_validation_tables ffvt
2100: , fnd_flex_value_sets ffvs
2101: , wms_db_objects wdor
2102: , wms_parameters_b wpbr
2103: , wms_db_objects wdol