VIEW: APPS.ASO_PVT_QTE_LINES_PRINT_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 INVENTORY_ITEM_TYPE , QUOTE_LINES.LINE_NUMBER , QUOTE_LINES.ORDER_LINE_TYPE_ID , QUOTE_LINES.ORGANIZATION_ID , QUOTE_LINES.INVENTORY_ITEM_ID , ITEMS.CONCATENATED_SEGMENTS , ITEMS.PADDED_CONCATENATED_SEGMENTS , ITEMS.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_ALL 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 INVENTORY_ITEM_TYPE
, QUOTE_LINES.LINE_NUMBER
, QUOTE_LINES.ORDER_LINE_TYPE_ID
, QUOTE_LINES.ORGANIZATION_ID
, QUOTE_LINES.INVENTORY_ITEM_ID
, ITEMS.CONCATENATED_SEGMENTS
, ITEMS.PADDED_CONCATENATED_SEGMENTS
, ITEMS.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_ALL 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)