VIEW: APPS.ASO_PVT_QUOTE_LINES_UI_V

Source

View Text - Preformatted

SELECT QUOTE_LINES.ROWID ROW_ID, QUOTE_LINES.QUOTE_LINE_ID, QUOTE_LINES.QUOTE_HEADER_ID, QUOTE_LINES.CREATION_DATE, QUOTE_LINES.CREATED_BY, QUOTE_LINES.LAST_UPDATE_DATE, QUOTE_LINES.LAST_UPDATED_BY, QUOTE_LINES.LAST_UPDATE_LOGIN, QUOTE_LINES.REQUEST_ID, QUOTE_LINES.PROGRAM_APPLICATION_ID, QUOTE_LINES.PROGRAM_ID, QUOTE_LINES.PROGRAM_UPDATE_DATE, QUOTE_LINES.ORG_ID, QUOTE_LINES.LINE_CATEGORY_CODE, QUOTE_LINES.ITEM_TYPE_CODE, LOOKUP.MEANING ITEM_TYPE, QUOTE_LINES.LINE_NUMBER, QUOTE_LINES.START_DATE_ACTIVE, QUOTE_LINES.END_DATE_ACTIVE, QUOTE_LINES.ORDER_LINE_TYPE_ID, QUOTE_LINES.ORGANIZATION_ID, QUOTE_LINES.INVENTORY_ITEM_ID, QUOTE_LINES.QUANTITY, QUOTE_LINES.UOM_CODE, QUOTE_LINES.MARKETING_SOURCE_CODE_ID, 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.RELATED_ITEM_ID, QUOTE_LINES.ITEM_RELATIONSHIP_TYPE, QUOTE_LINES.ACCOUNTING_RULE_ID, QUOTE_LINES.INVOICING_RULE_ID, QUOTE_LINES.SPLIT_SHIPMENT_FLAG, QUOTE_LINES.BACKORDER_FLAG, QUOTE_LINES.SERVICE_ITEM_FLAG, QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG, QUOTE_DETAILS.QUOTE_LINE_DETAIL_ID, QUOTE_DETAILS.SERVICE_COTERMINATE_FLAG, QUOTE_DETAILS.SERVICE_DURATION, QUOTE_DETAILS.SERVICE_UNIT_SELLING_PERCENT, QUOTE_DETAILS.SERVICE_UNIT_LIST_PERCENT, QUOTE_DETAILS.SERVICE_NUMBER, QUOTE_DETAILS.SERVICE_REF_TYPE_CODE , decode(QUOTE_LINES.ITEM_TYPE_CODE, 'SRV', SRV_LOOKUP.MEANING, null) SERVICE_REF_TYPE, QUOTE_DETAILS.SERVICE_REF_LINE_ID, QUOTE_DETAILS.SERVICE_REF_SYSTEM_ID, QUOTE_DETAILS.UNIT_PERCENT_BASE_PRICE, QUOTE_DETAILS.REF_LINE_ID, QUOTE_DETAILS.TOP_MODEL_LINE_ID, QUOTE_DETAILS.ATO_LINE_ID, QUOTE_DETAILS.COMPONENT_SEQUENCE_ID, QUOTE_DETAILS.SERVICE_PERIOD, QUOTE_LINES.ATTRIBUTE_CATEGORY, QUOTE_LINES.ATTRIBUTE1, QUOTE_LINES.ATTRIBUTE2, QUOTE_LINES.ATTRIBUTE3, QUOTE_LINES.ATTRIBUTE4, QUOTE_LINES.ATTRIBUTE5, QUOTE_LINES.ATTRIBUTE6, QUOTE_LINES.ATTRIBUTE7, QUOTE_LINES.ATTRIBUTE8, QUOTE_LINES.ATTRIBUTE9, QUOTE_LINES.ATTRIBUTE10, QUOTE_LINES.ATTRIBUTE11, QUOTE_LINES.ATTRIBUTE12, QUOTE_LINES.ATTRIBUTE13, QUOTE_LINES.ATTRIBUTE14, QUOTE_LINES.ATTRIBUTE15, QUOTE_LINES.ATTRIBUTE16, QUOTE_LINES.ATTRIBUTE17, QUOTE_LINES.ATTRIBUTE18, QUOTE_LINES.ATTRIBUTE19, QUOTE_LINES.ATTRIBUTE20, QUOTE_LINES.PRICED_PRICE_LIST_ID, QUOTE_LINES.AGREEMENT_ID, QUOTE_LINES.commitment_id, 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.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.PRICING_LINE_TYPE_INDICATOR , QUOTE_LINES.END_CUSTOMER_PARTY_ID, QUOTE_LINES.END_CUSTOMER_CUST_PARTY_ID, QUOTE_LINES.END_CUSTOMER_PARTY_SITE_ID, QUOTE_LINES.END_CUSTOMER_CUST_ACCOUNT_ID, QUOTE_LINES.SHIP_MODEL_COMPLETE_FLAG, QUOTE_LINES.CHARGE_PERIODICITY_CODE, QUOTE_LINES.LINE_PAYNOW_CHARGES, QUOTE_LINES.LINE_PAYNOW_TAX, QUOTE_LINES.LINE_PAYNOW_SUBTOTAL, QUOTE_LINES.OBJECT_VERSION_NUMBER, QUOTE_LINES.CONFIG_MODEL_TYPE FROM ASO_QUOTE_LINES QUOTE_LINES, ASO_QUOTE_LINE_DETAILS QUOTE_DETAILS, ASO_LOOKUPS LOOKUP, ASO_LOOKUPS SRV_LOOKUP WHERE QUOTE_LINES.QUOTE_LINE_ID = QUOTE_DETAILS.QUOTE_LINE_ID(+) AND LOOKUP.LOOKUP_TYPE = 'ASO_ITEM_TYPE' AND LOOKUP.LOOKUP_CODE = QUOTE_LINES.ITEM_TYPE_CODE AND SRV_LOOKUP.LOOKUP_TYPE = 'ASO_SERVICE_REF_TYPE' AND NVL(QUOTE_DETAILS.SERVICE_REF_TYPE_CODE,'UNSPECIFIED') = SRV_LOOKUP.LOOKUP_CODE ORDER BY QUOTE_LINES.LINE_NUMBER, DECODE(QUOTE_DETAILS.SERVICE_REF_TYPE_CODE,'QUOTE', (SELECT BOM_SORT_ORDER FROM ASO_QUOTE_LINE_DETAILS WHERE QUOTE_LINE_ID=QUOTE_DETAILS.SERVICE_REF_LINE_ID), QUOTE_DETAILS.BOM_SORT_ORDER), DECODE(QUOTE_DETAILS.SERVICE_REF_TYPE_CODE,'QUOTE', QUOTE_DETAILS.SERVICE_REF_LINE_ID,QUOTE_LINES.QUOTE_LINE_ID), DECODE(QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG,'Y',0,QUOTE_LINES.QUOTE_LINE_ID)

