DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on WMS_DB_OBJECT_REFERENCES

Line 1860: , wms_db_object_references wdor

1856: , NVL(wdorm.table_alias, wdo.table_alias)
1857: , wdo.context_dependent_flag
1858: FROM wms_db_objects wdo
1859: , wms_db_obj_ref_members wdorm
1860: , wms_db_object_references wdor
1861: , wms_parameters_b wpb
1862: , (SELECT wsc.parameter_id
1863: FROM wms_sort_criteria wsc
1864: WHERE wsc.rule_id = p_rule_id

Line 1898: , wms_db_object_references wdori

1894: CONNECT BY wdop.db_object_id = PRIOR wdop.parent_db_object_id
1895: START WITH wdop.db_object_id IN (SELECT wdoi.db_object_id
1896: FROM wms_db_objects wdoi
1897: , wms_db_obj_ref_members wdormi
1898: , wms_db_object_references wdori
1899: , wms_parameters_b wpbi
1900: , (SELECT wsc.parameter_id
1901: FROM wms_sort_criteria wsc
1902: WHERE wsc.rule_id = p_rule_id