VIEW: APPS.ASO_QUOTE_LINES_V

Source

View Text - Preformatted

SELECT QUOTE_LINES.ROWID ROW_ID ,QUOTE_LINES.QUOTE_LINE_ID QUOTE_LINE_ID ,QUOTE_LINES.QUOTE_HEADER_ID QUOTE_HEADER_ID ,QUOTE_LINES.CREATION_DATE CREATION_DATE ,QUOTE_LINES.CREATED_BY CREATED_BY ,QUOTE_LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE ,QUOTE_LINES.LAST_UPDATED_BY LAST_UPDATED_BY ,QUOTE_LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN ,QUOTE_LINES.REQUEST_ID REQUEST_ID ,QUOTE_LINES.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID ,QUOTE_LINES.PROGRAM_ID PROGRAM_ID ,QUOTE_LINES.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE ,QUOTE_LINES.ORG_ID ORG_ID ,QUOTE_LINES.LINE_CATEGORY_CODE LINE_CATEGORY_CODE ,QUOTE_LINES.ITEM_TYPE_CODE ITEM_TYPE_CODE ,LOOKUP.MEANING ITEM_TYPE ,QUOTE_LINES.LINE_NUMBER LINE_NUMBER ,QUOTE_LINES.START_DATE_ACTIVE START_DATE_ACTIVE ,QUOTE_LINES.END_DATE_ACTIVE END_DATE_ACTIVE ,QUOTE_LINES.ORDER_LINE_TYPE_ID ORDER_LINE_TYPE_ID ,QUOTE_LINES.ORGANIZATION_ID ORGANIZATION_ID ,QUOTE_LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID ,QUOTE_LINES.QUANTITY QUANTITY ,QUOTE_LINES.UOM_CODE UOM_CODE ,QUOTE_LINES.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID ,QUOTE_LINES.PRICE_LIST_ID PRICE_LIST_ID ,I_PRICE_LISTS.NAME PRICE_LIST_NAME ,QUOTE_LINES.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID ,QUOTE_LINES.CURRENCY_CODE CURRENCY_CODE ,QUOTE_LINES.LINE_LIST_PRICE LINE_LIST_PRICE ,QUOTE_LINES.LINE_ADJUSTED_AMOUNT LINE_ADJUSTED_AMOUNT ,QUOTE_LINES.LINE_ADJUSTED_PERCENT LINE_ADJUSTED_PERCENT ,QUOTE_LINES.LINE_QUOTE_PRICE LINE_QUOTE_PRICE ,QUOTE_LINES.RELATED_ITEM_ID RELATED_ITEM_ID ,QUOTE_LINES.ITEM_RELATIONSHIP_TYPE ITEM_RELATIONSHIP_TYPE ,QUOTE_LINES.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID ,QUOTE_LINES.INVOICING_RULE_ID INVOICING_RULE_ID ,QUOTE_LINES.INVOICE_TO_PARTY_SITE_ID ,QUOTE_LINES.INVOICE_TO_PARTY_ID ,QUOTE_LINES. INVOICE_TO_CUST_ACCOUNT_ID , QUOTE_LINES.INVOICE_TO_CUST_PARTY_ID ,QUOTE_LINES.SPLIT_SHIPMENT_FLAG SPLIT_SHIPMENT_FLAG ,QUOTE_LINES.BACKORDER_FLAG BACKORDER_FLAG ,QUOTE_LINES.LINE_TYPE_SOURCE_FLAG ,QUOTE_LINES.SERVICE_ITEM_FLAG ,QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG ,QUOTE_LINES.SELLING_PRICE_CHANGE ,QUOTE_LINES.RECALCULATE_FLAG ,QUOTE_LINES.PRICING_LINE_TYPE_INDICATOR ,QUOTE_DETAILS.QUOTE_LINE_DETAIL_ID QUOTE_LINE_DETAIL_ID ,QUOTE_DETAILS.SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG ,QUOTE_DETAILS.SERVICE_DURATION SERVICE_DURATION ,QUOTE_DETAILS.SERVICE_UNIT_SELLING_PERCENT SERVICE_UNIT_SELLING_PERCENT ,QUOTE_DETAILS.SERVICE_UNIT_LIST_PERCENT SERVICE_UNIT_LIST_PERCENT ,QUOTE_DETAILS.SERVICE_NUMBER SERVICE_NUMBER ,QUOTE_DETAILS.SERVICE_REF_TYPE_CODE ,QUOTE_DETAILS.SERVICE_REF_LINE_ID ,QUOTE_DETAILS.SERVICE_REF_SYSTEM_ID ,QUOTE_DETAILS.UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE ,QUOTE_DETAILS.SERVICE_PERIOD SERVICE_PERIOD ,QUOTE_LINES.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY ,QUOTE_LINES.ATTRIBUTE1 ATTRIBUTE1 ,QUOTE_LINES.ATTRIBUTE2 ATTRIBUTE2 ,QUOTE_LINES.ATTRIBUTE3 ATTRIBUTE3 ,QUOTE_LINES.ATTRIBUTE4 ATTRIBUTE4 ,QUOTE_LINES.ATTRIBUTE5 ATTRIBUTE5 ,QUOTE_LINES.PRICED_PRICE_LIST_ID PRICED_PRICE_LIST_ID ,QUOTE_LINES.ATTRIBUTE6 ATTRIBUTE6 ,QUOTE_LINES.AGREEMENT_ID AGREEMENT_ID ,QUOTE_LINES.commitment_id commitment_id ,QUOTE_LINES.ATTRIBUTE7 ATTRIBUTE7 ,QUOTE_LINES.ATTRIBUTE8 ATTRIBUTE8 ,QUOTE_LINES.ATTRIBUTE9 ATTRIBUTE9 ,QUOTE_LINES.ATTRIBUTE10 ATTRIBUTE10 ,QUOTE_LINES.ATTRIBUTE11 ATTRIBUTE11 ,QUOTE_LINES.ATTRIBUTE12 ATTRIBUTE12 ,QUOTE_LINES.ATTRIBUTE13 ATTRIBUTE13 ,QUOTE_LINES.ATTRIBUTE14 ATTRIBUTE14 ,QUOTE_LINES.ATTRIBUTE15 ATTRIBUTE15 ,QUOTE_LINES.ATTRIBUTE16 ATTRIBUTE16 ,QUOTE_LINES.ATTRIBUTE17 ATTRIBUTE17 ,QUOTE_LINES.ATTRIBUTE18 ATTRIBUTE18 ,QUOTE_LINES.ATTRIBUTE19 ATTRIBUTE19 ,QUOTE_LINES.ATTRIBUTE20 ATTRIBUTE20 ,ITEMS.CONCATENATED_SEGMENTS INVENTORY_ITEM ,ITEMS.PADDED_CONCATENATED_SEGMENTS ,ITEMS.DESCRIPTION ITEM_DESCRIPTION ,ITEMS.shippable_item_flag ,QUOTE_LINES. LINE_QUOTE_PRICE * QUOTE_LINES.QUANTITY LINE_EXTENDED_PRICE ,QUOTE_DETAILS.CONFIG_HEADER_ID ,QUOTE_DETAILS.CONFIG_REVISION_NUM ,QUOTE_DETAILS.COMPLETE_CONFIGURATION_FLAG ,QUOTE_DETAILS.VALID_CONFIGURATION_FLAG ,QUOTE_LINES.DISPLAY_ARITHMETIC_OPERATOR DISPLAY_ARITHMETIC_OPERATOR ,QUOTE_LINES.CONFIG_MODEL_TYPE from ASO_QUOTE_LINES QUOTE_LINES, ASO_I_PRICE_LISTS_V I_PRICE_LISTS, ASO_QUOTE_LINE_DETAILS QUOTE_DETAILS, ASO_I_ITEMS_V ITEMS, ASO_LOOKUPS LOOKUP WHERE QUOTE_LINES.PRICE_LIST_ID = I_PRICE_LISTS.PRICE_LIST_ID(+) AND QUOTE_LINES.QUOTE_LINE_ID = QUOTE_DETAILS.QUOTE_LINE_ID(+) AND QUOTE_LINES.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID AND QUOTE_LINES.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID AND LOOKUP.LOOKUP_TYPE = 'ASO_ITEM_TYPE' AND LOOKUP.LOOKUP_CODE = QUOTE_LINES.ITEM_TYPE_CODE

