[Home] [Help]
| Product: | IBE - iStore |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
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
, R.LINE_RELATIONSHIP_ID
, R.CREATION_DATE RCREATION_DATE
, R.CREATED_BY RCREATED_BY
, R.LAST_UPDATED_BY RLAST_UPDATED_BY
, R.LAST_UPDATE_DATE RLAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN RLAST_UPDATE_LOGIN
, R.REQUEST_ID RREQUEST_ID
, R.PROGRAM_APPLICATION_ID RPROGRAM_APPLICATION_ID
, R.PROGRAM_ID RPROGRAM_ID
, R.PROGRAM_UPDATE_DATE RPROGRAM_UPDATE_DATE
, R.QUOTE_LINE_ID RQUOTE_LINE_ID
, R.RELATED_QUOTE_LINE_ID
, R.RELATIONSHIP_TYPE_CODE
, R.RECIPROCAL_FLAG
FROM ASO_QUOTE_LINES L
, ASO_LINE_RELATIONSHIPS R
WHERE L.QUOTE_LINE_ID = R.QUOTE_LINE_ID(+)