View: ASO_APR_QUOTE_HEADERS_V

View Text

SELECT A.ASO_APR_OBJ_APPROVAL_ID
, D.DESCRIPTION "AK_OBJECT"
, A.APPROVAL_STATUS
, A.SUBMISSION_DATE
, B.SALESREP_FIRST_NAME
, B.SALESREP_LAST_NAME
, B.QUOTE_HEADER_ID
, B.QUOTE_VERSION
, B.QUOTE_NAME
, B.TOTAL_QUOTE_PRICE
, C.CUSTOMER_NAME
FROM ASO_APR_OBJ_APPROVALS A
, ASO_QUOTE_HEADERS_V B
, ASO_I_CUST_ACCOUNTS_V C
, AK_OBJECTS_VL D
WHERE A.AK_OBJECT = 'ASO_QUOTE_HEADERS_V'
AND D.DATABASE_OBJECT_NAME = A.AK_OBJECT
AND B.QUOTE_HEADER_ID = TO_NUMBER(A.KEY_VALUE1)
AND B.CUST_ACCOUNT_ID = C.CUST_ACCOUNT_ID

Columns