View Text - HTML Formatted

SELECT QUOTE_LINES.ROWID ROW_ID
, QUOTE_LINES.QUOTE_LINE_ID QUOTE_LINE_ID
, QUOTE_LINES.QUOTE_HEADER_ID QUOTE_HEADER_ID
, QUOTE_LINES.CREATION_DATE CREATION_DATE
, QUOTE_LINES.CREATED_BY CREATED_BY
, QUOTE_LINES.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QUOTE_LINES.LAST_UPDATED_BY LAST_UPDATED_BY
, QUOTE_LINES.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QUOTE_LINES.REQUEST_ID REQUEST_ID
, QUOTE_LINES.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, QUOTE_LINES.PROGRAM_ID PROGRAM_ID
, QUOTE_LINES.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUOTE_LINES.ORG_ID ORG_ID
, QUOTE_LINES.LINE_CATEGORY_CODE LINE_CATEGORY_CODE
, QUOTE_LINES.ITEM_TYPE_CODE ITEM_TYPE_CODE
, LOOKUP.MEANING ITEM_TYPE
, QUOTE_LINES.LINE_NUMBER LINE_NUMBER
, QUOTE_LINES.START_DATE_ACTIVE START_DATE_ACTIVE
, QUOTE_LINES.END_DATE_ACTIVE END_DATE_ACTIVE
, QUOTE_LINES.ORDER_LINE_TYPE_ID ORDER_LINE_TYPE_ID
, QUOTE_LINES.ORGANIZATION_ID ORGANIZATION_ID
, QUOTE_LINES.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, QUOTE_LINES.QUANTITY QUANTITY
, QUOTE_LINES.UOM_CODE UOM_CODE
, QUOTE_LINES.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, QUOTE_LINES.PRICE_LIST_ID PRICE_LIST_ID
, I_PRICE_LISTS.NAME PRICE_LIST_NAME
, QUOTE_LINES.PRICE_LIST_LINE_ID PRICE_LIST_LINE_ID
, QUOTE_LINES.CURRENCY_CODE CURRENCY_CODE
, QUOTE_LINES.LINE_LIST_PRICE LINE_LIST_PRICE
, QUOTE_LINES.LINE_ADJUSTED_AMOUNT LINE_ADJUSTED_AMOUNT
, QUOTE_LINES.LINE_ADJUSTED_PERCENT LINE_ADJUSTED_PERCENT
, QUOTE_LINES.LINE_QUOTE_PRICE LINE_QUOTE_PRICE
, QUOTE_LINES.RELATED_ITEM_ID RELATED_ITEM_ID
, QUOTE_LINES.ITEM_RELATIONSHIP_TYPE ITEM_RELATIONSHIP_TYPE
, QUOTE_LINES.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, QUOTE_LINES.INVOICING_RULE_ID INVOICING_RULE_ID
, QUOTE_LINES.INVOICE_TO_PARTY_SITE_ID
, QUOTE_LINES.INVOICE_TO_PARTY_ID
, QUOTE_LINES. INVOICE_TO_CUST_ACCOUNT_ID
, QUOTE_LINES.INVOICE_TO_CUST_PARTY_ID
, QUOTE_LINES.SPLIT_SHIPMENT_FLAG SPLIT_SHIPMENT_FLAG
, QUOTE_LINES.BACKORDER_FLAG BACKORDER_FLAG
, QUOTE_LINES.LINE_TYPE_SOURCE_FLAG
, QUOTE_LINES.SERVICE_ITEM_FLAG
, QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG
, QUOTE_LINES.SELLING_PRICE_CHANGE
, QUOTE_LINES.RECALCULATE_FLAG
, QUOTE_LINES.PRICING_LINE_TYPE_INDICATOR
, QUOTE_DETAILS.QUOTE_LINE_DETAIL_ID QUOTE_LINE_DETAIL_ID
, QUOTE_DETAILS.SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG
, QUOTE_DETAILS.SERVICE_DURATION SERVICE_DURATION
, QUOTE_DETAILS.SERVICE_UNIT_SELLING_PERCENT SERVICE_UNIT_SELLING_PERCENT
, QUOTE_DETAILS.SERVICE_UNIT_LIST_PERCENT SERVICE_UNIT_LIST_PERCENT
, QUOTE_DETAILS.SERVICE_NUMBER SERVICE_NUMBER
, QUOTE_DETAILS.SERVICE_REF_TYPE_CODE
, QUOTE_DETAILS.SERVICE_REF_LINE_ID
, QUOTE_DETAILS.SERVICE_REF_SYSTEM_ID
, QUOTE_DETAILS.UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE
, QUOTE_DETAILS.SERVICE_PERIOD SERVICE_PERIOD
, QUOTE_LINES.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, QUOTE_LINES.ATTRIBUTE1 ATTRIBUTE1
, QUOTE_LINES.ATTRIBUTE2 ATTRIBUTE2
, QUOTE_LINES.ATTRIBUTE3 ATTRIBUTE3
, QUOTE_LINES.ATTRIBUTE4 ATTRIBUTE4
, QUOTE_LINES.ATTRIBUTE5 ATTRIBUTE5
, QUOTE_LINES.PRICED_PRICE_LIST_ID PRICED_PRICE_LIST_ID
, QUOTE_LINES.ATTRIBUTE6 ATTRIBUTE6
, QUOTE_LINES.AGREEMENT_ID AGREEMENT_ID
, QUOTE_LINES.COMMITMENT_ID COMMITMENT_ID
, QUOTE_LINES.ATTRIBUTE7 ATTRIBUTE7
, QUOTE_LINES.ATTRIBUTE8 ATTRIBUTE8
, QUOTE_LINES.ATTRIBUTE9 ATTRIBUTE9
, QUOTE_LINES.ATTRIBUTE10 ATTRIBUTE10
, QUOTE_LINES.ATTRIBUTE11 ATTRIBUTE11
, QUOTE_LINES.ATTRIBUTE12 ATTRIBUTE12
, QUOTE_LINES.ATTRIBUTE13 ATTRIBUTE13
, QUOTE_LINES.ATTRIBUTE14 ATTRIBUTE14
, QUOTE_LINES.ATTRIBUTE15 ATTRIBUTE15
, QUOTE_LINES.ATTRIBUTE16 ATTRIBUTE16
, QUOTE_LINES.ATTRIBUTE17 ATTRIBUTE17
, QUOTE_LINES.ATTRIBUTE18 ATTRIBUTE18
, QUOTE_LINES.ATTRIBUTE19 ATTRIBUTE19
, QUOTE_LINES.ATTRIBUTE20 ATTRIBUTE20
, ITEMS.CONCATENATED_SEGMENTS INVENTORY_ITEM
, ITEMS.PADDED_CONCATENATED_SEGMENTS
, ITEMS.DESCRIPTION ITEM_DESCRIPTION
, ITEMS.SHIPPABLE_ITEM_FLAG
, QUOTE_LINES. LINE_QUOTE_PRICE * QUOTE_LINES.QUANTITY LINE_EXTENDED_PRICE
, QUOTE_DETAILS.CONFIG_HEADER_ID
, QUOTE_DETAILS.CONFIG_REVISION_NUM
, QUOTE_DETAILS.COMPLETE_CONFIGURATION_FLAG
, QUOTE_DETAILS.VALID_CONFIGURATION_FLAG
, QUOTE_LINES.DISPLAY_ARITHMETIC_OPERATOR DISPLAY_ARITHMETIC_OPERATOR
, QUOTE_LINES.CONFIG_MODEL_TYPE
FROM ASO_QUOTE_LINES QUOTE_LINES
, ASO_I_PRICE_LISTS_V I_PRICE_LISTS
, ASO_QUOTE_LINE_DETAILS QUOTE_DETAILS
, ASO_I_ITEMS_V ITEMS
, ASO_LOOKUPS LOOKUP
WHERE QUOTE_LINES.PRICE_LIST_ID = I_PRICE_LISTS.PRICE_LIST_ID(+)
AND QUOTE_LINES.QUOTE_LINE_ID = QUOTE_DETAILS.QUOTE_LINE_ID(+)
AND QUOTE_LINES.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND QUOTE_LINES.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID
AND LOOKUP.LOOKUP_TYPE = 'ASO_ITEM_TYPE'
AND LOOKUP.LOOKUP_CODE = QUOTE_LINES.ITEM_TYPE_CODE