Saturday 19 November 2016

query to find the price list name for item

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 =104
and msi.segment1 ='GT2/001244F';

1 comment: