Friday, December 14, 2018

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';

No comments:

Post a Comment