[Home] [Help]
APPS.WMS_STRATEGY_PVT dependencies on WMS_DB_OBJECTS_PARENTS
Line 1022: FROM wms_db_objects_parents mpdop
1018: FROM wms_db_objects mpdo
1019: WHERE mpdo.db_object_id = l_strat_asgmt_db_object_id
1020: UNION
1021: SELECT mpdop.parent_db_object_id
1022: FROM wms_db_objects_parents mpdop
1023: WHERE mpdop.type_code = l_search_type_code
1024: Connect by mpdop.DB_OBJECT_ID = prior mpdop.PARENT_DB_OBJECT_ID
1025: Start with mpdop.DB_OBJECT_ID = l_strat_asgmt_db_object_id AND
1026: mpdop.type_code = l_search_type_code );