VIEW: APPS.ASO_PVT_QUOTE_LINES_BALIVIEW_V

Source

View Text - Preformatted

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 ,quote_lines.config_model_type from aso_quote_lines 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

View Text - HTML Formatted

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
, QUOTE_LINES.CONFIG_MODEL_TYPE
FROM ASO_QUOTE_LINES 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