VIEW: APPS.WMS_XDOCK_SOURCE_ASSIGNMENTS_V

Source

View Text - Preformatted

SELECT wxsa.criterion_id , wccb.criterion_type , wxsa.source_type , wxsa.last_updated_by , wxsa.last_update_date , wxsa.created_by , wxsa.creation_date , wxsa.last_update_login , wxsa.source_code , ml.meaning source_name , wxsa.priority FROM WMS_XDOCK_SOURCE_ASSIGNMENTS wxsa , WMS_CROSSDOCK_CRITERIA_B wccb , MFG_LOOKUPS ml WHERE wxsa.criterion_id = wccb.criterion_id AND ml.lookup_type = 'WMS_XDOCK_' || DECODE( wccb.criterion_type , 1, 'OPPORTUNISTIC_' , 2, 'PLANNED_' ) || DECODE( wxsa.source_type , 1, 'SUPPLY' , 2, 'DEMAND' ) AND ml.lookup_code = wxsa.source_code

View Text - HTML Formatted

SELECT WXSA.CRITERION_ID
, WCCB.CRITERION_TYPE
, WXSA.SOURCE_TYPE
, WXSA.LAST_UPDATED_BY
, WXSA.LAST_UPDATE_DATE
, WXSA.CREATED_BY
, WXSA.CREATION_DATE
, WXSA.LAST_UPDATE_LOGIN
, WXSA.SOURCE_CODE
, ML.MEANING SOURCE_NAME
, WXSA.PRIORITY
FROM WMS_XDOCK_SOURCE_ASSIGNMENTS WXSA
, WMS_CROSSDOCK_CRITERIA_B WCCB
, MFG_LOOKUPS ML
WHERE WXSA.CRITERION_ID = WCCB.CRITERION_ID
AND ML.LOOKUP_TYPE = 'WMS_XDOCK_' || DECODE( WCCB.CRITERION_TYPE
, 1
, 'OPPORTUNISTIC_'
, 2
, 'PLANNED_' ) || DECODE( WXSA.SOURCE_TYPE
, 1
, 'SUPPLY'
, 2
, 'DEMAND' )
AND ML.LOOKUP_CODE = WXSA.SOURCE_CODE