VIEW: APPS.QP_PRICE_LIST_LINES_V

Source

View Text - Preformatted

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 = QP_UTIL.Get_Item_Validation_Org AND QPLL.LIST_LINE_TYPE_CODE = 'PLL'

View Text - HTML Formatted

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 = QP_UTIL.GET_ITEM_VALIDATION_ORG
AND QPLL.LIST_LINE_TYPE_CODE = 'PLL'