[Home] [Help]
View: ASO_APR_QUOTE_APPROVAL_V
Product: | ASO - Order Capture |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT A.ASO_APR_OBJ_APPROVAL_ID
, A.APPROVAL_SEQUENCE
, A.APPROVAL_STATUS
, A.DATE_SENT
, A.DATE_RECEIVED
, B.DISPLAY_NAME "REVIEWER"
, B.EMAIL_ADDRESS
, B.TERRITORY
, C.GROUP_NUMBER
FROM ASO_APR_APPROVAL_DET_B A
, WF_ROLES B
, JTF_RS_GROUPS_B C
WHERE C.GROUP_ID = A.JTF_RS_APPROVER_GROUP_ID
AND B.NAME = 'RS_GROUP:' || TO_CHAR(NVL(A.JTF_RS_APPROVER_ID
, A.JTF_RS_APPROVER_GROUP_ID))
Columns
Name |
ASO_APR_OBJ_APPROVAL_ID |
APPROVAL_SEQUENCE |
APPROVAL_STATUS |
DATE_SENT |
DATE_RECEIVED |
REVIEWER |
EMAIL_ADDRESS |
TERRITORY |
GROUP_NUMBER |