CZ - --Query to find the difference b/w 2 configurations :

--Query to find the difference b/w 2 configurations :

select
CFG.ps_node_name Name,
TXT.TEXT_STR Description,
CFG.item_num_val Quantity
from
CZ_CONFIG_ITEMS CFG,
CZ_INTL_TEXTS TXT,
CZ_PS_NODES ND
where CFG.inventory_item_id is not null
and ND.intl_text_id=TXT.intl_text_id
and ND.ps_node_id=CFG.ps_node_id
and CFG.config_hdr_id = :1
and CFG.config_rev_nbr = :2

MINUS

select
CFG.ps_node_name Name,
TXT.TEXT_STR Description,
CFG.item_num_val Quantity
from
CZ_CONFIG_ITEMS CFG,
CZ_INTL_TEXTS TXT,
CZ_PS_NODES ND
where CFG.inventory_item_id is not null
and ND.intl_text_id=TXT.intl_text_id
and ND.ps_node_id=CFG.ps_node_id
and CFG.config_hdr_id = :3
and CFG.config_rev_nbr = :4