Query to Find the Price list name for Item in Oracle Apps R12

SELECT qph.name

, msi.segment1

, qpl.operand

, qpl.product_precedence

FROM  qp_list_headers qph,

apps.qp_list_lines_v qpl,

inv.mtl_system_items_b msi

WHERE  qph.list_header_id = qpl.list_header_id

and qpl.product_attr_value = to_char(msi.inventory_item_id)

and msi.ORGANIZATION_ID =4

and msi.segment1 ='RED0126MCO';

👋 Hi, I'm Suriya — QA Engineer with 4+ years of experience in manual, API & automation testing.

📬 Contact Me | LinkedIn | GitHub

📌 Follow for: Real-Time Test Cases, Bug Reports, Selenium Frameworks.