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 WMS_DB_OBJECTS

Line 820: g_base_table_alias wms_db_objects.table_alias%TYPE;

816: and x.lot_number = lot.lot_number (+)
817: ';
818: g_pick_base LONG;
819: --
820: g_base_table_alias wms_db_objects.table_alias%TYPE;
821: g_input_table_alias wms_db_objects.table_alias%TYPE;
822: g_base_select LONG;
823: g_base_group_by LONG;
824: g_rule_select LONG;

Line 821: g_input_table_alias wms_db_objects.table_alias%TYPE;

817: ';
818: g_pick_base LONG;
819: --
820: g_base_table_alias wms_db_objects.table_alias%TYPE;
821: g_input_table_alias wms_db_objects.table_alias%TYPE;
822: g_base_select LONG;
823: g_base_group_by LONG;
824: g_rule_select LONG;
825: g_rule_select_serial LONG;

Line 1343: l_input_table_name wms_db_objects.table_name%TYPE;

1339: --
1340: -- variables needed for dynamic SQL
1341: l_identifier VARCHAR2(10);
1342: -- variables for the base and input representing DB objects
1343: l_input_table_name wms_db_objects.table_name%TYPE;
1344: l_type_dependent_alias wms_db_objects.table_alias%TYPE;
1345:
1346: --
1347: -- cursor for the base and input representing DB objects

Line 1344: l_type_dependent_alias wms_db_objects.table_alias%TYPE;

1340: -- variables needed for dynamic SQL
1341: l_identifier VARCHAR2(10);
1342: -- variables for the base and input representing DB objects
1343: l_input_table_name wms_db_objects.table_name%TYPE;
1344: l_type_dependent_alias wms_db_objects.table_alias%TYPE;
1345:
1346: --
1347: -- cursor for the base and input representing DB objects
1348: CURSOR baseinp IS

Line 1352: FROM wms_db_objects wdo1, wms_db_objects wdo2

1348: CURSOR baseinp IS
1349: SELECT wdo1.table_alias
1350: , wdo2.table_name
1351: , wdo2.table_alias
1352: FROM wms_db_objects wdo1, wms_db_objects wdo2
1353: WHERE wdo1.db_object_id = 1
1354: AND wdo2.db_object_id = 2;
1355: --
1356: BEGIN

Line 1821: l_db_object_id wms_db_objects.db_object_id%TYPE;

1817: l_api_name VARCHAR2(30) := 'BuildRuleSQL';
1818: -- variables needed for dynamic SQL
1819: l_identifier VARCHAR2(10);
1820: -- other variables
1821: l_db_object_id wms_db_objects.db_object_id%TYPE;
1822: l_table_name wms_db_objects.table_name%TYPE;
1823: l_table_alias wms_db_objects.table_alias%TYPE;
1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;

Line 1822: l_table_name wms_db_objects.table_name%TYPE;

1818: -- variables needed for dynamic SQL
1819: l_identifier VARCHAR2(10);
1820: -- other variables
1821: l_db_object_id wms_db_objects.db_object_id%TYPE;
1822: l_table_name wms_db_objects.table_name%TYPE;
1823: l_table_alias wms_db_objects.table_alias%TYPE;
1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;

Line 1823: l_table_alias wms_db_objects.table_alias%TYPE;

1819: l_identifier VARCHAR2(10);
1820: -- other variables
1821: l_db_object_id wms_db_objects.db_object_id%TYPE;
1822: l_table_name wms_db_objects.table_name%TYPE;
1823: l_table_alias wms_db_objects.table_alias%TYPE;
1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1827: l_column_name wms_parameters_b.column_name%TYPE;

Line 1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;

1820: -- other variables
1821: l_db_object_id wms_db_objects.db_object_id%TYPE;
1822: l_table_name wms_db_objects.table_name%TYPE;
1823: l_table_alias wms_db_objects.table_alias%TYPE;
1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1827: l_column_name wms_parameters_b.column_name%TYPE;
1828: l_expression wms_parameters_b.expression%TYPE;

Line 1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;

1821: l_db_object_id wms_db_objects.db_object_id%TYPE;
1822: l_table_name wms_db_objects.table_name%TYPE;
1823: l_table_alias wms_db_objects.table_alias%TYPE;
1824: l_context_dependent_flag wms_db_objects.context_dependent_flag%TYPE;
1825: l_parent_table_alias wms_db_objects.table_alias%TYPE;
1826: l_parameter_type_code wms_parameters_b.parameter_type_code%TYPE;
1827: l_column_name wms_parameters_b.column_name%TYPE;
1828: l_expression wms_parameters_b.expression%TYPE;
1829: l_data_type_code wms_parameters_b.data_type_code%TYPE;

Line 1882: FROM wms_db_objects wdo

