VIEW: APPS.ASO_PVT_QUOTE_LINES_NUM_V

Source

View Text - Preformatted

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, ITEMS.item_type, 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, QUOTE_LINES.LINE_QUOTE_PRICE * QUOTE_LINES.QUANTITY, QUOTE_LINES.START_DATE_ACTIVE, QUOTE_LINES.END_DATE_ACTIVE, QUOTE_LINES.INVOICE_TO_PARTY_SITE_ID, QUOTE_LINES.INVOICE_TO_PARTY_ID, QUOTE_LINES.INVOICE_TO_CUST_PARTY_ID, QUOTE_LINES.MARKETING_SOURCE_CODE_ID, 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.SECURITY_GROUP_ID, QUOTE_LINES.OBJECT_VERSION_NUMBER, QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID, QUOTE_LINES.MINISITE_ID, QUOTE_LINES.SECTION_ID, QUOTE_LINES.PRICED_PRICE_LIST_ID, QUOTE_LINES.AGREEMENT_ID, QUOTE_LINES.COMMITMENT_ID, QUOTE_LINES.DISPLAY_ARITHMETIC_OPERATOR, QUOTE_LINES.LINE_TYPE_SOURCE_FLAG, QUOTE_LINES.SERVICE_ITEM_FLAG, QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG, 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.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.SELLING_PRICE_CHANGE, QUOTE_LINES.RECALCULATE_FLAG, 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.CHARGE_PERIODICITY_CODE, QUOTE_LINES.SHIP_MODEL_COMPLETE_FLAG, QUOTE_LINES.LINE_PAYNOW_CHARGES, QUOTE_LINES.LINE_PAYNOW_TAX, QUOTE_LINES.LINE_PAYNOW_SUBTOTAL, DECODE(QUOTE_LINES.CHARGE_PERIODICITY_CODE,NULL,NULL, (SELECT unit_of_measure FROM mtl_uom_conversions WHERE uom_class=FND_PROFILE.value('ONT_UOM_CLASS_CHARGE_PERIODICITY') AND uom_code=quote_lines.charge_periodicity_code)) CHARGE_PERIODICITY_MEANING, 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, LINE_DETAILS.SERVICE_REF_OPTION_NUMB, LINE_DETAILS.SERVICE_REF_SHIPMENT_NUMB, LINE_DETAILS.RETURN_REF_TYPE, LINE_DETAILS.RETURN_REF_HEADER_ID, LINE_DETAILS.RETURN_REF_LINE_ID, LINE_DETAILS.RETURN_REASON_CODE, LINE_DETAILS.REF_TYPE_CODE, LINE_DETAILS.REF_LINE_ID, LINE_DETAILS.INSTANCE_ID, LINE_DETAILS.BOM_SORT_ORDER, LINE_DETAILS.CONFIG_DELTA, LINE_DETAILS.CONFIG_INSTANCE_NAME, LINE_DETAILS.TOP_MODEL_LINE_ID, LINE_DETAILS.ATO_LINE_ID, LINE_DETAILS.COMPONENT_SEQUENCE_ID, SHIP.SHIP_QUOTE_PRICE, DECODE(COMPLETE_CONFIGURATION_FLAG,'N', (Select MEANING From ASO_LOOKUPS Where lookup_type = 'ASO_CONFIGURATION_STATUS' AND lookup_code = 'INCOMPLETE' AND (TRUNC(SYSDATE) BETWEEN NVL(TRUNC(START_DATE_ACTIVE),TRUNC(SYSDATE)) AND NVL(TRUNC(END_DATE_ACTIVE),TRUNC(SYSDATE))) and enabled_flag = 'Y'), decode(VALID_CONFIGURATION_FLAG,'N', (Select MEANING From ASO_LOOKUPS Where lookup_type = 'ASO_CONFIGURATION_STATUS' AND lookup_code = 'INCOMPLETE' AND (TRUNC(SYSDATE) BETWEEN NVL(TRUNC(START_DATE_ACTIVE),TRUNC(SYSDATE)) AND NVL(TRUNC(END_DATE_ACTIVE),TRUNC(SYSDATE))) and enabled_flag = 'Y'))) MODEL_STATUS, QUOTE_LINES.CONFIG_MODEL_TYPE FROM ASO_QUOTE_LINES QUOTE_LINES, ASO_QUOTE_LINE_DETAILS LINE_DETAILS, MTL_SYSTEM_ITEMS_VL ITEMS, ASO_SHIPMENTS SHIP 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 AND QUOTE_LINES.QUOTE_HEADER_ID = SHIP.QUOTE_HEADER_ID AND QUOTE_LINES.QUOTE_LINE_ID = SHIP.QUOTE_LINE_ID ORDER BY QUOTE_LINES.LINE_NUMBER, DECODE(LINE_DETAILS.SERVICE_REF_TYPE_CODE,'QUOTE', (SELECT BOM_SORT_ORDER FROM ASO_QUOTE_LINE_DETAILS WHERE QUOTE_LINE_ID=LINE_DETAILS.SERVICE_REF_LINE_ID), LINE_DETAILS.BOM_SORT_ORDER), DECODE(LINE_DETAILS.SERVICE_REF_TYPE_CODE,'QUOTE', LINE_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.ORG_ID
, QUOTE_LINES.LINE_CATEGORY_CODE
, QUOTE_LINES.ITEM_TYPE_CODE
, ITEMS.ITEM_TYPE
, 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
, QUOTE_LINES.LINE_QUOTE_PRICE * QUOTE_LINES.QUANTITY
, QUOTE_LINES.START_DATE_ACTIVE
, QUOTE_LINES.END_DATE_ACTIVE
, QUOTE_LINES.INVOICE_TO_PARTY_SITE_ID
, QUOTE_LINES.INVOICE_TO_PARTY_ID
, QUOTE_LINES.INVOICE_TO_CUST_PARTY_ID
, QUOTE_LINES.MARKETING_SOURCE_CODE_ID
, 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.SECURITY_GROUP_ID
, QUOTE_LINES.OBJECT_VERSION_NUMBER
, QUOTE_LINES.INVOICE_TO_CUST_ACCOUNT_ID
, QUOTE_LINES.MINISITE_ID
, QUOTE_LINES.SECTION_ID
, QUOTE_LINES.PRICED_PRICE_LIST_ID
, QUOTE_LINES.AGREEMENT_ID
, QUOTE_LINES.COMMITMENT_ID
, QUOTE_LINES.DISPLAY_ARITHMETIC_OPERATOR
, QUOTE_LINES.LINE_TYPE_SOURCE_FLAG
, QUOTE_LINES.SERVICE_ITEM_FLAG
, QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG
, 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.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.SELLING_PRICE_CHANGE
, QUOTE_LINES.RECALCULATE_FLAG
, 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.CHARGE_PERIODICITY_CODE
, QUOTE_LINES.SHIP_MODEL_COMPLETE_FLAG
, QUOTE_LINES.LINE_PAYNOW_CHARGES
, QUOTE_LINES.LINE_PAYNOW_TAX
, QUOTE_LINES.LINE_PAYNOW_SUBTOTAL
, DECODE(QUOTE_LINES.CHARGE_PERIODICITY_CODE
, NULL
, NULL
, (SELECT UNIT_OF_MEASURE
FROM MTL_UOM_CONVERSIONS
WHERE UOM_CLASS=FND_PROFILE.VALUE('ONT_UOM_CLASS_CHARGE_PERIODICITY')
AND UOM_CODE=QUOTE_LINES.CHARGE_PERIODICITY_CODE)) CHARGE_PERIODICITY_MEANING
, 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
, LINE_DETAILS.SERVICE_REF_OPTION_NUMB
, LINE_DETAILS.SERVICE_REF_SHIPMENT_NUMB
, LINE_DETAILS.RETURN_REF_TYPE
, LINE_DETAILS.RETURN_REF_HEADER_ID
, LINE_DETAILS.RETURN_REF_LINE_ID
, LINE_DETAILS.RETURN_REASON_CODE
, LINE_DETAILS.REF_TYPE_CODE
, LINE_DETAILS.REF_LINE_ID
, LINE_DETAILS.INSTANCE_ID
, LINE_DETAILS.BOM_SORT_ORDER
, LINE_DETAILS.CONFIG_DELTA
, LINE_DETAILS.CONFIG_INSTANCE_NAME
, LINE_DETAILS.TOP_MODEL_LINE_ID
, LINE_DETAILS.ATO_LINE_ID
, LINE_DETAILS.COMPONENT_SEQUENCE_ID
, SHIP.SHIP_QUOTE_PRICE
, DECODE(COMPLETE_CONFIGURATION_FLAG
, 'N'
, (SELECT MEANING
FROM ASO_LOOKUPS
WHERE LOOKUP_TYPE = 'ASO_CONFIGURATION_STATUS'
AND LOOKUP_CODE = 'INCOMPLETE'
AND (TRUNC(SYSDATE) BETWEEN NVL(TRUNC(START_DATE_ACTIVE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(END_DATE_ACTIVE)
, TRUNC(SYSDATE)))
AND ENABLED_FLAG = 'Y')
, DECODE(VALID_CONFIGURATION_FLAG
, 'N'
, (SELECT MEANING
FROM ASO_LOOKUPS
WHERE LOOKUP_TYPE = 'ASO_CONFIGURATION_STATUS'
AND LOOKUP_CODE = 'INCOMPLETE'
AND (TRUNC(SYSDATE) BETWEEN NVL(TRUNC(START_DATE_ACTIVE)
, TRUNC(SYSDATE))
AND NVL(TRUNC(END_DATE_ACTIVE)
, TRUNC(SYSDATE)))
AND ENABLED_FLAG = 'Y'))) MODEL_STATUS
, QUOTE_LINES.CONFIG_MODEL_TYPE
FROM ASO_QUOTE_LINES QUOTE_LINES
, ASO_QUOTE_LINE_DETAILS LINE_DETAILS
, MTL_SYSTEM_ITEMS_VL ITEMS
, ASO_SHIPMENTS SHIP
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
AND QUOTE_LINES.QUOTE_HEADER_ID = SHIP.QUOTE_HEADER_ID
AND QUOTE_LINES.QUOTE_LINE_ID = SHIP.QUOTE_LINE_ID ORDER BY QUOTE_LINES.LINE_NUMBER
, DECODE(LINE_DETAILS.SERVICE_REF_TYPE_CODE
, 'QUOTE'
, (SELECT BOM_SORT_ORDER
FROM ASO_QUOTE_LINE_DETAILS
WHERE QUOTE_LINE_ID=LINE_DETAILS.SERVICE_REF_LINE_ID)
, LINE_DETAILS.BOM_SORT_ORDER)
, DECODE(LINE_DETAILS.SERVICE_REF_TYPE_CODE
, 'QUOTE'
, LINE_DETAILS.SERVICE_REF_LINE_ID
, QUOTE_LINES.QUOTE_LINE_ID)
, DECODE(QUOTE_LINES.SERVICEABLE_PRODUCT_FLAG
, 'Y'
, 0
, QUOTE_LINES.QUOTE_LINE_ID)