Oracle EBS Advanced Pricing Tables
来源:互联网 发布:游戏解说软件 编辑:程序博客网 时间:2024/05/16 14:10
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_LINES
QP_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_ATTRIBUTES
QP_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_LINESQP_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 NameSELECT line.*FROM QP_LIST_LINES line,QP_LIST_HEADERS_B headerWHERE line.LIST_HEADER_ID = header.LIST_HEADER_IDAND line.list_header_id IN (SELECT list_header_id FROM QP_LIST_HEADERS_TL WHERE name = 'Corporate'); --Price List NameSELECT *FROM QP_LIST_HEADERS_B SPL , QP_LIST_LINES SPLL , QP_PRICING_ATTRIBUTES QPAWHERE SPLL.LIST_HEADER_ID = SPL.LIST_HEADER_IDAND QPA.LIST_HEADER_ID = SPL.LIST_HEADER_IDAND SPLL.LIST_LINE_ID = QPA.LIST_LINE_IDAND QPA.LIST_HEADER_ID IN (SELECT list_header_id FROM QP_LIST_HEADERS_TL WHERE name = 'Corporate'); --Price List NameSELECT qpa.*FROM QP_LIST_HEADERS_B SPL , QP_LIST_LINES SPLL , QP_PRICING_ATTRIBUTES QPA, MTL_SYSTEM_ITEMS_B MSIWHERE MSI.ORGANIZATION_ID = 244AND MSI.INVENTORY_ITEM_ID = 434257AND SPL.LIST_HEADER_ID = 164075AND SPLL.LIST_HEADER_ID = SPL.LIST_HEADER_IDAND QPA.LIST_HEADER_ID = SPL.LIST_HEADER_IDAND SPLL.LIST_LINE_ID = QPA.LIST_LINE_IDAND 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_CODEAND QPA.PRICING_ATTRIBUTE_CONTEXT IS NULLAND QPA.EXCLUDER_FLAG = 'N'AND QPA.PRICING_PHASE_ID =1;
- Oracle EBS Advanced Pricing Tables
- Oracle EBS Advanced Pricing Tables .
- Oracle EBS Advanced Pricing Tables
- Oracle Advanced Pricing White Papers
- Oracle EBS Tables
- Oracle EBS Tables
- oracle ebs Order Management Tables.
- Advanced Pricing - How to source Pricing Attributes using QP_CUSTOM_SOURCE.Get_Custom_Attribute_Valu
- oracle ebs
- oracle ebs
- 在采购中使用Advanced Pricing达到price break的效果
- Oracle EBS发展历史
- Oracle EBS安装
- Oracle EBS中的快捷键
- Oracle EBS setup(reference)
- oracle ebs服务器
- Oracle EBS借贷关系
- oracle,EBS常用数据表
- 李彦宏在南开大学的演讲
- 《Fundamentals of Project Management 4th Edition》 读书笔记 第九章 项目控制和评估
- 如何测试洗牌程序
- 一个合格的程序员应该读过哪些书
- 使用STL的经验总结_指定关联容器的比较类型_12
- Oracle EBS Advanced Pricing Tables
- ActiveMQ学习笔记
- 行测问题之汽车接送的问题
- 最新版 apache_2.2.11 与 apache-tomcat-6.0.18 集成方案
- HOJ 2201 Sum of Cubes
- Eclipse中SVN插件中英文互相转换方法
- 交叉编译用于android系统里的C/C++应用程序/库文件(其实就是运行于linux之上的应用程序)。
- 程序员面试题积累
- PL/SQL Developer 配置截圖