1878: SELECT wdo.db_object_id
1879: , wdo.table_name
1880: , wdo.table_alias
1881: , wdo.context_dependent_flag
1882: FROM wms_db_objects wdo
1883: , wms_parameters_b wpb
1884: , (SELECT wsc.parameter_id
1885: FROM wms_sort_criteria wsc
1886: WHERE wsc.rule_id = p_rule_id

Line 1910: FROM wms_db_objects wdo

1906: SELECT wdo.db_object_id
1907: , wdo.table_name
1908: , wdo.table_alias
1909: , wdo.context_dependent_flag
1910: FROM wms_db_objects wdo
1911: , (SELECT wdop.parent_db_object_id
1912: FROM wms_db_objects_parents wdop
1913: WHERE wdop.type_code = p_type_code
1914: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id

Line 1912: FROM wms_db_objects_parents wdop

1908: , wdo.table_alias
1909: , wdo.context_dependent_flag
1910: FROM wms_db_objects wdo
1911: , (SELECT wdop.parent_db_object_id
1912: FROM wms_db_objects_parents wdop
1913: WHERE wdop.type_code = p_type_code
1914: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id
1915: START WITH wdop.db_object_id IN (SELECT wdod.db_object_id
1916: FROM wms_db_objects wdod

Line 1916: FROM wms_db_objects wdod

1912: FROM wms_db_objects_parents wdop
1913: WHERE wdop.type_code = p_type_code
1914: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id
1915: START WITH wdop.db_object_id IN (SELECT wdod.db_object_id
1916: FROM wms_db_objects wdod
1917: , wms_parameters_b wpbd
1918: , (SELECT wscd.parameter_id
1919: FROM wms_sort_criteria wscd
1920: WHERE wscd.rule_id = p_rule_id

Line 1945: FROM wms_db_objects wdo

1941: SELECT wdo.db_object_id
1942: , wdo.table_name
1943: , NVL(wdorm.table_alias, wdo.table_alias)
1944: , wdo.context_dependent_flag
1945: FROM wms_db_objects wdo
1946: , wms_db_obj_ref_members wdorm
1947: , wms_db_object_references wdor
1948: , wms_parameters_b wpb
1949: , (SELECT wsc.parameter_id

Line 1977: FROM wms_db_objects wdo

1973: SELECT wdo.db_object_id
1974: , wdo.table_name
1975: , wdo.table_alias
1976: , wdo.context_dependent_flag
1977: FROM wms_db_objects wdo
1978: , (SELECT wdop.parent_db_object_id
1979: FROM wms_db_objects_parents wdop
1980: WHERE wdop.type_code = p_type_code
1981: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id

Line 1979: FROM wms_db_objects_parents wdop

1975: , wdo.table_alias
1976: , wdo.context_dependent_flag
1977: FROM wms_db_objects wdo
1978: , (SELECT wdop.parent_db_object_id
1979: FROM wms_db_objects_parents wdop
1980: WHERE wdop.type_code = p_type_code
1981: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id
1982: START WITH wdop.db_object_id IN (SELECT wdoi.db_object_id
1983: FROM wms_db_objects wdoi

Line 1983: FROM wms_db_objects wdoi

1979: FROM wms_db_objects_parents wdop
1980: WHERE wdop.type_code = p_type_code
1981: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id
1982: START WITH wdop.db_object_id IN (SELECT wdoi.db_object_id
1983: FROM wms_db_objects wdoi
1984: , wms_db_obj_ref_members wdormi
1985: , wms_db_object_references wdori
1986: , wms_parameters_b wpbi
1987: , (SELECT wsc.parameter_id

Line 2025: FROM wms_db_objects wdop, wms_parameters_b wpbp, wms_parameters_b wpb, wms_db_object_joins wdoj

2021: , wpbp.column_name
2022: , wpbp.expression
2023: , wpbp.data_type_code
2024: , wdop.table_alias -- alias n.a. for multi object based parameters
2025: FROM wms_db_objects wdop, wms_parameters_b wpbp, wms_parameters_b wpb, wms_db_object_joins wdoj
2026: WHERE wdoj.db_object_id = l_db_object_id
2027: AND wdoj.type_code = p_type_code
2028: AND wpb.parameter_id = wdoj.parameter_id
2029: AND wpbp.parameter_id = wdoj.parent_parameter_id

Line 2041: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_rules_b wrb

2037: , wpb.column_name
2038: , wpb.expression
2039: , wpb.data_type_code
2040: , wdo.table_alias -- alias n.a. for multi object based parameters
2041: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_rules_b wrb
2042: WHERE wrb.rule_id = p_rule_id
2043: AND wpb.parameter_id = wrb.qty_function_parameter_id
2044: AND wdo.db_object_id(+) = wpb.db_object_id;
2045:

Line 2101: , wms_db_objects wdor

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
2104: , wms_parameters_b wpbl
2105: , wms_restrictions wr

Line 2103: , wms_db_objects wdol

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
2104: , wms_parameters_b wpbl
2105: , wms_restrictions wr
2106: WHERE wr.rule_id = p_rule_id
2107: AND wpbl.parameter_id = wr.parameter_id

Line 2139: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_sort_criteria wsc

2135: , wsc.rule_id
2136: , wsc.sequence_number
2137: , wpb.object_id -- Added for Bug 13448337
2138: , wsc.parameter_id -- Added for Bug 13448337
2139: FROM wms_db_objects wdo, wms_parameters_b wpb, wms_sort_criteria wsc
2140: WHERE wsc.rule_id = p_rule_id
2141: AND wpb.parameter_id = wsc.parameter_id
2142: AND wdo.db_object_id(+) = wpb.db_object_id
2143: ORDER BY wsc.rule_id, wsc.sequence_number;

Line 2153: FROM wms_rule_consistencies wrc, wms_parameters_b wpb, wms_db_objects wdo

2149: SELECT wpb.parameter_type_code
2150: , wpb.column_name
2151: , wpb.expression
2152: , wdo.table_alias
2153: FROM wms_rule_consistencies wrc, wms_parameters_b wpb, wms_db_objects wdo
2154: WHERE wrc.rule_id = p_rule_id
2155: AND wpb.parameter_id = wrc.parameter_id
2156: AND wdo.db_object_id(+) = wpb.db_object_id;
2157: BEGIN