iStore Info

This Blog to Store All Information Related to Oracle EBS Apps, Useful Applications, Latest Technology.

Price List Query

SELECT 
LIST.OPERAND,LIST.PRODUCT_ATTR_VAL_DISP,LIST.START_DATE_ACTIVE,LIST.END_DATE_ACTIVE,HEADER.CURRENCY_CODE,HEADER.NAME,HEADER.DESCRIPTION
FROM qp_list_lines_v LIST, qp_secu_list_headers_v HEADER
WHERE LIST.LIST_HEADER_ID=HEADER.LIST_HEADER_ID