View: AS_QUOTE_LINES_V

View Text

SELECT AS_QUOTE_LINES.ROWID ROW_ID
, AS_QUOTE_LINES.QUOTE_LINE_ID
, AS_QUOTE_LINES.LAST_UPDATE_DATE
, AS_QUOTE_LINES.LAST_UPDATED_BY
, AS_QUOTE_LINES.CREATION_DATE
, AS_QUOTE_LINES.CREATED_BY
, AS_QUOTE_LINES.LAST_UPDATE_LOGIN
, AS_QUOTE_LINES.REQUEST_ID
, AS_QUOTE_LINES.PROGRAM_APPLICATION_ID
, AS_QUOTE_LINES.PROGRAM_ID
, AS_QUOTE_LINES.PROGRAM_UPDATE_DATE
, AS_QUOTE_LINES.QUOTE_ID
, AS_QUOTE_LINES.INVENTORY_ITEM_ID
, AS_QUOTE_LINES.ORGANIZATION_ID
, AS_QUOTE_LINES.PRICE_LIST_LINE_ID
, AS_QUOTE_LINES.LINE_QUOTE_PRICE
, AS_QUOTE_LINES.CURRENCY_CODE
, AS_QUOTE_LINES.QUANTITY
, AS_QUOTE_LINES.UOM_CODE
, AS_QUOTE_LINES.LINE_NUMBER
, AS_QUOTE_LINES.LINK_TO_LINE_ID
, AS_QUOTE_LINES.PARENT_LINE_ID
, AS_QUOTE_LINES.LEAD_LINE_ID
, AS_QUOTE_LINES.LINE_LIST_PRICE
, AS_QUOTE_LINES.LINE_DISCOUNT_AMOUNT
, AS_QUOTE_LINES.LINE_DISCOUNT_PERCENT
, AS_QUOTE_LINES.LINE_DISCOUNT_MTHD_CODE
, AS_QUOTE_LINES.DISCOUNT_ID
, AS_QUOTE_LINES.DISCOUNT_LINE_ID
, AS_QUOTE_LINES.FLOATING_PRICE_FLAG
, AS_QUOTE_LINES.TAX_CODE
, AS_QUOTE_LINES.TAX_CODE_EDITED_FLAG
, AS_QUOTE_LINES.TAX_EXEMPT_NUM
, AS_QUOTE_LINES.TAX_EXEMPT_REASON_CODE
, AS_QUOTE_LINES.START_DATE_ACTIVE
, AS_QUOTE_LINES.END_DATE_ACTIVE
, AS_QUOTE_LINES.TOP_BILL_SEQUENCE_ID
, AS_QUOTE_LINES.GROUP_ID
, AS_QUOTE_LINES.SHIP_SET_NUMBER
, AS_QUOTE_LINES.PRICING_CONTEXT
, AS_QUOTE_LINES.PRICING_ATTRIBUTE1
, AS_QUOTE_LINES.PRICING_ATTRIBUTE2
, AS_QUOTE_LINES.PRICING_ATTRIBUTE3
, AS_QUOTE_LINES.PRICING_ATTRIBUTE4
, AS_QUOTE_LINES.PRICING_ATTRIBUTE5
, AS_QUOTE_LINES.PRICING_ATTRIBUTE6
, AS_QUOTE_LINES.PRICING_ATTRIBUTE7
, AS_QUOTE_LINES.PRICING_ATTRIBUTE8
, AS_QUOTE_LINES.PRICING_ATTRIBUTE9
, AS_QUOTE_LINES.PRICING_ATTRIBUTE10
, AS_QUOTE_LINES.PRICING_ATTRIBUTE11
, AS_QUOTE_LINES.PRICING_ATTRIBUTE12
, AS_QUOTE_LINES.PRICING_ATTRIBUTE13
, AS_QUOTE_LINES.PRICING_ATTRIBUTE14
, AS_QUOTE_LINES.PRICING_ATTRIBUTE15
, AS_QUOTE_LINES.ATTRIBUTE_CATEGORY
, AS_QUOTE_LINES.ATTRIBUTE1
, AS_QUOTE_LINES.ATTRIBUTE2
, AS_QUOTE_LINES.ATTRIBUTE3
, AS_QUOTE_LINES.ATTRIBUTE4
, AS_QUOTE_LINES.ATTRIBUTE5
, AS_QUOTE_LINES.ATTRIBUTE6
, AS_QUOTE_LINES.ATTRIBUTE7
, AS_QUOTE_LINES.ATTRIBUTE8
, AS_QUOTE_LINES.ATTRIBUTE9
, AS_QUOTE_LINES.ATTRIBUTE10
, AS_QUOTE_LINES.ATTRIBUTE11
, AS_QUOTE_LINES.ATTRIBUTE12
, AS_QUOTE_LINES.ATTRIBUTE13
, AS_QUOTE_LINES.ATTRIBUTE14
, AS_QUOTE_LINES.ATTRIBUTE15
, MSI.DESCRIPTION
, SO_DISCOUNTS.NAME DISCOUNT_NAME
, SO_DISCOUNT_LINES.PERCENT DISCOUNT_PERCENT
, SO_DISCOUNT_LINES.AMOUNT DISCOUNT_AMOUNT
, SO_DISCOUNT_LINES.PRICE DISCOUNT_PRICE
, AS_INTEREST_TYPES.INTEREST_TYPE_ID
, AS_INTEREST_TYPES.INTEREST_TYPE
, AS_INTEREST_CODES_PRI.INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, AS_INTEREST_CODES_PRI.CODE PRIMARY_INTEREST_CODE
, AS_INTEREST_CODES_SEC.INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, AS_INTEREST_CODES_SEC.CODE SECONDARY_INTEREST_CODE
, AS_INTEREST_TYPES.INTEREST_TYPE || '/' || AS_INTEREST_CODES_PRI.CODE || '/' || AS_INTEREST_CODES_SEC.CODE || '/' || MTL_SYSTEM_ITEMS_OPP.DESCRIPTION INTEREST_CATEGORY
, AS_QUOTE_LINES.SHIP_TO_CONTACT_ID
, AS_QUOTE_LINES.SHIP_TO_SITE_USE_ID
, AS_QUOTE_LINES.SHIP_METHOD_CODE
, AS_QUOTE_LINES.FREIGHT_TERMS_CODE
, AS_QUOTE_LINES.SHIPPING_INSTRUCTIONS
, AS_QUOTE_LINES.SERVICED_DURATION
, AS_QUOTE_LINES.SERVICE_COTERMINATE_FLAG
, AS_QUOTE_LINES.SERVICE_PARENT_LINE_ID
, AS_QUOTE_LINES.PRICE_LIST_ID
FROM AS_QUOTE_LINES
, MTL_SYSTEM_ITEMS_VL MSI
, SO_DISCOUNTS
, SO_DISCOUNT_LINES
, AS_INTEREST_TYPES
, AS_INTEREST_CODES AS_INTEREST_CODES_PRI
, AS_INTEREST_CODES AS_INTEREST_CODES_SEC
, MTL_SYSTEM_ITEMS_VL MTL_SYSTEM_ITEMS_OPP
, AS_LEAD_LINES
WHERE AS_QUOTE_LINES.LEAD_LINE_ID = AS_LEAD_LINES.LEAD_LINE_ID (+)
AND AS_LEAD_LINES.INTEREST_TYPE_ID = AS_INTEREST_TYPES.INTEREST_TYPE_ID (+)
AND AS_LEAD_LINES.PRIMARY_INTEREST_CODE_ID = AS_INTEREST_CODES_PRI.INTEREST_CODE_ID (+)
AND AS_LEAD_LINES.SECONDARY_INTEREST_CODE_ID = AS_INTEREST_CODES_SEC.INTEREST_CODE_ID (+)
AND AS_LEAD_LINES.INVENTORY_ITEM_ID = MTL_SYSTEM_ITEMS_OPP.INVENTORY_ITEM_ID (+)
AND AS_LEAD_LINES.ORGANIZATION_ID = MTL_SYSTEM_ITEMS_OPP.ORGANIZATION_ID (+)
AND AS_QUOTE_LINES.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND AS_QUOTE_LINES.ORGANIZATION_ID = MSI.ORGANIZATION_ID (+)
AND AS_QUOTE_LINES.DISCOUNT_ID = SO_DISCOUNTS.DISCOUNT_ID (+)
AND AS_QUOTE_LINES.DISCOUNT_LINE_ID = SO_DISCOUNT_LINES.DISCOUNT_LINE_ID (+)

Columns