Product: | ASO - Order Capture |
---|---|
Description: | Transition Rules for Quote Statuses |
Implementation/DBA Data: | APPS.ASO_STATUS_TRANSITIONS_V |
SELECT T.ROWID
, T.TRANSITION_ID
, T.CREATION_DATE
, T.CREATED_BY
, T.LAST_UPDATED_BY
, T.LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN
, T.REQUEST_ID
, T.PROGRAM_APPLICATION_ID
, T.PROGRAM_ID
, T.LOV_DRIVEN_FLAG
, T.PROGRAM_UPDATE_DATE
, T.USER_MAINTAINABLE_FLAG
, T.FROM_STATUS_ID
, T.TO_STATUS_ID
, VL.STATUS_CODE
, VL.MEANING
, VL.DESCRIPTION
, T.ENABLED_FLAG
, T.ATTRIBUTE_CATEGORY
, T.ATTRIBUTE1
, T.ATTRIBUTE2
, T.ATTRIBUTE3
, T.ATTRIBUTE4
, T.ATTRIBUTE5
, T.ATTRIBUTE6
, T.ATTRIBUTE7
, T.ATTRIBUTE8
, T.ATTRIBUTE9
, T.ATTRIBUTE10
, T.ATTRIBUTE11
, T.ATTRIBUTE12
, T.ATTRIBUTE13
, T.ATTRIBUTE14
, T.ATTRIBUTE15
FROM ASO_QUOTE_STATUS_TRANSITIONS T
, ASO_QUOTE_STATUSES_VL VL
WHERE VL.QUOTE_STATUS_ID = T.TO_STATUS_ID