[Home] [Help]
View: AS_QUOTE_LINES_V
| Product: | AS - Sales Foundation |
|---|
| Description: | Quotation lines view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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
| ROW_ID |
| QUOTE_LINE_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| LAST_UPDATE_LOGIN |
| REQUEST_ID |
| PROGRAM_APPLICATION_ID |
| PROGRAM_ID |
| PROGRAM_UPDATE_DATE |
| QUOTE_ID |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| PRICE_LIST_LINE_ID |
| LINE_QUOTE_PRICE |
| CURRENCY_CODE |
| QUANTITY |
| UOM_CODE |
| LINE_NUMBER |
| LINK_TO_LINE_ID |
| PARENT_LINE_ID |
| LEAD_LINE_ID |
| LINE_LIST_PRICE |
| LINE_DISCOUNT_AMOUNT |
| LINE_DISCOUNT_PERCENT |
| LINE_DISCOUNT_MTHD_CODE |
| DISCOUNT_ID |
| DISCOUNT_LINE_ID |
| FLOATING_PRICE_FLAG |
| TAX_CODE |
| TAX_EXEMPT_NUM |
| TAX_EXEMPT_REASON_CODE |
| START_DATE_ACTIVE |
| END_DATE_ACTIVE |
| TOP_BILL_SEQUENCE_ID |
| GROUP_ID |
| SHIP_SET_NUMBER |
| PRICING_CONTEXT |
| PRICING_ATTRIBUTE1 |
| PRICING_ATTRIBUTE2 |
| PRICING_ATTRIBUTE3 |
| PRICING_ATTRIBUTE4 |
| PRICING_ATTRIBUTE5 |
| PRICING_ATTRIBUTE6 |
| PRICING_ATTRIBUTE7 |
| PRICING_ATTRIBUTE8 |
| PRICING_ATTRIBUTE9 |
| PRICING_ATTRIBUTE10 |
| PRICING_ATTRIBUTE11 |
| PRICING_ATTRIBUTE12 |
| PRICING_ATTRIBUTE13 |
| PRICING_ATTRIBUTE14 |
| PRICING_ATTRIBUTE15 |
| ATTRIBUTE_CATEGORY |
| ATTRIBUTE1 |
| ATTRIBUTE2 |
| ATTRIBUTE3 |
| ATTRIBUTE4 |
| ATTRIBUTE5 |
| ATTRIBUTE6 |
| ATTRIBUTE7 |
| ATTRIBUTE8 |
| ATTRIBUTE9 |
| ATTRIBUTE10 |
| ATTRIBUTE11 |
| ATTRIBUTE12 |
| ATTRIBUTE13 |
| ATTRIBUTE14 |
| ATTRIBUTE15 |
| DESCRIPTION |
| DISCOUNT_NAME |
| DISCOUNT_PERCENT |
| DISCOUNT_AMOUNT |
| DISCOUNT_PRICE |
| INTEREST_TYPE_ID |
| INTEREST_TYPE |
| PRIMARY_INTEREST_CODE_ID |
| PRIMARY_INTEREST_CODE |
| SECONDARY_INTEREST_CODE_ID |
| SECONDARY_INTEREST_CODE |
| INTEREST_CATEGORY |
| TAX_CODE_EDITED_FLAG |
| SHIP_TO_CONTACT_ID |
| SHIP_TO_SITE_USE_ID |
| SHIP_METHOD_CODE |
| FREIGHT_TERMS_CODE |
| SHIPPING_INSTRUCTIONS |
| SERVICED_DURATION |
| SERVICE_COTERMINATE_FLAG |
| SERVICE_PARENT_LINE_ID |
| PRICE_LIST_ID |
| Name |