View: AST_QUOTES_UWQ_V

Product:	AST - TeleSales
Description:	View for Quotes Node on UWQ.
Implementation/DBA Data:	APPS.AST_QUOTES_UWQ_V

View Text

SELECT OBJB.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, 'QUOTE_HEADER_ID=&ID AUTO_QUERY=T' IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'QUOTE_HEADER_ID' IEU_PARAM_PK_COL
, TO_CHAR(QUOTE.QUOTE_HEADER_ID) IEU_PARAM_PK_VALUE
, DECODE(RES.CATEGORY
, 'EMPLOYEE'
, 'RS_INDIVIDUAL'
, 'PARTNER'
, 'RS_PARTNER'
, NULL) RESOURCE_TYPE
, PARTY.PARTY_NAME CUSTOMER_NAME
, PARTY.PERSON_FIRST_NAME FIRST_NAME
, PARTY.PERSON_LAST_NAME LAST_NAME
, PARTY.PARTY_TYPE PARTY_TYPE
, IACC.ACCOUNT_NUMBER ACCOUNT_NUMBER
, QUOTE.QUOTE_NAME
, QUOTE.CREATION_DATE
, QUOTE.CREATED_BY
, QUOTE.LAST_UPDATE_DATE
, QUOTE.LAST_UPDATED_BY
, RS.SOURCE_NAME LAST_UPDATED_BYNAME
, QUOTE.QUOTE_NUMBER||'
, V'||QUOTE.QUOTE_VERSION QUOTE_NUMBER
, QUOTE.QUOTE_EXPIRATION_DATE
, QUOTE.QUOTE_STATUS_ID
, QUOTE.TOTAL_LIST_PRICE
, QUOTE.CURRENCY_CODE CURRENCY_CODE
, QUOTE.TOTAL_ADJUSTED_AMOUNT
, QUOTE.TOTAL_ADJUSTED_PERCENT
, QUOTE.TOTAL_TAX
, QUOTE.SURCHARGE
, QUOTE.TOTAL_SHIPPING_CHARGE
, QUOTE.TOTAL_QUOTE_PRICE
, QUOTE.RESOURCE_ID
, ISTATUS.STATUS_CODE STATUS_CODE
, ISTATUS.MEANING QUOTE_STATUS
, QUOTE.EMPLOYEE_PERSON_ID
FROM JTF_OBJECTS_B OBJB
, ASO_QUOTE_HEADERS_ALL QUOTE
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS IACC
, ASO_QUOTE_STATUSES_VL ISTATUS
, JTF_RS_RESOURCE_EXTNS RS
, JTF_RS_RESOURCE_EXTNS RES
WHERE QUOTE.PARTY_ID = PARTY.PARTY_ID
AND QUOTE.QUOTE_STATUS_ID = ISTATUS.QUOTE_STATUS_ID(+)
AND QUOTE.CUST_ACCOUNT_ID = IACC.CUST_ACCOUNT_ID(+)
AND QUOTE.LAST_UPDATED_BY = RS.USER_ID
AND QUOTE.RESOURCE_ID = RES.RESOURCE_ID(+)
AND OBJB.OBJECT_CODE = 'ASO_QUOTE'

Columns