DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on WMS_ORG_HIERARCHY_OBJS

Line 964: ,WMS_ORG_HIERARCHY_OBJS mpoho

960: cursor hierarchy is
961: select mpo.OBJECT_ID
962: ,mpo.STRAT_ASGMT_DB_OBJECT_ID
963: from WMS_OBJECTS_B mpo
964: ,WMS_ORG_HIERARCHY_OBJS mpoho
965: where mpoho.ORGANIZATION_ID = l_organization_id
966: and mpoho.TYPE_CODE = p_type_code
967: and mpo.OBJECT_ID = mpoho.OBJECT_ID
968: and mpo.STRAT_ASGMT_DB_OBJECT_ID is not null