View: ASO_PVT_QUOTE_LINES_BALI_V

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

View Text

SELECT QUOTE_LINES.ROWID ROW_ID
, QUOTE_LINES.QUOTE_LINE_ID
, QUOTE_LINES.QUOTE_HEADER_ID
, QUOTE_LINES.ORG_ID
, QUOTE_LINES.LINE_CATEGORY_CODE
, QUOTE_LINES.ITEM_TYPE_CODE
, QUOTE_LINES.LINE_NUMBER
, QUOTE_LINES.ORDER_LINE_TYPE_ID
, QUOTE_LINES.ORGANIZATION_ID
, QUOTE_LINES.INVENTORY_ITEM_ID
, ITEMS.CONCATENATED_SEGMENTS INVENTORY_ITEM
, ITEMS.PADDED_CONCATENATED_SEGMENTS
, ITEMS.DESCRIPTION ITEM_DESCRIPTION
, LPAD(' '
, DECODE(LINE_DETAILS.SERVICE_REF_TYPE_CODE
, 'QUOTE'
, 1
, LENGTH(TRANSLATE( LINE_DETAILS.COMPONENT_CODE
, '-0123456789'
, '-')))* 4) || 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
, 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 ORDER BY DECODE(LINE_DETAILS.SERVICE_REF_TYPE_CODE
, 'QUOTE'
, LINE_DETAILS.SERVICE_REF_LINE_ID
, QUOTE_LINES.QUOTE_LINE_ID)
, DECODE(QUOTE_LINES.ITEM_TYPE_CODE
, 'SVA'
, 1
, 2)

Columns