eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ASO_PVT_QUOTE_LINES_BALIVIEW_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_PVT_QUOTE_LINES_BALIVIEW_V

View Text

SELECT QUOTE_LINES.ROWID
, QUOTE_LINES.QUOTE_LINE_ID
, QUOTE_LINES.QUOTE_HEADER_ID
, QUOTE_LINES.ORG_ID
, QUOTE_LINES.LINE_CATEGORY_CODE
, QUOTE_LINES.LINE_NUMBER
, QUOTE_LINES.ORDER_LINE_TYPE_ID
, QUOTE_LINES.ORGANIZATION_ID
, QUOTE_LINES.INVENTORY_ITEM_ID
, ITEMS.CONCATENATED_SEGMENTS
, ITEMS.BOM_ITEM_TYPE
, QUOTE_LINES.ITEM_TYPE_CODE
, ITEMS.DESCRIPTION
, QUOTE_LINES.QUANTITY
, QUOTE_LINES.UOM_CODE
, QUOTE_LINES.PRICE_LIST_ID
, QUOTE_LINES.PRICE_LIST_LINE_ID
, QUOTE_LINES.CURRENCY_CODE
, QUOTE_LINES.LINE_LIST_PRICE
, QUOTE_LINES.LINE_ADJUSTED_AMOUNT
, QUOTE_LINES.LINE_ADJUSTED_PERCENT
, QUOTE_LINES.LINE_QUOTE_PRICE
, QUOTE_LINES.LINE_LIST_PRICE * QUOTE_LINES.QUANTITY
, QUOTE_LINES.LINE_ADJUSTED_AMOUNT * QUOTE_LINES.QUANTITY
, QUOTE_LINES.START_DATE_ACTIVE
, QUOTE_LINES.END_DATE_ACTIVE
, ITEMS.SERVICEABLE_PRODUCT_FLAG
, ITEMS.SERVICE_ITEM_FLAG
, ITEMS.VENDOR_WARRANTY_FLAG
, ITEMS.RETURNABLE_FLAG
, ITEMS.PADDED_CONCATENATED_SEGMENTS
, LINE_DETAILS.QUOTE_LINE_DETAIL_ID
, LINE_DETAILS.CONFIG_HEADER_ID
, LINE_DETAILS.CONFIG_REVISION_NUM
, LINE_DETAILS.CONFIG_ITEM_ID
, LINE_DETAILS.COMPLETE_CONFIGURATION_FLAG
, LINE_DETAILS.VALID_CONFIGURATION_FLAG
, LINE_DETAILS.COMPONENT_CODE
, LINE_DETAILS.SERVICE_COTERMINATE_FLAG
, LINE_DETAILS.SERVICE_DURATION
, LINE_DETAILS.SERVICE_UNIT_SELLING_PERCENT
, LINE_DETAILS.SERVICE_UNIT_LIST_PERCENT
, LINE_DETAILS.SERVICE_NUMBER
, LINE_DETAILS.SERVICE_PERIOD
, LINE_DETAILS.SERVICE_REF_TYPE_CODE
, LINE_DETAILS.SERVICE_REF_ORDER_NUMBER
, LINE_DETAILS.SERVICE_REF_LINE_NUMBER
, LINE_DETAILS.SERVICE_REF_LINE_ID
, LINE_DETAILS.SERVICE_REF_SYSTEM_ID
, LINE_DETAILS.UNIT_PERCENT_BASE_PRICE
FROM ASO_QUOTE_LINES_ALL QUOTE_LINES
, ASO_QUOTE_LINE_DETAILS LINE_DETAILS
, MTL_SYSTEM_ITEMS_VL ITEMS
WHERE QUOTE_LINES.QUOTE_LINE_ID = LINE_DETAILS.QUOTE_LINE_ID (+)
AND 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
ORG_ID
LINE_CATEGORY_CODE
LINE_NUMBER
ORDER_LINE_TYPE_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
INVENTORY_ITEM
BOM_ITEM_TYPE
ITEM_TYPE_CODE
ITEM_DESCRIPTION
QUANTITY
UOM_CODE
PRICE_LIST_ID
PRICE_LIST_LINE_ID
CURRENCY_CODE
LINE_LIST_PRICE
LINE_ADJUSTED_AMOUNT
LINE_ADJUSTED_PERCENT
LINE_QUOTE_PRICE
EXTENDED_LIST_PRICE
EXTENDED_ADJUSTED_AMOUNT
START_DATE_ACTIVE
END_DATE_ACTIVE
SERVICEABLE_PRODUCT_FLAG
SERVICE_ITEM_FLAG
VENDOR_WARRANTY_FLAG
RETURNABLE_FLAG
PADDED_CONCATENATED_SEGMENTS
QUOTE_LINE_DETAIL_ID
CONFIG_HEADER_ID
CONFIG_REVISION_NUM
CONFIG_ITEM_ID
COMPLETE_CONFIGURATION_FLAG
VALID_CONFIGURATION_FLAG
COMPONENT_CODE
SERVICE_COTERMINATE_FLAG
SERVICE_DURATION
SERVICE_UNIT_SELLING_PERCENT
SERVICE_UNIT_LIST_PERCENT
SERVICE_NUMBER
SERVICE_PERIOD
SERVICE_REF_TYPE_CODE
SERVICE_REF_ORDER_NUMBER
SERVICE_REF_LINE_NUMBER
SERVICE_REF_LINE_ID
SERVICE_REF_SYSTEM_ID
UNIT_PERCENT_BASE_PRICE