DBA Data[Home] [Help]

APPS.WMS_STRATEGY_PVT dependencies on WMS_ORG_HIERARCHY_OBJS

Line 1002: ,WMS_ORG_HIERARCHY_OBJS mpoho

998: cursor hierarchy is
999: select mpo.OBJECT_ID
1000: ,mpo.STRAT_ASGMT_DB_OBJECT_ID
1001: from WMS_OBJECTS_B mpo
1002: ,WMS_ORG_HIERARCHY_OBJS mpoho
1003: where mpoho.ORGANIZATION_ID = l_organization_id
1004: and mpoho.TYPE_CODE = p_type_code
1005: and mpo.OBJECT_ID = mpoho.OBJECT_ID
1006: and mpo.STRAT_ASGMT_DB_OBJECT_ID is not null