select msr.sourcing_rule_type, msso.vendor_id, msso.source_type, msa.assignment_set_id, msr.sourcing_rule_id, pad.approved_supplier_list_id, pasl.owning_organization_id, pasl.owning_organization_code, pasl.owning_organization_name, 
pasl.supplier_name, pasl.supplier_site,
pasl.item_id,pasl.item_number, pql.item_revision, pasl.item_description, pasl.asl_status, 
pq.segment1 as quotation_number, pql.line_num as line_number, 
pasl.ocessing_lead_time, pasl.min_order_qty, paa.fixed_lot_multiple, pq.currency_code as currency, pql.unit_price,
pql.unit_meas_lookup_code as uom, pqpb.price_break_quantity, pqpb.discounted_price, pqpb.operating_unit_name as ship_to
from pofg_approved_supplier_lists pasl, pofg_asl_documents pad, po_headers_all pq, 
po_lines_all pql, pofg_quotation_price_breaks pqpb, po_asl_attributes paa, po_approved_supplier_list pasl2,
MRP_SR_ASSIGNMENTS msa, MRP_SOURCING_RULES msr, MRP_SR_SOURCE_ORG_V msso
where pasl.approved_supplier_list_id=pad.approved_supplier_list_id
and pasl.approved_supplier_list_id=pasl2.asl_id
and pasl.using_organization_id=pad.using_organization_id
--and pasl.site_operating_unit_id=pad.operating_unit_id
and pad.document_id=pql.po_header_id
and pad.document_line_id=pql.po_line_id(+)
--and pad.approved_supplier_list_id=pasv.asl_id
and pad.approved_supplier_list_id=paa.asl_id
and pq.po_header_id=pql.po_header_id
and pql.po_header_id=pqpb.quotation_id(+)
and pql.po_line_id=pqpb.quotation_line_id(+)
and pasl.asl_status='Approved'
and pq.type_lookup_code='QUOTATION'
and (pasl2.disable_flag is null or pasl2.disable_flag='N')
and msa.inventory_item_id=pasl.item_id
and msa.assignment_set_id=17
--and msa.assignment_id=msr.assignment_id
and msa.sourcing_rule_id=msr.sourcing_rule_id
and msso.vendor_id=pq.vendor_id
and msso.vendor_site_id=pq.vendor_site_id