DBA Data[Home] [Help]

VIEW: APPS.WMS_OBJECTS_STRATEGY_V

Source

View Text - Preformatted

SELECT DISTINCT wsav.ORGANIZATION_ID ,wsav.OBJECT_TYPE_CODE ,wsav.OBJECT_TYPE_MEANING ,wsav.OBJECT_TYPE_DESCRIPTION ,wsav.OBJECT_NAME ,wsav.OBJECT_DESCRIPTION ,wsav.OBJECT_ID ,wsav.PK1_VALUE ,wsav.PK2_VALUE ,wsav.PK3_VALUE ,wsav.PK4_VALUE ,wsav.PK5_VALUE ,wsav.VALUE_NAME FROM WMS_STRATEGY_ASSIGNMENTS_V wsav
View Text - HTML Formatted

SELECT DISTINCT WSAV.ORGANIZATION_ID
, WSAV.OBJECT_TYPE_CODE
, WSAV.OBJECT_TYPE_MEANING
, WSAV.OBJECT_TYPE_DESCRIPTION
, WSAV.OBJECT_NAME
, WSAV.OBJECT_DESCRIPTION
, WSAV.OBJECT_ID
, WSAV.PK1_VALUE
, WSAV.PK2_VALUE
, WSAV.PK3_VALUE
, WSAV.PK4_VALUE
, WSAV.PK5_VALUE
, WSAV.VALUE_NAME
FROM WMS_STRATEGY_ASSIGNMENTS_V WSAV