Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_QUOTE_LINES_RG_V retrieves all quote line detail. |
Implementation/DBA Data: | Not implemented in this database |
SELECT AQL.ROW_ID
, AQL.QUOTE_LINE_ID
, AQL.QUOTE_HEADER_ID
, OLT.NAME ACTION_NAME
, AQL.INVENTORY_ITEM_ID
, AQL.INVENTORY_ITEM
, AQL.ITEM_DESCRIPTION
, AQL.PRICE_LIST_NAME
, AQL.UOM_CODE
, AQL.QUANTITY
, CS.NAME SYSTEM_NAME
, XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE) FREQUENCY
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'NON-RECURRING'
, AQL.LINE_LIST_PRICE
, 0) LINE_LIST_PRICE_CHARGE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'RECURRING'
, AQL.LINE_LIST_PRICE
, 0) LINE_LIST_PRICE_RATE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'NON-RECURRING'
, AQL.LINE_ADJUSTED_AMOUNT
, 0) LINE_ADJUSTED_AMOUNT_CHARGE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'RECURRING'
, AQL.LINE_ADJUSTED_AMOUNT
, 0) LINE_ADJUSTED_AMOUNT_RATE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'NON-RECURRING'
, AQL.LINE_ADJUSTED_PERCENT
, 0) LINE_ADJUSTED_PERCENT_CHARGE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'RECURRING'
, AQL.LINE_ADJUSTED_PERCENT
, 0) LINE_ADJUSTED_PERCENT_RATE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'NON-RECURRING'
, AQL.LINE_QUOTE_PRICE
, 0) LINE_QUOTE_PRICE_CHARGE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'RECURRING'
, AQL.LINE_QUOTE_PRICE
, 0) LINE_QUOTE_PRICE_RATE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'NON-RECURRING'
, AQL.LINE_LIST_PRICE*AQL.QUANTITY
, 0) EXT_LIST_PRICE_CHARGE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'RECURRING'
, AQL.LINE_LIST_PRICE*AQL.QUANTITY
, 0) EXT_LIST_PRICE_RATE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'NON-RECURRING'
, AQL.LINE_ADJUSTED_AMOUNT*AQL.QUANTITY
, 0) EXT_ADJUSTED_AMOUNT_CHARGE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'RECURRING'
, AQL.LINE_ADJUSTED_AMOUNT*AQL.QUANTITY
, 0) EXT_ADJUSTED_AMOUNT_RATE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'NON-RECURRING'
, AQL.LINE_ADJUSTED_PERCENT
, 0) EXT_ADJUSTED_PERCENT_CHARGE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'RECURRING'
, AQL.LINE_ADJUSTED_PERCENT
, 0) EXT_ADJUSTED_PERCENT_RATE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'NON-RECURRING'
, AQL.LINE_QUOTE_PRICE*AQL.QUANTITY
, 0) EXT_QUOTE_PRICE_CHARGE
, DECODE(XNC_PRICING_PVT.GET_ITEM_TYPE(AQL.UOM_CODE
, OLT.NAME)
, 'RECURRING'
, AQL.LINE_QUOTE_PRICE*AQL.QUANTITY
, 0) EXT_QUOTE_PRICE_RATE
, AQL.CREATION_DATE
, AQL.CREATED_BY
, AQL.LAST_UPDATE_DATE
, AQL.LAST_UPDATED_BY
, AQL.LAST_UPDATE_LOGIN
, AQL.REQUEST_ID
, AQL.PROGRAM_APPLICATION_ID
, AQL.PROGRAM_ID
, AQL.PROGRAM_UPDATE_DATE
, AQL.ORG_ID
, AQL.LINE_CATEGORY_CODE
, AQL.ITEM_TYPE_CODE
, AQL.ITEM_TYPE
, AQL.LINE_NUMBER
, AQL.START_DATE_ACTIVE
, AQL.END_DATE_ACTIVE
, AQL.ORDER_LINE_TYPE_ID
, AQL.ORGANIZATION_ID
, AQL.MARKETING_SOURCE_CODE_ID
, AQL.PRICE_LIST_ID
, AQL.PRICE_LIST_LINE_ID
, AQL.CURRENCY_CODE
, AQL.LINE_LIST_PRICE
, AQL.LINE_ADJUSTED_AMOUNT
, AQL.LINE_ADJUSTED_PERCENT
, AQL.LINE_QUOTE_PRICE
, AQL.RELATED_ITEM_ID
, AQL.ITEM_RELATIONSHIP_TYPE
, AQL.ACCOUNTING_RULE_ID
, AQL.INVOICING_RULE_ID
, AQL.INVOICE_TO_PARTY_SITE_ID
, AQL.INVOICE_TO_PARTY_ID
, AQL.SPLIT_SHIPMENT_FLAG
, AQL.BACKORDER_FLAG
, AQL.QUOTE_LINE_DETAIL_ID
, AQL.SERVICE_COTERMINATE_FLAG
, AQL.SERVICE_DURATION
, AQL.SERVICE_UNIT_SELLING_PERCENT
, AQL.SERVICE_UNIT_LIST_PERCENT
, AQL.SERVICE_NUMBER
, AQL.SERVICE_REF_TYPE_CODE
, AQL.SERVICE_REF_LINE_ID
, AQL.UNIT_PERCENT_BASE_PRICE
, AQL.SERVICE_PERIOD
, AQL.ATTRIBUTE_CATEGORY
, AQL.ATTRIBUTE1
, AQL.ATTRIBUTE2
, AQL.ATTRIBUTE3
, AQL.ATTRIBUTE4
, AQL.ATTRIBUTE5
, AQL.ATTRIBUTE6
, AQL.ATTRIBUTE7
, AQL.ATTRIBUTE8
, AQL.ATTRIBUTE9
, AQL.ATTRIBUTE10
, AQL.ATTRIBUTE11
, AQL.ATTRIBUTE12
, AQL.ATTRIBUTE13
, AQL.ATTRIBUTE14
, AQL.ATTRIBUTE15
, AQL.CONFIG_HEADER_ID
, AQL.CONFIG_REVISION_NUM
, AQL.COMPLETE_CONFIGURATION_FLAG
, AQL.VALID_CONFIGURATION_FLAG
FROM XNC_ITEM_TYPE_V XIT
, OE_LINE_TYPES_V OLT
, CS_SYSTEMS_ALL_VL CS
, ASO_QUOTE_LINES_V AQL
WHERE NVL(AQL.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND AQL.ORDER_LINE_TYPE_ID = OLT.LINE_TYPE_ID(+)
AND AQL.SERVICE_REF_SYSTEM_ID = CS.SYSTEM_ID(+)
AND AQL.INVENTORY_ITEM_ID = XIT.INVENTORY_ITEM_ID
AND AQL.ORGANIZATION_ID = XIT.ORGANIZATION_ID