Here is another SQL Which I extensively used to validate the price list conversions in the OM Cloud implementations and getting the price list(s) export from the Fusion SCM Applications.
SELECT qplt.name “Price List”,
qplt.price_list_type_code,
qplt.currency_code Currency,
qplt.start_date,
qplt.end_date,
qplt.description,
qplt.org_id Business_Unit_ID,
qplt.status_code Status,
— qpli.price_list_item_id, qpli.price_list_id,
qpli.item_level_code,
(SELECT item_number FROM fusion.egp_system_items esi WHERE esi.inventory_item_id = qpli.item_id AND esi.organization_id=300000007099064) “Item”, — Master Org Id
(SELECT unit_of_measure FROM fusion.fnd_units_of_measure_vl WHERE uom_code=qpli.pricing_uom_code)”Pricing UOM”,
qpli.pricing_uom_code,
qpli.line_type_code,
qpli.primary_pricing_uom_flag ,
qplc.charge_line_number ,
— qplc.price_list_charge_id ,
— qplc.pricing_basis_id ,
— qplc.tier_context_code ,
— qplc.charge_definition_id ,
— qplc.parent_entity_type_code ,
— qplc.parent_entity_id ,
qplc.calculation_method_code “Calculation Method”,
qplc.base_price ,
— qplc.usage_uom_code ,
— qplc.price_periodicity_code ,
qplc.can_adjust_flag “Allow Manual Adjustments”,
qplc.start_date,
qplc.end_date
— qplc.tiered_pricing_header_id ,
— qplc.attribute_pricing_matrix_id ,
— qplc.calculation_type_code ,
— qplc.cost_calculation_amount
FROM fusion.QP_PRICE_LISTS_VL qplt ,
fusion.QP_PRICE_LIST_ITEMS qpli,
fusion.qp_price_list_charges qplc
WHERE qplt.price_list_id = qpli.price_list_id
AND qplc.parent_entity_id(+) = qpli.price_list_item_id
AND qplt.name = ”
ORDER BY qplt.name, qpli.price_list_id, qpli.price_list_item_id