SELECT hp.party_name sales_representative
FROM ra_customer_trx_all rcta
,jtf_rs_salesreps jrs
,hz_parties hp
WHERE rcta.primary_resource_salesrep_id=jrs.resource_salesrep_id
AND jrs.resource_id=hp.party_id
SELECT dh.source_order_number ,df.source_line_number as so_line_number ,df.fulfill_line_number ,ddr.doc_user_key as po_number...
No comments:
Post a Comment