Tables
QP_LIST_HEADERS_BQP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions.
QP_LIST_LINESQP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. This table stores all types of list lines; price list lines, all types of modifiers including price modifier list lines used to derive factors. The different types of list lines are based on Lookup Type, 'LIST_LINE_TYPE_CODE'.
QP_PRICING_ATTRIBUTESQP_PRICING_ATTRIBUTES stores product information and pricing attributes. The PRODUCT_ATTRIBUTE and PRODUCT_ATTRIBUTE_VALUE columns identify the product or level in the item hierarchy, i.e item context at which the price or modifier is set. The PRICING_ATTRIBUTE_CONTEXT, PRICING_ATTRIBUTE and PRICING_ATTR_VALUE_FROM columns store the pricing attributes which further define what is being priced. If the PRICING_ATTRIBUTE_CONTEXT is VOLUME the pricing attributes column stores the break unit attribute, e.g. item quantity and both the PRICING_ATTR_VALUE_FROM and PRICING_ATTR_VALUE_TO columns can be populated. The Product information is repeated for all pricing attributes. A record is always created for the VOLUME context which may or may not have an attribute defined.
Relationship
QP_LIST_HEADERS_B <---LIST_HEADER_ID ---> QP_LIST_LINES
QP_LIST_LINES <---LIST_HEADER_ID,LIST_LINE_ID ---> QP_PRICING_ATTRIBUTES
QP_PRICING_ATTRIBUTES <---PRODUCT_ATTR_VALUE <> TO_CHAR(MSI.INVENTORY_ITEM_ID)---> mtl_system_items_b
Useful Queries
SELECT * FROM QP_LIST_HEADERS_B WHERE list_header_id IN (SELECT list_header_id FROM QP_LIST_HEADERS_TL WHERE name = 'Corporate');--Price List Name
SELECT line.*
FROM QP_LIST_LINES line,QP_LIST_HEADERS_B header
WHERE line.LIST_HEADER_ID = header.LIST_HEADER_ID
AND line.list_header_id IN (SELECT list_header_id FROM QP_LIST_HEADERS_TL WHERE name = 'Corporate'); --Price List Name
SELECT *
FROM QP_LIST_HEADERS_B SPL ,
QP_LIST_LINES SPLL ,
QP_PRICING_ATTRIBUTES QPA
WHERE SPLL.LIST_HEADER_ID = SPL.LIST_HEADER_ID
AND QPA.LIST_HEADER_ID = SPL.LIST_HEADER_ID
AND SPLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPA.LIST_HEADER_ID IN (SELECT list_header_id FROM QP_LIST_HEADERS_TL WHERE name = 'Corporate'); --Price List Name
SELECT qpa.*
FROM QP_LIST_HEADERS_B SPL ,
QP_LIST_LINES SPLL ,
QP_PRICING_ATTRIBUTES QPA,
MTL_SYSTEM_ITEMS_B MSI
WHERE MSI.ORGANIZATION_ID = 244
AND MSI.INVENTORY_ITEM_ID = 434257
AND SPL.LIST_HEADER_ID = 164075
AND SPLL.LIST_HEADER_ID = SPL.LIST_HEADER_ID
AND QPA.LIST_HEADER_ID = SPL.LIST_HEADER_ID
AND SPLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPA.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND QPA.PRODUCT_ATTRIBUTE = 'PRICING_ATTRIBUTE1'
AND QPA.PRODUCT_ATTR_VALUE = TO_CHAR(MSI.INVENTORY_ITEM_ID)
AND QPA.PRODUCT_UOM_CODE = MSI.PRIMARY_UOM_CODE
AND QPA.PRICING_ATTRIBUTE_CONTEXT IS NULL
AND QPA.EXCLUDER_FLAG = 'N'
AND QPA.PRICING_PHASE_ID =1;
分享到:
相关推荐
Oracle EBS 操作手册
Oracle EBS中文数据字典.pdf
此针对于oracle ebs的值集进行详细的讲解
OracleEBS中文数据字典
win7 ORACLE ebs 需要的文件和具体设置步骤 详细
Integrating_EBS_with_Oracle_Internet_Directory_and_Oracle_Single_Sign-On Oracle EBS 单点登录 方案
ORACLE EBS R12 安装步骤详解,讲述ORACLE EBS R12的详细安装步骤,感觉不错,和大家一块分享
ORACLE ebs 各个模块的表之间的关联关系,方便大家熟悉ebs系统的表结构
Oracle EBS 各模块详解 01采购培训 02库存培训 03销售培训 04应付培训 05总帐培训 06应收培训
这是一份完整的Oracle ebs 项目制造模块培训文档,可以了解Oracle ebs 项目制造模块(PJM)的所有功能及流程。
ORACLEEBS财务全模块操作手册中文版收集.pdf
Oracle EBS开发文档(form, report), 写得很不错
Oracle EBS 采购请购单接口示例,亲测可用 个人网站 http://a66.site 公众号:LXFIMJ
Oracle EBS R12中的配置文件及中文说明
oracle ebs之http通用接口开发
主要内容是oracle EBS财务模块,就学习ERP挺好的材料,分为五个部分 Oracle EBS财务模块(一)基本功能 Oracle EBS财务模块(二)基本组成模块 Oracle EBS财务模块(三)总账功能 Oracle EBS财务模块(四)账套 ...
oracleebs库存模块中文版手册.pdf
Oracle EBS 功能顾问入门必备参考书目。共上下两册。每册分为两个压缩包,需要同时下载完后才能解压成功。本资源是上册第一个压缩包。其余压缩包请从本人其他上传资源中找。
ORACLE EBS R12.1.3 克隆详细步骤 该文档描述了Oracle 应用R12系统的克隆过程。 文档内容适用于所有12.x.x版本,例如12.0,12.0.4和12.1.x。在适用的部分,12.0.x系列统称为12.0版本,而12.1.x系列统称为12.1版本。...
从百度、CSDN等各大平台,花大量积分收集并整理的ORACLE资料,在此低分贡献出来。