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