improve query performance
SQL Query
--------------------------------
SELECT DISTINCT '1' AS
status,
2 AS
partner_type,
CASE
WHEN f.ship_to_cust_id > ' ' THEN
f.ship_cust_name1 || '|' || f.ship_to_cust_id
ELSE
f.ship_cust_name1 || '|' || f.cust_name || '|' || f.location
END AS
partner_name,
CASE
WHEN f.ship_to_cust_id > ' ' THEN
f.ship_to_cust_id
ELSE
f.location
END AS
partner_number,
2 AS
deleted_flag,
TRUNC(sysdate) AS
last_update_date,
'P' AS
sr_instance_code,
1 AS
process_flag,
'0' AS
cost_account_number
FROM sysadm.ps_pl_item_attrib a,
0