DBA Data[Home] [Help]

APPS.AMS_WFMOD_PVT dependencies on AMS_DM_TARGETS_B

Line 592: FROM ams_dm_models_vl model, ams_dm_targets_b target

588: , model_name
589: , status_code
590: , owner_user_id
591: , target.active_flag
592: FROM ams_dm_models_vl model, ams_dm_targets_b target
593: WHERE model_id = p_obj_id
594: AND target.target_id = model.target_id
595: ;
596:

Line 605: FROM ams_dm_models_all_b model, ams_dm_scores_vl score, ams_dm_targets_b target

601: , score.score_name
602: , score.status_code
603: , score.owner_user_id
604: , target.active_flag
605: FROM ams_dm_models_all_b model, ams_dm_scores_vl score, ams_dm_targets_b target
606: WHERE score_id = p_obj_id
607: AND score.model_id = model.model_id
608: AND target.target_id = model.target_id
609: ;