Product: | QP - Advanced Pricing |
---|---|
Description: | Price List Line information. Provided for backward compatibility for other applications. |
Implementation/DBA Data: | APPS.QP_PRICE_LIST_LINES_V |
SELECT QPLL.ROWID ROW_ID
, QPLL.LIST_LINE_ID
, QPLL.CREATION_DATE
, QPLL.CREATED_BY
, QPLL.LAST_UPDATE_DATE
, QPLL.LAST_UPDATED_BY
, QPLL.LAST_UPDATE_LOGIN
, QPLL.PROGRAM_APPLICATION_ID
, QPLL.PROGRAM_ID
, QPLL.PROGRAM_UPDATE_DATE
, QPLL.REQUEST_ID
, QPLL.LIST_HEADER_ID
, QP_PRICE_LIST_PVT.GET_INVENTORY_ITEM_ID(QPLL.LIST_LINE_ID)
, QP_PRICE_LIST_PVT.GET_PRODUCT_UOM_CODE(QPLL.LIST_LINE_ID)
, QPLL.ARITHMETIC_OPERATOR
, QPLL.OPERAND
, QPLL.GENERATE_USING_FORMULA_ID
, 'Y'
, QP_PRICE_LIST_PVT.GET_PRICING_ATTR_CONTEXT(QPLL.LIST_LINE_ID)
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE1')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE2')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE3')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE4')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE5')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE6')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE7')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE8')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE9')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE10')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE11')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE12')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE13')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE14')
, QP_PRICE_LIST_PVT.GET_PRICING_ATTRIBUTE(QPLL.LIST_LINE_ID
, 'PRICING_ATTRIBUTE15')
, QPLL.START_DATE_ACTIVE
, QPLL.END_DATE_ACTIVE
, QPLL.CONTEXT
, QPLL.ATTRIBUTE1
, QPLL.ATTRIBUTE2
, QPLL.ATTRIBUTE3
, QPLL.ATTRIBUTE4
, QPLL.ATTRIBUTE5
, QPLL.ATTRIBUTE6
, QPLL.ATTRIBUTE7
, QPLL.ATTRIBUTE8
, QPLL.ATTRIBUTE9
, QPLL.ATTRIBUTE10
, QPLL.ATTRIBUTE11
, QPLL.ATTRIBUTE12
, QPLL.ATTRIBUTE13
, QPLL.ATTRIBUTE14
, QPLL.ATTRIBUTE15
, MSI.PADDED_CONCATENATED_SEGMENTS
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION ITEM_DESCRIPTION
, MSI.PRIMARY_UNIT_OF_MEASURE
, QP_PRICE_LIST_PVT.GET_CUSTOMER_ITEM_ID(QPLL.LIST_LINE_ID)
, QPLL.PRIMARY_UOM_FLAG
, QPLL.REVISION
, QPLL.REVISION_DATE
, QPLL.REVISION_REASON_CODE
, QPLL.COMMENTS
FROM MTL_SYSTEM_ITEMS_KFV MSI
, QP_LIST_LINES QPLL
WHERE MSI.INVENTORY_ITEM_ID = QP_PRICE_LIST_PVT.GET_INVENTORY_ITEM_ID(QPLL.LIST_LINE_ID)
AND MSI.ORGANIZATION_ID = TO_NUMBER(FND_PROFILE.VALUE('QP_ORGANIZATION_ID'))
AND QPLL.LIST_LINE_TYPE_CODE = 'PLL'