OM Price Lists
--select * --from org_organization_definitions; --execute fnd_client_info.set_org_context(111); --price lists forms colums details SELECT --header tl.name , tl.description , h.currency_code , h.start_date_active , h.end_date_active , h.rounding_factor , h.active_flag , h.mobile_download --, h.PAYMENT_TERMS , h.comments --lines , lt.product_attribute_context , lt.product_attribute , (SELECT segment1 FROM mtl_system_items_b WHERE inventory_item_id = lt.product_attr_value AND ROWNUM = 1) product_value , (SELECT description FROM mtl_system_items_b WHERE inventory_item_id = lt.product_attr_value AND ROWNUM = 1) product_description , l.product_uom_code , lt.list_line_id , l.arithmetic_operator , l.operand operand_value , l.product_precedence --breaks , (SELECT segment1 FROM mtl_system_items_b WHERE inventory_item_id = qpb.product_attr_value AND ROWNUM = 1) pricing_attr , qpb.pricing_attr_value_from , qpb.pricing_attr_value_to , qpb.operand operand_price , qpb.arithmetic_operator break_arithmetic_operator --ATT , lt.comparison_operator_code , lt.pricing_attr_value_from att_value_from , lt.pricing_attr_value_to att_value_to FROM qp_list_headers_b h , qp_list_headers_tl tl -- , qp_list_lines_v l , qp_list_lines l , qp_pricing_attributes lt , qp_price_breaks_v qpb WHERE 1 = 1 AND l.list_line_type_code IN ('PLL', 'PBH') AND lt.pricing_phase_id = 1 AND lt.qualification_ind IN (4, 6, 20, 22) AND l.pricing_phase_id = 1 AND l.qualification_ind IN (4, 6, 20, 22) AND lt.pricing_attribute_context IS NULL AND l.list_line_id = qpb.parent_list_line_id(+) AND lt.list_line_id = l.list_line_id AND tl.list_header_id = h.list_header_id AND tl.language = 'US' AND h.list_header_id = l.list_header_id AND lt.product_attribute_context = 'ITEM' AND EXISTS (SELECT '1' FROM mtl_system_items_b mtl WHERE lt.product_attr_value = mtl.inventory_item_id AND mtl.organization_id = (SELECT qp_util.get_item_validation_org FROM DUAL) AND lt.product_attribute = 'PRICING_ATTRIBUTE1' UNION SELECT '1' FROM DUAL WHERE lt.product_attribute <> 'PRICING_ATTRIBUTE1') -- AND (l.list_header_id = 8570) -- AND (l.pa_list_header_id = '8570') -- AND tl.description LIKE 'SH - RMB for General Customer%' -- AND TL.name = 'SH RMB' -- AND L.LIST_LINE_ID = 147031 AND h.orig_org_id = 111 --KEY AND tl.name = 'SH RMB' --key