[Home] [Help]
APPS.WMS_STRATEGY_PVT dependencies on WMS_DB_OBJECTS_PARENTS
Line 984: FROM wms_db_objects_parents mpdop
980: FROM wms_db_objects mpdo
981: WHERE mpdo.db_object_id = l_strat_asgmt_db_object_id
982: UNION
983: SELECT mpdop.parent_db_object_id
984: FROM wms_db_objects_parents mpdop
985: WHERE mpdop.type_code = l_search_type_code
986: Connect by mpdop.DB_OBJECT_ID = prior mpdop.PARENT_DB_OBJECT_ID
987: Start with mpdop.DB_OBJECT_ID = l_strat_asgmt_db_object_id AND
988: mpdop.type_code = l_search_type_code );