View: AST_LS_QUOTES_V

View Text

SELECT ASO_QUOTES.ROWID ROW_ID
, ASO_QUOTES.QUOTE_HEADER_ID
, ASO_QUOTES.ORDER_ID
, ASO_QUOTES.QUOTE_NAME
, ASO_QUOTES.QUOTE_NUMBER
, ASO_QUOTES.QUOTE_VERSION
, ASO_QUOTES.QUOTE_STATUS_ID
, I_STATUS.MEANING QUOTE_STATUS
, ASO_QUOTES.QUOTE_EXPIRATION_DATE
, ASO_QUOTES.ORIGINAL_SYSTEM_REFERENCE OPPORTUNITY_NUMBER
, ASO_QUOTES.ORIG_MKTG_SOURCE_CODE_ID ORIG_CAMPAIGN_ID
, ASO_QUOTES.MARKETING_SOURCE_CODE_ID CAMPAIGN_ID
, ASO_QUOTES.TOTAL_LIST_PRICE
, ASO_QUOTES.TOTAL_ADJUSTED_AMOUNT
, ASO_QUOTES.TOTAL_ADJUSTED_PERCENT
, ASO_QUOTES.TOTAL_TAX
, ASO_QUOTES.SURCHARGE
, ASO_QUOTES.TOTAL_SHIPPING_CHARGE
, ASO_QUOTES.TOTAL_QUOTE_PRICE
, ASO_QUOTES.EMPLOYEE_PERSON_ID
, I_PPF.FIRST_NAME SALESREP_FIRST_NAME
, I_PPF.LAST_NAME SALESREP_LAST_NAME
, ASO_QUOTES.PARTY_ID
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, I_PARTIES.PARTY_NAME
, NULL) ORGANIZATION_NAME
, I_PARTIES.PARTY_TYPE
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, I_CONTACT.FIRST_NAME
, I_PARTIES.PERSON_FIRST_NAME) PERSON_FIRST_NAME
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, I_CONTACT.MIDDLE_NAME
, I_PARTIES.PERSON_MIDDLE_NAME) PERSON_MIDDLE_NAME
, DECODE(I_PARTIES.PARTY_TYPE
, 'ORGANIZATION'
, I_CONTACT.LAST_NAME
, I_PARTIES.PERSON_LAST_NAME) PERSON_LAST_NAME
, QUOTE_LINES.QUOTE_LINE_ID
, QUOTE_LINES.INVENTORY_ITEM_ID
, QUOTE_LINES.INVENTORY_ITEM
, QUOTE_LINES.DESCRIPTION ITEM_DESCRIPTION
FROM ASO_QUOTE_HEADERS_ALL ASO_QUOTES
, AST_LS_QUOTES_LINES_V QUOTE_LINES
, PER_ALL_PEOPLE_F I_PPF
, HZ_PARTIES I_PARTIES
, ASO_I_ORG_CONTACT_NW_V I_CONTACT
, ASO_QUOTE_STATUSES_VL I_STATUS
WHERE ASO_QUOTES.QUOTE_STATUS_ID = I_STATUS.QUOTE_STATUS_ID(+)
AND ASO_QUOTES.PARTY_ID = I_PARTIES.PARTY_ID(+)
AND ASO_QUOTES.ORG_CONTACT_ID = I_CONTACT.ORG_CONTACT_ID(+)
AND ASO_QUOTES.EMPLOYEE_PERSON_ID = I_PPF.PERSON_ID (+)
AND SYSDATE BETWEEN NVL(I_PPF.EFFECTIVE_START_DATE
, SYSDATE)
AND NVL(I_PPF.EFFECTIVE_END_DATE
, SYSDATE)
AND ASO_QUOTES.QUOTE_HEADER_ID = QUOTE_LINES.QUOTE_HEADER_ID(+)

Columns