[Home] [Help]
View: AST_LS_QUOTES_LINES_V
Product: | AST - TeleSales |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /*+ INDEX(QUOTE_LINES) */ QUOTE_LINES.ROWID ROW_ID
, QUOTE_LINES.QUOTE_LINE_ID
, QUOTE_LINES.QUOTE_HEADER_ID
, QUOTE_LINES.INVENTORY_ITEM_ID
, ITEMS.SEGMENT1 INVENTORY_ITEM
, ITEMS.DESCRIPTION
FROM ASO_QUOTE_LINES_ALL QUOTE_LINES
, ASO_I_ITEMS_V ITEMS
WHERE QUOTE_LINES.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND QUOTE_LINES.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
Columns
Name |
ROW_ID |
QUOTE_LINE_ID |
QUOTE_HEADER_ID |
INVENTORY_ITEM_ID |
INVENTORY_ITEM |
DESCRIPTION |