Pricing details for audit purpose

 SELECT distinct

    pi.list_header_id,

    pl.name AS price_list_name,

    pil.list_line_id,

    pil.INVENTORY_ITEM_ID,

    msib.segment1 AS item_code,

    msib.description AS item_description,

    --pil.unit_price,

    pil.start_date_active,

    pil.end_date_active

    --pil.currency_code

    , (select user_name from fnd_user  where user_id = pil.CREATED_BY ) created_by_user

    , pil.CREATION_DATE creation_date

    , (select user_name from fnd_user  where user_id = pil.LAST_UPDATED_BY ) updated_by_user

    , pil.LAST_UPDATE_DATE updated_date

FROM  apps.qp_list_headers_all pi

    , qp_list_lines pil

    , apps.mtl_system_items_b msib 

    , apps.qp_list_headers_tl pl

WHERE  msib.organization_id = 9786 --:ORG_ID

    and pi.list_header_id = pil.list_header_id

    and pi.list_header_id = 1234

    and pil.INVENTORY_ITEM_ID = msib.inventory_item_id

    and pi.list_header_id = pl.list_header_id

    AND msib.segment1 ='12345-6'

  --  AND pil.start_date_active <= SYSDATE

   -- AND (pil.end_date_active IS NULL OR pil.end_date_active >= SYSDATE)

ORDER BY

    pil.start_date_active DESC;