VIEW: APPS.AST_QUOTES_UWQ_V

Source

View Text - Preformatted

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 , NVL(PARTYORG.PARTY_NAME, PARTY.PARTY_NAME) CUSTOMER_NAME , NVL(PARTYPER.PERSON_FIRST_NAME,PARTY.PERSON_FIRST_NAME) FIRST_NAME , NVL(PARTYPER.PERSON_LAST_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 , DECODE(RS.SOURCE_NAME,NULL,NVL((SELECT USER_NAME FROM FND_USER WHERE USER_ID = 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, HZ_RELATIONSHIPS REL, HZ_PARTIES PARTYPER, HZ_PARTIES PARTYORG 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' AND PARTY.PARTY_ID = REL.PARTY_ID(+) AND REL.SUBJECT_TYPE(+) = 'PERSON' AND REL.SUBJECT_ID = PARTYPER.PARTY_ID(+) AND REL.OBJECT_TYPE(+) = 'ORGANIZATION' AND REL.OBJECT_ID = PARTYORG.PARTY_ID (+) AND QUOTE.MAX_VERSION_FLAG = 'Y'

View Text - HTML Formatted

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
, NVL(PARTYORG.PARTY_NAME
, PARTY.PARTY_NAME) CUSTOMER_NAME
, NVL(PARTYPER.PERSON_FIRST_NAME
, PARTY.PERSON_FIRST_NAME) FIRST_NAME
, NVL(PARTYPER.PERSON_LAST_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
, DECODE(RS.SOURCE_NAME
, NULL
, NVL((SELECT USER_NAME
FROM FND_USER
WHERE USER_ID = 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
, HZ_RELATIONSHIPS REL
, HZ_PARTIES PARTYPER
, HZ_PARTIES PARTYORG
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'
AND PARTY.PARTY_ID = REL.PARTY_ID(+)
AND REL.SUBJECT_TYPE(+) = 'PERSON'
AND REL.SUBJECT_ID = PARTYPER.PARTY_ID(+)
AND REL.OBJECT_TYPE(+) = 'ORGANIZATION'
AND REL.OBJECT_ID = PARTYORG.PARTY_ID (+)
AND QUOTE.MAX_VERSION_FLAG = 'Y'