SELECT lead.rowid, lead.lead_id, lead.creation_date, lead.lead_number, lead.status, lead.customer_id, lead.total_amount, lead.description, party.party_name FROM AS_LEADS_ALL LEAD,HZ_PARTIES PARTY WHERE lead.customer_id = party.party_id
SELECT LEAD.ROWID
, LEAD.LEAD_ID
, LEAD.CREATION_DATE
, LEAD.LEAD_NUMBER
, LEAD.STATUS
, LEAD.CUSTOMER_ID
, LEAD.TOTAL_AMOUNT
, LEAD.DESCRIPTION
, PARTY.PARTY_NAME
FROM AS_LEADS_ALL LEAD
, HZ_PARTIES PARTY
WHERE LEAD.CUSTOMER_ID = PARTY.PARTY_ID
|
|
|