DBA Data[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 );