FND Design Data [Home] [Help]

View: ASO_STATUS_TRANSITIONS_V

Product: ASO - Order Capture
Description: Transition Rules for Quote Statuses
Implementation/DBA Data: ViewAPPS.ASO_STATUS_TRANSITIONS_V
View Text

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

Columns

Name
ROW_ID
TRANSITION_ID
CREATION_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
LOV_DRIVEN_FLAG
PROGRAM_UPDATE_DATE
USER_MAINTAINABLE_FLAG
FROM_STATUS_ID
TO_STATUS_ID
TO_STATUS_CODE
TO_STATUS_MEANING
TO_STATUS_DESCRIPTION
ENABLED_FLAG
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15