DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_DB_OBJECT_REFERENCES

Line 1947: , wms_db_object_references wdor

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
1950: FROM wms_sort_criteria wsc
1951: WHERE wsc.rule_id = p_rule_id

Line 1985: , wms_db_object_references wdori

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
1988: FROM wms_sort_criteria wsc
1989: WHERE wsc.rule_id = p_rule_id