VIEW: APPS.ASG_SDQ_UPDATE_V

Source

View Text - Preformatted

SELECT distinct min_qid qid from ( select pub_item,access_id, dml_type, qid , min(qid) over ( partition by pub_item, access_id order by dml_type range unbounded preceding ) as min_qid, min(dml_type) over ( partition by pub_item, access_id) as min_dmltype from asg_system_dirty_queue where client_id = asg_base.get_user_name() and transaction_id = asg_base.get_current_tranid() ) where dml_type = min_dmltype

View Text - HTML Formatted

SELECT DISTINCT MIN_QID QID
FROM ( SELECT PUB_ITEM
, ACCESS_ID
, DML_TYPE
, QID
, MIN(QID) OVER ( PARTITION BY PUB_ITEM
, ACCESS_ID ORDER BY DML_TYPE RANGE UNBOUNDED PRECEDING ) AS MIN_QID
, MIN(DML_TYPE) OVER ( PARTITION BY PUB_ITEM
, ACCESS_ID) AS MIN_DMLTYPE
FROM ASG_SYSTEM_DIRTY_QUEUE
WHERE CLIENT_ID = ASG_BASE.GET_USER_NAME()
AND TRANSACTION_ID = ASG_BASE.GET_CURRENT_TRANID() )
WHERE DML_TYPE = MIN_DMLTYPE