View: IBE_SH_QLINES_SITEMS_V

View Text

SELECT L.QUOTE_LINE_ID
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, L.REQUEST_ID
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_ID
, L.PROGRAM_UPDATE_DATE
, L.QUOTE_HEADER_ID
, L.ORG_ID
, L.LINE_CATEGORY_CODE
, L.ITEM_TYPE_CODE
, L.LINE_NUMBER
, L.START_DATE_ACTIVE
, L.END_DATE_ACTIVE
, L.ORDER_LINE_TYPE_ID
, L.INVOICE_TO_PARTY_SITE_ID
, L.INVOICE_TO_PARTY_ID
, L.ORGANIZATION_ID
, L.INVENTORY_ITEM_ID
, L.QUANTITY
, L.UOM_CODE
, L.MARKETING_SOURCE_CODE_ID
, L.PRICE_LIST_ID
, L.PRICE_LIST_LINE_ID
, L.CURRENCY_CODE
, L.LINE_LIST_PRICE
, L.LINE_ADJUSTED_AMOUNT
, L.LINE_ADJUSTED_PERCENT
, L.LINE_QUOTE_PRICE
, L.RELATED_ITEM_ID
, L.ITEM_RELATIONSHIP_TYPE
, L.ACCOUNTING_RULE_ID
, L.INVOICING_RULE_ID
, L.SPLIT_SHIPMENT_FLAG
, L.BACKORDER_FLAG
, L.ATTRIBUTE_CATEGORY
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
, SI.CONCATENATED_SEGMENTS
, SI.DESCRIPTION
, UM.UNIT_OF_MEASURE
FROM ASO_QUOTE_LINES_ALL L
, MTL_SYSTEM_ITEMS_VL SI
, MTL_UNITS_OF_MEASURE_VL UM
WHERE SI.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID
AND SI.ORGANIZATION_ID = L.ORGANIZATION_ID
AND L.UOM_CODE = UM.UOM_CODE

Columns