View Text - HTML Formatted

SELECT QUOTE_LINES.ROWID ROW_ID
, QUOTE_LINES.QUOTE_LINE_ID
, QUOTE_LINES.QUOTE_HEADER_ID
, QUOTE_LINES.CREATION_DATE
, QUOTE_LINES.CREATED_BY
, QUOTE_LINES.LAST_UPDATE_DATE
, QUOTE_LINES.LAST_UPDATED_BY
, QUOTE_LINES.LAST_UPDATE_LOGIN
, QUOTE_LINES.REQUEST_ID
, QUOTE_LINES.PROGRAM_APPLICATION_ID
, QUOTE_LINES.PROGRAM_ID
, QUOTE_LINES.PROGRAM_UPDATE_DATE
, QUOTE_LINES.ORG_ID
, QUOTE_LINES.LINE_CATEGORY_CODE
, QUOTE_LINES.ITEM_TYPE_CODE
, LOOKUP.MEANING ITEM_TYPE
, QUOTE_LINES.LINE_NUMBER
, QUOTE_LINES.START_DATE_ACTIVE
, QUOTE_LINES.END_DATE_ACTIVE
, QUOTE_LINES.ORDER_LINE_TYPE_ID
, QUOTE_LINES.ORGANIZATION_ID
, QUOTE_LINES.INVENTORY_ITEM_ID
, QUOTE_LINES.QUANTITY
, QUOTE_LINES.UOM_CODE
, QUOTE_LINES.MARKETING_SOURCE_CODE_ID
, 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.RELATED_ITEM_ID
, QUOTE_LINES.ITEM_RELATIONSHIP_TYPE
, QUOTE_LINES.ACCOUNTING_RULE_ID
, QUOTE_LINES.INVOICING_RULE_ID
, QUOTE_LINES.SPLIT_SHIPMENT_FLAG
, QUOTE_LINES.BACKORDER_FLAG
, QUOTE_LINES.SERVICE_ITEM_FLAG
, QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG
, QUOTE_DETAILS.QUOTE_LINE_DETAIL_ID
, QUOTE_DETAILS.SERVICE_COTERMINATE_FLAG
, QUOTE_DETAILS.SERVICE_DURATION
, QUOTE_DETAILS.SERVICE_UNIT_SELLING_PERCENT
, QUOTE_DETAILS.SERVICE_UNIT_LIST_PERCENT
, QUOTE_DETAILS.SERVICE_NUMBER
, QUOTE_DETAILS.SERVICE_REF_TYPE_CODE
, DECODE(QUOTE_LINES.ITEM_TYPE_CODE
, 'SRV'
, SRV_LOOKUP.MEANING
, NULL) SERVICE_REF_TYPE
, QUOTE_DETAILS.SERVICE_REF_LINE_ID
, QUOTE_DETAILS.SERVICE_REF_SYSTEM_ID
, QUOTE_DETAILS.UNIT_PERCENT_BASE_PRICE
, QUOTE_DETAILS.REF_LINE_ID
, QUOTE_DETAILS.TOP_MODEL_LINE_ID
, QUOTE_DETAILS.ATO_LINE_ID
, QUOTE_DETAILS.COMPONENT_SEQUENCE_ID
, QUOTE_DETAILS.SERVICE_PERIOD
, QUOTE_LINES.ATTRIBUTE_CATEGORY
, QUOTE_LINES.ATTRIBUTE1
, QUOTE_LINES.ATTRIBUTE2
, QUOTE_LINES.ATTRIBUTE3
, QUOTE_LINES.ATTRIBUTE4
, QUOTE_LINES.ATTRIBUTE5
, QUOTE_LINES.ATTRIBUTE6
, QUOTE_LINES.ATTRIBUTE7
, QUOTE_LINES.ATTRIBUTE8
, QUOTE_LINES.ATTRIBUTE9
, QUOTE_LINES.ATTRIBUTE10
, QUOTE_LINES.ATTRIBUTE11
, QUOTE_LINES.ATTRIBUTE12
, QUOTE_LINES.ATTRIBUTE13
, QUOTE_LINES.ATTRIBUTE14
, QUOTE_LINES.ATTRIBUTE15
, QUOTE_LINES.ATTRIBUTE16
, QUOTE_LINES.ATTRIBUTE17
, QUOTE_LINES.ATTRIBUTE18
, QUOTE_LINES.ATTRIBUTE19
, QUOTE_LINES.ATTRIBUTE20
, QUOTE_LINES.PRICED_PRICE_LIST_ID
, QUOTE_LINES.AGREEMENT_ID
, QUOTE_LINES.COMMITMENT_ID
, 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.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.PRICING_LINE_TYPE_INDICATOR
, QUOTE_LINES.END_CUSTOMER_PARTY_ID
, QUOTE_LINES.END_CUSTOMER_CUST_PARTY_ID
, QUOTE_LINES.END_CUSTOMER_PARTY_SITE_ID
, QUOTE_LINES.END_CUSTOMER_CUST_ACCOUNT_ID
, QUOTE_LINES.SHIP_MODEL_COMPLETE_FLAG
, QUOTE_LINES.CHARGE_PERIODICITY_CODE
, QUOTE_LINES.LINE_PAYNOW_CHARGES
, QUOTE_LINES.LINE_PAYNOW_TAX
, QUOTE_LINES.LINE_PAYNOW_SUBTOTAL
, QUOTE_LINES.OBJECT_VERSION_NUMBER
, QUOTE_LINES.CONFIG_MODEL_TYPE
FROM ASO_QUOTE_LINES QUOTE_LINES
, ASO_QUOTE_LINE_DETAILS QUOTE_DETAILS
, ASO_LOOKUPS LOOKUP
, ASO_LOOKUPS SRV_LOOKUP
WHERE QUOTE_LINES.QUOTE_LINE_ID = QUOTE_DETAILS.QUOTE_LINE_ID(+)
AND LOOKUP.LOOKUP_TYPE = 'ASO_ITEM_TYPE'
AND LOOKUP.LOOKUP_CODE = QUOTE_LINES.ITEM_TYPE_CODE
AND SRV_LOOKUP.LOOKUP_TYPE = 'ASO_SERVICE_REF_TYPE'
AND NVL(QUOTE_DETAILS.SERVICE_REF_TYPE_CODE
, 'UNSPECIFIED') = SRV_LOOKUP.LOOKUP_CODE ORDER BY QUOTE_LINES.LINE_NUMBER
, DECODE(QUOTE_DETAILS.SERVICE_REF_TYPE_CODE
, 'QUOTE'
, (SELECT BOM_SORT_ORDER
FROM ASO_QUOTE_LINE_DETAILS
WHERE QUOTE_LINE_ID=QUOTE_DETAILS.SERVICE_REF_LINE_ID)
, QUOTE_DETAILS.BOM_SORT_ORDER)
, DECODE(QUOTE_DETAILS.SERVICE_REF_TYPE_CODE
, 'QUOTE'
, QUOTE_DETAILS.SERVICE_REF_LINE_ID
, QUOTE_LINES.QUOTE_LINE_ID)
, DECODE(QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG
, 'Y'
, 0
, QUOTE_LINES.QUOTE_LINE_ID)